Advanced Microsoft Excel Spreadsheets
Introduction & Review
Efficient Spreadsheet Design, Review Basic Spreadsheet Development
Splitting and Freezing Windows
Formatting, Functions & Formulae
Review Basic Functions, Time/Date Functions, Text Functions, Nesting Functions, Conditional Formatting, The IF Function, Cell Comments, Copy, Paste and Paste Special, Sorting, Multiple Column Sorts (Custom Sort)
Spreadsheet Database Features
Lists, Advanced Filtering, Lookup Functions, Pivot Tables Review
Multiple Sheets/Files
Review Multiple Sheets, Linking Sheets, Importing, Hiding Rows & Columns, Worksheet & Workbook Protection
Analysing Data
Creating Scenarios, Using, Editing and Deleting Scenarios
Advanced Charts
Review of Creating a Chart, Advanced Chart Options
Auditing
Tracking Precedent and Dependent Cells
Excel Macros
Creating a macro, running a macro
Speaker
-
Geraldine Meskill