watching now
5
Students 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 MICROSOFT EXCEL FORMULAS AND FUNCTIONS course.
- I am attached 44 Real world excel work books file for the illustration under this course and I explained one by one in relevant chapter, after completing this course you are able to perform those excel work books yourself in easy manner.
- At completion of this course you will master the Most Essencial And popular Microsoft Excel Formulas And Functions skills of writing and combining formulas and functions, as well as You Will Be performed Well In calculations process in Microsoft Excel that will increase your productivity in Excel. Below the Areas , You Will Be Master In Excel.
The Area You Will Be Master in 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
What Will You 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 ,Date & Time,Lookup,DATA VALIDATION, FILTER Functions In Microsoft Excel
Requirements
- A computer or laptop
- No prior Excel knowledge is needed.
- Microsoft Excel Need to be installed
Curriculum
Course consist of total 3h 20min of content, in total.
Section 1: Introduction to the course
02:57
Section 2: Chapter 02 - Mathematical Functions
37:29
MIN, ROUND, and SUMIF function
08:35
COUNT, COUNTA, and COUNTIF function
07:04
Mathematical Function - overall excersises
13:36
Section 3: Chapter 01 - Introduction to Excel
19:09
Introduction To Excel - Part 2
07:55
Section 4: Chapter 03 - Text Functions
44:50
LEFT, RIGHT, CONCATENATE functions
09:41
UPPER, LOWER, MID functions
05:47
PROPER, TRIM, REPT functions
05:16
TYPE, EXACT, HYPERLINK functions
08:09
Text functions - overall excercises
15:57
Section 5: Chapter 04 - Date & Time Functions
34:40
YEAR, MONTH, DAY functions
07:21
HOUR, MINUTE,S ECOND, TIME, DATE functions
10:14
DATE & TIME functions - overall excercises
09:23
Section 6: Chapter 05 - Logical Functions
37:16
IF and VLOOKUP functions
12:29
AND, OR functions
08:57
Logical functions - overall excercises
15:50
Section 7: Chapter 06 - Data Validation & Filter
24:32
Data Validation & Filter
12:54
Data Validation and Filter - overall excercises
11:38
About the Instructor
I Am the Expert in Microsoft Office ,Tally ERP 9,Accounting & Finance Related Subjects and A Degree Holder (Specialization In Finance) , I Was Working in Different Positions Such as Senior Accountant and Financial Manager of Construction Company. I Have Been Teaching More Than 5 Years And I Delivered Various Lecture Programs and My All Lecture Programs are Much Dynamics & interesting as well. I Hope That You Will Enjoy My All Courses
See All Instructor CoursesBitDegree platform reviews
Days
Hours
Minutes
Seconds