COVID-19 Update

All Public Compuease classes can be taken virtually from the comfort of your home or office.
This Live Instructor-Led online training is the same great training you expect from CompuEase, just using the power of the internet to deliver it remotely.
Register for any class on this site as you would normally and we will reach out and help you get set up for your virtual class.
If you are new to working in a remote environment and your organization uses Microsoft Teams, make sure to check out our free Microsoft Teams Introductory Webinar or sign up for our special full-featured 4-hour Microsoft Teams Course and get up to speed.

Excel 2010 Level 3 (Advanced)

Course Length: 6hrs (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