Excel Online (Microsoft 365): Work Smarter with Copilot

Course details

Microsoft Excel Online brings the power of the renowned spreadsheet software to your web browser, offering a flexible and collaborative platform for data management and analysis. In this foundational course, discover how to navigate the Excel Online interface, work with basic formulas, and leverage essential features that make data organization efficient and intuitive. Through hands-on exercises and real-world examples, build confidence in creating, formatting, and sharing spreadsheets while learning time-saving techniques for remote collaboration. For Copilot users, learn how to enhance your productivity by integrating AI assistance into your workflow.

Learning objectives
Navigate the Excel Online interface confidently and understand its core functionality.
Create and format spreadsheets using essential tools and features.
Collaborate effectively with others through file sharing and simultaneous editing.
Apply basic formulas and functions to analyze data efficiently.
Smartly leverage Copilot (if you have this subscription).

Concepts

0. Introduction

01 - Kickstart your Excel Online journey

1. Getting Started with Excel Online

02 - Getting acquainted with Excel Online
03 - Exploring essential features in Excel
04 - Enhancing your data with formatting
05 - Personalizing your view with Sheet View
06 - Using version history in Excel to fix mistakes
07 - Challenge - Use Excel Online to undo mistakes
08 - Solution - Use Excel Online to undo mistakes

2. Collaborating Effectively in Excel Online

09 - Sharing your work and collaborating with others
10 - Securing your files with permission settings
11 - Exchanging feedback with cell notes
12 - Improving collaboration with cell comments
13 - Tracking edits in Excel with Show Changes

3. Visualizing Data with Charts in Excel Online

14 - What you need to know before creating charts
15 - Creating eye-catching Excel charts for stakeholders
16 - Customizing charts with advanced Excel tools
17 - Building powerful PivotTables in Excel
18 - Designing engaging PivotCharts
19 - Challenge - Use Excel Online to create a PivotTable
20 - Solution - Use Excel Online to create a PivotTable

4. Supercharging Your Data with Copilot

21 - Getting started with Copilot in Excel
22 - Using Copilot to analyze your data
23 - Partnering with Copilot for enhanced productivity
24 - Challenge - Use Copilot to create a chart
25 - Solution - Use Copilot to create a chart

5. Taking Your Excel Skills to the Next Level

26 - Optimizing the look and feel of your Excel workbook
27 - Making navigation easier with Freeze Panes
28 - Enhancing usability in Excel with zoom features
29 - Streamlining your layout with modern grids
30 - Adding interactive elements with checkboxes

6. Using Excel Online for Personal Projects

31 - Creating an Excel workbook for personal use
32 - Designing and sharing a responsibility chart
33 - Planning and managing a vacation budget in Excel

Conclusion

34 - Getting the most out of Excel Online

Excel Online (Microsoft 365): Work Smarter with Copilot

Authors

Joshua Rischin