Skill Development Microsoft Excel for Beginners by CA Agrika Khatri

Opening first Excel worksheet, Introduction of every element on sheet and defining range.

Navigation, Data Entry, Formatting and basic calculation Copying formulas, Relative and Absolute Referencing

Comprehensive practice of Relative and absolute referencing Referencing further practice

Quick revision, explaining ribbon and excel shortcuts

Backstage of excel ie. File Tab and introducing the operational

shortcuts L1

Backstage of excel ie. File Tab and introducing the operational shortcuts L2

Customizing the ribbon intro to formula tab

TRUE, FALSE, IF, AND, OR function

IF Function together with AND, OR function. Nested if function

Autosum functions and mathematical exercises

Paste special function

Paste link, transpose, insert, delete and format cells function Linking data between the sheets and its benefit

Conditional formatting

Count Function

Rank function, minimum, MAX, large and Small Function

Sumif, SumIFS

CountIF, Averagelf Function

Mround, Ceiling, Floor

Integer and Trunc functions

AND FUNCTION

Trim and Proper Function

Find and Search Function

Upper, lower and Proper Function

Concatenate Function

Substitute function practice

Substitute and repeat Function

Repeat and Substitute Function

Rounddown, RoundUp functions

Replace Function

Date and Time Function Introduction

Customise your own date format

Today Function and addition, subtraction to dates

EDATE Function

EOM Function

Introduction to chart and different ways of inserting a chart

Introducing all the chart elements and formatting each element 41 improving your chart by using various charts layouts, colours and designs

Data series editing, saving a template and other basic chart details When to use which chart type-an intro & winding up session

VLOOKUP Function

MATCH & HLOOKUP Function

Tell me what do you want option in excel

Protecting, freeze panes, show and customize the ribbon

Undo last step vs. Undo many steps at one go

Table making, designing, Sort & Filter in table mode and with the use of Slicer option

AutoCorrect function for short hand writing, Automatic decimal entry and various miscellaneous points in FILE Tab

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.