×
×

Free MS-Excel class

learn ms excel in a subtle way

FREE
Description
Instructor
Pre-Requisites
Syllabus
Reviews
Materials
Discussion Forum
Description Instructor Pre-Requisites Syllabus Reviews Materials Discussion Forum

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?
  • 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.
Who should take this course?
  • Post graduate student
  • Businessman
  • Graduate
  • Office going person
Lecture 1 :- Introduction & Statistical Functions

. HOW TO SELECT ROW AND COLUMN

  • Topics

  1. 1. . HOW TO SELECT ROW AND COLUMN
  2. 2. MERGE AND CENTER / WRAP TEXT
  3. 3. SUM, SUMIF, SUMIFS
  4. 4. AVERAGE, AVERAGEIF, AVERAGEIFS
Reviews For The Course

5.0

2 Ratings &
0 Reviews

Rating breakdown

5
80% Complete (danger)
2
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. 


0 Comments

14 Students

2 Courses

Invalid Comment

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

Recommended Courses

×
×
×
×