excelisfun | Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01 @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/01-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/01-M365ExcelClass.pdf
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Topics in video:
1. (00:00) Introduction
2. (00:14) Intro Song
3. (00:22) Download Files and Create Class Folder
4. (01:45) Change File Extensions in Windows Explorer
5. (02:30) Color Coding Conventions for Class
6. (04:46) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7. (06:17) Naming Convention for all objects in class
8. (07:38) Tabs in the Excel Ribbon
9. (08:26) Quick Access Toolbar = QAT. Build Custom QAT
10. (11:04) Navigating through Workbook
11. (12:26) Keyboards: Desktop or Laptop?
12. (13:36) Keyboard Shortcuts
13. (16:41) First Formula: SUM function using a keyboard
14. (18:27) Cursors
15. (18:37) Data & Alignment and how Default Alignment Helps
16. (19:42) Second and Third Formulas yield an error
17. (20:59) Why Default Alignment is important: Fourth & Fifth Formulas
18. (22:10) Default Alignment to track down errors
19. (23:50) Dont Use Center Alignment!!!
20. (25:09) What Excel Does: Hold Data, Calculations and Data Analysis
21. (27:00) Summary
22. (27:22) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/
#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#freeclass
#freecourse
#FoundationofExcel
#EfficientExcel
#365MECS01Part2
#365MicrosoftExcelCompleteClass
#LaptopFunctionKeys
#AccessFKeys
#LapTopFkeysnotwork
#LaptopFkeysnotwork.FunctionKeysLaptop
#ChangeSettingforFKeys
#ChangeDefaultSettingsforLaptopfunctionkeys
#RadosawPoprawski
#F2EditMode
#F4CellReferences
#F12SaveAs
#FreeClass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#excelbasics
#excelforbeginner
#excelformulaforjobinterview
#excelforbegginers
Download Excel File: https://excelisfun.net/files/01-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/01-M365ExcelClass.pdf
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Topics in video:
1. (00:00) Introduction
2. (00:14) Intro Song
3. (00:22) Download Files and Create Class Folder
4. (01:45) Change File Extensions in Windows Explorer
5. (02:30) Color Coding Conventions for Class
6. (04:46) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7. (06:17) Naming Convention for all objects in class
8. (07:38) Tabs in the Excel Ribbon
9. (08:26) Quick Access Toolbar = QAT. Build Custom QAT
10. (11:04) Navigating through Workbook
11. (12:26) Keyboards: Desktop or Laptop?
12. (13:36) Keyboard Shortcuts
13. (16:41) First Formula: SUM function using a keyboard
14. (18:27) Cursors
15. (18:37) Data & Alignment and how Default Alignment Helps
16. (19:42) Second and Third Formulas yield an error
17. (20:59) Why Default Alignment is important: Fourth & Fifth Formulas
18. (22:10) Default Alignment to track down errors
19. (23:50) Dont Use Center Alignment!!!
20. (25:09) What Excel Does: Hold Data, Calculations and Data Analysis
21. (27:00) Summary
22. (27:22) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/
#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#freeclass
#freecourse
#FoundationofExcel
#EfficientExcel
#365MECS01Part2
#365MicrosoftExcelCompleteClass
#LaptopFunctionKeys
#AccessFKeys
#LapTopFkeysnotwork
#LaptopFkeysnotwork.FunctionKeysLaptop
#ChangeSettingforFKeys
#ChangeDefaultSettingsforLaptopfunctionkeys
#RadosawPoprawski
#F2EditMode
#F4CellReferences
#F12SaveAs
#FreeClass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#excelbasics
#excelforbeginner
#excelformulaforjobinterview
#excelforbegginers
