4.32 (484 reviews)
☑ 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
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
Best Rated Course on Udemy
You will learn various data analysis techniques using MS Excel
Latest updated and Doubts Are Solved in this course
Carefully designed curriculum By Proficient In Microsoft Excel Expert
you can complete this course In Short time
Essential & Popular Microsoft Excel related examples and case studies Provided
44 Examples And practice exercises Are Able to Download in The Recourse Section
Your queries will be responded by the Instructor With In Short time
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!
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
UPPER, LOWER,MID FUNCTIONS
TYPE, EXACT,HYPERLINK FUNCTIONS
TEXT FUNCTION - OVERALL EXERCISES
CHAPTER -04- DATE & TIME FUNCTIONS
NOW AND TODAY 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
Course is nice. Precise and to the point. Worksheet is provided with each lesson as do it yourself practice.
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.
Love the way he is teaching. Presentation is also very good , overall a very good experience from this course. Thank you!
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.
In a term of knowledge about excel this course is fine. The English grammar and pronunciation are disturbing.
The course instructor English and the way of delivering the content is not engaging with the listener. A course you can give a try .
it's a very nice video and that video i learn all inmoprtant formula's thanks for this video and thanks for udemy
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
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
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.
Watched Few Videos, not fully completed, So far , Learned some more inputs about Excel Formulas and Functions etc., Great Course