Learning Excel Desktop (Microsoft 365) (2021)
1h 27mBeginner2021-09-07
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, quickly share your spreadsheets with others, and more.
Skills covered
Personal Productivity SoftwareOffice 365Microsoft 365SpreadsheetsMicrosoft ExcelLearningBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Build an Excel foundation in Microsoft 365
- 02 - What you need to know
1. Getting Started
- 03 - What is Excel
- 04 - Create a new workbook
- 05 - Add text and numbers
- 06 - Add formulas and functions
- 07 - Copy and paste with relative cell referencing
- 08 - Use AutoFill
2. Modifying Worksheets
- 09 - Format text
- 10 - Format numbers
- 11 - Format dates and times
- 12 - Manage columns
- 13 - Manage rows
- 14 - Freeze panes
- 15 - Insert recommended charts
3. Sharing and Printing Workbooks
- 16 - Print workbooks
- 17 - Send workbooks as email attachments
- 18 - Share workbooks using online options
Conclusion
- 19 - Next steps