Microsoft Excel Advanced

Level
Total time

Microsoft Excel Advanced

Aspect Training
Logo Aspect Training
Provider rating: starstarstarstarstar 9.8 Aspect Training has an average rating of 9.8 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Aspect Training offers their products as a default in the following regions: Surrey

Description

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

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 Aspect's Advanced Excel training 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 Micro…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

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 Aspect's Advanced Excel training 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® 2007, 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.

Aspect Training's 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 Aspect Training's Excel Advance course. Book a place for yourself and see how Aspect Training's Excel Advance course can completely change the way you do business.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.