Microsoft Excel 2010 Training Course Advanced

Microsoft Excel 2010 Overview

This training 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 the training you will have learned how to enhance productivity and efficiency by streamlining the workflow, collaborate with other workbook users, audit worksheets, analyse data, work with multiple workbooks, import and export data, integrate Excel data with the web and structure workbooks with XML.

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Course Prerequisites:

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.

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