Microsoft Office Excel 2010 Intermediate

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.