View all the services available for students of the Institute
Study with us
View member services
Services to support your business
This course provides essential knowledge and practical skills to create effective charts and dynamic dashboards for data visualisation. Using Microsoft Excel and PowerPoint, the course enables learners to interpret, analyse and communicate business data through clear and impactful visual representations. The course includes comprehensive instructions and structured hands-on exercises to create presentations and dashboards from scratch.
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and Effective Macro creation and editing are explored.
Currently in planning more details to follow