VIDEO

READING

QUIZ

Understand the different features of the excel interface - navigation, selection of cells, and data entry along with basic calculations.

Kick Start Microsoft Excel

Learn to write the most frequently used excel functions in calculations such as SUM, AVERAGE, MAX, and MIN.

Working with formula

Learn the tools to format datasets using border formatting, alignment, cell, and font formatting. Insert pictures and learn to make them visually appealing in workbooks.

Formatting

Learn the tools, techniques, and tricks to manage and structure the workbook. Conditional formatting will be taught in this chapter too.

Modifying workbooks and worksheets

This chapter will introduce you to some basic functions to work with dates and texts to extract relevant information.

Text and Date functions

Understand techniques to visualize the data in different charts and add little nuances in charts to enhance the visual appeal.

Exploring charts

Named ranges open the doors for automation in excel workbooks. Learn how to create, manage and apply named ranges in a function.

Named Ranges

Learn to perform calculations based on some conditions using advanced formulas such as SUMIF, COUNTIF, and more. Automate boring work with Excel table.

Conditional functions

Learn to use AND, OR, and IF operators to write complex instruction in excel

Operators

Unleash the power of Pivots table and pivot charts to perform complex calculations within seconds and create basic interactive visualizations using slicers.

Pivot tables

Gather details about creating data validation based on formula and interactive conditional formatting that ensures data entry is systematically processed.

Data validation

Become proficient in utilizing the Lookup Function, the most frequently used function of Excel, to solve real-world business problems.

Lookup functions

Master the tips and tricks to identify the hidden errors in a workbook and resolve them.

Auditing a workbook

Explore the exciting design principles used by industry experts and create interactive dashboards through real business projects.

Design Principles and building Interactive dashboard

Macros can be very useful to perform repetitive tasks with just a click. Learn how to record and edit a set of actions as many times as you want.

Macros

Learn Power pivots to broaden your skills to play with large data using multiple sources and create data models to perform complex calculations in seconds. 

Power Pivots

Learn how to create different business scenarios and optimize a business objective using Solver and Goal Seek

Data modeling 

Take care of messy workbooks with dynamic and automated fixes. Learn to fix dates, remove blank and unwanted characters to clean files.

Data cleaning techniques

Learn how to break down business problems into small pieces and solve them using business funnels

Understanding Business Funnels

Expand your skills in automation using advanced lookup functions INDIRECT, ADDRESS and OFFSET

Advanced Lookup Functions

Learn tips and tricks to print the workbooks on a piece of paper

Printing Workbooks

Data is meaningless unless it tells a story. Learn how to create beautiful and interactive dashboards using advanced techniques

Building Professional Dashboard

Master the art of deriving insights through the most popular techniques in Excel. Become industry ready in just 3 months learning from real business case studies delivered by the masters of the Industry from Amazon, Microsoft, Swiggy & many more. Get certified as a “Microsoft Excel Expert”

Microsoft Excel Certification Course | Beginner to Advanced | SkilloVilla

The curriculum is really best in class. I learnt all the necessary practical concepts and SkilloVilla team helped me get placed at Flipkart. It's a great place to learn directly from industry experts and sharpen your skills. Really recommend it!

Anshul Gupta

SkilloVilla’s Data Science Track helped me switch career. Live classes and top notch courses really helped me. And the best part was the resume preparation and mock interviews drills which created a virtual interview environment and helped me prepare well for actual interviews

Hardik Kaneriya

SkilloVilla played a very important role in starting my career right. Combination of videos, live classes and projects helped me understand the concepts throughly. Live Classes by experts made the learning process very interesting and taught me real life application. Very well-structured program.

Vaibhav Jaiswal

Excellent content and great mentorship! I had no clue how to get a job in data. SkilloVilla helped me not only learn from very scratch but also helped me understand practical applications through expert driven live classes. Thanks you SkilloVilla team and Deepak Sir for supporting me till I got placed.

Raj Golhani

Course not independently purchasable

Excel: Beginner - Advanced

Learn to manipulate complex data and derive insights through various visualization techniques by using the most popular tool and functions of Excel.

Excel: Beginner - Advanced

Master these skills

Level & pre-requisites

Skills covered

Level & pre-requisites

Skills covered