Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: http://ift.tt/2kPLWg5
Download Full Written Notes: http://ift.tt/2xFJdfr
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:30) Excel file = “Workbook”, not “Document”
3. (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers)
4. (02:29) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5. (03:46) Worksheet = Sheet = All the Cells
6. (03:55) Sheet Tab = Name of worksheet and Insert New Sheets
7. (04:18) Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
8. (04:18) You can add new sheets with Plus button to the right of the sheets:
9. (05:00) Workbook = All the sheets = File = File Name
10. (05:20) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
11. (05:20) Move Cursor
12. (05:20) Fill Handle = after you select a cell the little black square in the lower right corner.
13. (05:20) Cross Hair or “Angry Rabbit” Cursor
14. (06:45) Entering data or formulas
15. (07:42) Cross Hair or “Angry Rabbit” Cursor Magic
16. (13:22) Default Alignment In Excel:
17. (14:20) Stylistic Formatting examples:
18. (17:22) Select whole table:
19. (18:35) Entering data into a large range of cells
20. (22:05) Formulas
21. (22:05) First Formula using SUM
22. (24:37) Cell References
23. (26:15) AVERAGE Function
24. (34:40) Percentage Formula with Relative Cell Reference and Absolute Cell References Cell
25. (42:30) Number Formatting
26. (47:52) Page Setup
27. (58:32) Move Sheet and Copying Sheet:
28. (01:01:47) Summary
Month: October 2017
Office 2016 Video #12: Create PowerPoint Presentation With Pictures, Links and Videos
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2wAbeAk
Class web page link: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction and Download Video, Picture and Excel Files
2. (01:25) Add PowerPoint icon to Task bar and Open PowerPoint
3. (02:30) Title Slide
4. (03:10) New Slide
5. (03:33) Slide Pane to create slides and type text
6. (05:00) Outline View to create slides and type text
7. (07:54) Different Layouts
8. (08:36) Insert Photo
9. (09:44) Insert Videos
10. (13:50) Insert Paste Special Link
11. (17:43) Themes and Variants on Design Ribbon
12. (18:21) Transitions Ribbon tab
13. (21:00) Animation Ribbon tab
14. (21:30) Slide Master
15. (27:31) Run Slide Show
16. (29:08) Different Views, including Notes View
17. (30:05) Printing and Page Setup
18. 31:35) Handout Slide Master to Adjust printing for page numbers
19. (32:46) ) Summary
Office 2016 Video #11: Create Folders To Organize Your Files
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Class web page link: http://ift.tt/2wAbeAk
This video review file management using Windows Explorer. We see how to use Ctrl + Shift + N to create new folders and how to use our Ctrl & Shift selection tricks to highlight files and then we use our Mouse to click and drag to move files from one folder on a drive to a different folder on the same drive.
Office 2016 Video #10: Word Styles, Table of Contents & Send to PowerPoint (Intro To PowerPoint)
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download files and notes at class web page: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction
2. (00:27) Create a New Style so it is available in other documents
3. (06:50) Create Table of Contents using Header 1 Style
4. (11:26) Send Word Document to PowerPoint using Header 1 Style
5. (16:54) Create a Blank PowerPoint and add a Title Slide Layout, Design Theme to all slides, a Transition to all slides and start and stop the PowerPoint Presentation using keyboards
6. (21:50) Summary
Office 2016 Video #05.5: Saving Files to Correct Folders in Busn 216
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
This is a reminder video to save files to the correct folders
Office 2016 Video #08: Create Research Paper in Word
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2wAbeAk
Class web page link: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction
2. (01:00) Rules for MLA Documentation Style
3. (04:19) Set MLA Style
4. (05:10) Set Margins
5. (05:50) Insert Header
6. (09:05) Insert Footer to show Page Numbers
7. (12:28) Add First Line Indent
8. (16:00) Numbered List
9. (17:00) Insert Citation for first time in document
10. (17:43) Manage Sources
11. (24:05) Insert Footnote
12. (25:15) Edit Style
13. (29:45) Insert Bibliography
14. (32:35) Find & Replace
15. (35:51) Auto Correct to create a shorthand
16. (37:53) Summary
Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)
Download Excel File #1: http://ift.tt/2fRzTtj Download Excel File #2: http://ift.tt/2y6qjgT
Download Zipped Folder: http://ift.tt/2fQnypv
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how
Topics:
1. (00:16) Introduction
2. (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016
3. (03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report!
4. (17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set
5. (21:50) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report.
6. (22:34) Diagram to understand Data Model and Power Pivot
7. (46:46) Unhanded Exception Error.
8. (48:02) Summary
Reference Video:
Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model
https://www.youtube.com/watch?v=Jzt-I4mt8sQ
Office 2016 Video #07: Create a Resume in Word
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2wAbeAk
Class web page link: http://ift.tt/2wAbeAk
Topics in this video:
1. (00:01) Introduction
2. (00:13) Guidelines for Resume
3. (02:18) Look at Word Resume Templates
4. (03:03) Set System Name in Word Options
5. (03:28) How to use Template
6. (03:50) Understanding Word Tables
7. (06:08) Download Start File
8. (06:47) Create Custom Resume with Two Columns
9. (06:47) Create Structure and Formatting for Resume
10. (07:52) Created Letterhead in Resume
11. (09:34) Change Paragraph Spacing (Before and After) of all paragraphs in documents
12. (11:00) Add Columns to Resume
13. (11:59) Set Section so we can have Columns on one part of the page, but not the other
14. (13:18) Add two Columns to the second section of our document
15. (13:36) Create a Column Break
16. (14:32) Change width of columns
17. (15:25) Add consistent formatting to the different parts of the Resume using Format Painter
18. (23:09) Convert Two Column Resume to Single Column Resume with all elements listed vertically
19. (24:30) Summary
Office 2016 Video #06: Business Letter, Letterhead, Save As Template (Much More)
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2hnkMfl
Class web page link: http://ift.tt/2hnnuOo
Topics in this video:
1. (00:01) Introduction
2. (00:34) Create Word Document in Windows Explorer
3. (01:28) Create Letterhead
4. (2:10) Character Level Formatting
5. (03:51) Paragraph Level Formatting
6. (05:29) Line Spacing
7. (08:28) Paragraph Level Borders
8. (10:48) Save As Template
9. (14:34) Set Tabs
10. (17:38) Insert Date
11. (19:30) Business Letter
12. (20:16) Paste Special “Keep Text Only”
13. (22:46) How to Edit a Word Template with extension .dotx
Video link for Office Tab Video:
Office 2013 Class #14: Word Set Tabs: Left, Center, Right, Decimal, Bar, Leader, and the Ruler
https://www.youtube.com/watch?v=YIfmXMw-KIE
Office 2016 Video #05: Create Ad Flyer In Word, Create pdf and web page files with Save As
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2hnkMfl
Class web page link: http://ift.tt/2hnnuOo
Topics in this video:
1. (00:01) Introduction
2. (03:21) Formatting Keyboards:
3. (07:40) Insert Clip Art or Pictures
4. (11:05) Highlighting and Fill to add background color
5. (14:39) Highlight to end of document = Ctrl + Shift + End
6. (14:39) Bullets and Numbering are a Paragraph Level Formatting
7. (16:43) Page Setup, a Section Level Formatting
8. (17:55) Tab and Shift Tab to move forward and backward through dialog box or web site text boxes
9. (19:55) Page Borders
10. (21:23) Auto Save Time cam be changed in Options dialog Box
11. (22:03) Print dialog box AND Print Preview
12. (23:10) Spell Check
13. (25:05) Save As pdf File
14. (26:25) Save As web site
15. (30:00) Summary