-
Level 1
17 Lessons-
Start1. Why We Need Excel (3:56)
-
Start2. Opening and Saving Files, Extensions (6:34)
-
Start3. Using Templates (4:52)
-
Start4. Working with Sheets (10:24)
-
Start5. Tabs in Excel (6:25)
-
Start6. Writing Formulas (7:14)
-
Start7. Formulas with Cell References (11:29)
-
Start8. Formatting the Cells (12:05)
-
Start9. Formatting. Useful Tricks (7:48)
-
Start10. Format Painter (7:33)
-
Start11. Formatting the Sheet (3:59)
-
Start12. Printing File (9:13)
-
Start13. Page Layout (8:59)
-
Start14. Sort (3:21)
-
Start15. Filter (7:08)
-
Start16. Changing the Order of Columns (5:45)
-
Start17. Freeze Panes (4:25)
-
-
Level 2
16 Lessons-
Start01. Improve your speed (9:32)
-
Start02. Make Files Look Nice (24:35)
-
Start03. Analyze Tables Fast (18:39)
-
Start04. Create Series of Data (9:18)
-
Start05. Find and Select (13:47)
-
Start06. Sort Data in a New Way (8:47)
-
Start07. Filter Data (14:24)
-
Start08. Split Text to Columns Using Some Logics (8:10)
-
Start09. Make List of Unique Data (6:00)
-
Start10. Dummy Checks for Data Input (10:19)
-
Start11. Transform Tables (9:23)
-
Start12. How to Understand Formulas (15:17)
-
Start13. Get Data From Another Table (19:58)
-
Start14. Let Excel Know New Data is There (7:38)
-
Start15. Sum Data Based on Criteria (12:49)
-
Start16. Count Data Based on Criteria (7:37)
-
