Microsoft Excel 2010 Level 3 (Advanced)

Switch version: 2019/2016/2013
Course Length: 6 hours (1 day)
Excel can create and display impressive-looking spreadsheets, data tables and charts, but also has many powerful tools that can be used to quickly analyze large amounts of information. VLOOKUP and HLOOKUP functions as well as Data Analysis tools can be used to generate solutions that might otherwise take longer to resolve. Pivot Tables can be used to group, calculate, filter and chart data to create simple, readable metrics in a short period of time.

Learning Objectives:
In this course, you will interpret, analyze, and display data using the most effective tools designed to produce accurate financial statistics. You will:
  • Use VLOOKUP and HLOOKUP functions to quickly facilitate search features in your spreadsheet
  • Create Scenarios, Use Data Analysis Tools such as Goal Seek, Input Tables and Solver
  • Create Pivot Tables, Format Pivot Tables and Generate Charts Using Pivot Tables
  • Link, Consolidate, and Combine Data
  • Create and Edit Macros
  • Create and Edit Basic VBA code
Target Student:
This course is for individuals who have a good understanding of Excel functions and wish to build on their knowledge of advanced features.

Course Outline:
Section 1: Getting the Most from Your Data
Lesson 1.1: Outlining and Grouping Data
Lesson 1.2: Exploring Scenarios
Lesson 1.3: Using Data Analysis Tools
Lesson 1.4: Using Solver
Lesson 1.5: Excel and Hyperlinks

Section 2: Pivoting Data
Lesson 2.1: Getting Started with Pivot Tables
Lesson 2.2: Working with Pivot Table Data
Lesson 2.3: Formatting a Pivot Table
Lesson 2.4: Using the Classic Pivot Table Layout
Lesson 2.5: Advanced Pivot Table Tasks
Lesson 2.6: Using Power Pivot

Section 3: Charting Pivoted Data
Lesson 3.1: Getting Started with Pivot Charts
Lesson 3.2: Using the Pivot Chart Tools Tabs
Lesson 3.3: Formatting a Pivot Chart
Lesson 3.4: Advanced Pivot Chart Tasks

Section 4: Advanced Excel Tasks
Lesson 4.1: Using Advanced Functions
Lesson 4.2: Using the VLOOKUP Function
Lesson 4.3: Using Custom AutoFill Lists
Lesson 4.4: Linking, Consolidating, and Combining Data

Section 5: Macros, Visual Basic, and Excel Programming
Lesson 5.1: Creating a Basic Macro
Lesson 5.2: Visual Basic and Macros
Lesson 5.3: More Macro Tasks
Lesson 5.4: Advanced Visual Basic Tasks

This Course Comes With

PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Level 3 (Advanced)
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes

To view additional ticket options, click the "Filter by Date" button and select more dates.

Date(s) Price Qty
August 19, 2020 9am to 4pm EDT $350.00 (CAD)*  
November 23, 2020 9am to 4pm EST $350.00 (CAD)*  
December 17, 2020 9am to 4pm EST $350.00 (CAD)*  
January 26, 2021 9am to 4pm EST $350.00 (CAD)*  
February 24, 2021 9am to 4pm EST $350.00 (CAD)*  
March 26, 2021 9am to 4pm EDT $350.00 (CAD)*  

* 13% HST will be applied on checkout

Online registration closes two business days before the start of the class.
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here