Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

In House Microsoft Excel Intermediate Training Course

Microsoft  Excel Training Courses

 

You will also learn how manage an Excel database including sorting, filtering and creating subtotals. You will learn to simplify formulas by creating and applying cell names as well as applying advanced charting techniques

 

This course package includes free Training Needs Analysis (TNA) for Microsoft Excel  using Gmetrix testing software to assess training  requirements. For more details, see our TNA page or call us 0161 408 0435.

 

Versions: 2007, 2010, 2013

 

Course Type: In- House, Instructor led.

 

Duration: 1 day

 

Target Audience

The target student for this course should be comfortable using a personal computer and Microsoft Windows . You should have some experience using Microsoft Excel, preferably our Microsoft Excel Introduction Training Course.

 

Course Content

 

(Content may vary depending on software version)

Module 1: Advanced Formula Tasks

Module 4: Sorting, Outlining and Grouping Data

Understanding Relative and Absolute Cell References

Using Sort and Filter

Using Multiple Cell References

Outlining Data

Using 3D References

Showing and Hiding Outline Details

Using Array Formulas

Grouping Data

 

Creating Subtotals

Module 2: Working with Named Ranges

Removing Outlining and Grouping

Understanding Named Ranges

Advanced Filtering

Defining Named Ranges

 

Editing Named Ranges

 

Deleting Named Ranges

Module 5: Managing Data

Using Named Ranges in Formulas

Consolidating Information

 

Removing Duplicates

Module 3: Using Advanced Functions

Configuring Data Validation

Using the PMT Function

Transposing Data

Using the FV Function

Converting Text to Columns

Using VLOOKUP and HLOOKUP Functions

 

Using IF, AND, OR Functions

Module 6: Charting Data

 

Creating Sparklines

 

Inserting Charts

 

Create a combination chart with a secondary axis

 

Add a Trend or Moving Average Line

Related Courses

 

In House Training Courses