AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Excel 2007

Print Version

This course has been designed to get you up and going, quickly, easily, and painlessly with Microsoft® Excel 2007, the most popular spreadsheet application in the marketplace today. The instructor guides you through the use of the basic spreadsheet functions ensuring your success and enhanced productivity. Learn about the new navigation features within Microsoft's new Office interface.

Practice what you learn with the hands-on interactive labs.



3 levels - 80 modules - 9 learning hours

 

Available Options

SINGLE USER: Excel 2007 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs$149.00Add To Cart
1 YR ONLINE$149.00Add To Cart
CD-ROMs$149.00Add To Cart
DVD-Video$149.00Add To Cart
MULTI USER: Excel 2007 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs$298.00Add To Cart
CD-ROMs$298.00Add To Cart
DVD-Video$298.00Add To Cart
For additional licensing options. pricing and information, call 877-752-3529

Course Instructor: Debbie Dalrymple

Debbie has been doing computer training since 1992. Starting her training career at Computer Learning Center in Washington DC working with DOS and early Windows applications she has transitioned to the latest Windows software that we know today. Throughout the past two decades Debbie has worked training students and providing technical support and consulting services in a variety of other industries such as Architecture, Law, Federal Government, Pharmaceutical and the Oil Industry as well as extensive non-profit work.

Course Outline

Excel 2007 Basic

1.0 Creating a Basic Worksheet
  • 1.1 Explore the User Interface and the Ribbon
  • 1.2 Customize the Quick Access Toolbar
  • 1.3 Navigate and Select in Excel
  • 1.4 Enter Data and Save a Workbook
  • Lab 1
2.0 Performing Calculations
  • 2.1 Create Basic Formulas
  • 2.2 Calculate with Functions
  • 2.3 Copy Formulas and Functions
  • Lab 2
3.0 Modifying a Worksheet
  • 3.1 Manipulate Data
  • 3.2 Working with Cells, Columns, and Rows
  • 3.3 Search for Data in a Worksheet
  • 3.4 Spell Check a Worksheet
  • Lab 3
4.0 Formatting a Worksheet
  • 4.1 Modify Fonts
  • 4.2 Add Borders and Color to Cells
  • 4.3 Change Column Width and Row Height
  • 4.4 Apply Number Formats
  • 4.5 Using Styles
  • Lab 4
5.0 Printing Workbook Contents
  • 5.1 Print Workbook Contents Using Default Print Options
  • 5.2 Setting Page Breaks
  • Lab 5
6.0 Managing Large Workbooks
  • 6.1 Format Worksheet Tabs
  • 6.2 Manage Worksheets in a Workbook
  • 6.3 Manage the View of Large Worksheets
Excel 2007 Intermediate

1.0 Calculating Data with Advanced Formulas
  • 1.1 Manage Cell and Range Names
  • 1.2 Calculating Data Across Worksheets
  • 1.3 Analyzing Data with Logical and Lookup Functions
  • Lab 1
2.0 Organizing Worksheet and Table Data
  • 2.1 Creating and Modifying Tables
  • 2.2 Formatting Tables
  • 2.3 Sorting or Filtering Worksheet or Table Data
  • 2.4 Calculating Data in a Table or Worksheet
  • Lab 2
3.0 Presenting Data Using Charts
  • 3.1 How to Create a Chart
  • 3.2 Modifying Charts
  • 3.3 Formatting Charts
  • Lab 3
4.0 Analyzing Data Using PivotTables and PivotCharts
  • 4.1 Creating a PivotTable Report
  • 4.2 Analyzing and Modifying a PivotTable
5.0 Inserting Graphic Objects
  • 5.1 Inserting and Modifying Pictures and ClipArt
  • 5.2 Drawing and Modifying Shapes
  • Lab 4
6.0 Customizing and Enhancing Workbooks and the Excel Environment
  • 6.1 How to Customize the Excel Environment
  • 6.2 Customizing Workbooks
  • 6.3 Managing Themes
  • 6.4 How to Create and Use Templates
  • Lab 5
Excel 2007 Advanced

1.0 Streamlining Workflow
  • 1.1 Creating Macros
  • 1.2 Adding Macros to the Quick Access Toolbar
  • 1.3 Editing a Macro
  • 1.4 Using Conditional Formatting
  • 1.5 Applying Data Validation to a Worksheet
  • 1.6 Updating Workbook Properties
  • 1.7 Modifying Excel Options
2.0 Collaborating with Others
  • 2.1 Protecting Files and Sharing Workbooks
  • 2.2 Merging Multiple Workbooks
  • 2.3 Adjusting Macro Settings
  • 2.4 Restricting Document Access
3.0 Auditing Worksheets
  • 3.1 Tracing Cell Precedents and Dependents
  • 3.2 Troubleshooting Errors in Formulas
  • 3.3 Watching and Evaluating Formulas
  • 3.4 Creating a Data List Outline
4.0 Analyzing Data
  • 4.1 Adding a Trend Line to Charts
  • 4.2 Create Scenarios and Performing What-If Analysis
5.0 Working with Multiple Workbooks
  • 5.1 Create a Workspace
  • 5.2 Consolidate Data
  • 5.3 Managing Linked Cells in Different Workbooks
6.0 Importing and Exporting Data
  • 6.1 Exporting Excel Data
  • 6.2 Importing a Table from Word
  • 6.3 Importing a Delimited Text File