Microsoft Excel: Advanced

Course Overview

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

After this Advanced Excel training course you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. On this course you'll scratch the surface of one of Excel's most ingenious capabilities that has the potential to revolutionize the way you conduct your tasks - the Excel web query.

In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Excel Advance course will have you creating your own data powerhouses with just a few clicks. Most people are surprised at how much power Excel has to offer after taking this Excel Advance course.

Not sure whether this is the right Microsoft training course for you? For a more advanced search, click on our course category page

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)

Prerequisites

Delegates should have attended both of the following courses (or similar) prior to this course:

• Excel Introduction
• Excel Intermediate

Course Outline

Streamlining Workflow

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others

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

Auditing Worksheets

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

Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform 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

Using Excel 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