Excel Business Analysis course content

Excel 2010 Data Analysis

Excel 2010  data analysisInstructor-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

  • Create a table and use structured referencing
  • Create a number of Pivot tables from one dataset
  • Consolidate data from several data sources into one Pivot Table
  • Add and manipulate a Pivot chart
  • Use data validation and concatenation
  • Use statistical functions for forecasting
  • Record and assign a basic macro
  • Be aware of Power Pivot and its capabilities

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