Click Here To Show/Hide Course Description

Module 1: Excel Essentials

• 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
  

Module 2: Introduction to Formulas/Functions

• 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 3: Moving/Copying Data, Autofill, & Formatting

• Inserting rows and columns
• Move and copy 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
  

Module 4: Spreadsheet Design, Page Setup & Printing

• Using and creating templates
• Worksheets - insert, delete, rename, move, copy, & group
• 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 5: Database/List Tools

• 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
  

Module 6: Charting Data with Graphs

• 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 7: Import Data & Pivot Tables

• Importing data
• Creating a database query
• Create and modify pivot tables
• Creating pivot charts

Module 8: Protecting Data, Customizing Excel and Linking

• Linking data
• Applying Data Validation
• Protecting cells, worksheets, and workbooks
• Using conditional formatting
• Using Data Bars or Icon Sets with conditional formatting
• Creating custom views & customizing Excel
  

Module 9: Creating Advanced Formulas/Functions

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

Module 10: Advanced Formulas/Functions Continued

• Using LOOKUP functions
• Using Database functions
• Using Text functions
• Other useful functions
• Creating User Defined functions

Module 11: Using the "What If" Data Analysis Tools

• Consolidating data
• Using the Goal Seek and Solver Tools
• Creating Data Tables
• Using the Scenario Manager

Module 12: Introduction to Macros and Customizing Toolbars

• 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