Click Here To Show/Hide Course Description

Module 1: Excel Essentials  & Intro to Formulas

• 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
• 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 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
• Formatting spreadsheet data
• Applying autoformat
• 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
• Printing your worksheets

Module 3: Database/List Tools and Charting

• 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
• 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 4: Import Data & Pivot Tables , Protection & Linking

• Importing data
• Creating a database query
• Creating and modifying pivot tables
• Creating pivot charts
• Linking data
• Applying Data Validation
• Protecting cells, worksheets, and workbooks
• Using conditional formatting
• Inserting comments
• 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
• Other useful functions

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

• Consolidating data
• Using the Goal Seek and Solver Tools
• Creating Data Tables
• Using the Scenario Manager
• Recording and running a macro
• Editing a macro
• Creating buttons to run macros
• Customizing toolbars