Microsoft Excel 365 (Level 1)
New to Excel or need a refresher? This course is designed to help you master the fundamentals of Excel and learn time-saving tips that will allow you to get things done more quickly and efficiently.
- Delivery
- 6 hours
- Delivery
- Live online · English or French
- Price
- C$399
Per participant. Prices exclude HST and GST.
What you'll walk away with
- Build workbooks, worksheets and formulas from scratch
- Use relative and absolute cell references correctly
- Format, preview and print professional worksheets
Course objectives
- Overview of Excel ribbons and commands
- Create new Excel workbooks and worksheets
- Organise columns and rows and edit cell content
- Create formulas using relative and absolute references
- Manage worksheets and work with multiple worksheets
- Change the page setup, and preview/print workbooks
Course outline
Unit 1: Getting Started with Excel
- Understanding spreadsheet concepts
- Creating and saving workbooks
- Opening and closing workbooks
Unit 2: Modifying Worksheets
- Working with columns and rows
- Working with cell contents
Unit 3: Using Formulas and Functions
- Creating and using formulas
- Creating and using functions
- Using absolute cell references
- Inserting functions
Unit 4: Formatting and Viewing Worksheets
- Using workbook views
Unit 5: Printing Workbooks
- Changing the page setup
- Previewing and printing workbooks
Unit 6: Developing a Realistic Action Plan
- Developing a personal action plan
Related courses
Intermediate · 6 hours
Getting Started with M365 Copilot
Microsoft 365 Copilot helps you generate high-quality content in a fraction of the time. Whether you need to draft an email, a report or a presentation, Copilot can assist with smart suggestions and relevant examples across the apps you already use.
Foundation · 3 hours
Mastering Copilot Chat (Free Version)
A focused programme designed to help individuals leverage the power of Copilot Chat — Microsoft's basic Copilot option — to enhance productivity and streamline daily tasks.
Intermediate · 6 hours
Microsoft Excel 365 (Level 2)
Master the use of formulas and advanced functions, effortlessly create and organise tables, filter and sort data, add and format engaging visuals, and confidently protect and finalise your workbooks.
Want this course for your team?
I deliver every session personally, 100% live online, in a full day or two half days — in English or French.