Course Summary:

Welcome to the Office 365 Excel Web App Essentials workshop. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed.

In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.

Course Objectives:

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:

• Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
• Understand the Excel 365 browser interface
• Upload a spreadsheet to the Shared Documents library 
• Download and reload workbooks
• Open in Editing View
• Open the spreadsheet in the Excel desktop application for more advanced features
• Understand saving and collaborating
• Enter labels and values
• Build, copy and edit formulas
• Use absolute referencing appropriately
• Understand the difference between Formulas and Functions
• Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
• Sort and filter data
• Collaborate with others on a spreadsheet
• Use alignment options
• Apply borders and fill color
• Insert and work with Tables and Charts
• Insert links

Course Outline

Module One: Getting Started

• Workshop Objectives
• Pre-Assignment Review

Module Two: Welcome to OfficeWeb Apps

• The Home Page
• The Team Site
• Shared Documents
• Uploading a Spreadsheet
• Module Two: Review Questions

Module Three: Worksheets and Workbooks

• Opening a Spreadsheet
• Overview of the Reading View
• Understanding Worksheets vs. Workbooks
• Downloading and Reloading
• Closing Spreadsheets
• Module Three: Review Questions

Module Four: Working with Excel Files

• Using the Find Command
• Saving a Copy
• Editing in Browser
• The Excel Web App Interface
• Opening in Excel
• Module Four: Review Questions

Module Five: Editing in the Browser (I)

• About Saving and Save As
• A New File and AutoSaving
• Entering Data
• Editing Data
• Using the Wrap Command
• Module Five: Review Questions

Module Six: Editing in the Browser (II)

• Cut, Copy, and Paste
• Using Undo and Redo
• Adding Rows and Columns
• Deleting Cells
• Using Timesaving Shortcuts
• Module Six: Review Questions

Module Seven: Building Formulas

• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute References
• Module Seven: Review Questions

Module Eight: Understanding Functions

• Formulas vs. Functions
• Using the SUM Function
• Using Other Basic Excel Functions
• Using AutoComplete
• Module Eight: Review Questions

Module Nine: Working with Data

• Sorting Data
• Filtering Data
• About Collaborating
• About Refreshing External Data
• Module Nine:Review Questions

Module Ten: Formatting Your Data

• Changing the Appearance of Text
• Changing the Appearance of Numbers
• Setting Alignment Options
• Adding Borders
• Adding Fill Color
• Module Ten: Review Questions

Module Eleven: The Insert Tools

• Inserting Tables
• Inserting Charts
• Working with Charts
• Inserting Links
• Module Eleven: Review Questions
• Module Twelve: Wrapping Up
• Words from the Wise