Excel 2010/13/16 Advanced

Prerequisite: Has attended an Excel Intermediate course or have equivalent knowledge.

Duration: One day

Course Topics

Linking Workbooks
* Linking data
* Linking spreadsheets and workbooks by formulas
* Creating links with paste special
* Consolidating data from multiple sheets and workbooks
* Array formulas

Advanced list management
* Custom filters
* Advanced filtering
* Filters and charts
* Filters and the Autosum button

Database functions
* Dcount
* Dsum
* Daverage

Data Analysis Tools
* Scenario manager
* Goal seek
* Solver

Auditing features
* Spreadsheet auditing
* Tracing precedent and dependent formulas
* Trace errors
* Cell comments
* Sharing / track changes

Advanced data management
* Data validation
* Conditional formatting
* Creating reports
* Group and outline
* Custom views
* Report manager

External data
* Importing data from Access
* Web queries