Microsoft Office 365 Excel Expert

Welcome to the third part of our Microsoft 365 Excel courseware. Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and connectivity to make collaboration and production as easy as possible.

This course is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover:

Using Excel Online

Worksheet Automation

Auditing and Error Checking

Data Analysis and Presentation

Working with Multiple Workbooks

Exporting and Sorting Data

 

By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.

–

Prerequisites

 

This manual assumes the user has completed, or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including:

Excel basics

Working with data

Modifying worksheets

Printing workbook contents

Managing large workbooks

Customizing the Excel environment

Creating advanced formulas

Analyzing data with logical and lookup functions

Organizing worksheets data with tables

Visualizing data with charts

Analyzing data with PivotTables, slicers, and PivotCharts

Working with graphical objects

Enhancing workbooks

 

Topics

 

Lesson 1: Excel Online

Lesson 2: Worksheet Automation

Lesson 3: Auditing and Error Checking

Lesson 4: Data Analysis and Presentation

Lesson 5: Working with Multiple Workbooks

Lesson 6: Exporting and Sourcing Data