Excel 2010 Training

Delegates learn how to create, edit and enhance Excel 2010 charts, and use financial and logical functions. Learners will also gain hands-on experience using linking, consolidation of worksheets, and databases.

Microsoft Excel 2010 Courses

We offer a range of training courses on Microsoft Excel 2010, from Introduction through to Microsoft Excel VBA. Excel is one of our regular scheduled training courses which are held at our city of London training centre.

EXCEL 2010 INTERMEDIATE TRAINING COURSE CONTENT DURATION - 1 DAY

Module 1 - Review of Basics

Module 2 - File Linking
Creating links to other workbooks & worksheets
Updating links to other workbooks
Changing link paths

Module 3 - File Consolidation and 3D Worksheets
File consolidation
Selecting more than one worksheet
Formatting and data entry in 3D worksheets
Creating 3D formulas
Copying 3D formulas
Compare and merge Workbooks

Module 4 - Pivot Tables
Creating Pivot tables
Changing the Pivot table layout
Formatting
Producing reports
Manipulating query headings
Grouping and ungrouping data fields
Using Slicers

Module 5 - Absolute Cell Referencing
Distinguishing between absolute and partial cell addressing
Using absolute and partial cell addressing
Referencing in formulas

Module 6 - Advanced Formatting
Comments: adding, amending, deleting
Displaying Comments
Editing Comments

Module 7 - Conditional Formatting
Compare cells against one another
Format cells that match values or conditions
Manage conditional formatting rules
Using Sparklines

Module 8 - Passwording
Files & Worksheets
Ranges within worksheets
Allow users to edit ranges
Watch window

Module 9 – Managing Data
Building tables
Creating a table
Add a total row
Apply styles to a table
Removing Duplicates

Module 10 - Filtering Records
Filtering Records
Extracting Data
Custom Autofilter
Removing the Autofilter
Advanced filtering
Sorting Data

Module 11 - Working with Dates
Creating date series,
Calculations with dates
Date Functions

Module 12 - Working with Shapes and Pictures
Adding Shapes, Inserting Pictures and Adding Text
Using Smart Art
Working with Shapes
Formatting Shapes and Text
Using Screenshot Tool

Module 13 – Customising Excel
Customise the list of recently used files
Customise the Quick Access Toolbar
Customise the Popular Settings
Creating customised lists
Using customised lists

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk

Premier's London Training Centre
42 New Broad Street, EC2

How to find us

Premier's most popular courses:

Excel VBA Training
Microsoft Project Training
Prince2 Practitioner
Excel Advanced Training
Sharepoint Designer
Visio Flowcharting