Microsoft Excel 2010 Training Course Advanced Birmingham

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

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

Birmingham Brindleyplace 2nd Floor 3 BrindleyPlace Birmingham B1 2JB United Kingdom Brindleyplace is an award winning business and leisure destination in the heart of Birmingham city centre. Microsoft Excel 2010 Training Course Advanced can be learned at this location. Alternatively if you live in and around Birmingham 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