Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Certified ADVANCED Excel Course
Lesson 1
Introduction (23:58)
Sum, Average And If Function (36:51)
Lesson 2
Absolute Refrence (32:07)
Lesson 3
Charts (45:04)
Lesson 4
Sort ,Filter, Subtotal, Form, And Projects (32:47)
Lesson 5
Nested If, Linking Excel File To Word And Multiple Sheet Reference (35:48)
Lesson 6 ADVANCE EXCEL
Recording Macros, Count If And Sum If (36:06)
Lesson 7
Pivot Table (32:56)
Lesson 8
Conditional Formating (31:59)
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
Introduction
Complete and Continue