info@cambridgeinfotech.in   080- 40943580 / 9902461116

Advance Excel

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF. What-if analysis Pivot Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • MACROS (Intro)
  • Introduction to VBA Prog

Duration:  1Months