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
Tag: How to
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
Office 2016 Video #04: Introduction to Word 2016: 20 Important Tips for Efficiency
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. (01:10) Add Word Shortcut to Task Bar
3. (02:15) Why we use Word
4. (02:5) Title Bar & Save As
5. (04:09) Alt + Tab Keyboard to jump between Active Windows
6. (06:35) Ribbons
7. (06:35) Customizing the Quick Access Toolbar QAT
8. (11:20) Typing with RAND Trick
9. (12:36 and 26:20) Non-printing characters provide useful information
10. (14:21) Page Break
11. (13:25) Wordwrap
12. (17:11) Backspace and Delete
13. (19:40) Status Bar
14. (20:03) Navigation
15. (20:50) Selection Tricks:
16. (25:12) Clipboard
17. (27:26) Paste Ctrl Smart Tags
18. (30:35) Mini Toolbar
19. (32:23) Formatting Characters (Character Level Formatting)
20. (32:52) Formatting Paragraphs (Paragraph Level Formatting)
21. (34:48) Alt Keyboard Shortcuts
22. (38:26) Summary
Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)
Excel Magic Trick 1467: Count Open Projects by Day and Project Code, Including Empty Cells
Download Files: http://ift.tt/2xWBRR3
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to Count Open Projects by Day and Project Code, Including Empty Cells with the following Complex Criteria: 1) Start Date Less Than or Equal To Date AND 2) Start Date NOT Empty Cell AND 3) End Date Great Than Or Equal To Date OR End Date = Empty Cell AND 4) Project Code = Project Code. Learn about COUNTIFS and SUMPRODUCT functions and the elements that go into each function when there is comp-lex Criteria. Also learn about what the syntax is for āNot Empty Cellā and āEmpty Cellā in the COUNTIFS function. Further, learn how to have both an AND Logical Test and an OR Logical Test in the SUMPRODUCT function and the COUNTIFS Function.
Topics:
1. (00:11) Introduction
2. (03:35) SUMPRODUCT Function Formula.
3. (13:03) Two COUNTIFS Functions Formula
4. (20:14) SUMPRODUCT & COUNTIFS functions in same formula, with a Function Argument Array Operation in the COUNTIFS.
5. (25:36) Summary
Reference Videos:
Excel Magic Trick 784: Empty Cells OR Formula Created Blank: Confusion Over Word “Blank”
Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas
Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)
https://www.youtube.com/watch?v=1y8kpjZYicg
Excel Magic Trick 1466: Formulas For Start of Month & Number Days in Month From Any Date
Download Files: http://ift.tt/2y9sscu
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to create Formulas For Start of Month & Number Days in Month From Any Date using the EOMONTH and EDATE Functions.
Introduction to Busn 216 Computer Applications for Business People & Canvas Web Sites
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Topics in this video:
1. (00:01) Introduction
2. (00:14) Look at our āPeople Web Siteā
3. (00:36) Review some parts of syllabus
4. (14:48) How Videos work & how to download files
5. (18:01) Change Settings in Google Chrome Browser so you can use Save As to save your files
6. (19:30) Look at our āCanvas Web Siteā
7. (21:31) Summary
Office 2016 Video #03: Build Logical System of Folders to Manage Files
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:24) Example of Logical System of folders to organize files
3. (02:53) Create System of Folders for our class
4. (13:32) Importance of correct names for Test Folders
5. (14:53) Hint about Test #1
6. (16:17) Change Download settings in Chrome Browser
7. (18:48) Summary
Office 2016 Video #02: Windows Explorer for File Management
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. ( Create folders
3. Rename files and folders
4. Copy and paste files or folders
5. Move files or folders
6. Delete files or folders
7. Verify Downloads
8. Backup your files
9. Download pictures from your phone
10. Compress Folder
11. () Summary
Office 2016 Video #01: Introduction to Office 2016 & Windows Explorer
Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download notes: http://ift.tt/2hkt3kk
Class web page link: http://ift.tt/2hnnuOo
Topics in this video:
1. (00:01) Introduction
2. (00:28) Programs/Apps (application software)
3. (02:32) Task Bar
4. (02:56) Operating Systems
5. (03:11) Start Button
6. (05:23) USB Flash Drive
7. (05:58) Introduction to Windows Explorer
8. (09:34) Deleting a File or Folder and the Delete Key
9. (10:40) Folders and Keyboard for creating New Folder
10. (10:55) Naming files and folders
11. (16:02 and 39:22) Title Bar
12. (16:22) File menu: Backstage View
13. (19:36) Ribbon
14. (22:08) Status Bar
15. (23:00) Save and Save As
16. (25:01) Files and File Extensions
17. (31:56) Showing File Extensions
18. (36:09) Macro = m in file names
19. (39:39) Size of buttons in Ribbon keep changing!?!?
20. (41:24) Summary
Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word “Holiday”
Download Files: http://ift.tt/2fjT82j
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to apply Conditional Formatting with a Logical Formula so that dates in a list that are holiday lists show up with the word āHolidayā and with red fill and white font. See the Excel Spreadsheet Function: the MATCH function. Also learn about how to use Custom Number Formatting to show words or text instead of the actual date.
Excel Magic Trick 1464: Is Item In List? Formula to Check if Item is in a List on Separate Sheet.
Download Files: http://ift.tt/2wcZVBU
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to check whether or not an item in is a list using the MATCH Function. Learn three different formula that may work for your situation:
1. (00:11) Introduction
2. (00:53) Excel New Windows & Arrange All features to show different sheets in same workbook on screen at same time.
3. (02:54) Formula #1 to check whether item is in a list using MATCH and ISNUMBER functions.
4. (06:14) Formula #2 to check whether item is NOT in a list using MATCH and ISNA functions.
5. (07:13) Formula #3 to check whether item is in a list using IF and MATCH and ISNUMBER functions. This formula puts the text āFoundā or āNot Foundā in cell.
6. (08:30) Conclusion