ADVANCE EXCEL CONCEPTS

CHAPTER - 1 ADVANCE EXCEL OVERVIEW

CHAPTER - 2 Ms Excel ( IF Condition )

CHAPTER - 3 Ms Excel ( Adv. IF Condition )

CHAPTER - 4 MS EXCEL ( TABLE CREATOR PROGRAMME)

CHAPTER - 5 CONDITIONAL FORMATING IN DETAIL

CHAPTER - 6 ADVANCE CONDITIONAL FORMATING IN DETAIL

CHAPTER - 7 FORMAT OPTION & ALL

CHAPTER - 8 PIVOT TABLE & INSERT TAB

CHAPTER - 9 PAGE LAYOUT

CHAPTER - 10 BASIC TO ADVANCE FORMULA PART - 1

CHAPTER - 11 BASIC TO ADVANCE FORMULA PART - 2

CHAPTER - 12 BASIC TO ADVANCE FORMULA PART - 3

CHAPTER - 13 Microsoft Excel Lookup, Vlookup and Hlookup Function

CHAPTER - 14 TAX INVOICE

CHAPTER - 15 PICTURE LOOKUP

CHAPTER - 16 DEFINE NAME & NAME MANAGER

CHAPTER - 17 AGE CALCULATOR

CHAPTER - 18 FORMULA ADUITING

CHAPTER - 19 DATA TAB

CHAPTER - 20 HOW MANY TYPES OF ENTER

CHAPTER - 21 FILTER

CHAPTER - 22 CALCULATION OF EMI USING PMT, IMPT, PPMT FUNCTION

CHAPTER - 23 SEQUENCE

CHAPTER - 24 HOW TO ADD MINUTES

CHAPTER - 25 FIND DAY AND MOTH NAMES USING TEXT FUNCTION

CHAPTER - 26 HOW TO CALCULATE ANY ORGANIZATION ATTANDANCE

CHAPTER - 27 CREAT SALARY SHEET IN EXCEL

CHAPTER - 28 EMPLOYEE PAYROLL

CHAPTER - 29 HOW TO CREATE RANK

CHAPTER - 30 HOW TO CREATE QR CODE

CHAPTER - 31 DATA ENTRY FORM

CHAPTER - 32 FORMULAS