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
Absolute Refrence (32:07)
Lesson 2- Sum, Average , If Function (25:05)
Lesson 3
Charts (45:04)
Lesson 3 - Absolute Refrence (21:45)
Lesson 4
Sort ,Filter, Subtotal, Form, And Projects (32:47)
Lesson 4- Chart (27:37)
Lesson 5
Nested If, Linking Excel File To Word And Multiple Sheet Reference (35:48)
Lesson 5 - Sort, Filter, Subtotal And Form (23:07)
Lesson 6 ADVANCE EXCEL
Recording Macros, Count If And Sum If (36:06)
Lesson 6- Nested If And Projects (24:26)
Lesson 7
Pivot Table (32:56)
Lesson 7- Linking Excel File To Word, Multiple Sheet Refrence, Recording Macros (23:12)
Lesson 8
Conditional Formating (31:59)
Lesson 8- Count If (23:53)
Lesson 8- Sumif (19:44)
Pivot Table 365
New Lesson (28:26)
Lesson 9
Scenario Manager And VBA Control (34:37)
Lesson 10
Vlookup And Hlookup (32:49)
Lesson 11
Vlookup, Hlookup And IF And (30:48)
Lesson 12
Time Calculation, Adv. Conditional Formating And Vlookup (35:40)
Lesson 13
Date Calculation, Age Calculation And Character Function (28:03)
Lesson 14
If - Or, Rank, Power And Financial Function (35:24)
Lesson 15
Transpose, Goal Seek, Sumproduct And Forecast (27:46)
Lesson 16
Dropdown List, Average If And Ceiling (31:11)
Lesson 17
Practise Test (27:38)
***ALL ADVANCED EXCEL PROJECTS---DOWNLOAD FROM HERE
***PROJECTS
Conditional Formating 365
New Lesson (23:20)
New Lesson (22:36)
Sum, Average And If Function
Complete and Continue