Microsoft Excel 2010 Training Course Advanced Luton

This course teaches you how to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. You will learn how to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

After completing this course you will have learnt how to enhance productivity and efficiency by streamlining the workflow, collaborate with other workbook users, audit worksheets, analyze data, work with multiple workbooks, import and export data, integrate Excel data with the web and structure workbooks with XML.

Microsoft Excel 2010 Training Course (Advanced) Outline - Luton

Streamlining Workflow

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

Collaborating with Other Users

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

Auditing Worksheets

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

Analyzing Data

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

Working with Multiple Workbooks

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

Importing and Exporting Data

• 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

• Develop XML Maps
• Import and Export XML Data

Luton 960 Capability Green Luton LU1 3PE United Kingdom Luton Capability Green is ideally situated at the end of a boulevard on the Capability Business Park. Located approximately 30 miles from central London, the Centre offers easy access to the M1 motorway and London Luton Airport. An ideal spot for your Advanced Microsoft Excel 2010 Training Course. Alternatively if you live in and around Luton and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester