Certificate In Excel 365 Essentials Online Course

Module One: Getting Started
By the end of this course, you should be able to:

• Open and close spreadsheets
• 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
• Differentiate between worksheets, workbooks, rows, columns, and cells
• Download and reload workbooks
• Use the Find Command
• Save a Copy
• Open in Editing View
• Open the spreadsheet in the Excel desktop application for more advanced features
• Understand saving and collaborating
• Create a new file
• Enter labels and values
• Edit data
• Use the Wrap Command
• Use cut, copy, and paste
• Use Undo and redo
• Add rows and columns
• Delete cells
• Understand shortcuts
• 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
• Understand Autocomplete
• Sort and filter data
• Collaborate with others on a spreadsheet
• Refresh and recalculate data
• Format text and numbers
• Use alignment options
• Apply borders and fill color
• Insert and work with Tables
• Insert and work with Charts
• Insert links

Module Two: Welcome to Office 365 Web Apps

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

Module Three: Worksheets and Workbooks

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

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 Five: Editing in the Browser (one)

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

Module Six: Editing in the Browser (two)

• Cut, Copy, and Paste
• Using Undo and Redo
• Adding Rows and Columns
• Deleting Cells
• Using Timesaving Shortcuts

Module Seven: Building Formulas

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

Module Eight: Understanding Functions

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

Module Nine: Working with Data

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

Module Ten: Formatting Your Data

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

Module Eleven: The Insert Tools

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

Module Twelve: Wrapping Up
Words from the Wise