Course Outline - MS Excel advanced

Table as a Database
How to prepare data for processing (rules and requirements)
Saparate Text to Columns, Transpose the table
External sources
Find duplicate data
Sorting and filtering (Multiple, custom Sorting, Advanced Filter)
Consolidate, Subtotal and Group
PivotTable and PivotChart
Solver Add-in
Scenarios
Tracking changes – Revisions
Lock, Password protect saved files/worksheets
Form Controls
Introducing the automation
Macro Recorder, VBA code