Advanced Excel 2010 training and certification in Washington DC
George Mason University, Volgenau School of Engineering

TAIT 0231: Advanced Excel 2010


Overview

Advanced Excel 2010

This hands-on course will teach you 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. Students will also learn how to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.


Audience and Prerequisites

This hands-on course is for students who have either attended the Intermediate Excel 2010 coure or have equivalent knowledge.

Back to top

Course Outline Detail

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
 
Registration
Click here to download the registration form (fax or mail)
Schedule

Please call for our upcoming class schedule

Tuition

$225

CEUs
0.8 CEUs
8 Hours
Onsite Opportunity

Enhance your organization's competitive edge!

George Mason University's TechAdvance Program can tailor programs to meet your organization's needs. Companies or agencies interested in bringing this program on site should contact TechAdvance at 703-993-1551.

Contact Info.
Online contact form
Address:

  George Mason University
TechAdvance
Volgenau School of Engineering
  4400 University Drive, MS 4A3
  Fairfax, VA 22030

Telephone: 703-993-1551
Email: advance@gmu.edu
Volgenau School of Engineering George Mason University