This course 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
WHO SHOULD ATTEND?
Excel Users who are seeking to learn the advanced features of Excel 365.
Lesson 1: Excel Online
Topic A: Accessing and Using Excel Online
Topic B: Features that Differ Between Excel Online and the Excel Desktop Application
Lesson 2: Worksheet Automation
Topic A: Managing Workbook Properties
Topic B: Working with Macros
Topic C: Create and Use a Template
Topic D: Use Data Validation in a Workbook
Lesson 3: Auditing and Error Checking
Topic A: Tracing Cells
Topic B: Error Checking
Topic C: Evaluating Formulas and Using the Watch Window
Topic D: Data List Outlines
Lesson 4: Data Analysis and Presentation
Topic A: Quick Analysis Tool
Topic B: Adding Sparklines
Topic C: What-If Analysis
Topic D: The Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic A: Arrange Workbooks
Topic B: Linking to Data in Multiple Workbooks
Topic C: Consolidating Data
Lesson 6: Exporting and Sourcing Data
Topic A: Exporting Data
Topic B: Using Data Sources
Topic C: Use a Microsoft Form for Data Collection