This course will introduce you to the essential data analysis tools and techniques in Excel, such as pivot tables, charts, slicers, and dashboards. You will learn how to perform what-if analysis using scenarios, goal seek, and data tables to explore the impact of different assumptions and values on your results. You will also learn how to create simple macros to automate repetitive tasks and enhance your productivity. Additionally, you will learn how to use data validation to control the type and range of data that can be entered in a cell, and how to use advanced functions such as VLOOKUP, INDEX, MATCH, and IFERROR to perform complex calculations and lookups.
You should have completed the level 2 course or have a good understanding of Excel
You will require a copy of Microsoft Excel and a computer
Using two monitors would be a help but essential
The course is designed for people wanting automate processes in Excel
This course is useful for people that carry out data analytical tasks
This course is useful if you work with large data sets and want to quickly interrogate specific sets
This course is design for people that wish to move their Excel understand forward
Add Related products to weekly line up
other products in the same category: