Microsoft Excel Functions and Formulas 2026
Master over 125 Excel Functions, XLOOKUP, Dynamic Arrays, Logical Functions , Text Functions, Regex Functions and More

What you'll learn
- Master over 120 Excel functions to build formulas, analyse data, automate tasks, and solve real-world spreadsheet problems.
- Use functions like XLOOKUP, IF, FILTER, LET, LAMBDA, dynamic arrays, and advanced formulas to build professional Excel workbooks.
- Clean, transform, analyse, and visualise data using text, date, lookup, logical, statistical, and dynamic array functions.
- Create reusable formulas using modern Excel best practices.
Requirements
- No prior Excel experience required. Just Microsoft Excel and a willingness to learn.
Who this course is for
- Complete beginners who want to master Excel from the ground up.
- Office professionals looking to improve productivity with Excel.
- Students preparing for careers that require strong Excel skills.
- Business analysts, accountants, and managers working with data.
- Anyone wanting to learn modern Excel functions.
Download Links
12.39 GB Total Size