Excel 365 Essentials
Welcome to the Office 365 Excel Web App Essentials course. 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 course, participants 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
Categories
Microsoft Excel