Course Details

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

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

Manuals are included in the course fee.

Annemarieke Ymker