Click Here To Show/Hide Course Description

Module 1: Excel Essentials

• Introduction to the Excel interface
• Navigating and selecting cells
• Keyboard Shortcuts
• Entering and editing data
• Deleting and canceling data
• Performing simple calculations
• Saving your workbook

Module 2: Introduction to Formulas/Functions

• Spreadsheet structure and design
• 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
• Formatting spreadsheet data
• Apply autoformat

Module 4: Spreadsheet Design, Page Setup & Printing

• Using and creating templates
• Worksheets - insert, delete, rename, move, copy, & group
• Freezing and splitting panes
• Spell checking your data
• Setting print options through Page Setup
• Printing your worksheets

Module 5: Database/List Tools

• Overview of list design
• Single and Multi-level sorting
• Setting custom sort options
• Filtering data in a list using custom and multiple condition criteria
• Using the advanced filter for unlimited 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
• 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
• Inserting comments
• 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

• Recording and running a macro
• Editing a macro
• Creating buttons to run macros
• Customizing toolbars