Event Guide

Powered by:

Microsoft Excel Intermediate Version 2010

Sorry this event has been and gone

When:

  • Fri 4 Apr ’14, 9:00am – 12:30pm

Where:

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

Restrictions:

R15

Ticket Information:

  • General Admission: $244.00

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

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