Learning Excel Desktop (Microsoft 365) (2024)
1h 31mBeginner2024-04-19
Authors

David Rivers
Author, Trainer, and Learning and Development Expert
Course details
Are you looking to get started with Microsoft Excel? In this beginner-level course, follow instructor David Rivers as he introduces new users to the fundamentals of Excel. David covers the Excel interface, then goes into how to create new workbooks, add and format numbers and text, work with basic formulas and functions, and leverage key features such as AutoFill, which allows you to quickly fill new cells using existing cells where there is a pattern. He shows you how to freeze columns and rows, insert charts, use Copilot to generate AI-powered insights, quickly share your spreadsheets with others, and more.
Skills covered
SpreadsheetsMicrosoft ExcelLearningBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Build your Excel foundation in Microsoft 365
- 02 - What you need to know
1. Get Started with Excel
- 03 - What is Excel
- 04 - Create a new workbook
- 05 - Add text data
- 06 - Add numbers
- 07 - Add formulas and functions
- 08 - Copy and paste with relative cell referencing
- 09 - Use autofill
- 10 - Prevent relative addressing
2. Modify Worksheets
- 11 - Format text
- 12 - Format numbers
- 13 - Manage columns
- 14 - Manage rows
- 15 - Freeze panes
- 16 - Insert recommended charts
- 17 - Using Copilot
3. Share and Print Workbooks
- 18 - Print workbooks
- 19 - Send workbooks as email attachments
- 20 - Share workbooks using online options
Conclusion
- 21 - Expand your Excel knowledge
Related courses
- Learning Excel Desktop (Microsoft 365)
- Learning Excel Desktop (Microsoft 365) (2021)
- 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 Excel
- Digital Transformation in Practice: Virtual Collaboration Tools
- Getting Started with Microsoft 365
- Advance Your Career as an Administrative Professional
- Getting Started with Microsoft Word
- Working Smarter with Microsoft 365
- Optimizing Enterprise Security and Productivity Using Microsoft 365
- Become a Data Analyst