ADVANCE EXCEL COURSE 

  Lesson 1

Available in days

days after you enroll

• Introduction (23:58) Preview
• Sum, Average And If Function (36:51) Preview
• Lesson 1 - Introduction (24:55) Start
• Lesson 1 - Introduction (29:59) Start
• Lesson 1 - Introduction (30:02) Start

  Lesson 2

Available in days

days after you enroll

• Lesson 2- Sum, Average , If Function (25:05) Start

  Lesson 3

Available in days

days after you enroll

• Lesson 3 - Absolute Refrence (21:45) Start

  Lesson 4

Available in days

days after you enroll

• Lesson 4- Chart (27:37) Start

  Lesson 5

Available in days

days after you enroll

• Lesson 5 - Sort, Filter, Subtotal And Form (23:07) Start

  Lesson 6

Available in days

days after you enroll

• Lesson 6- Nested If And Projects (24:26) Start

  Lesson 7

Available in days

days after you enroll

• Lesson 7- Linking Excel File To Word, Multiple Sheet Refrence, Recording Macros (23:12) Start

  Lesson 8 - ADVANCE EXCEL

Available in days

days after you enroll

• Lesson 8- Count If (23:53) Start
• Lesson 8- Sumif (19:44) Start

  Lesson 9

Available in days

days after you enroll

• Lesson 9 - Pivot Table (28:26) Start

  Lesson 10

Available in days

days after you enroll

• Lesson 10 - Pivot Table (19:31) Start

  Lesson 11

Available in days

days after you enroll

• Lesson 11- Conditional Formating (23:20) Start
• Lesson 11 - Conditional Formating (22:36) Start

  Lesson 12

Available in days

days after you enroll

• Lesson 12 - Scenario Manager And VBA Control (34:37) Start

  Lesson 13

Available in days

days after you enroll

• Lesson 13 - Vlookup And Hlookup (32:49) Start

  Lesson 14

Available in days

days after you enroll

• Lesson 14 - Vlookup, Hlookup And IF And (30:48) Start

  Lesson 15

Available in days

days after you enroll

• Lesson 15 - Time Calculation, Adv. Conditional Formating And Vlookup (35:40) Start

  Lesson 16

Available in days

days after you enroll

• Lesson 16 - Date Calculation, Age Calculation And Character Function (28:03) Start

  Lesson 17

Available in days

days after you enroll

• Lesson 17 - If - Or, Rank, Power And Financial Function (35:24) Start

  Lesson 18

Available in days

days after you enroll

• Lesson 18 - Transpose, Goal Seek, Sumproduct And Forecast (27:46) Start

  Lesson 19

Available in days

days after you enroll

• Lesson 19 - Dropdown List, Average If And Ceiling (31:11) Start

  Lesson 20

Available in days

days after you enroll

• Lesson 20 - Practise Test (27:38) Start

  ***ALL ADVANCED EXCEL PROJECTS---DOWNLOAD FROM HERE

Available in days

days after you enroll

• ***PROJECTS Start