Microsoft Excel 2010 Training Course Advanced Brentwood

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 - Brentwood

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

Microsoft-Excel-2010-Training-Course-Brentwood-Advanced

Course Duration: 1 Day

Other courses you may be interested in:

Intermediate Microsoft Excel 2010 Training Course

Or if you need to get back to basics

Beginners Microsoft Excel 2010 Training Course

Brentwood 3 The Drive Jubilee House Great Warley Brentwood CM13 3FR United Kingdom This is located on the Warley Hill Business Park, which is just one mile from Brentwood town center and the railway station from which a direct link to London departs every 15 minutes. Brentwood is situated in the north east sector of the M25. An ideal location for your Advanced Microsoft Excel 2010 Training Course. Alternatively if you live in and around Brentwood 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.

Maybe you would prefer your training at an alternative venue. Birmingham Brentwood Cambridge Ipswich Leicester Luton Milton Keynes Northampton Norwich Peterborough

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