Course Details

MS Excel 2010 Advanced (Tues May 13th 2014)
The registration period has expired.
Category:
Information Technology
Target group:
Strong users of Excel who want to develop Excel Advanced features including formulas, pivot tables, macros and generating summary reports
Content:

  • Overview of Excel Shortcuts

  • What is new in Excel 2010

  • Advanced Worksheet functions: left, right, mid, find, Sumif, Countif, lookupfunctions incl. VLookUp, HLookUp, Index, Match, Statistical functions incl. Forecast, Frequency Function, Database Functions incl Watching A Function, Evaluate A Function, Formula Auditing
  • Advanced Charting Concepts

  • Data Entry Validation

  • Data Consolidation

  • Data Tables

  • Pivot Tables

  • Subtotal tool

  • Macros
Prerequisites:
Intermediate level MS Excel.
Applicants will be requested to complete pre-training questionnaire.
Start date (yyyy-mm-dd):
May 13, 2014
Duration:
1 days
Time:
9.30am - 4.30pm
Organiser:
Organisation & Staff Development, Human Resources
Venue:
PC Suite, Nursing and Midwifery Library Extension, Basement level, JHL
The registration period has expired.

Back