This course is delivered ONLINE

Format

The course is instructor-led and will be delivered remotely. It offers a hands-on learning experience with practical exercises. You will start with the basics and build your skills to use intermediate and advanced features and functionalities.

• March 4 and 5, 2021
• Two full days - 8AM to 5PM Pacific Time
• There will be several breaks scheduled through the day with 1-hour lunch break
• Time will be given to practice and do exercises

Material will be provided at the time of the session.

Prerequisites

• No prior experience in MS Word is required.
• Access to computer/laptop with Microsoft Word software (2016 or newer) installed on your device

Course Outline

Basics

Exploring A Workbook

Entering Text, Dates And Numbers

Resizing Columns And Rows

Modifying Rows And Columns

Formatting Worksheet

Formulas and Functions

Designing Workbook For Calculations

Calculating Dates

Calculating With Formulas

Calculating With Functions

Applying Excel Functions

Interpreting Error Values

Auto Filling Formulas And Data Patterns

Exploring Cell References

Looking Up Data

Lookup Tables And Logical Functions

Calculating Running Totals With The Quick Analysis Tool

Working With IF Logical Functions

Using Lookup Functions

Exploring Logical Functions

Applying Summary IF Functions

Creating PivotTables

Formatting A PivotTable

Setting PivotTable Options

Introducing PivotCharts

Using Slicers

Drilling Down A PivotTable

Performing What If Analyses With Formulas And Functions

Formatting

Formatting Cell Text

Working With Fill Colors And Backgrounds

Using Functions And Formulas With Sales Data

Formatting Numbers

Formatting Worksheet Cells

Calculating Averages

Applying Cell Styles

Copying And Pasting Formulas

Finding And Replacing Text And Formats

Working With Themes

Highlighting Data With Conditional Formats

Formatting Input, Calculated And Output Values

Charts

Chart Elements

Getting Started With Excel Charts

Creating A Pie Chart

Working With Chart Elements

Performing What If Analyses With Charts

Creating A Column Chart

Creating A Line Chart

Creating A Combination Chart

Scatter Charts, Data Bars And Sparklines

Creating A Scatter Chart

Editing The Chart Data Source

Exploring Other Chart Types

Creating Data Bars

Creating Sparklines