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 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