What is Microsoft Excel?
Excel is a powerful tool for organising, analysing, visualising 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
- Intro to Excel
- Create a workbook
- Save your workbook to OneDrive
- Analyse and format
- Collaborate
- Set up your mobile apps
Tips, 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, IF function.
Customise your data: create a drop-down list, combine text from two or more cells, freeze panes to lock rows and columns.
Analyse with PivotTables: create a PivotTable to analyse worksheet data, design the layout and format of a PivotTable, sort data in a PivotTable or PivotChart.
