About the course
Use Formula Auditing tools to find and fix errors
Use Analysis tools
Create macros
Create permanent connections to external sources
Protect your data with Data Integrity tools
Use Linked Data Types
Create a dashboard using PivotTables, slicers and timelines
Audience Profile
Delegates who use Excel as a powerful analysis tool to regularly analyse complex data sets.
Delegates who are very familiar with Microsoft Excel and can use intermediate functions.
Formula Auditing
What is it?
Trace Precedents
Trace Dependents
Show Formulas
Error Checking
Evaluate Formula
Watch Window
Analysis Tools
Advanced Filter
Subtotal
What – If Analysis: Goal Seek
What – If Analysis: Data Tables
What – If Analysis: Scenario Manager
Analyze Data
Macros
Overview
VBA macros
Get Data
Overview
From Microsoft Access Database
From Web
Data Integrity
Data Validation
Password Protection
Data Types
Linked Data Types
Dashboard
PivotTables
PivotCharts
Slicers & Timelines
