Microsoft Excel 2016 Beginners & Intermediate Excel Training

This course teaches Microsoft Excel 2016 from the ground up, covering the specific tools and techniques that appear in its own module list. You will learn to work comfortably with Excel 2016 and its advanced features, including what is new in this version. The training focuses on keyboard shortcuts that make regular tasks quicker, sophisticated functions that improve work quality, and how to build professional charts and pivot tables. By the end, you can format spreadsheets, use functions such as SUMIFS, and create a complete profit-and-loss statement from scratch.

The course takes an office-focused approach. It starts with a quick introduction to the basics, then moves into Excel best practices, keyboard shortcuts, and functions. You will learn to create professional charts and build a profit-and-loss statement using practical exercises. The instructor, 365 Careers, structures the lessons so that each skill builds on the last, moving from interface familiarity to data analysis tools.

At the end of the course, you will be able to format worksheets, use sophisticated functions, create charts and pivot tables, and build a profit-and-loss statement. These are concrete outcomes you can apply immediately at work or in personal projects.

This course does not cover newer Excel versions or advanced data modelling with Power Pivot. If you need those topics, the site lists alternatives such as the Microsoft Excel - Excel from Beginner to Advanced 2026 course, which runs 23 hours and costs ₹469, or the Microsoft Excel: Business Intelligence w/ Power Query & DAX course at ₹499 for 7.5 hours. Both carry a 4.7 rating and are also self-paced on Udemy.

Free options include the site’s Excel courses hub, which lists many beginner and intermediate courses at no cost. If you are just starting out, that hub is a good place to compare what is available before committing to a paid course.