Introduction
Take your Excel skills to the next level with this Intermediate Excel short course. Designed for those who already understand the basics, this course will help you work more confidently and efficiently with data.
You’ll learn how to use more advanced formulas and functions, manage and analyse data sets, and create more dynamic and professional spreadsheets. Whether you're using Excel at work, in your business, or for study, these skills will help you get more done, more accurately.
What will I Learn?
This course is ideal if you want to understand the basics of Microsoft Excel and need to extend your knowledge and application. Topics covered include:
- Development of formulas
- Macros
- Go to Special
- Pivot tables
- Named Ranges
- Drop-down lists
- Conditional formatting
- Excel tables for data analysis
- Using Sparklines
- Text to column