Data and Office

Microsoft Excel for Office 365 (Desktop or Online): Part 3

Make complex workbooks easier to manage and use advanced Excel tools to investigate data.

1 Day · Live instructor-led training

What you will work on

Work across multiple workbooks
Use lookups and audit formulas
Automate repetitive work with macros
Explore forecasting and advanced visualizations

What the course covers

Explore the curriculum to see how it fits the work you want to do.

Lesson 1: Working with Multiple Worksheets and Workbooks

Use Links and External References
Use 3-D References
Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

Collaborate on a Workbook
Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros

Lesson 4: Using Lookup Functions and Formula Auditing

Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas

Lesson 5: Forecasting Data

Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecast Data Trends

Lesson 6: Creating Sparklines and Mapping Data

Create Sparklines
Map Data

Who this course is for

Experienced Excel users handling larger analyses or shared workbooks.

Before you attend

Best suited to learners already comfortable with Excel formulas, charts and tables.

Included with this course

Live instructor-led class
A preparation checklist for prerequisites, class access and setup
Altvina support for questions, concerns and next-step guidance

Ongoing mentorship is a separate paid service.

Support from Altvina

Have a question about course fit, learner details or access? Our team is your contact for enrollment support.

Ask a Course Question

Payments, refunds and class changes

Clear payment dates

Pay a $50 deposit per learner or full tuition. With your explicit agreement, the remaining balance is charged seven days before class. You receive an advance reminder.

Flexible before the cutoff

Class payments are refundable until seven days before the start. After that they are non-refundable; contact Altvina if an issue arises.

If the scheduled class changes

If Altvina or the training provider cancels or materially changes your class, you can choose a refund or an alternative date. We will contact you to arrange your choice.

Training instruction is delivered by Logical Operations or the provider listed for the class. Altvina handles enrollment and customer support.