Excel 2010 Advanced Training Course

Our Excel 2010 Advanced training course will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel 2010 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros.

We frequently get comments back from clients stating that they wish they attended our Excel 2010 Advanced course ages ago. It would have saved them so much time!

At Mouse Training, we can provide free TNA's and also create a bespoke Excel 2010 Advanced course to suit your exact needs. If you are not sure that this is the course you need, or would like to exclude/include more content, we are more than happy to do this. Remember, all our courses are closed courses, so you decide what you should know, not a pre-defined schedule.

So, if you need to save time, money and get more from your spreadsheets, let us be your learning partner. With clients such as HSBC, Google and many more, you can rest assured you will be getting the most from your investment on our Excel 2010 Advanced Training Course

Excel 2010 Advanced Training Course Info

Audience: This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros

Course Duration

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

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

Use Lookup & Informational Functions
Create Pivot Tables
Use What-If Tools
Sharing and Tracking Workbooks
Record Basic Macros

Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.

Course Duration

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

Course Locations / Schedule

This course can be run Onsite, at our 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 Advanced Training Course Contents

Recap Functions

If Statements
Nested If
And
Or
Not
Combining If, And, Or, Not
Sumif
Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)

Lookup and Information Functions

Match function
Index Function
ISTEXT, ISVALUE, ISDATE,ISNULL,ISERR, ISNA
IFERROR
Offset
Advanced List Management
Advanced Filter
Database Functions: Dsum, Dmin, Dmax, Daverage, Dcount

Summarising Data with Pivot Tables

Inserting calculated fields
Manipulating Fields
Changing Value Filed Settings
Using Report Filter
Grouping Data containing Dates and Numbers
Formatting Pivot Table
Showing and Hiding the Grand Totals
Refreshing Data In Pivot Table
Changing The Scope Of The Data source
Summarizing Values by Sum, Count, Average, Max, and Product
Show Values As % of Grand Total, % of Column Total, % of Row Total
Pivot Table Options
Using Slicers for Effective Filtering
Pivot Chart

General Analysis Tools

Scenarios
Custom Views
Goal Seek
Solver
Data Tables
One Input
Two Input

Protecting and Sharing

Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Protecting cells, sheets, files
Password protecting a file
Password protecting a cell range

Introduction to Macros

Displaying the Developer Tab
Review And Purpose Of Macros
Where To Save Macros
Absolute and relative record
Running macros: Assigning to Quick Access Toolbar, shpaes, Pictures and keyboard shortcuts

Templates