Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Certified ADVANCED Excel Course
Lesson 1
Introduction (23:58)
Sum, Average And If Function (36:51)
Lesson 1 - Introduction (24:55)
Lesson 1 - Introduction (29:59)
Lesson 1 - Introduction (30:02)
Lesson 2
Lesson 2- Sum, Average , If Function (25:05)
Lesson 3
Lesson 3 - Absolute Refrence (21:45)
Lesson 4
Lesson 4- Chart (27:37)
Lesson 5
Lesson 5 - Sort, Filter, Subtotal And Form (23:07)
Lesson 6
Lesson 6- Nested If And Projects (24:26)
Lesson 7
Lesson 7- Linking Excel File To Word, Multiple Sheet Refrence, Recording Macros (23:12)
Lesson 8 - ADVANCE EXCEL
Lesson 8- Count If (23:53)
Lesson 8- Sumif (19:44)
Lesson 9
Lesson 9 - Pivot Table (28:26)
Lesson 10
Lesson 10 - Pivot Table (19:31)
Lesson 11
Lesson 11- Conditional Formating (23:20)
Lesson 11 - Conditional Formating (22:36)
Lesson 12
Lesson 12 - Scenario Manager And VBA Control (34:37)
Lesson 13
Lesson 13 - Vlookup And Hlookup (32:49)
Lesson 14
Lesson 14 - Vlookup, Hlookup And IF And (30:48)
Lesson 15
Lesson 15 - Time Calculation, Adv. Conditional Formating And Vlookup (35:40)
Lesson 16
Lesson 16 - Date Calculation, Age Calculation And Character Function (28:03)
Lesson 17
Lesson 17 - If - Or, Rank, Power And Financial Function (35:24)
Lesson 18
Lesson 18 - Transpose, Goal Seek, Sumproduct And Forecast (27:46)
Lesson 19
Lesson 19 - Dropdown List, Average If And Ceiling (31:11)
Lesson 20
Lesson 20 - Practise Test (27:38)
***ALL ADVANCED EXCEL PROJECTS---DOWNLOAD FROM HERE
***PROJECTS
Lesson 18 - Transpose, Goal Seek, Sumproduct And Forecast
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock