Course Details
Microsoft Office Excel Power User, version 2010
24 Jul 2015
Professional Development
Computer Skills / Applications
Manukau Institute of Technology
Faculty of Business and Information Technology
Reception, Floor 2
Corner of Manukau Station Road and Davies Avenue,
Manukau
Half Day
9.00am to 12.30pm
9.00am to 12.30pm
$241.50
including GST
including GST
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
Manuals are included in the course fee.
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
Manuals are included in the course fee.
Annemarieke Ymker