Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

10 Reviews

Munirka, Delhi

Course ID: 42313

Munirka, Delhi

Students Interested 0 (Seats Left 0)

10 Reviews

#### Introduction to MS Excel and Understanding Basic Working with it

Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar

Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions

Using Excel Shortcuts with Full

List of Excel shortcuts:

Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheets

Protecting & Un protecting Cells, Rows, Columns and Sheets with or without Password

Page Layout, Themes, Background and Printer Properties

#### Working with Formulas/Functions

Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc

Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc

Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc

Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc

Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc

Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc

Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc

Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc

#### Conditional Formatting

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Color Scales and Icon Sets in Conditional Formatting

Creating New Rules and Managing Existing Rules

#### Data Sorting and Filtering

Sorting Data by Values, Colors, etc

Using Filters to Sort Data

#### Pivot Tables

Creating Pivot Tables

Using Pivot Table Options

Changing and Updating Data Range

Formatting Pivot Table and Making Dynamic Pivot Tables

#### Pivot Charts

Creating Pivot Charts

Types of Pivot Charts and Their Usage

Formatting Pivot Charts and Making Dynamic Pivot Charts

#### VBA Macro

Introduction to VBA Macro

Recording Macro & Understanding Code Behind

Editing, Writing VBA Code and Saving as Macro or Add-In

Not decided yet.

## Students also enrolled in these Courses

4.88 Avg Rating

41 Reviews

42 Students

1 Courses

Neetu Kumari

MBA-HR, B.Sc Maths

She is having more than 4 years of giving professional training on MS Advance Excel to multiple professional to enhance their professional skills as per their expert areas.

4.0

Average Rating

90%
10%
0%
0%
0%

## Reviews

V

Vipin Saini

Best training institute in basic computer and advanced tally accounting in South Delhi. Improve your skills by joining of Drona Training Academy and boost up your career in advanced Tally with GST.

M

Md Aslam Ansari

It was a good experience with Drona Training Academy. They provided me a very good platform to learn and gain enough knowledge in Basic Computer. Their trainer was good and had enough knowledge. I would definitely suggest it for the enthusiast who is willing to gain knowledge in basic computer. Highly Recommended.

O

Ojasvi Chugh

It is a Best Institute for Advanced Excel Training Course, provides a good and creative environment for students. Their faculty was really helpful and educated having years of experience, being really supportive and expressive. Overall it was a good experience to study here.

R

Rubi Rajput

Best for Basic Computer Course, I've joined for basic computer course. As per my learning experience I am very happy with their teaching approach and support. Always recommended.

N

Neha Rajput

Drona Training Academy is best for Basic Computer Course, it is guided by an expert and well experienced one.

U

Ujjwal

Drona Training Academy is one of the best places for basic computer training. I've completed my basic computer training from there. Training vulture was so cozy and trainers are very cooperative. Must recommend.

L

Lalita Kumari

Drona Training Academy is best for Computer Training Courses. I have joined for basic computer course for my banking career and it is guided by an Excel expert and particularly experienced one. They give totally down to earth hands on. I am happy with their teaching approach and support, they give course content session shrewd and they additionally give notes to each class.

P

Drona Training Academy is one of the best institute for Basic Computer Course, their well experienced faculty or expert will transform your Computer skills in under a week without the disappointment you are used to.

H

Himanshu Sharma

Drona Training Academy provides Best Advanced excel Training in Delhi based on current industry standards. They Provides Best advanced Training in Delhi by industry expert.

A

Abhishek Rathore

Drona Training Academy is one of the best institute for Advance Excel Course, their well experienced faculty or expert will transform your Excel skills in under a week without the disappointment you are used to.

## Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

Enquire

Please enter valid question or comment

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Enter valid Email or Phone Number