Excel 2007: Introduction

Course Description:

Learn the basics of Microsoft Excel 2007, including creating spreadsheets and charts.

You will learn how to:

·         Identify the different parts of the Excel 2007 screen

·         Use the Ribbon

·         Use Tabs

·         Navigate through a worksheet using the mouse and keyboard

·         Use the new shortcuts

·         Create & edit a spreadsheet

·         Create a basic formula

·         Format a range of numbers

·         Format text

·         Create charts

·         Page Setup options

·         Print a spreadsheet

·         Use the Help option

Prerequisites:

Good working knowledge of Microsoft Windows

Excel 2007: Advanced

Course Description:

Learn the more advanced features of Microsoft Excel, including database manipulating and filtering.

You will learn how to:

• Enter in formulas
• Create and modify a chart
• Select page setup options
• Scale a chart
• Use Excel to create a database
• Sort records
• Use compound criteria
• Use the data form
• Use AutoFilter option
• Extract unique records
• Formula link & command link worksheets
• Name a cell range

Prerequisites: 

Excel 2007 Introduction or equivalent 

Excel 2007:  Data Manipulation

Course Description:

Learn how to access some of the toools of data manipulation such as sorting, advanced filtering, using the divider bars groups, outline, and the data form.

You will learn how to:

• Use Excel to create a database
• Sort a database
• Perform multiple sorts
• Use the data form
• Locate records
• Use autofiller
• Use compound criteria
• Use unique records
• Group and outline
• Divider bars
• Formula linking worksheets
• Command linking worksheets

Prerequisites: 

Excel 2007 Advanced or Equivalent