Prerequisites

Basic knowledge of Windows is required with the follow pre-requisites:

Able to maneuver with the mouse – Point, Click, Drag and Double Click.

Able to configure the desktop

Able to use the Control Panel

Able to move and re-size Application Windows

Able to switch between task applications

Course Objectives

This course is designed to give office workers a systematic understanding of a spreadsheet and its benefits.

This program will equip participants with essential skills of effectively utilizing spreadsheet software in a dayto-day business environment. Hand-on exercises will help to reinforce concepts and features covered.

Module 1: What’s New in Excel 2007?

Becoming Familiar with the New User Interface

Managing Larger Data Collections

Using the New Microsoft Office File Format

Formatting Cells and Worksheets

Managing Data Tables More Effectively

Creating Formulas More Easily by Using Formula AutoComplete

Summarizing Data Using New Functions

Creating Powerful Conditional Formats

Creating More Attractive Charts

Controlling Printouts More Carefully

Module 2: Setting Up a Workbook

Creating Workbooks

Modifying Workbooks

Modifying Worksheets

Customizing the Excel 2007 Program Window

:: Course EXC07SBS ::

Module 3: Working with Data and Data Tables

Entering and Revising Data

Moving Data within a Workbook

Finding and Replacing Data

Correcting and Expanding Upon Worksheet Data

Defining a Table

Module 4: Performing Calculations on Data

Naming Groups of Data

Creating Formulas to Calculate Values

Summarizing Data That Meets Specific Conditions

Finding and Correcting Errors in Calculations

Module 5: Changing Document Appearance

Formatting Cells

Defining Styles

Applying Workbook Themes and Table Styles

Making Numbers Easier to Read

Changing the Appearance of Data Based on Its Value

Adding Images to a Document

Module 6: Focusing on Specific Data Using Filters

Limiting Data That Appears on Your Screen

Manipulating List Data

Defining Valid Sets of Values for Ranges of Cells

Module 7: Reordering and Summarizing Data

Sorting Data Lists

Organizing Data into Levels

Looking Up Information in a Data List

Module 8: Combining Data from Multiple Sources

Using Data Lists as Templates for Other Lists

Linking to Data in Other Worksheets and Workbooks

Consolidating Multiple Sets of Data into a Single Workbook

Grouping Multiple Sets of Data

Module 9: Analyzing Alternative Data Sets

Defining and Editing Alternative Data Sets

Defining Multiple Alternative Data Sets

Varying Your Data to Get a Desired Result Using Goal Seek

Finding Optimal Solutions with Solver

Analyzing Data with Descriptive Statistics

:: Course EXC07SBS ::

Module 10: Creating Dynamic Lists with PivotTables

Analyzing Data Dynamically with PivotTables

Filtering, Showing and Hiding PivotTable Data

Editing PivotTables

Formatting PivotTables

Creating PivotTables from External Data

Module 11: Creating Charts and Graphics

Creating Charts

Customizing the Appearance of Charts

Finding Trends in Your Data

Creating Dynamic Charts Using PivotCharts

Creating Diagrams by Using SmartArt

Module 12: Printing

Adding Headers and Footers to Printed Pages

Preparing Worksheets for Printing

Printing Data Lists

Printing Parts of Data Lists

Printing Charts

Module 13: Automating Repetitive Tasks with Macros

Introducing Macros

Creating and Modifying Macros

Running Macros When a Button Is Clicked

Running Macros When a Workbook Is Opened

Module 14: Working with Other Microsoft Office System Programs

Including Microsoft Office System Documents in Excel 2007 Worksheets

Storing Excel 2007 Documents as Parts of

Module 15: Collaborating with Colleagues

Sharing Data Lists

Managing Comments

Tracking and Managing Colleagues’ Changes

Protecting Workbooks and Worksheets

Authenticating Workbooks

Saving Workbooks for the Web

Programme scope, delivery arrangements and suitability are confirmed during enquiry.

Microsoft Excel 2007 Step by Step