Microsoft Excel Training: Advanced

To View Class Dates: Please use the pull-down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

All instructor-led classes on our public schedule will be LIVE ONLINE.  Same trainers, same outlines and small classes (5 or less).

Want an in-person class? We can have one of our trainers come to your office for 1on1 or group training. For a quote, call 877 760 0078, email us at info@sonictraining.com or request a quote.

Popular Collaborative Software Training Classes

• Google Docs and Google Drive (click to see dates)
• Microsoft Teams (click to see dates)
• Microsoft SharePoint (click to see dates)
• Microsoft Power BI (click to see dates)
• Google Meet (click to see dates)
• Zoom (call 877 760 0078 for class information)
• SmartSheet (click to see dates)
• Slack Fundamentals (call 877 760 0078 for class information)
• Adobe Captivate (call 877 760 0078 for class information)

To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

• Our Excel Introduction course is held before this course. It is a one-day class.
• Want Excel training at your company site? (group or 1on1) -- click here.
• We have taught thousands of business professionals throughout the years. Read what our students say
• Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterward.
• Are you signing up for more MS Office classes? See our package discounts page

 

Excel Training Description - Advanced

Target Student: This Excel Training course is meant for those desiring to gain advanced skill sets necessary for calculating data using macros, functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Prerequisites: Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft® Office Excel®: Level 2, intermediate.

Microsoft Excel Training: Advanced

Lesson 1: Streamlining Workflow

Topic 1A: Update Workbook Properties

Topic 1B: Create a Macro

Topic 1C: Edit a Macro

Topic 1D: Apply Conditional Formatting

Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

Topic 2A: Protect Files

Topic 2B: Share a Workbook

Topic 2C: Set Revision Tracking

Topic 2D: Review Tracked Revisions

Topic 2E: Merge Workbooks

Topic 2F: Administer Digital Signatures

Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cells

Topic 3B: Troubleshoot Invalid Data and Formula Errors

Topic 3C: Watch and Evaluate Formulas

Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline

Topic 4B: Create Sparklines

Topic 4C: Create Scenarios

Topic 4D: Perform a What-If Analysis

Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

Topic 5A: Create a Workspace

Topic 5B: Consolidate Data

Topic 5C: Link Cells in Different Workbooks

Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

Topic 6A: Export Excel Data

Topic 6B: Import a Delimited Text File

Topic 6C: Import and Export XML Data

Lesson 7: Integrating Excel Data with the Web

Topic 7A: Publish a Worksheet to the Web

Topic 7B: Import Data from the Web

Topic 7C: Create a Web Query