Course Details

MS Excel Advanced 2010 (Wed March 5th 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.
Start date (yyyy-mm-dd):
Mar 5, 2014
Duration:
1 days
Time:
9:30a.m. - 4:30p.m.
Organiser:
Organisation and Staff Development office
Venue:
Nursing & Midwifery PC Suite, Basement Level, Nursing & Midwifery Library Extension
Deadline:
4 days before
The registration period has expired.

Back