Master Microsoft Excel - Excel from Beginner to Advanced

This course builds a solid foundation in Microsoft Excel, walking through the tools and techniques needed for everyday data work. You will start with the Basics, learning how to navigate the interface, enter data, and perform simple calculations using core formulas. The module then moves into Functions & Formulas, where you will write formulas using IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, and INDEX to automate tasks and handle calculations. You will also learn to create charts with Trend Lines and Dual Axis, and use Excel as a database with Sort and Filter options to manage lists.

Beyond the basics, the course covers how to avoid common database design flaws and increase productivity through efficient worksheet editing and formatting. In the intermediate section, you will work with Tables, Charts, and PivotTables & PivotCharts to summarise and analyse data. The advanced modules focus on workbook collaboration, auditing worksheets, and analysing data to draw meaningful conclusions. By the end, you will be able to build functional spreadsheets, clean and transform data sets, and present findings using visual charts — skills that apply directly to office administration, finance, and project coordination roles in the Indian job market.

This course does not cover VBA scripting or advanced macro development. Learners looking for automation through code should consider the Business Intelligence course in the alternatives list, which includes Power Query and DAX modules. Those who need only beginner-level skills may find the Beginners & Intermediate Excel Training course more suitable, as it condenses the same core topics into a shorter 3.5-hour format.

All materials are in English, the course is self-paced, and a certificate is available upon completion. The instructor, Kirt Kershaw, holds certifications as a Microsoft Office Excel Specialist and Expert across multiple versions, with over 17 years of training experience.