Microsoft Excel for Office 365 Part 02

Develop more advanced Microsoft Excel skills and learn how to work with larger datasets, smarter formulas and powerful reporting tools to improve workplace productivity.

Overview

Microsoft Excel for Office 365 Part 2 builds on the foundational skills gained in Part 1 and introduces learners to more advanced features used in modern business environments. This course focuses on improving data management, spreadsheet accuracy, reporting capabilities and productivity using Microsoft Excel within Microsoft 365.

Course Content

Working with Larger Worksheets and Workbooks Advanced Formatting Techniques Using Logical Functions Working with Date and Time Functions Data Validation Sorting and Filtering Data Conditional Formatting Working with Excel Tables Advanced Formula Techniques Lookup Functions Creating and Managing PivotTables Creating Professional Charts and Reports Sharing and Collaborating within Microsoft 365

This course is ideal for:

Microsoft Excel for Office 365 Part 2 is ideal for professionals who regularly work with spreadsheets and want to improve their ability to analyse, organise and present data. The course is particularly beneficial for administrators, finance teams, HR professionals, office managers, sales support teams and business professionals who rely on Excel for reporting, tracking, forecasting and decision-making. It is also suitable for individuals looking to strengthen their Microsoft 365 productivity skills and progress towards more advanced Excel capabilities.

Requirements

Learners should have a good understanding of basic Microsoft Excel concepts, including workbook creation, cell formatting, formulas and worksheet management. Completion of Microsoft Excel for Office 365 Part 1 or equivalent practical experience is strongly recommended.

Talk to someone about this course

Our consultants can share upcoming course dates and pricing with you.