Microsoft Excel Training Courses: Excel courses in London & UK

	Home \| Training \| Solutions \|Contact Us t: +44(0)20 7729 1811
About Us \| IT Training \| Financial Training \| Management Training \|Delegate Information

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

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

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