Excel 365 is a cloud-based application that gives you the convenience and flexibility of sharing and working on worksheets simultaneously with other users anywhere, using any web-enabled device. Learn how to increase your productivity and efficiency through accessibility and collaboration among Excel 365 users by attending this Excel 365 Training Course.
This course covers the following topics: understanding the Excel 365 browser interface, creating, managing, sharing and collaborating on a spreadsheet from anywhere, how to open, save and close worksheets, how to use the basic Excel functions (SUM, AVERAGE, MAX, and MIN) and much more.
This comprehensive training course is now available in Singapore. Contact us today!
Course Outline
Excel 365 Training Course – Lesson 1
Getting Started
– Icebreaker
– Housekeeping Items
– The Parking Lot
– Workshop Objectives
Excel 365 Training Course – Lesson 2
Welcome to Excel 365
– The Home Page
– The Team Site
– Shared Documents
– Uploading a Spreadsheet
Excel 365 Training Course – Lesson 3
Worksheets and Workbooks
– Opening a Spreadsheet
– Overview of the Reading View
– Understanding Worksheets vs. Workbooks
– Downloading and Reloading
– Closing Spreadsheets
Excel 365 Training Course – Lesson 4
Working with Excel Files
– Using the Find Command
– Saving a Copy
– Editing in Browser
– The Excel Web App Interface
– Opening in Excel
Excel 365 Training Course – Lesson 5
Editing in the Browser – Part 1
– About Saving and Save As
– A New File and Autosaving
– Entering Data
– Editing Data
– Using the Wrap Command
Excel 365 Training Course – Lesson 6
Editing in the Browser – Part 2
– Using Undo and Redo
– Adding Rows and Columns
– Deleting Cells
– Using Timesaving Shortcuts
Excel 365 Training Course – Lesson 7
Building Formulas
– The Math Basics of Excel
– Building a Formula
– Editing a Formula
– Copying a Formula
– Relative vs. Absolute References
Excel 365 Training Course – Lesson 8
Understanding Functions
– Formulas vs. Functions
– Using the SUM Function
– Using Other Basic Excel Functions
– Using AutoComplete
Excel 365 Training Course – Lesson 9
Working with Data
– Sorting Data
– Filtering Data
– About Collaborating
– About Refreshing External Data
Excel 365 Training Course – Lesson 10
Formatting Your Data
– Changing the Appearance of Text
– Changing the Appearance of Numbers
– Setting Alignment Options
– Adding Borders
– Adding Fill Color
Excel 365 Training Course – Lesson 11
The Insert Tools
– Inserting Tables
– Inserting Charts
– Working with Charts
– Inserting Links
Excel 365 Training Course – Lesson 12
Wrapping Up
– Words from the Wise
– Review of the Parking Lot
– Lessons Learned
– Completion of Action Plans and Evaluations