Microsoft Excel

What is Microsoft Excel?

Excel is a powerful tool for organizing, analyzing, visualizing data, making informed decisions, and tracking progress.

Excel offers:

Advanced data analysis tools
Streamlined collaboration
Cloud-based storage
Automation with Macros and Power Automate
Integration with other M365 apps
Security and compliance features

Getting Started

Create a workbook

Save your workbook to OneDrive

Analyze and format

Set up your mobile apps

Tops, tricks and next level features

What’s new

Use XLOOKUP to find what you need

Work with stocks and geography data

Turn your data into insights

Use functions

List of all Excel functions available

VLOOKUP function

Customize your data

Create a drop-down list

Combine text from two or more cells

Freeze panes to lock rows & columns

Analyse with PivotTables

Create a PivotTable to analyze worksheet data

Design the layout and format of a PivotTable

Sort data in a PivotTable or PivotChart