You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf.  You will also see how you can create create superb visualisations using charts and maps.  The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.Outline is below: Conditional formatting Average function/Count Maximum function/Sum Minimum function/SumIF Basic Scenarios Sheet Layout and design Named Cells/Ranges Absolute Referencing/ percentages Basic Pivot Tables Using 3-D Referencing Goal Seek Data Tables Sheet and cell Protection Linking Sheets and Workbooks Using Array Formulae Using Group and Outline/Saving Views Naming Worksheets Using the Subtotals Feature Creating Templates Basic Lookups/Basic IF