This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
2 Days
The Advanced Excel course shows you how to work with databases in Microsoft Excel using filtering, sorting and subtotals.
This training course introduces participants to PivotTables, Macros and Hyperlinks and teaches logical, lookup, reference, and statistical functions.
If you are experienced in designing and modifying spreadsheets, can write formulas and have worked with IF and VLOOKUP functions, this advanced Excel course is for you.
Completion of Microsoft Excel Intermediate training course or equivalent skill level.
https://aimwa.com/courses-events/computer-skills/excel/940-excel-essentials/
https://aimwa.com/courses-events/computer-skills/excel/933-excel-intermediate/
This course provides an insight into advanced functions typically used in organisations to summarise, analyse, explore, and present visualisations of data. It is particularly useful if you need to:
After completion of the Advanced Excel course you will be able to:
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
This course highlights the concepts of project management and introduces Microsoft Project’s key features of how to set up a schedule and a resource pool, how to assign resources to tasks and how to track a project.
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.