Excel 2010 Data Analysis
Instructor-led Excel 2010 Business Analysis course content
Duration: |
Intended audience: |
1 day |
Anyone who uses Excel 2010 for data analysis |
Aims: |
To offer alternative methods of using Excel by leveraging the enhanced capabilities of this version |
Objectives: |
By the end of the session delegates will be able to
|
Prerequisites: |
A good knowledge of Excel 2010 at Advanced level including an understanding of mathematics and databases |
Tables
Creating & formatting a table
Adding Totals
Extending columns
Adding data
Adding calculated fields
Structured References
Pivot Tables
Integration with Tables
Creating from scratch
Grouping
Refreshing
Adding calculated fields
Slicer Tool
Multiple Pivot Tables from one Dataset
Creating
Creating a basic dashboard
Multiple Consolidation Range Pivot Tables
Consolidation range Pivot table
Pivot Charts
Adding & formatting a chart
Chart layout
Data Validation
Adding a drop-down list
Combining data validation with a LOOKUP function
Statistical Functions
Statistical Data Analysis
Linear regression analysis
Enabling the Data Analysis Add-in
=LINEST function
Forecasting
Forecasting with a chart
=FORECAST function
=TREND function
=GROWTH function
=OFFSET function
=INDIRECT function
Macros
Recording a basic Macro
Relative and absolute macros
Power Pivot
An Introduction
Enabling the Add-in
Power Pivot Tables
If you prefer to learn from video tutorials we have a wide range of Excel 2010 and 2013 eLearning modules here
See also our Excel 2010 Advanced tutorials and Intermediate tutorials
3 short sessions useful as each one re-enforces learnings from the previous session (& less intense than fewer longer sessions). The gap between them wasn’t too long which was good
Jeremy, 121 Paddington