Microsoft Excel

Microsoft Excel 2007 Course Offerings

Microsoft Excel 2007 Courses

Protion offers three different in Microsoft Excel2007 courses to meet your training requirements.

These include:

Microsoft Excel 2007 Introduction
Microsoft Excel 2007 Intermediate
Microsoft Excel Pivot Tables 2007 Introduction

Click on the course to view the details.

Microsoft Excel 2007 Introduction

Course Objectives

The overall objective of the Learning Intervention is to become acquainted with Microsoft Excel’s basic introductory functionality. Once you have completed this training module, you will be able to access MS Excel and utilize the program in a simple and beneficial manner.

Course Outline

Learning Unit 1 – The Basics of Excel 2007

· Navigate in and around MS Excel

· Use the Microsoft Excel Help Function

Learning Unit 2 – Navigate in the worksheet and enter Information

· Navigate within a Worksheet

· Enter Data into a Worksheet

· Edit Data within a Worksheet

· Clear Content, Formatting and Comments within a Worksheet

· Use the Fill Handle

Learning Unit 3 – Formulae and Functions

· Work with Formulae

· Work with Functions

· Understand Cell References

Learning Unit 4 – File Operations

· Save New and Existing Files

· Save Files as a different Type or Name

· Close Files

· Open Existing Files

· Create New Files

LearningUnit 5 – Moving and Copying Data

· Cut Cells within a Worksheet

· Copy Cells within a Worksheet

· Use the Clipboard

· Drag and Drop Data within Cells

· Use the Shortcut Menu

· Move and Copy Data between Workbooks

· Insert Data Cells between existing Data Cells

· Move and Copy between Worksheets

· Use the Paste Special Function

Learning Unit 6 – Formatting

· Format Font and Cells

· Format Columns and Rows

· Insert and Delete Cells, Rows, Columns or Worksheets

· Use the Format Painter

· Use Shortcut keys for Formatting

Learning Unit 7 – Working with Multiple Sheets

· Work with Multiple Worksheets

· Activate Group Mode

· Fill Data Across Worksheets

· Protect Worksheet Data

· Protect Worksheets

· View Worksheets Side by Side

· Hide Windows

· Watch Windows

· Change the Colour of Worksheet Tabs

Learning Unit 8 – Printing

· Preview Worksheets before Printing

· Setup Worksheets to be printed

Learning Unit 9 – Manipulating Large Worksheets

· Split the Screen

· Freeze Panes within a Worksheet

· Use the Zoom function in a Worksheet

Learning Unit 10 – Sorting and Subtotalling Data

· Sort Data within a List

· Use the Subtotal Function

Pre Requisites

Learners must have a good understanding of the Windows environment and must also have completed the following Learning Programmes:

· Computer Literacy

Duration of Program

1 Day

Microsoft Excel 2007 Intermediate

Overall Outcome

The overall outcome of the Learning Intervention is to become acquainted with Microsoft Excel’s intermediate functionality. Once you have completed this training module, you will be familiar with intermediate options of accessing MS Excel and utilizing the program in a simple and beneficial manner.

Course Outline

Learning Unit 1 – Introduction

Learning Unit 2 – Functions

· Complete a review of the basic formulas and functions

· Use Absolute referencing

· Create several worksheets which utilise useful calculations

Learning Unit 3 – Working with Multiple Worksheets

· Name, Create and Delete worksheets

· Display and Arrange worksheets

· Copy and move worksheets

· View Multiple worksheets at once

· Link content to other Workbooks and Worksheets

· Reference cells on different Workbooks and Worksheets

· Protect a sheet from changes

Learning Unit 4 – Finding, sorting and Filters

· Create data tables

· Import data from other programs

· Find and replace data

· Sort worksheet data

· Understand tables

· Filter data

· Split data into multiple columns

· Concatenate data

Learning Unit 5 – Performing Advanced Formatting

· Apply Formatting themes

· Apply Cell Styles

· Share Custom Styles between Workbooks

· Create conditional Formatting

· Create and apply Multiple conditional Formatting

· Use and apply Custom Number Formats

Pre Requisites

Learners must have a good understanding of the Windows environment and must also have completed the following Learning Programmes:

MS Excel Introduction

· Entering and editing text within cells

· Adding and deleting rows, columns and cells

· Changing row heights and column widths

· Applying text formatting (including different fonts, sizes and colours)

· Use of basic number formatting e.g. currency, percentage, decimal point

· Be able to perform simple Sum, Average and Count functions

· Be able to create simple Excel formulas

Duration of Program

· 1 Day

Microsoft Excel Pivot Tables 2007 Introduction

Course Objectives

By the end of the Training Program, you will be able to:

· Prepare the data for creating the Pivot table, by:

o Splitting Text from one to two columns

o Formatting the date range

o Create a Pivot table

o Applying custom filters

o Removing filters

o Calculate subtotal

o Manipulating data within the Pivot Table

o Create Pivot Charts

Course Outline

Learning Unit 1 – Data Preparation

· Prepare the data for creating the Pivot table, by:

· Splitting Text from one to two columns

· Formatting the date range

Learning Unit 2 – Creating a Pivot Table

· Create a Pivot table

· Applying custom filters

· Removing filters

· Calculate subtotal

· Manipulating data within the Pivot Table

Learning Unit 3 – Creating Pivot Charts

· Create Pivot Charts

Pre Requisites

Learners must have a good understanding of the Windows environment and must also have completed the following Learning Programmes:

· Computer Literacy

· Excel Intermediate

Duration of Program

4 Hours