This course covers a comprehensive introduction to Excel's capabilities with Worksheet Formulas & Functions, PivotTables, Slicers, Charts, and Excel Tables. The learning outcomes include understanding various Excel formulas, PivotTable features, data analysis tools, and chart visualization techniques. Students will learn individual skills such as creating dynamic formulas, utilizing PivotTables for data analysis, and visualizing data trends through charts. The teaching method involves video tutorials with practical examples and demonstrations. This course is intended for individuals looking to enhance their Excel skills, particularly in data analysis and visualization.
Overview
Syllabus
) Introduction.
) Calculations in Excel.
) Worksheet formulas definition and elements.
) Example of Number Formula.
) ROUND function.
) How Number Formatting Interacts with Numbers and Formulas.
) Example of Text Formula.
) TEXTBEFORE function.
) FORMULATEXT function.
) IFNA function.
) Show Nothing with a Formula using Zero Length Text String “”.
) Example of Logical Formula using Comparative Operators.
) Don’t Get Tricked By Number Formatting.
) Alt Keyboard Shortcuts.
) Excel’s Golden Rule = Most Important Formula Tip.
) Excel Models.
) Percentage Number Format.
) Style Formatting.
) “Old School” Formula that Requires a Relative Cell Reference and a Manual Copy action..
) Angry Rabbit Copy Cursor.
) “New School” Formula that Spills Results.
) Dynamic Spilled Array Formula.
) Beauty of Excel. Bricklin and Frankston and VisiCalc..
) Summary of Worksheet Formulas and Excel Models.
) Define Data Analysis.
) Define Data, Table, Field, Record.
) Tools for Data Analysis.
) Data Analysis Goals for Video.
) Excel Table feature.
) Define PivotTable .
) PivotTable feature.
) Grouping Dates to create Month Report.
) PivotTable Cache.
) Change Report Layout, Manually and Default Settings.
) Calculations in Values Area of PivotTable.
) Number Formatting for PivotTable.
) Conditional Formatting in PivotTable.
) Add New Data to Excel Table and Refresh PivotTable.
) Default Settings For Expanding Excel Tables.
) Excel Line Chart to Show Sales Trends from a PivotTable.
) Formatting Chart.
) Rules for Visualizing with Charts.
) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends.
) Excel Data Analysis Tools Summary.
) Summary of Video.
) Closing and Video Links.
Taught by
ExcelIsFun
