watching now
5 Students

#### 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.

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
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