Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01
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) Don’t 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
#RadosławPoprawski
#F2EditMode
#F4CellReferences
#F12SaveAs
#FreeClass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#excelbasics
#excelforbeginner
#excelformulaforjobinterview
#excelforbegginers
Видео Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01 канала ExcelIsFun
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) Don’t 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
#RadosławPoprawski
#F2EditMode
#F4CellReferences
#F12SaveAs
#FreeClass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#excelbasics
#excelforbeginner
#excelformulaforjobinterview
#excelforbegginers
Видео Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01 канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big DataIntroduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, RatioSpilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different CountriesMSPTDA 08.5: Power Query Group By Unique List or Consecutive OccurrencesMSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to ExcelMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeOffice 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/ConditionsHighline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.E-DAB 01: What is Data Analysis & Business Intelligence?E-DAB 09: Power BI Desktop: Data Modeling & Interactive VisualizationsHighline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUPMicrosoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain VariablesE-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards