Microsoft Excel Training Courses: Excel courses in London & UK

Microsoft Excel 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 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 ADVANCED TRAINING COURSE CONTENT DURATION - 1 DAY

Next Scheduled Course Date

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

EXCEL 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

REPORT MANAGER

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

Sharepoint Training

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

How to find us

Premier's most popular courses:

SharePoint 2007 Power User
Microsoft Project Training
Prince2 Practitioner
Excel VBA Training
Sharepoint Designer
Visio Flowcharting