What you learn in Advance Excel

Ch - 1 Introduction to Ms Excel

Ch - 2 IF Condition And Statement

Ch - 3 Adv IF Condition And Statement And Home Tab

Ch - 4 Create Table Program In Excel

Ch - 5 Conditional Formatting in detail

Ch - 6 Conditional Formatting in detail Part 2

Ch - 7 Format option In Home tab

Ch - 8 Pivot Table And Insert Tab

Ch - 9 Page layout Tab And How to Setup Excel Sheets for Print

Ch - 10 Basic to Adv Formula Part - 1

Ch - 11 Basic to Adv Formula Part - 2

Ch - 12 Basic to Adv Formula Part - 3

Ch - 13 Lookup and Vlookup and Hlookup Function

Ch - 14 Create Invoice Bill Part - 1

Ch - 14 Create Invoice Bill Part - 2

Ch - 15 Picture Lookup

Ch -16 Define Name And Name Manager

Ch - 17 Create Age Calculator

Ch - 18 Formula Auditing

Ch - 19 Data Tab

Ch - 20 Data Tool And Consolidate And What if Analysis And Data Validation

Ch - 21 Review Tab

Ch - 22 Calculation of EMI Using PMT And IPMT And PPMT Functions

Ch - 23 View Tab