Curriculum
Course:
ADVANCE EXCEL 2019
Login
Curriculum
ADVANCE EXCEL 2019
Introduction
0/5
Excel Review (Introduction)
9:17
Preview
Table
4:14
Preview
Format
16:13
Preview
Data Type
14:35
Data Validation
2:06
LOGICAL FUNCTION
0/5
If function
13:50
If and more condition
38:42
Exercises 04-Part 1
15:33
Exercises 04-Part 2
11:51
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី ២ ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Function AND & OR
0/8
AND function
6:42
If with AND Function
29:00
Exercises 03
Text lesson
OR Function
6:42
If with OR Function
4:51
NOT Function
2:50
If, AND, OR & NOT Function
22:26
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី ៣ ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Function DATE & Time
0/13
Day Function
3:00
Month Function
0:39
Year Function
1:41
Days360 Function
2:00
Today function
1:04
Now Function
0:23
Hour and Minute Function និងកំណែលំហាត់ទី១
12:53
Date Function
2:10
Date function និងកំណែលំហាត់ទី ២
7:39
Nested of logical and Date/Time
6:04
Nested of logical and Date/Time_Ex4
37:36
លំហាត់ទី ៥
9:23
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី 4ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Math Function
0/13
MOD Function
0:40
SQRT Function
2:03
INT Function
0:49
Sumif Function
13:24
Round down Function
3:46
Products Function
1:00
Power Function
1:05
Nested of IF with SUMIF
13:24
Nested of IF with SUMIF (Ex3)
38:54
ISBLANK
4:13
Type Function
6:41
IF, Hour, Minute Function
8:30
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី 5ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Lookup and Vlookup Function
0/17
Lookup Function
4:00
VLOOKUP Function
20:34
Transpose Function
3:22
Extract Function
3:12
Len Function
2:51
Left Function
0:54
Right Function
0:24
MID Function
2:00
Upper Function
1:45
Lower Function
0:20
Concalenate
5:25
ISBLANK Function
4:07
Count If Function
1:56
Count A Function
0:56
Count Blank Function
0:57
សំនួរប្រលងសាកល្បង ទី 1 (Advance Excel) រយះពេល 5mn
5 questions
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី ៦ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Pivot Table
0/4
Pivot Table Filter
4:36
Preview
Fill in Missing Data
6:43
សំនួរប្រលងសាកល្បង ទី 2 (Advance Excel) រយះពេល 5mn
5 questions
សូមធ្វើការអនុវត្តលំហាត់ជំពូកទី 7ទាំងអស់នឹងផ្ញើរមកកាន់យើងខ្ញុំ
Assignment
Advance Protect Sheet
0/2
Advance Protect Sheet
04:37
សំនួរប្រលងសាកល្បង ទី 3 (Advance Excel) រយះពេល 5mn
3 questions
Additional Setting Format
0/2
Conditional Formating
4:40
Freeze Panes
4:28
សំនួរប្រលងបញ្ចប់វគ្គសិក្សា រយៈពេល ៣០នាទី (Advanced Excel)
0/1
សំនួរប្រលងបញ្ចប់វគ្គសិក្សា រយៈពេល ៣០នាទី (Advanced Excel)
13 questions
Video lesson
Format
Please enable JavaScript
play-sharp-fill
Sign In
Continue with
Google
or sign in with email
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Confirmation link sent
Please follow the instructions sent to your email address
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?