MS EXCEL 2007/2010 – ADVANCED LEVEL (DURATION: 2 DAYS)

Course Outline:

  • Date and Time functions
  • Logical functions (IF, AND, OR…)
  • Summary functions (SUMIF, COUNTA, COUNTIF…)
  • Reference functions (VLOOKUP, HLOOKUP…)
  • Financial functions (FV, PV, NPV, PMT…)
    Text functions (PROPER, UPPER, CONCATENATE, LEFT…)
  • Nested functions
  • Array formulas
  • Data Validation
  • What-If Analysis (Data Tables, Scenarios, Goal Seek, Solver…)
  • Pivot Tables and Pivot Charts
  • Excel Auditing tools & functions
  • Preventing wrong date formats
  • Preventing duplication of invoice numbers
  • Macros
 
 
DURATION AND COURSE FEES


Duration :2 days

Fee Per Participant: GH¢500

 

 
 
       
   
 
Copyright © 2009 ~ Applied- Excel Training . All rights reserved. Developed and Hosted by Pamey