Excel Formulas & Functions, PivotTables, Slicers & Charts

) 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.