Data and Office

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

Turn everyday spreadsheets into useful analysis with stronger formulas, tables and charts.

1 Day · Live instructor-led training

What you will work on

Use logical, date and text functions
Sort, filter and organize lists
Create charts and formatted tables
Summarize data with PivotTables and PivotCharts

What the course covers

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

Lesson 1: Working with Functions

Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date and Time Functions
Work with Text Functions

Lesson 2: Working with Lists

Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data

Lesson 3: Analyzing Data

Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

Create Charts
Modify and Format Charts
Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers

Who this course is for

Excel users ready to move beyond basic worksheets.

Before you attend

Basic Excel calculations and workbook skills, equivalent to Excel Part 1.

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.