Most Essential & Popular Excel Formulas And Functions
4.2 (38 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,577 students enrolled

Most Essential & Popular Excel Formulas And Functions

Excel Master,Filter,AND,OR ,Vlookup,IF Conditions,Microsoft excel Formulas & Functions ,Excel Basic Formulas & Functions
4.2 (38 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,577 students enrolled
Last updated 3/2020
English
Current price: $119.99 Original price: $199.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 44 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • A computer or laptop
  • No prior Excel knowledge is needed.
  • Microsoft Excel 2007 ,2010,2013,2016,2019 or Office 365 (Some features may not be available in earlier versions)
Description
  • 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 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.

The Course Contents As Below


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


Who this course is for:
  • Excel users both inexperienced and experienced who don't feel confident about using Excel formulas and Functions
  • Anyone who uses Excel for work or personal needs such as Sales Manager, Students, Individual, Accountants ,Auditor, Financial Analyst, Information Clerk
  • Anyone who uses Excel for entering data, lists, formulas, functions
Course content
Expand all 21 lectures 03:21:44
+ CHAPTER -01 - INTRODUCTION TO EXCEL
2 lectures 19:09
Introduction To Excel - Part 1
11:14
Introduction To Excel - Part-2
07:55
+ CHAPTER-02 - MATHEMATICAL FUNCTIONS
4 lectures 37:28
MIN, ROUND AND SUMIF FUNCTION
08:35
COUNT,COUNTA AND COUNTIF FUNCTION
07:03
MATHEMATICAL FUNCTION - OVERALL EXERCISES
13:36
+ CHAPTER -03 - TEXT FUNCTIONS
5 lectures 44:46
UPPER, LOWER,MID FUNCTIONS
05:46
PROPER,TRIM,REPT FUNCTIONS
05:15
TYPE, EXACT,HYPERLINK FUNCTIONS
08:09
TEXT FUNCTION - OVERALL EXERCISES
15:56
+ CHAPTER -04- DATE & TIME FUNCTIONS
4 lectures 34:38
YEAR,MONTH,DAY FUNCTIONS
07:20
HOUR,MINUTE,SECOND,TIME,EDATE FUNCTIONS
10:13
DATE & TIME FUNCTION - OVERALL EXERCISES
09:23
+ CHAPTER -05- LOGICAL FUNCTIONS
3 lectures 37:16
IF AND VLOOKUP FUNCTIONS
12:29
AND ,OR FUNCTIONS
08:57
LOGICAL FUNCTION - OVERALL EXERCISES
15:50