### Office 2016 Video #04: Introduction to Word 2016: 20 Important Tips for Efficiency

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Topics in this video:
1. (00:01) Introduction
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
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
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
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)

### Excel Magic Trick 1466: Formulas For Start of Month & Number Days in Month From Any Date

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
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.
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
7. (18:48) Summary

### Office 2016 Video #02: Windows Explorer for File Management

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
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
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.
Topics in this video:
1. (00:01) Introduction
2. (00:28) Programs/Apps (application software)
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”

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.

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

### Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?

Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to create a single cell Array Formula to calculate Total Sales from a Column of Units Sold and a column of Prices (5,000 transactions). See how to use SUMPRODUCT function to calculate the unrounded total, and see how to use the ROUND and SUMPRODUCT function to calculate the rounded total. Learn about the basics of Array Formulas.

### Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each?

Excel, Excel 2016, Highline College, Mike Girvin, excelisfun, Excel Magic Trick, Ctrl + D, Ctrl + Enter, Copy Quickly Down Column, Excel keyboard shortcuts, Copy Formula Down Column, Excel Keyboards, Keyboard shortcuts in Excel, What does Ctrl + Enter Do?, What does Ctrl + D do?, Excel Ctrl Enter, Excel Ctrl D, Fill Down, Populate highlighted cells with edited formula