Hi, welcome to A Drop of Excel.

A lot of people have come to me saying that learning Excel is a very long process and seems very tedious, because it's too vast and too much to learn.

So what i've tried to do here is, put in all the 'essentials only' in a 12 video series called 'A Drop of Excel'.

Each of these videos requires your 45 min - 1 hour dedicated time to learn (and practice).

After this, you will be proficient enough to be able to use Excel on daily basis very smoothly.

I will be starting from the very scratch of Excel and not from any advanced level. But having said that, even if you know the basics, still getting the fundamentals right is very important and then we will move on to learn further.

Go ahead, Start learning!

01 | User Interface and Cell Referencing Basics

02 | Data types and Data structure

03 | Data and Cell Formatting

04 | How to create Formulas and work with various Functions Fundamentals in Excel

05 | How to create a Formula across Sheets and or Files in Excel

06 | How to work with Dates in Excel

07 | How to work with a Large Set of Data in Excel

08 | Restrict and Protect in Excel

09 | Working with IF Conditions and Conditional Formatting in Excel

10 | Paste Special, Find & Replace, Go to Special

11 | How to use $, Vlookup and Xlookup in Excel

12 | Reporting using Pivot Tables, Slicers and Pivot Charts