Excel 2010 Intermediate Training Course

Our Excel 2010 Intermediate course will build on your current Excel skills. The course will focus more on Excel Functions, Worksheet Management, Working with Lists and Charting your data. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.

This is one of our most popular Excel 2010 courses, as most users of Excel never need to use more complex functions or advanced data manipulation. The Excel 2010 intermediate course covers most uses of Excel, including functions, list management (Filters, Sorting etc), working across multiple sheets and charting your data.

If you are not quite sure if this is the correct level of course for you, please contact us. As part of our standard service offering, we do a free Training Needs Analysis and can also create a tailored or bespoke Excel 2010 intermediate course that could cover more of the basics or advanced topics as required.

Mouse Training is run by trainers, so our primary objective is to provide you with the tools you need, not others. We can also run your Excel 2010 intermediate course onsite and provide all the training equipment too!

Excel 2010 Intermediate Training Course Info

Audience: This Excel intermediate course will build on your basic Excel skills and show you more complex formulae, how to build formulae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.

Course Duration

This is a 1 day Excel 2010 Intermediate Course. Course starts at 09:30 and runs until 16:30

Excel 2010 Intermediate Course Objectives: After the course, you will be able to:

Use Logical Functions, Financial and Statistical Functions
Nest Functions
Multiple Worksheet Management and Formulae
Create Charts
Protect Worksheets & Workbooks

Requirements: To get the most from this course, you must be able to perform basic Excel actions and create formulae and functions.

Course Duration

This is a 1 day Excel 2010 Intermediate Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our London Excel 2010 training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel 2010 Intermediate Training Course Contents

Recapping Basics

Absolute, Relative References Basic calculations

Recap Linking

Inserting and deleting sheets
Changing the default number of workbook sheets

Naming Cell Ranges

Concept And Purpose
Naming Individual Cells
Naming Range Of Cells
Deleting And Amending Named Ranges
Using Name Ranges in Formulae/Functions
Named Ranges As Navigation Aid

Linking Sheets and Files

Changing the default number of workbook sheets
3D Calculations
Linking sheets in the same file
Linking different Excel files
Using Edit, Links
Viewing Different Files On One Screen
Saving a workspace
Window Split
Freeze Panes
Viewing Different Parts Of The Sheet On One Screen
Watch Window

Conditional Functions

Benefits And Purpose
IF Statements
Nested If
SUMIF And SUMIFS
AVERAGEIF And AVERAGEIFS
COUNTIF and COUNTIFS
ISERROR And IFERROR
Nesting IF WITH AND, OR

Applying and Managing Conditional Formatting

Data Bars
Colour Scales
Icon Sets
Top/Bottom

Basic Lookup Functions

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)

Essential List Management

Sorting Data (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Sort
Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Filter
Advanced Filter
Adding Subtotals
Freeze Panes
Group and Outline
Data Form
Format As Table Feature
Data Consolidation

Formulae Auditing Formula View

Tracing Precedents
Tracing Dependents
Using Watch Window
Go To Special…

Charts/Graphs Advanced Techniques

Creating Chart Using Shortcut Keys
Saving Custom Chart as Templates
Setting Chart as Default
Applying Trendlines
Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc...
Using Sparklines (Line, Column, Win/Loss)

**All the Excel 2010 intermediate course content above can be tailored by adding more basic or advanced functionality**