watching now
2 Students
21 Lessons
Beginner

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

Curriculum

3h 20m
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

Description

Requirements

  • A computer or laptop
  • No prior Excel knowledge is needed.
  • Microsoft Excel Need to be installed

About the Instructor

Reviews 0
Students 1
Courses 1

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

BitDegree platform reviews

Our students say Excellent
4.5 out of 5
trustpilot logo 1 trustpilot logo