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
Month: September 2017
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
Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?
Download Files: http://ift.tt/2xWBRR3
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
Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula
Download Files: http://ift.tt/2eLv1WF
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn how to look up an item in a list of items and list all the relative positions for that item in a single cell. See the functions TEXTJOIN, IF, ISNA, MATCH. See extensive discussion about Array Formulas. Learn different Formula Element options for listing all relative positions in a formula.