ICP Consulting
Tel: 011 510 0555
  • Home
  • About Us
  • Discipline
    • Conducting a Disciplinary Hearing
    • Discipline in the Workplace
  • Softskills
    • Supervisor Training
    • Conflict Management
    • Health and Safety>
      • SHE Awareness
      • SHEQ Representative
      • Legal Liability
    • Communicate
    • Customer Care
  • Microsoft Office
    • Computer Literacy
    • Introduction to Excel
    • Advanced Excel
    • Introduction to PowerPoint
    • Advanced PowerPoint
    • Intermediate Word
    • Advanced Word
  • Insight
    • Business Data Analysis
    • PowerPivot
  • Contact Us

Advanced Excel

Picture
This two day workshop is designed for  business users who are familiar with Excel and would like to learn advanced tables, graphs and data functions.   

The workshop will benefit users from Sales, Marketing, Human Resources, finance and other functions of the business.



Workshop Outcomes:
  • Formatting Tables
  •  Sorting & Filtering Tables
  • Aggregating Tables
  • Aggregation of Sumif, Averageif, Countif Formulas
  • Using Date Formulas
  • Logical Formulas (Vlookup, Hlookup, If
  •  Text Formulas
  •  Finance Formulas
  •  Auditing Formulas
  • Connecting to External Data
  •  Using Excel as a Database
  •  Creating Graphs in Excel

Click to Download the Brochure
SETA Accreditation 4057, BEE Status 4