Overview & Prerequisite

This Microsoft Excel 2010 Training course is aimed at those who have a very good understanding of Excel 2010 at a Foundation level.

Knowledge of the following topics will be assumed:

Basic Formula, Relative Reference, Absolute Reference, Page Setup & Presentation.

Course content

Getting Started with 2010
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
Microsoft Back Office replaces the File menu
Customise the Ribbon!

Multiple Sheets
Moving Around
Selection Techniques
Inserting
Deleting
Copying
Fill by Example
Group Mode
Consolidation

Template
Create
Modify
Save
Auto templates
Using templates
Inserting templates

Protection
Cell Protection
Sheet Protection
Workbook Protection
File Protection
Multi-user access

Book Now or Enquire

File Linking
External Reference
Dependant Workbook
Source Workbook
Update Links

Printing
View Manager
PageLayout View
Print Manager

Lists
Forms
Custom Filtering
Advanced Filtering
Subtotals

Charts
Creating Charts
Autotemplate

New Features of Excel 2010

New General Features
Increased Capacity
Office Backstage View
More Templates
File Types
New Formatting Features
Galleries
Conditional Formatting
New Formula Features
Resizable Formula Bar
AutoComplete
Name Manager
New Analysis Features
Excel Tables
Filtering and Sorting
New Proofing Features
Page Layout View
SparkLines
Slicers

Book Now or Enquire