▲PARNELL Learning www.parnell-learning.com

Microsoft Excel 2007 Essentials 

This course will show you how to do more with your data, including adding graphics (such as Smart Art and PivotTables) and performing advanced data analysis. This course is a must-have for anyone who works with Excel on a daily basis.
Professional training materials to teach either one day or half day Microsoft Office training workshops including Excel 2007. Thousands of trainer's around the world now use these customizable training solutions every day with confidence. Everything you need is classroom ready, so you can focus on the training.

Excel 2007 Course Outline:

Module One: Getting Started
Icebreaker - Housekeeping Items - Pre-Assignment Review - Workshop Objectives - Action Plans And Evaluation Forms
Module Two: Opening And Closing Excel
Opening Excel - Understanding The Interface - Understanding Worksheets - Understanding Workbooks - Closing Excel
Module Three: Your First Worksheet
Entering Data - Using The Wrap Command - Editing Data - Adding Rows And Columns - Checking Your Spelling
Module Four: Working With Excel Files
About the New File Format - Saving Files - Publishing Files To PDF - Sending Files via E-Mail - Opening Files
Module Five: Viewing Excel Data
An Overview Of Excel Views - Switching Views - Using Zoom - Switching Between Open Files
Module Six: Printing Excel Data
An Overview Of The Page Layout Tab - Setting Up Your Page - Using Print Preview - Printing Data
Module Seven: Building Formulas
The Math Basics Of Excel - Building A Formula - Editing A Formula - Copying A Formula - Relative vs Absolute Referencing
Module Eight: Using Excel Functions
Formulas vs Functions - Understanding The Formulas Tab - Using The SUM Function - Using Other Basic Excel Functions - Using The Status Bar to Perform Calculations
Module Nine: Using Time Saving Tools
Using AutoSum - Using AutoFill - Using AutoComplete - Sorting Data - Filtering Data
Module Ten: Formatting Your Data
Changing The Appearance Of Your Text - Changing The Appearance Of Numbers - Setting Alignment Options - Changing Cell Size - Using The Merge Command
Module Eleven: Working With Colours
Adding Borders - Adding Shading - Using Cell Styles - Using The Format Painter - Using Conditional Formatting
Module Twelve: Wrapping Up
Words from the Wise - Parking Lot - Action Plans and Evaluations