Excel & Business Math Class taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Download Excel File: http://ift.tt/2Bja2Ic
Download pdf Notes: http://ift.tt/2z0ULFQ
Entire Class Web Site: http://ift.tt/2BjafuY
Topics in Video:
1. (00:01) Introduction
2. (00:34) Class Web Site, Class Files & USB Drive to store files from class
3. (01:56) Download Excel & pdf Files. Look at different Browsers: Chrome, Internet Explorer, Mozilla
4. (03:05) Create Folder & Save Files using Save As & Windows Explorer
5. (05:49) Why we use Excel for Business Math
6. (09:46) Conventions for Class
7. (13:18) What does Excel do?
8. (14:35) Excel Workbook Layout
9. (17:38) Move Between Sheets
10. (19:00) Zoom in and out = Ctrl + Roll Wheel on Mouse
11. (20:00) Ribbon Tabs
12. (20:38) QAT – Quick Access Toolbar
13. (21:20) First Excel Formula: Total Sales
14. (31:33) Selecting a Range with the Selection Cursor
15. (31:40) Number Formatting as a Façade to display numbers in a different way that the Actual Number in the cell
16. (34:06) Second Excel Formula: Net Income. Also see how to copy a formula to the side (not down a column)
17. (35:32) Verify that Number Formatting is NOT misleading
18. (36:52) Review PDF Notes ()
19. (37:52) Summary
Next Video: Excel & Business Math 02