excelisfun | Excel Formulas & Functions, PivotTables, Slicers & Charts - 365 MECS 02 @excelisfun | Uploaded 2 years ago | Updated 17 hours ago
Download Excel File: https://excelisfun.net/files/02-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/02-M365ExcelClass.pdf
Comprehensive introduction to what Excel can do with Worksheet Formulas & Functions, PivotTables, Slicers, Charts and Excel Tables. This is M365 Excel Video 2.
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:56) Calculations in Excel
3. (02:25) Worksheet formulas definition and elements
4. (03:00) Example of Number Formula
5. (05:07) ROUND function
6. (09:18) How Number Formatting Interacts with Numbers and Formulas
7. (13:22) Example of Text Formula
8. (14:01) TEXTBEFORE function
9. (18:02) FORMULATEXT function
10. (19:02) IFNA function
11. (19:37) Show Nothing with a Formula using Zero Length Text String
12. (20:44) Example of Logical Formula using Comparative Operators
13. (22:46) Dont Get Tricked By Number Formatting
14. (24:54) Alt Keyboard Shortcuts
15. (25:56) Excels Golden Rule = Most Important Formula Tip
16. (27:53) Excel Models
17. (29:26) Percentage Number Format
18. (32:09) Style Formatting
19. (33:14) Old School Formula that Requires a Relative Cell Reference and a Manual Copy action.
20. (34:23) Angry Rabbit Copy Cursor
21. (35:37) New School Formula that Spills Results
22. (36:53) Dynamic Spilled Array Formula
23. (38:56) Beauty of Excel. Bricklin and Frankston and VisiCalc.
24. (39:39) Summary of Worksheet Formulas and Excel Models
25. (40:02) Define Data Analysis
26. (42:31) Define Data, Table, Field, Record
27. (45:07) Tools for Data Analysis
28. (45:40) Data Analysis Goals for Video
29. (45:52) Excel Table feature
30. (48:00) Define PivotTable
31. (49:24) PivotTable feature
32. (51:40) Grouping Dates to create Month Report
33. (52:02) PivotTable Cache
34. (53:12) Change Report Layout, Manually and Default Settings
35. (54:36) Calculations in Values Area of PivotTable
36. (56:36) Number Formatting for PivotTable
37. (59:13) Conditional Formatting in PivotTable
38. (01:01:13) Add New Data to Excel Table and Refresh PivotTable
39. (01:02:56) Default Settings For Expanding Excel Tables
40. (01:03:27) Excel Line Chart to Show Sales Trends from a PivotTable
41. (01:04:55) Formatting Chart
42. (01:05:25) Rules for Visualizing with Charts
43. (01:09:56) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends
44. (01:12:07) Excel Data Analysis Tools Summary
45. (01:12:44) Summary of Video
46. (01:13:13) 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
#formulas
#pivottables
#slicers
#charts
#M365ExcelVideo2
#MECS2
#EasyPivotTable
#PivotTableReports
#ChartinginExcel
#WorksheetFormulas
#Formulasmadeasy
#LearnExcelFormulas
#FormulasandFunctions
#BuildingExcelModels
#ExcelsGoldenRule
#conditionalformatting
#TypesofFormulas
#NumberFormattingandFormulas
#BeautyofExcel
#freeclass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#visualization
#excelbasics
#excelformulaforjobinterview
#excelforbeginners
#excelforbeginner
#freeexcelcourse
#excelisfun
Download Excel File: https://excelisfun.net/files/02-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/02-M365ExcelClass.pdf
Comprehensive introduction to what Excel can do with Worksheet Formulas & Functions, PivotTables, Slicers, Charts and Excel Tables. This is M365 Excel Video 2.
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:56) Calculations in Excel
3. (02:25) Worksheet formulas definition and elements
4. (03:00) Example of Number Formula
5. (05:07) ROUND function
6. (09:18) How Number Formatting Interacts with Numbers and Formulas
7. (13:22) Example of Text Formula
8. (14:01) TEXTBEFORE function
9. (18:02) FORMULATEXT function
10. (19:02) IFNA function
11. (19:37) Show Nothing with a Formula using Zero Length Text String
12. (20:44) Example of Logical Formula using Comparative Operators
13. (22:46) Dont Get Tricked By Number Formatting
14. (24:54) Alt Keyboard Shortcuts
15. (25:56) Excels Golden Rule = Most Important Formula Tip
16. (27:53) Excel Models
17. (29:26) Percentage Number Format
18. (32:09) Style Formatting
19. (33:14) Old School Formula that Requires a Relative Cell Reference and a Manual Copy action.
20. (34:23) Angry Rabbit Copy Cursor
21. (35:37) New School Formula that Spills Results
22. (36:53) Dynamic Spilled Array Formula
23. (38:56) Beauty of Excel. Bricklin and Frankston and VisiCalc.
24. (39:39) Summary of Worksheet Formulas and Excel Models
25. (40:02) Define Data Analysis
26. (42:31) Define Data, Table, Field, Record
27. (45:07) Tools for Data Analysis
28. (45:40) Data Analysis Goals for Video
29. (45:52) Excel Table feature
30. (48:00) Define PivotTable
31. (49:24) PivotTable feature
32. (51:40) Grouping Dates to create Month Report
33. (52:02) PivotTable Cache
34. (53:12) Change Report Layout, Manually and Default Settings
35. (54:36) Calculations in Values Area of PivotTable
36. (56:36) Number Formatting for PivotTable
37. (59:13) Conditional Formatting in PivotTable
38. (01:01:13) Add New Data to Excel Table and Refresh PivotTable
39. (01:02:56) Default Settings For Expanding Excel Tables
40. (01:03:27) Excel Line Chart to Show Sales Trends from a PivotTable
41. (01:04:55) Formatting Chart
42. (01:05:25) Rules for Visualizing with Charts
43. (01:09:56) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends
44. (01:12:07) Excel Data Analysis Tools Summary
45. (01:12:44) Summary of Video
46. (01:13:13) 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
#formulas
#pivottables
#slicers
#charts
#M365ExcelVideo2
#MECS2
#EasyPivotTable
#PivotTableReports
#ChartinginExcel
#WorksheetFormulas
#Formulasmadeasy
#LearnExcelFormulas
#FormulasandFunctions
#BuildingExcelModels
#ExcelsGoldenRule
#conditionalformatting
#TypesofFormulas
#NumberFormattingandFormulas
#BeautyofExcel
#freeclass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#visualization
#excelbasics
#excelformulaforjobinterview
#excelforbeginners
#excelforbeginner
#freeexcelcourse
#excelisfun
