Event Guide

Powered by:

Microsoft Excel Power User Version 2010

Sorry this event has been and gone

When:

  • Fri 18 Sep ’15, 9:00am – 12:30pm

Where:

Manukau Institute of Technology, Corner of Manukau Station Road & Davies Avenue, Manukau City

Restrictions:

R15

Ticket Information:

  • General Admission: $324.50

Who should attend?
Attendees must have attended Microsoft Office Excel for Beginners, Intermediate & Advanced or have equivalent experience to attend this course.

Core Content:

Analysing & organising data
- Creating scenarios & scenario reports
- Using Goal Seeker
- Using Solver

Conditional formatting
- Apply
- Delete
- Using the C.F. Rules Manager
- Changing Excel's default options
- Working with data tables
- Consolidating data by position or category
- Viewing workbooks/workspace
- Hiding sheets

Templates
- Charts
- Spreadsheets

Advanced functions
- Concatenate
- Isblank

Appendix of common functions
- Financial
- Date & time
- Math & trig
- Statistical
- Database
- Text
- Logical
- IF
- Sparklines

Email: businesstraining@manukau.ac.nz

Related Events

How to get your Event listed

To have your Event appear on NZHerald Events, go to www.eventfinda.co.nz who supply the event listings for this site.

Click here to add your Event now!
Powered by:

© Copyright 2019, NZME. Publishing Limited