Microsoft Excel 2010 Advanced Training

This course introduces techniques for enhancing, customising and automating Excel worksheets. It includes tasks such as advanced functions, pivot tables, macros, auditing and analytical tools.

Microsoft Excel 2010 Courses

We offer a range of training courses on Microsoft Excel, from Introduction through to Microsoft Excel VBA. Excel is one of our regular scheduled training courses held at our city of London training centre.We can also offer in-house Excel training courses throughout the UK.

EXCEL 2010 FUNCTIONS
If statements
Text functions
Date and time
Look up tables
Sub totals
Conditional Sum Wizard
Lookup Wizard

EXCEL 2010 TEMPLATES
Creating
Accessing
Editing

DATABASES
Creating
Sorting
Using Forms
Using the Auto Filter
Advanced filters

AUDITING A WORKBOOK
Checking data for errors
Finding data precedents
Finding formula dependants
Error Checking
Formula Auditing Mode

PIVOT TABLES
Creating Pivot tables
Producing reports
Manipulating query headings
Grouping and ungrouping data fields

IMPORT AND EXPORTING DATA
Copy and paste
Paste special
Paste link

MACROS
Overview of macros/VBA
Recording a macro
Running macros
Assigning macros to buttons
Simple editing of macros

EXCEL'S ANALYTICAL TOOLS
Goal seek
Scenarios
Solver
2 & 1 way input tables
Report manager
Data Analysis Tools

Related Courses:

Finance for Non-Financial Managers

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