☑️ Fundementals of Excel

Begin with understanding the basics of excel, understand the user interface, the common terminologies used, how to navigate the software with ease. Finally finish with understanding how to document your work, save, and open it.

☑️ Formulas in Excel

Learn the most widely used formulas of excel, understand how they are structured, how they work based on cell references, and so on. Explore how calculations occur via the BODMAS order, and finally get acquainted with the highly useful fill handle.

☑️ Modifying and Formatting

Master the art of modifying and formatting the numerous elements of Excel, making use of the ability to customise your own formats. Understand the different data types which you can use, and learn the smaller hidden utilities to make your sheets look presentable and easy to use.

☑️ Functions in Excel

Get introduced to the powerful world of functions. Understand the structure of functions, the basic functions for everyday use, the common errors which you may come across while using functions, and how to avoid them.

☑️ Working with large sets of data

Learn to work with large sets of data by using the filtering & sorting options. Get familiar with conditional formatting, the art of showcasing your data in a unique manner, and draw the attention of your users where it really matters.

☑️ Working with more functions

Dive deep into the world of functions to familiarise yourself with the different types of functions which exist, and the massive possibilities they bring. Learn how to work with criteria(s), working with different functions in the same sheet to perform operations accordingly.

☑️ Working with charts

Begin visualising data via charts. Learn how to create charts, suitable for different purposes. Start formatting charts, customizing different elements of the visualization, and modifying them once the charts are created.

☑️ Working with named ranges

Get familiar with named ranges, how to create them, the solutions they provide, and the challenges they pose. Combine named ranges with formulas and functions for powerful results. Finally, manage all your named ranges to ensure minimal effort with maximum output.

☑️ Working with data validation

Learn how to validate data in the contents of the sheet, the most common types of errors you encounter whilst using this, and also how to identify/correct the respective errors. Also learn how to customize the ability to validate certain types of data on your sheets. Finally, wrap it up with using dynamic referencing along with data validation.

☑️ Pivot Tables

Welcome to the powerful world of pivot tables. Understand what they mean, what they are used for, and the numerous utility they provide. Get familiar with the different fields of pivot tables, how to create pivot charts, and how to interact with those charts using slicers to create dynamic visualisation(s).

☑️ Working with Logic functions

Understand what logical functions are, and what they are used for. Acquaint yourself with creating logical functions, nested functions, how to use the right function to tackle different conditions, and finally, how to combine different logical functions into one. Also learn how the IFERROR() function works to make your sheets look clean.

☑️ Working with Lookup functions

Get familiar with the super useful functionality of the LOOKUP functions. Learn the different types of LOOKUP functions which exist including the VLOOKUP, HLOOKUP, INDEX, MATCH functions. Combine these functions in different manners to begin automating your sheets, and allow dynamic interactions to extract data as needed.

☑️ Auditing and protecting

Learn how to protect your sheets from different types of errors. Master the art of identifying errors, tracing where they come from, and how to fix them. Get familiar with the different tools which allow you to fix errors faster and efficiently. Finally learn how to protect your worksheets and workbooks.