ADVANCE EXCEL

ADVANCE EXCEL

ADVANCE EXCEL

  • GETTING STARTED

  • FORMATTING A SPREADSHEET

  • FORMULAS AND FUNCTIONS

  • PAY SLIP OF EMPLOYEE

  • WORKING WITH LARGE WORKSHEET

  • FUNCTION WITH CONDITION, SUMIF, COUNTIF

  • WORKING WITH CHARTS

  • PIVOT TABLE

  • DATA VALIDATION

  • WORKING WITH TEMPLATES

  • SORTING AND FILTERING DATA

  • WORKING WITH REPORTS

  • LOOKUP, HLOOKUP, VLOOKUP,

  • FINANCE FORMULAS

  • ADVANCE FILTER CONDITION

  • CONDITIONAL FORMATTING

  • PAGE SETUP, PREVIEWING AND PRINTING

  • DATABASE OPERATIONS

  • WORKING WITH MIS REPORTS

  • MACROS

PROJECTS WORKS EXAMPLES

  • MONTHLY EXPENSES RECORD
  • TO DO LIST
  • PHONE LIST
  • SALARY RECORDS ETC.

OTHERS LOGICAL FORMALAS

  • IF, AND DATE , MATH , FORMULAS
  • GOAL SEEK, HYPERLINK
  • GROUPING & UNGROUPING
  • SCENARIO MANAGER & MUCH MORE
FEES : 5000/- Duration 3 Months
ENROLL NOW