Microsoft Excel 2010 Training Course Advanced Heathrow

Heathrow Advanced Microsoft Excel 2010 Course Overview

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a Microsoft Excel 2010 Training Course Advanced training course near Heathrow airport could be the ideal solution.

The Microsoft Excel 2010 Training Course Advanced course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Advanced Excel training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.

Course Duration: 1 Day

Course Prerequisites for your training in Heathrow

Before undertaking this course it would be good if you are at an Intermediate Level in Excel. With an understanding of Pivot Tables, Tables, VLookup. You should be comfortable using functions with a basic understanding of function arguments and using function in conjunction with each other.

Complete Course Outline

Streamlining Workflow using Microsoft Excel 2010

• Update Workbook Properties
• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

Collaborating with Other Users in Excel 2010

• Protect Files
• Share a Workbook
• Set Review Tracking
• Review Tracked Changes
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Auditing Worksheets using Excel 2010

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Analyzing Data in Excel 2010

• Create a Trendline
• Create Sparklines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks in Excel 2010

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Importing and Exporting Data using Excel 2010

• Export Excel Data
• Import a Delimited Text File

Integrating Excel Data with the Web

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Structuring Workbooks with XML using Excel 2010

• Develop XML Maps
• Import and Export XML Data

Have a look at our range of Excel Training Courses

Why not take your Excel skills up yet another level, with our VBA for Excel Training Course. Show your work colleagues who's the real Excel guru.

Other training courses you may be interested in:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Microsoft Excel 2010 VBA Training Course - Beginners

Intermediate Microsoft Excel 2010 Training Course

Or if you need to get back to basics

Beginners Microsoft Excel 2010 Training Course

Microsoft Excel 2013 Training Course Advanced