ADVANCE EXCEL

 COURSE DURATION : - 3 months

ELIGIBLITY : - 10 TH

SYLLABUS

• .CREATING MARKSHEET
• CITY TEMP
• SALARY SHEET 
• ATTENDANCE SHEET 
• PATIENT REPORT
• BALANCE SHEET 
• PROFIT AND LOSS
• SIMPLE INTERSEST
• INDEX AND MATCH
• ATTENDANCE SHEET 
• TRUCK NEED 
• BRAND AND TABLE
• BSNL BILL
• CASH IN HAND
• COMAPANY TIME TABLE
• CONCATENATE
• CONVERT INCH, MM, CM,YR,DAY HR,SEC
• AGE CALCULATION
• GOODS RETURN
• LCM
• PMT FORMULA
• PRODUCT EXPIRY SHEET
• RANK SHEET
• SALES AND PURCHASE WITH GST
• SALE TARGET
• STORE SHEET
• TRACE PRECEDENT AND DEPENDENTS
• STOCK MANAGEMENT
• V- LOOK UP
• MULTI V LOOK UP
• DASHBOARD
• PRODUCTS EXPIRE SHEET 
• H -LOOKUP
• X- LOOKUP
• TRANSPOSE DATA IN EXCEL
• DATA ENTRIES IN EXCEL
• INDEX IN EXCEL
• DATA VALIDATION
• GOAL SEET 
• DATA TABLE
• SENARIO MANAGER 
• ECEL MENU BAR
• EXCEL SHORT CUT COMMANDS
• DGET FUNCTON 
• DELETE BLANK ROW IN EXCEL 
• FILTER USE IN EXCEL 
• PIVOT TABLE IN EXCEL
• ROUNDING OFF FUNCTIONS