Introduction and Review: What’s New in Excel 2010, Efficient Spreadsheet Design, Review Basic Spreadsheet Development – Formulas, Cell Referencing, Formatting, Tools Options, Task Panes, Smart Tags and Options button Functions Review Basic Functions, Statistical Functions, Time / Date Functions, Text Functions, Nesting Functions, Conditional Formatting with Functions Multiple Sheets / Files Review Multiple Sheets, Grouping Sheets, Linking Sheets, Workbook Features Consolidation Building a Consolidation, Creating Consolidation Links Data Validation and Auditing Limiting Entries into a Cell, Creating a Drop Down List, Data Validation and Functions, Circling Invalid Data, Tracing Precedent and Dependent Cells Analysing Data Creating Data Tables for What-If Analysis, Building a Scenario, Multiple Scenarios, Summary Scenarios, Using Goal Seek and Solver Spreadsheet Database Features Advanced Filtering, Database Functions, Lookup Functions, Pivot Tables Review – Creating and Updating the Table, Changing the Table Structure, Creating Charts from the Data, Grouping Options , Pivot Table Options, On / Off Subtotals, Calculated Items, Showing / Hiding Fields, Slicers Advanced Charts Review of Creating a Chart, Advanced Chart Options, Advanced Formatting, Adding Trend lines, User Defined Charts Customising the Work Area Creating a Template, Using a Template, Styles, Custom Toolbars Sharing Workbooks Tracking Changes Options, etc