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

Recap

Absolute references
Basic function creation methods
Formulae
Data entry and formatting
Date, Text, Number principles

Range Names

Concept and Purpose
Naming individual or range cells
Deleting and amending named ranges
Using named cells/ranges in formulae
Create Named Ranges and Cells
Manage Names (Setting Scope, Deleting, Renaming)
Navigate Named Ranges
Use names to Calculate
Use ranges in Functions
Paste Names
Filter Names

Formula Auditing Tools

Revealing Formulae
Tracing Precedents/Dependents
Goto Special
3D Calculations
Linking sheets in the same file
Linking different Excel files
Using Edit, Links
Viewing different files at once
Saving a workspace
Viewing different sheets at once
Window Split
Data consolidation

Conditional Functions & Formats and Date Calculations

Work with Styles
Use If Statements, Nested If
Use And, Or, Not
Nesting If, And, Or, Not
Use the Sumif , Countif, Averageif
Use the Sumifs, Countifs, Averageifs
Use the Iserror, Iferror functions
Apply Conditional Formatting
Date Calculations
Calculate working days
Use the DAY(),MONTH(),YEAR() functions
Create and use Time calculations

Formulae Auditing

Use the Formula Auditing Tools
Reveal Formulae (in a cell)
Trace Precedents/Dependents
Setting a Watch
Goto Special

Worksheet Management & Linking

Link sheets in the same workbook
Link cells in different Excel files
Manage and edit Links
View different files at same time
Saving a workspace
View different sheets at same time
Data consolidation (within same file)
Data consolidation (across workbooks)

Data List Management

Create an Excel data list
Use the Excel List Tools
Use Autofilter
Sort the Data
Use the Advanced Filter
Add Subtotals to a list
Apply Data Validation to keep data clean
Group and Outline your data
Use the Data Form

Excel Charts / Graphs

Create a Chart with keyboard
Use the Chart Wizard
Edit and Format a chart
Change the Chart source Data
Apply Trendlines
Use Sparklines
Change Charts from objects to sheets
Add labels and axes to chart
Show specific Data Points
Save custom chart types
Change the default chart type
Using the Chart Wizard
Editing and Formatting charts
Saving custom chart types
Setting a default chart typ

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