Provider Registration Provider Login

Course Details

Book with this provider now

Microsoft Office Excel Intermediate, version 2010
17 Nov 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
$241.50
including GST
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
growme © copyright 2024 | Site by oneclick