In this session, you learnt:
- When and how to use LOOKUP and INDEX-MATCH functions for dynamic data retrieval.
- How to create and use pivot tables to summarise and analyse the current scenario.
- How to perform What-If Analysis to optimise logistics costs and delivery times across different shipping routes.
The following video provides a concise recap of all the concepts covered in this session.
This segment concludes the analysis of our use case. In the next session, you will explore additional Excel features and tools. You can download the final analysis workbook used in the demonstration from here.
Final Analysis