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

Lookup & Information Functions

Build the Vertical Lookup (Vlookup) function
Build the Horizontal Lookup (Hlookup) function
Build the Match and Index functions
Build the IsText, IsValue, IsDate , IsNull , IsErr, IsNa functions
Build and use Database Functions

Pivot Tables

Create A PivotTable
Change the PivotTable layout
Manipulate PivotTable fields
Format the PivotTable and apply Styles
Use Banding (Formatting)
Group & Ungroup items
Filter data in the PivotTable
Insert calculated fields
Change calculation options
Change PivotTable Options
Display and hide data in fields
Lay out reports on worksheet
Create a PivotChart from report
Manipulate PivotChart fields
Use Slicers

What If Analysis

Create and manipulate Scenarios
Create and change Custom Views
Build scenario Reports
Use the Goal Seek tool
Use Solver & Advanced Solver Features
Build Data Tables

Protecting & Sharing Files

Share a file
Track changes
Accept or reject changes
View Change history
Apply Data validation rules
Insert, edit and delete comments

Introduction to Macros

Review the purpose of Macros
Record a macro
Save a macro
Edit a Macro
Absolute and relative records
Running macros:
Apply macro to Custom buttons on the Ribbon or Quick Access toolbar, keyboard shortcuts

Customising Excel

Customise the Quick Access Toolbar and Ribbons
Set Workbook options
Change workbook defaults

Templates

View Template Types
Use Normal Template
Open Sample Templates
Create Custom Templates
Use Custom and online Templates
Open And Edit Templates
Setting Template Properties

Objects In Excel

Insert, Format And Delete Objects
Insert A Drawing Object
Use the design ribbon
Use SmartArt
Apply Formatting to SmartArt
Use QuickStyles
Explore 2D And 3D Formatting
Insert and use WordArt
Insert and Format Shapes
More on Themes and styles
Manually Format an object
Customise or create A Them

**You are able to include/exclude as much content as you need to create your own Excel 2010 Advanced Training Course**