Learning Excel Desktop (Microsoft 365)
1h 45mBeginner2025-04-22
Authors

David Rivers
Author, Trainer, and Learning and Development Expert
Course details
This course provides a step-by-step introduction to using Excel in Microsoft 365, covering essential features such as data entry, formatting, formulas, and functions. Learn how to modify worksheets, manage rows and columns, and create simple charts to visualize data. Additionally, instructor David Rivers explores using key tools like Copilot AI and collaboration options for sharing workbooks online. By the end of this course, you'll be equipped with the skills needed to efficiently navigate and utilize Excel for basic data management and reporting. Whether you're a beginner or need a refresher, this course offers a solid foundation for further Excel learning.
Learning objectives
Identify the key features and user interface elements of Excel in Microsoft 365.
Demonstrate how to enter, format, and manage text, numbers, and formulas in an Excel worksheet.
Apply basic functions, formulas, and formatting techniques to enhance readability and usability of data.
Analyze data trends using recommended charts and explore the use of Copilot AI for Excel assistance.
Utilize sharing, printing, and collaboration features to distribute and manage Excel workbooks efficiently.
Learning objectives
Identify the key features and user interface elements of Excel in Microsoft 365.
Demonstrate how to enter, format, and manage text, numbers, and formulas in an Excel worksheet.
Apply basic functions, formulas, and formatting techniques to enhance readability and usability of data.
Analyze data trends using recommended charts and explore the use of Copilot AI for Excel assistance.
Utilize sharing, printing, and collaboration features to distribute and manage Excel workbooks efficiently.
Skills covered
SpreadsheetsMicrosoft ExcelLearningBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Build a foundation in Excel Microsoft 365
- 02 - What you need to know
1. Get Started with Excel
- 03 - What is Excel
- 04 - Create a new workbook in Excel
- 05 - Add text data in Excel
- 06 - Add numbers to an Excel worksheet
- 07 - Add formulas and functions to an Excel worksheet
- 08 - Copy and paste with relative cell referencing in Excel
- 09 - Use autofill in Excel
- 10 - Prevent relative cell referencing in an Excel worksheet
2. Modify Worksheets
- 11 - Format text in Excel
- 12 - Format numbers in Excel
- 13 - Manage columns in an Excel worksheet
- 14 - Manage rows in an Excel worksheet
- 15 - Freeze panes in an Excel worksheet
- 16 - Insert recommended charts in Excel
- 17 - Get help from Copilot in Excel
- 18 - Manage sheets in an Excel workbook
3. Share and Print Workbooks
- 19 - Print Excel workbooks
- 20 - Send Excel workbooks as email attachments
- 21 - Share Excel workbooks using online options
Conclusion
- 22 - Expand your Excel knowledge
Related courses
- Learning Excel Desktop (Microsoft 365) (2021)
- Learning Excel Desktop (Microsoft 365) (2024)
- Learning Excel Online (Microsoft 365) (2023)
- Office for iPad and iPhone Essential Training
- Learning Access for Office 365
- Excel Power Query Tips and Techniques
- Office 365: Access Essential Training
- Building Solutions Using Excel and Access 2019 Together
Related learn paths
- Getting Started with Microsoft 365
- Getting Started with Microsoft Excel
- Advance Your Career as an Administrative Professional
- Digital Transformation in Practice: Virtual Collaboration Tools
- Getting Started with Microsoft Word
- Working Smarter with Microsoft 365
- Optimizing Enterprise Security and Productivity Using Microsoft 365
- Become a Data Analyst