×
×
MS-Excel(Basic and Advanced) Master MS-Excel and take your spreadsheets to the next level. 0.0 09 Jul - 18 Jul All Level 20 Hrs (10 Lectures) English Available Batches: 1
₹3000
All
20 Hrs (10 Lectures)
English
Interactive Live Learning
Certificate of Completion

## Knowledge & tools are required

• Ms-Excel 2013 version and above!
• Laptop and a good internet connection!
• Notebooks to make short and quick notes!

## Who should take this course

• Office going person!

## Learnings

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

## Skills you gain

• Ms-Excel
• excel for beginners
• excel

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

## Syllabus

29 Aug INTRODUCTION TO EXCEL
HOW TO SELECT ROW AND COLUMN

MERGE AND CENTER / WRAP TEXT

30 Aug STATISTICAL FUNCTION
SUM,SIMIF,SUMIFS

AVERAGE,AVERAGEIF,AVERGEIFS

COUNT,COUNTA,COUNTIF,COUNTIFS

05 Sep DOLLAR SIGN CONCEPT
HOW TO PUT DOLLAR SIGN,TYPES OF FIXES

06 Sep FILTER AND SORT
MULTILEVEL SORT

FILTER ON NUMBER AND TEXT

12 Sep CONDITIONAL AND LOGICAL FUNCTION
IF,NESTEDIF,AND,OR

13 Sep LOOKUP FUNCTION
VLOOKUP,HLOOKUP,INDEX

19 Sep LOOKUP WITH MATCH
VLOOKUP,HLOOKUP, AND INDEX WITH MATCH

20 Sep CONDITIONAL FORMATTING
VARIOUS TYPES OF CONDITIONAL FORMATTING

26 Sep PIVOT TABLE
VARIOUS ARRANGEMENT OF PIVOT TABLE

27 Sep MISCELLANEOUS FUNCTION AND DOUBT CLEARING
TEXT TO COLUMN,PASTE SPECIAL

## Subham Ghosh

Courses Published
14

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.

## Batches

09 Jul - 20 Jan
Timings : 11:00 AM - 12:15 PM

0.0
0 Reviews
5
0%
0% 0
4
0%
0% 0
3
0%
0% 0
2
0%
0% 0
1
0%
0% 0

## Discussion Forum

All
20 Hrs (10 Lectures)
English
Interactive Live Learning
Certificate of Completion