Do you sell tickets for an event, performance or venue?
Find out more about Eventfinda Ticketing.

You missed this – Subscribe & Avoid FOMO!

When:

Tue 19 Feb 2013, 9:00am–12:30pm

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

Restrictions: R15

Ticket Information:

  • General Admission: $243.50 ($241.50 + $2.00 fees)
  • Eventfinda tickets no longer on sale

Who should attend?

Attendees must have attended Microsoft Office Excel for Beginners or have equivalent experience to attend this course.

Core Content

Working with Multiple Worksheets
- Freezing Panes
- Split a Worksheet Window
- Tab Scrolling Buttons
- Tab Split Box
- Renaming Worksheets
- Inserting & Deleting Sheets
- Worksheet Tab Colours
- Moving & Copying Worksheets within the Workbook
- Selecting Sheets in a Workbook
- Group Edit Mode
- Viewing Workbooks

Creating Formulas Across Worksheets
- Linking Worksheet Information
- Consolidating Worksheets

Sorting & Filtering Information
- Databases (Lists)
- Sorting a Database/List
- Filters a Database/List

Series
- Series

Functions
- Functions
- Functions with Arguments
- Relative, Absolute, and Mixed Cell References
- Formula Errors

Preparing the Worksheet for Printing
- Preview your Worksheet
- To Print your Worksheet
-To Prepare your Worksheet for Printing
- Page Setup
- Page Layout Tab
- Page Breaks

Charts
- Create a New Chart
- Resizing and Moving a Chart
- Change the Layout or Style of a Chart
- Modifying a basic chart to meet your needs
- Changing the Chart Type
- Adding Elements to your Chart
- Editing your Chart
- Save a chart as a template

Useful Tips & Shortcuts
- Moving Within a Worksheet
- Selecting Within a Worksheet

Phone 0800 SKILL UP (754 5587) or email businesstraining@manukau.ac.nz to register.

Restaurants to book near Microsoft Office Excel 2010 Intermediate