Course Objectives

Through this training course you will be taught a variety of skills that will allow you to develop a greater understanding of many of the advanced features and tools that are included in Microsoft Word. Below is a summary of features and tools skills that will be explored.

Time

2-4 Hours

Instructional Method

Instructor lead, hands-on course

Prerequisites

• Excel 2003 Intermediate
• This course assumes that you have a basic understanding of Microsoft Excel and are comfortable with the following functions:
• Organizing Data
• Sorting and Filtering Data
• Analyzing Data
• Formulas
• Advanced Data Analyzing
• Formulae with Multiple Worksheets
• Formatting and Presenting Your Data

Who Should Attend?

This program is for anyone that is currently using Excel on a regular basis and wishes to improve their understanding of some of the tools and features that are included in Excel through formal instruction.

Course Content Overview

• M & M Math
• Advanced Functions
• Copying, Filling and Using Cells in Formulae
• Working with Templates
• Working with Multiple Worksheets
• Advanced Charting Options

Workbook Layout

Microsoft Excel Overview

• What is a Spreadsheet?
• Definition of Excel
• Basic Spreadsheet Information
• The Excel Workspace

Lesson One: M & M Math

• Creating your Spreadsheet
• Creating a Formula
• Creating a Chart

Lesson Two: Advanced Functions

• Using Advanced Functions

Lesson Three: Copying, Filling and Using Cells In Formulae

• Copying Information to Other Cells
• Referencing Cells
• Absolute Cell Reference
• Naming a cell

Lesson Four: Working with Templates

• Selecting a template
• Filling in Data and Viewing Results
• Saving a Template

Lesson Five: Working with Multiple Worksheets

• Adding, Deleting and Copying Worksheets
• Renaming Worksheets

Lesson Six: Advanced Charting Options

• Charting Basics
• Using Chart Wizard Options
• Adjusting Your Chart

To schedule this class:
Email Yona or call 815-437-9089