Udemy

Platform

English

Language

Microsoft

Category

Most Essential & Popular Excel Formulas And Functions - 2021

Vlookup,Excel Formulas and Functions ,Excel, advanced excel ,excel ,Basic Excel, Essential Excel, Excel Beginners,

4.32 (484 reviews)

Students

3.5 hours

Content

Jan 2021

Last Update
Regular Price

Topics

EXCLUSIVE SKILLSHARE OFFER
Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

How to write basics formulas and perform calculations from scratch

Learn the most popular Microsoft Excel functions for beginners

Identify formulas and functions and know the difference between the two.

How To Use The Popular Mathematical Function In Excel With Real Practical Excel Sheets Such As SUM, AVERAGE, MAX, MIN, ROUND, SUMIF, COUNT, COUNTA, COUNTIF Functions

How To Use The Essential Text Function In Excel With Real Practical Excel Sheets Which Are LEFT, RIGHT, CONCATENATE, UPPER, LOWER, MID, PROPER, TRIM, REPT, TYPE, EXACT, HYPERLINK Functions

How To Use The Essential & Popular Date & Time Functions In Excel With Real Practical Excel Sheets Which Are NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIME, EDATE

How To Use The Lookup Function In Excel Which Are IF, VLOOKUP, AND, OR, Functions With Real Practical Excel Sheets

How To Use The DATA VALIDATION, FILTER Function In Excel With Real Practical Excel Sheets


Description

Recent Student's Reviews


***This Course Is Really Too Good For Who Want To Learn Excel And Intermediate Level. The Trainer Demonstrates The Good Examples To Understand The Things In Better Matter, Not Only That He Provides Practical Methods That Is Really Awesome, Thank You So Much For Your Efforts And All The Best. - Vinaykumar Karne***


***Excellent Experience - Daniel Chong SáNchez***


***One Of The Best Excel Course For The Beginners, He Clearly Explains All The Important Things In A Short And Crispy Way Which Make The Course Easy To Learn. - Venkatesh Babu G***


***Great Teacher To Learn Lots Of Things With Simple Way. - Sawaimal Malhi***


***Awesome, I Learned New Excel Function - Faleti Sulaimon Shile ***


***I Enjoyed The Course! Thank You So Much! Best For Beginners, Very Easy To Follow. Thanks Again! - Danica Cecilia Rojero***


Nine Reasons why you should choose this Most Essential & Popular Excel Formulas And Functions - 2021 Course

  1. Best Rated Course on Udemy

  2. You will learn various data analysis techniques using MS Excel

  3. Latest updated and Doubts Are Solved in this course

  4. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  5. you can complete this course In Short time

  6. Essential & Popular Microsoft Excel related examples and case studies Provided

  7. 44 Examples And  practice exercises Are Able to Download in The Recourse Section

  8. Your queries will be responded by the Instructor With In Short time

  9. A Verifiable Certificate will Be Provided On the Completion



  • Excel formulas and functions are very important in the daily life , especially in cooperative world to obtain the meaningful massage to managerial people to decision making and They are essential to manipulating data and obtaining useful information from your Excel workbooks.

  • Without Excel formulas and functions, it is difficult to take important decisions. Welcome to MY MOST ESSENTIAL AND POPULAR EXCEL FORMULAS AND FUNCTIONS 2021 course.

  • I am going to be attached 44 Real world excel work books file for the illustration under this course and I am going to explain one by one in relevant chapter, after completing this course you are able to perform those excel work books yourself in easy manner.


What is covered in this course?


Chapter -01- Brief Introduction About Excel, Microsoft Excel Interface, Introduction Formulas & Functions

Chapter -02 - How To Use The Popular Mathematical Function In Excel With Real Practical Excel Sheets Such As SUM, AVERAGE, MAX, MIN, ROUND, SUMIF, COUNT, COUNTA, COUNTIF Functions

Chapter -03 - How To Use The Essential Text Function In Excel With Real Practical Excel Sheets Which Are LEFT, RIGHT, CONCATENATE, UPPER, LOWER, MID, PROPER, TRIM, REPT, TYPE, EXACT, HYPERLINK Functions

Chapter -04 - How To Use The Essential & Popular Date & Time Functions In Excel With Real Practical Excel Sheets Which Are NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIME, EDATE

Chapter -05- How To Use The Lookup Function In Excel Which Are IF, VLOOKUP, AND, OR Functions With Real Practical Excel Sheets

CHAPTER -06- How To Use The DATA VALIDATION, FILTER Function In Excel With Real Practical Excel Sheets


Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen


Screenshots

Most Essential & Popular Excel Formulas And Functions - 2021
Most Essential & Popular Excel Formulas And Functions - 2021
Most Essential & Popular Excel Formulas And Functions - 2021
Most Essential & Popular Excel Formulas And Functions - 2021

Content

INTRODUCTION THE COURSE

INTRODUCTION THE COURSE

CHAPTER -01 - INTRODUCTION TO EXCEL

Introduction To Excel - Part 1

Introduction To Excel - Part-2

CHAPTER-02 - MATHEMATICAL FUNCTIONS

SUM,AVERAGE AND MAX FUNCTIONS

MIN, ROUND AND SUMIF FUNCTION

COUNT,COUNTA AND COUNTIF FUNCTION

MATHEMATICAL FUNCTION - OVERALL EXERCISES

CHAPTER -03 - TEXT FUNCTIONS

LEFT,RIGHT,CONCATENATE FUNCTIONS

UPPER, LOWER,MID FUNCTIONS

PROPER,TRIM,REPT FUNCTIONS

TYPE, EXACT,HYPERLINK FUNCTIONS

TEXT FUNCTION - OVERALL EXERCISES

CHAPTER -04- DATE & TIME FUNCTIONS

NOW AND TODAY FUNCTIONS

YEAR,MONTH,DAY FUNCTIONS

HOUR,MINUTE,SECOND,TIME,EDATE FUNCTIONS

DATE & TIME FUNCTION - OVERALL EXERCISES

CHAPTER -05- LOGICAL FUNCTIONS

IF AND VLOOKUP FUNCTIONS

AND ,OR FUNCTIONS

LOGICAL FUNCTION - OVERALL EXERCISES

CHAPTER - 06 DATAVALIDATION & FILTER

DATA VALIDATION & FILTER

DATA VALIDATION AND FILTER - OVERALL EXERCISES


Reviews

M
Mohd16 May 2021

Course is nice. Precise and to the point. Worksheet is provided with each lesson as do it yourself practice.

J
Jason4 January 2021

It's to my eyes the best course to start with excel. It's short and it helps you to take out the fear that you have when you are thinking on manipulate excel.

A
Abhishek16 December 2020

Love the way he is teaching. Presentation is also very good , overall a very good experience from this course. Thank you!

V
Venkatesh14 October 2020

One of the best excel course for the beginners, He clearly explains all the important things in a short and crispy way which make the course easy to learn.

M
Mat28 September 2020

In a term of knowledge about excel this course is fine. The English grammar and pronunciation are disturbing.

E
Evander22 September 2020

The course instructor English and the way of delivering the content is not engaging with the listener. A course you can give a try .

Y
Yogesh20 September 2020

it's a very nice video and that video i learn all inmoprtant formula's thanks for this video and thanks for udemy

S
Shaeesta20 August 2020

The course is very helpful.Mr Mubeen had cleared all the doubts which I had earlier and his style of teaching is very simple yet informative. Thank you

M
MN10 August 2020

Nice and amazing course...and in each section end everything is revised . so it gives a good experience but only thing is only formula part of excel is covered. thank you to the speaker and content creator

V
VinayKumar15 March 2020

This course is really too good for who want to learn Excel and Intermediate Level. The Trainer demonstrates the good examples to understand the things in better matter, not only that he provides practical methods that is really awesome, Thank you so much for your efforts and All the Best.

R
Rams8 March 2020

Watched Few Videos, not fully completed, So far , Learned some more inputs about Excel Formulas and Functions etc., Great Course


Coupons

DateDiscountStatus
3/8/2020100% OFFExpired
3/23/202080% OFFExpired
4/7/202088% OFFExpired
4/12/202088% OFFExpired
5/16/202095% OFFExpired
5/21/2020100% OFFExpired
7/7/2020100% OFFExpired
7/20/2020100% OFFExpired
7/27/2020100% OFFExpired
8/6/2020100% OFFExpired
8/15/2020100% OFFExpired
8/18/2020100% OFFExpired
9/6/2020100% OFFExpired
9/13/2020100% OFFExpired
9/22/2020100% OFFExpired
10/13/2020100% OFFExpired
10/19/2020100% OFFExpired
11/1/2020100% OFFExpired
11/14/2020100% OFFExpired
11/22/2020100% OFFExpired
11/27/2020100% OFFExpired
12/2/2020100% OFFExpired
12/15/2020100% OFFExpired
12/24/2020100% OFFExpired
1/6/2021100% OFFExpired
1/26/2021100% OFFExpired
1/29/202150% OFFExpired
2/12/2021100% OFFExpired
2/21/2021100% OFFExpired
3/5/2021100% OFFExpired
3/13/2021100% OFFExpired
3/20/2021100% OFFExpired
4/6/2021100% OFFExpired
4/10/2021100% OFFExpired
4/17/2021100% OFFExpired
5/9/2021100% OFFExpired
5/18/2021100% OFFExpired
5/23/2021100% OFFExpired
6/7/2021100% OFFExpired
6/11/2021100% OFFExpired

2844954

Udemy ID

3/1/2020

Course created date

3/8/2020

Course Indexed date
Lee Jia Cheng
Course Submitted by

Twitter
Telegram