The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

) What is Excel?.
) What does Excel do? 1) Calculations, 2) Storing & Formatting Data, 3) Data Analysis.
) Formatting to make our Data Look Good. Build a Template that you can use over and over..
) See how to create a List of Days of the Week Quickly using the "Angry Rabbit"..
) Formulas & Cell References to make our Job Easier! Learn about the Excel Functions: SUM, AVERAGE, MAX and MIN..
) Keyboard Shortcuts are Amazing. Learn how to highlight 5000 rows of data quickly..
) Payroll Tax Calculations Hard? Not With Excel : ).
) Relative Cell References in Formulas.
) Absolute Cell References in Formulas.
) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features..
) Chart Your Results Dynamically!! Learn how to create a Column Chart for visualizing the difference across Categories..
) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable..
) Flash Fill to "Clean Your Data" in Seconds!.
) Summary of all topics..