Register Now
Over a Decade of Serious Learning for Ambitious Minds. * 9.5 of 10 (over 18 k student survey results - 2020)

Find A Class in Your City:

Excel Training: Intermediate & Advanced

Email this page | Print this page

Microsoft Excel Training: Intermediate & 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.

 

Effective March 12, 2020, all instructor-led classes at our offices can be taken LIVE ONLINE.  Same trainers, same outlines as before.

Want custom training for yourself or a group via live online medium? We can do that and have done that for over a decade now. For a quote, call 877 760 0078, email us at info@sonictraining.com or send us a note


Popular Collaborative Software Training Classes

 

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

 

 

Excel Training Description

(see below for day two outline)

Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Target Student: This Excel Training course is meant for those desiring to gain advanced skill sets necessary for calculating data using 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 1.


Excel Training Objectives

Upon successful completion of this course, students will be able to:

  • use advanced formulas.
  • organize worksheet and table data using various techniques.
  • create and modify charts.
  • analyze data using PivotTables, Slicers, and PivotCharts.
  • insert and modify graphic objects in a worksheet.
  • customize and enhance workbooks and the Microsoft Office Excel environment.


Microsoft Excel Training: Intermediate

Course Content

Lesson 1: Calculating Data with Advanced Formulas

 

Topic 1A: Apply Cell and Range Names

Topic 1B: Calculate Data Across Worksheets

Topic 1C: Use Specialized Functions

Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

 

Topic 2A: Create and Modify Tables

Topic 2B: Format Tables

Topic 2C: Sort or Filter Data

Topic 2D: Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts

 

Topic 3A: Create a Chart

Topic 3B: Modify Charts

Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

 

Topic 4A: Create a PivotTable Report

Topic 4B: Filter Data Using Slicers

Topic 4C: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

 

Topic 5A: Insert and Modify Pictures and ClipArt

Topic 5B: Draw and Modify Shapes

Topic 5C: Illustrate Workflow Using SmartArt Graphics

Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

 

Topic 6A: Customize the Excel Environment

Topic 6B: Customize Workbooks

Topic 6C: Manage Themes

Topic 6D: Create and Use Templates

 

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