Topic 1

Getting Started

• Icebreaker
• Housekeeping Items
• The Parking Lot
• Workshop Objectives

Topic 2

Building Formulas

• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute References

Topic 3

Welcome to Office 365 Excel

• The Home Page
• The Team Site
• Shared Documents
• Uploading a Spreadsheet

Topic 4

Understanding Functions

• Formulas vs. Functions
• Using the SUM Function
• Using Other Basic Excel Functions
• Using AutoComplete

Topic 5

Worksheets and Workbooks

• Opening a Spreadsheet
• Overview of the Reading View
• Understanding Worksheets vs. Workbooks
• Downloading and Reloading
• Closing Spreadsheets

Topic 6

Working with Data

• Sorting Data
• Filtering Data
• About Collaborating
• About Refreshing External Data

Topic 7

Working with Excel Files

• Using the Find Command
• Saving a Copy
• Editing in Browser
• The Excel Web App Interface
• Opening in Excel

Topic 8

Formatting Your Data

• Changing the Appearance of Text
• Changing the Appearance of Numbers
• Setting Alignment Options
• Adding Borders
• Adding Fill Color

Topic 9

Editing in the Browser – Part 1

• About Saving and Save As
• A New File and Autosaving
• Entering Data
• Editing Data
• Using the Wrap Command

Topic 10

The Insert Tools

• Inserting Tables
• Inserting Charts
• Working with Charts
• Inserting Links

Topic 11

Editing in the Browser – Part 2

• Using Undo and Redo
• Adding Rows and Columns
• Deleting Cells
• Using Timesaving Shortcuts

Topic 12

Wrapping Up

• Words from the Wise
• Review of the Parking Lot
• Lessons Learned
• Completion of Action Plans and Evaluations