You missed this – Subscribe & Avoid FOMO!

When:

Fri 20 Feb 2015, 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: $244.00 ($241.50 + $2.50 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

Restaurants to book near Microsoft Excel Intermediate Version 2010