Course Details

MS Excel 2010 Advanced (Wed June 11th 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):
Jun 11, 2014
Duration:
0 days
Time:
9:30a.m - 4:30p.m
Organiser:
Organisation and Staff Development, Human Resources
Venue:
PC Suite, Nursing and Midwifery Library Extension, Basement level, JHL
Deadline:
14 days before
The registration period has expired.

Back