Click Here To Show/Hide Course Description

Module 1: Excel Essentials  & Intro to Formulas/Functions

• Introduction to the Excel 2007 interface: Ribbon, Tabs & Tool-tips
• Navigating and selecting cells
• Keyboard Shortcuts
• Entering and editing data
• Deleting and canceling data
• Performing simple calculations
• Saving your workbook
• Checking compatibility with previous versions of Excel
• Spreadsheet structure and design
• Introduction to the Formulas Ribbon
• Creating basic formulas
• Creating basic functions
• Copying a formula with AutoFill
• Recognizing the differences b/w Relative and Absolute references

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

• Inserting rows and columns
• Moving and copying data
• Using the Autofill feature to complete a series of values
• Introduction to worksheet themes and styles
• Formatting spreadsheet data
• Apply automatic Cell Styles and table formats
• Using and creating templates
• Worksheets - inserting, deleting, renaming, moving, copying, & grouping
• Zooming in or out on a worksheet
• Freezing and splitting panes
• Spell checking your data
• Setting print options through Page Setup
• Using the Page Layout view
• Printing your worksheets

Module 3: Database/List Tools  & Charting

• Overview of list design
• Formatting a list as a table
• Single and Multi-level sorting
• Removing duplicate values from a list
• Filtering data in a list using custom and multiple condition criteria
• Inserting automatic subtotals in a list
• Creating charts in Excel
• Modifying and formatting chart types and chart elements
• Modifying themes to effect chart formatting
• Adding or deleting data from a chart
• Creating custom chart templates
• Printing a chart

Module 4: Import Data & Pivot Tables, Protecting & Linking

• Importing data
• Creating a database query
• Creating and modifying pivot tables
• Creating pivot charts
• Applying Data Validation
• Protecting cells, worksheets, and workbooks
• Linking data
• Using conditional formatting
• Using Data Bars or Icon Sets with conditional formatting
• Creating custom views & customizing Excel

Module 5: Creating Advanced Formulas/Functions

• Creating and applying names in a worksheet
• Using the IF function
• Nesting functions
• Calculating dates
• Using the formula auditing tools
• Using LOOKUP functions
• Using Database functions
• Using Text functions

Module 6: Using the "What If" Data Analysis Tools  & Macros

• Consolidating data
• Using the Goal Seek and Solver Tools
• Creating Data Tables
• Using the Scenario Manager
• Adding the Developer tab to the Ribbon
• Recording and running a macro
• Editing a macro
• Adding a button to run a macro
• Customizing the Quick Access toolbar