×
×

• 24 Apr 2021
• Get started before others
• English

₹ 3000

Description

This course basically deals with Ms-excel basic and advanced Function. Here you will be able to learn about the basics and advance formula which you will require in your day to day work.

Our Microsoft Excel Advanced course is suitable for those who want a sound working knowledge of Excel who wishes to progress to the most complicated functions and features.

What will you learn?
• You will be learning about the basic and advanced function of MS-excel
• The main focus will be on certain functions like -Conditional Function (IF) -Logical function (AND, OR) -Lookup function (VLOOKUP, HLOOKUP, INDEX) -CONDITIONAL FORMATTING
• There are some miscellaneous function which will make your work easier like -PASTE SPECIAL -TEXT-TO-COLUMN
• You will also learn how to write 2 functions at a time like -VLOOKUP AND MATCH -HLOOKUP AND MATCH -INDEX AND MATCH
What knowledge and tools are required?
• Notebooks to make short and quick notes
• Laptop and a good internet connection
• Ms-Excel 2013 version and above
Who should take this course?
• Office going person
Lecture 1 :- INTRODUCTION TO EXCEL

• Topics

1. 1. HOW TO SELECT ROW AND COLUMN
2. 2. MERGE AND CENTER / WRAP TEXT
Lecture 2 :- STATISTICAL FUNCTION

• Topics

1. 1. SUM,SIMIF,SUMIFS
2. 2. AVERAGE,AVERAGEIF,AVERGEIFS
3. 3. COUNT,COUNTA,COUNTIF,COUNTIFS
Lecture 3 :- DOLLAR SIGN CONCEPT

• Topics

1. 1. HOW TO PUT DOLLAR SIGN,TYPES OF FIXES
Lecture 4 :- FILTER AND SORT

• Topics

1. 1. MULTILEVEL SORT
2. 2. FILTER ON NUMBER AND TEXT
Lecture 5 :- CONDITIONAL AND LOGICAL FUNCTION

• Topics

1. 1. IF,NESTEDIF,AND,OR
Lecture 6 :- LOOKUP FUNCTION

• Topics

1. 1. VLOOKUP,HLOOKUP,INDEX
Lecture 7 :- LOOKUP WITH MATCH

• Topics

1. 1. VLOOKUP,HLOOKUP, AND INDEX WITH MATCH
Lecture 8 :- CONDITIONAL FORMATTING

• Topics

1. 1. VARIOUS TYPES OF CONDITIONAL FORMATTING
Lecture 9 :- PIVOT TABLE

• Topics

1. 1. VARIOUS ARRANGEMENT OF PIVOT TABLE
Lecture 10 :- MISCELLANEOUS FUNCTION AND DOUBT CLEARING

• Topics

1. 1. TEXT TO COLUMN,PASTE SPECIAL
Reviews For The Course

## 0.0★

Ratings &
0 Reviews

#### Rating breakdown

5
80% Complete (danger)
0
4
80% Complete (danger)
0
3
80% Complete (danger)
0
2
80% Complete (danger)
0
1
80% Complete (danger)
0

No Reviews Yet
Media
Documents

No Document For This Course.

Instructor Profile

# Subham Ghosh

Hello everyone, I am Subham Ghosh, completed my B.tech from Bhubaneswar and currently pursuing MBA from ICFAI Business School, Hyderabad. Since I understood the importance of excel in the daily routine work of many working professional and students, so I started teaching them. I have been a part of the excel workshop in my college where I have been teaching also to my college mates who didn't know anything about excel.

Invalid Comment

The comment contains inappropriate language. Please check before posting in the discussion forum.
Discussion Forum
×
×
×
×