Microsoft Excel 2010 - Level 3

Master advanced Microsoft Excel 2010 techniques with our Level 3 course, designed for professionals seeking to automate tasks, enhance data analysis skills, and collaborate efficiently within complex data environments.

Course Thumbnail

Essential Skills Gained

Checkmark

Automate Excel tasks for improved productivity.

Checkmark

Collaborate effectively on complex worksheets.

Checkmark

Audit and analyze data for accurate insights.

Checkmark

Integrate and manage data from multiple sources.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Spreadsheet Analysts
  • Data Managers
  • Financial Analysts
  • IT Professionals

Description

You will 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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Streamlining Workflow

  1. Update Workbook Properties

  2. Create a Macro

  3. Edit a Macro

  4. Apply Conditional Formatting

  5. Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

  1. Protect Files

  2. Share a Workbook

  3. Set Revision Tracking

  4. Review Tracked Revisions

  5. Merge Workbooks

  6. Administer Digital Signatures

  7. Restrict Document Access

Lesson 3: Auditing Worksheets

  1. Trace Cells

  2. Troubleshoot Invalid Data and Formula Errors

  3. Watch and Evaluate Formulas

  4. Create a Data List Outline

Lesson 4: Analyzing Data

  1. Create a Trendline

  2. Create Sparklines

  3. Create Scenarios

  4. Perform a What-If Analysis

  5. Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

  1. Create a Workspace

  2. Consolidate Data

  3. Link Cells in Different Workbooks

  4. Edit Links

Lesson 6: Importing and Exporting Data

  1. Export Excel Data

  2. Import a Delimited Text File

Lesson 7: Integrating Excel Data with the Web

  1. Publish a Worksheet to the Web

  2. Import Data from the Web

  3. Create a Web Query

Lesson 8: Structuring Workbooks with XML

  1. Develop XML Maps

  2. Import and Export XML Data

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.