MIMU Advanced Excel Training Resources

Welcome to MIMU Advanced Excel Training. This course will serve as an advanced level course on using Microsoft Excel software (Desktop Version 2016, 2019, Office 365) as it is the most ubiquitous when it comes to spreadsheet software as well as being a powerful data visualization and analysis tool. This course covers the topics such as Essential Skills, Data Grouping and Subtotal, Data Consolidation, Working with Table and Name, Advanced Functions and Formulas, Conditional Formatting, What-If-Analysis, Power Query and PowerPivot, Securing Excel File, Workbook and Worksheet and Sharing Workbook to collaborate.

On this page you will find course materials – videos, handouts and exercises - developed by MIMU for our Advanced Excel Training. Your feedback on how you find the course and especially on how they have helped your work will greatly help us to improve our courses. the MIMU Training Feedback Form.

This course is designed with the presumption that learners will have basic level expertise in Excel and therefore, we encourage you to explore our Basic Excel Training resources first if you don’t have. On the other hand, you can always use it as a refresher course.

Introduction and Training Materials

This chapter includes introduction to the course with manual and data source files.

Excel Essential Skills

This chapter is designed for users to learn Excel essential functions and features to be able to work efficiently in their daily tasks.  The following topics are covered:

Data Grouping and Subtotal

This chapter shows how to group and summarise a list of data and automatically calculate subtotals and grand totals. The following topics are covered:  

Data Consolidation

This chapter shows how to summarize and report results in a master worksheet from separate worksheets. The following topics are covered:

Working with Table

This chapter shows how to create and use the table in Microsoft Excel. The following topics are covered:

Working with Name

This chapter shows how to define and use Name in formulas that can make your formulas much easier to understand and maintain. Moreover, you can also learn how to create Dynamic Dropdown list and Lookup table. The following topics are covered:

Functions and Formulas

This chapter is designed for users who would like to learn the most commonly used functions and formulas in Excel. It also covered advanced level functions and formulas such as OFFSET, INDIRECT, INDEX, MATCH, the combination of INDEX and MATCH for vertical, horizontal, muti-columns and two ways lookup and creating dynamic dependent dropdown list. The following topics are covered:

Conditional Formatting

This chapter shows how to use Conditional Formatting in Excel. The following topics are covered:

What-If-Analysis

This chapter shows how to use What-if-Analysis in Excel. The following topics are covered:

Power Query and Power Pivot

This chapter shows how to use Power Query Editor and create calculated column and measure in Power Pivot. The following topics are covered:

Securing Excel File, Workbook and Worksheet

This chapter shows how to protect Excel file, worksheet elements and workbook. The following topics are covered:

Sharing Workbook to collaborate

This chapter shows how to share the workbook for collaborative working with multiple users. The following topics are covered:

MIMU Training Resources