Microsoft 365 Excel – Level 2
Once you know the basics, Excel becomes a powerful tool for analysing and summarising information. Microsoft Excel Level 2 helps you work faster and smarter with larger sets of data, so that you can find answers quickly and present them with confidence.
In this course, you will learn logical functions such as IF, AND and OR, and lookup functions such as VLOOKUP and XLOOKUP. You will also work with Excel tables, sorting and filtering, apply conditional formatting to highlight results, build PivotTables and PivotCharts, work across multiple worksheets and workbooks, and use data validation and protection to keep your data accurate.
Microsoft Excel Level 1, or equivalent experience, is recommended before you begin. On completion, you will be more efficient and more valuable in roles such as Office Administrator, Finance or Administrative Assistant, Data Administrator and Stock Controller. Take your Excel skills to the next level and book your place today.
- Logical functions (IF, AND, OR) and lookups (VLOOKUP/XLOOKUP)
- Working with Excel tables, sorting and filtering
- Conditional formatting to highlight results
- PivotTables and PivotCharts
- Working across multiple worksheets and workbooks
- Data validation and protecting data
- Office Administrator
- Finance / Admin Assistant
- Data Administrator
- Stock / Inventory Controller