Beginner's Excel Certificate Course by CA Agrika Khatri

Course Discontinued

This course is no longer available and has been discontinued

Topic Name	Topic Length
Introduction	8 mins
Opening First Excel worksheet, Intoduction of Every Element on Sheet and Defining Range	14 mins
Navigation, Data Entry, Formatting and Basic Calculation	16 mins
Copying Formulas, Relative and Absolute Referencing	11 mins
Comprehensive Practice of Relative and Absolute Referencing	5 mins
Referencing Further Practice	4 mins
Quick Revision, Explaining Ribbon and Excel Shortcuts	14 mins
Backstage of Excel ie. File Tab and Introducing the Operational Shortcuts	28 mins
Customizing the Ribbon Intro to Formula Tab	12 mins
TRUE, FALSE, IF, AND, OR Function	14 mins
IF Function Together with AND, OR Function	12 mins
Nested if Function	5 mins
Autosum Functions and Mathematical Exercises	18 mins
Paste Special Function	12 mins
Paste Link, Transpose, Insert,Delete and Format Cells Function	17 mins
Linking Data Between the Sheets and its Benefit	6 mins
Conditional Formatting	11 mins
Count Function	8 mins
Rank Function, Minimum, MAX, Large and Small Function	8 mins
Sumif, SumIFS	12 mins
CountIF, AverageIf Function	13 mins
Mround, Ceiling, Floor	9 mins
Rounddown, RoundUp Functions	6 mins
Integer and Trunc Functions	6 mins
Trim and Proper Function	9 mins
Find and Search Function	15 mins
Upper, Lower and Proper Function	6 mins
AND FUNCTION	11 mins
Concatenate Function	7 mins
Repeat and Substitute Function	11 mins
Substitute Function Practice	10 mins
Substitute and Repeat Function	6 mins
Replace Function	8 mins
Date and Time Function Introduction	12 mins
Customise Your Own Date Format	8 mins
Today Function and Addition, Substraction to Dates	8 mins
EDATE Function	9 mins
EOM Function	5 mins
Introduction to Chart and Different Ways of Inserting a Chart	14 mins
Introducing all the Chart Elements and Formatting Each Element	16 mins
Improving your Chart by Using Various Charts Layouts, Colors and Designs	6 mins
Data Series Editing, Saving a Template and Other Basic Chart Details	4 mins
When to Use Which Chart Type-an Intro and Winding up Session	11 mins
VLOOKUP Function	12 mins
MATCH and HLOOKUP Function	10 mins
Tell me what do You Want Option in Excel	4 mins
Protecting, Freeze Panes,Show and Customize the Ribbon	5 mins
Table Making, Designng, Sort and Filter in Table Mode and with the Use of Slicer Option	11 mins
AutoCorrect function for Short Hand Wriring, Automatic Decimal Entry and Various Miscellaneous Points in FILE Tab	10 mins

Meet Your Instructor

CA Agrika Khatri

CA Agrika is a qualified Chartered Accountant and holds experience in the Investment Banking Domain. Besides the technical professional background she has due inclination towards spiritual development and conducts programs on mind fullness, meditation and personal growth. She imparts lectures for professional examination and conducts several certification programs. Her easy way to learn mnemonic style and smart revision strategy has helped her student's crack tough professional exam.