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 2007 Level 3 (Advanced)

Course Length: 6hrs (1 Day)

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Learning Objectives:
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline:
Section 1: Advanced Topics
Lesson 1.1: Setting Excel Options
Lesson 1.2: Excel and Windows
Lesson 1.3: Using the Excel Viewer

Section 2: Getting the Most From Your Data
Lesson 2.1: Getting the Most From Your Data
Lesson 2.2: Pivot Tables
Lesson 2.3: More About Pivot Tables
Lesson 2.4: Exploring Scenarios
Lesson 2.5: What If Analysis

Section 3: Excel and the Internet
Lesson 3.1: Excel and Hyperlinks
Lesson 3.2: Saving Workbooks as Web Pages
Lesson 3.3: Getting Data from the Internet
Lesson 3.4: Excel and Office Servers

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

Section 5: Macros, VBA, and Excel Programming
Lesson 5.1: Macros
Lesson 5.2: More Macro Tasks
Lesson 5.3: Visual Basic and Macros