Log On/Register  

855.838.5028

Excel 2007

Duration: 3 Days, 6 Modules
Module Price: $130
Try Our Excel 2007 E-Learning Video Description

Day 1:

Excel Day 1 will create a strong foundation for using Excel 2007 as a place to organize and analyze information.  Students in this training course will start by establishing essential skills and best practices crucial for using Excel, and will leave with key tools to organize, format, and manage data in a spreadsheet as well as an understanding of basic formulas and functions.  This training course is designed for Individuals, Career Changers, and Skill enhancement.

 

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, copying and pasting 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
  • Grouping and Hiding Rows/Columns
  • Spell checking your data
  • Setting print options through Page Setup
  • Using the Page Layout view
  • Printing your worksheets

 

Day 2:

Day 2 of Excel 2007 training class concentrates on the core functions such as Sorting and Filtering, creating Data Charts and Pivot Tables.  Tools like Data Validation or Conditional Formatting, can help all Excel 2007 users from beginners to the more advanced. Day 2 Excel 2007 training gives attendees the stop by step instruction they need to apply these tools at home or in the office.  

 

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

 

Day 3:

The 3rd day of Excel 2007 training focuses on Advanced Functions like VLookups, SUMIFs and nesting functions. Learning how to utilize the strengths of multiple functions together is what makes this advanced training so valuable. Tools like Solver and Consolidate can save hours of guess and check and data entry, but are not intuitive and this Day 3 of Excel 2007 class breaks them down so they are easy to understand. The day finishes up with an over view of Macros and VBA. 

 

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

Day 1:

Excel Day 1 will create a strong foundation for using Excel 2007 as a place to organize and analyze information.  Students in this training course will start by establishing essential skills and best practices crucial for using Excel, and will leave with key tools to organize, format, and manage data in a spreadsheet as well as an understanding of basic formulas and functions.  This training course is designed for Individuals, Career Changers, and Skill enhancement.

 

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, copying and pasting 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
  • Grouping and Hiding Rows/Columns
  • Spell checking your data
  • Setting print options through Page Setup
  • Using the Page Layout view
  • Printing your worksheets

 

Day 2:

Day 2 of Excel 2007 training class concentrates on the core functions such as Sorting and Filtering, creating Data Charts and Pivot Tables.  Tools like Data Validation or Conditional Formatting, can help all Excel 2007 users from beginners to the more advanced. Day 2 Excel 2007 training gives attendees the stop by step instruction they need to apply these tools at home or in the office.  

 

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

 

Day 3:

The 3rd day of Excel 2007 training focuses on Advanced Functions like VLookups, SUMIFs and nesting functions. Learning how to utilize the strengths of multiple functions together is what makes this advanced training so valuable. Tools like Solver and Consolidate can save hours of guess and check and data entry, but are not intuitive and this Day 3 of Excel 2007 class breaks them down so they are easy to understand. The day finishes up with an over view of Macros and VBA. 

 

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

Prerequisites: No prerequisites for this course

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):