Zenler Player
Your course is loading. Hang tight.
Microsoft Excel Level 1 and Level 2
Back to curriculum
0% Complete
0% Complete
Working with Sheets (10:24)
Formulas with Cell References (11:29)
Make List of Unique Data (6:00)
1. Why We Need Excel (3:56)
2. Opening and Saving Files, Extensions (6:34)
3. Using Templates (4:52)
4. Working with Sheets (10:24)
5. Tabs in Excel (6:25)
6. Writing Formulas (7:14)
7. Formulas with Cell References (11:29)
8. Formatting the Cells (12:05)
9. Formatting. Useful Tricks (7:48)
10. Format Painter (7:33)
11. Formatting the Sheet (3:59)
12. Printing File (9:13)
13. Page Layout (8:59)
14. Sort (3:21)
15. Filter (7:08)
16. Changing the Order of Columns (5:45)
17. Freeze Panes (4:25)
01. Improve your speed (9:32)
02. Make Files Look Nice (24:35)
03. Analyze Tables Fast (18:39)
04. Create Series of Data (9:18)
05. Find and Select (13:47)
06. Sort Data in a New Way (8:47)
07. Filter Data (14:24)
08. Split Text to Columns Using Some Logics (8:10)
09. Make List of Unique Data (6:00)
10. Dummy Checks for Data Input (10:19)
11. Transform Tables (9:23)
12. How to Understand Formulas (15:17)
13. Get Data From Another Table (19:58)
14. Let Excel Know New Data is There (7:38)
15. Sum Data Based on Criteria (12:49)
16. Count Data Based on Criteria (7:37)
Free Previews
Working with Sheets (10:24)
Preview
Formulas with Cell References (11:29)
Preview
Make List of Unique Data (6:00)
Preview
Level 1
1. Why We Need Excel (3:56)
2. Opening and Saving Files, Extensions (6:34)
3. Using Templates (4:52)
4. Working with Sheets (10:24)
5. Tabs in Excel (6:25)
6. Writing Formulas (7:14)
7. Formulas with Cell References (11:29)
8. Formatting the Cells (12:05)
9. Formatting. Useful Tricks (7:48)
10. Format Painter (7:33)
11. Formatting the Sheet (3:59)
12. Printing File (9:13)
13. Page Layout (8:59)
14. Sort (3:21)
15. Filter (7:08)
16. Changing the Order of Columns (5:45)
17. Freeze Panes (4:25)
Level 2
01. Improve your speed (9:32)
02. Make Files Look Nice (24:35)
03. Analyze Tables Fast (18:39)
04. Create Series of Data (9:18)
05. Find and Select (13:47)
06. Sort Data in a New Way (8:47)
07. Filter Data (14:24)
08. Split Text to Columns Using Some Logics (8:10)
09. Make List of Unique Data (6:00)
10. Dummy Checks for Data Input (10:19)
11. Transform Tables (9:23)
12. How to Understand Formulas (15:17)
13. Get Data From Another Table (19:58)
14. Let Excel Know New Data is There (7:38)
15. Sum Data Based on Criteria (12:49)
16. Count Data Based on Criteria (7:37)
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Mark Complete