Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

Microsoft Excel Intermediate Training Course

Microsoft  Excel Training Courses

This Microsoft Excel Intermediate training course is intended for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel Introduction course and wish to increase their skills.

 

The course will show delegates how to use multiple worksheets and workbooks efficiently, working with more advanced formatting options including styles, themes & backgrounds and watermarks.

 

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

 

Course Type: In- House, Instructor led.

 

Duration: 1 day

 

Target Audience

This Microsoft Excel Intermediate training course is intended for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel Introduction course and wish to increase their skills.

 

Course Content

 

(Content may vary depending on software version)

 

Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas

 

Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas

 

Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions

 

Module 4: Sorting, Outlining and Grouping Data
Using Sort and Filter
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Advanced Filtering

 

Module 5: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Transposing Data
Converting Text to Columns

 

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

Interactive Dashboards Using Microsoft Excel

An Excel Dashboard provides analysis and insight into what is happening in your business. They summarise large data sets in real time. If you are required to report complex information such as...

In House Microsoft Excel VBA Training Course

By learning to write Excel VBA code, repetitive and tedious tasks in Microsoft Excel can be performed quickly and accurately. The result is increased efficiency, performance & productivity which...

Microsoft Excel Advanced Training Course

On this Microsoft Excel training course you will work with advanced database management, database functions, data validation & protection. You will learn how to work with PivotTables and...

Microsoft Excel Introduction Training Course

This course is for new or users with little Excel experience. The course is designed to introduce the basic concepts of an excel spreadsheet. We look at spreadsheet terminology and become familiar...