1-866-245-5224 sales@keystonelearning.com

Excel 2007: Excel 2007 Course Overview (All Levels)

Excel 2007: Excel 2007 Course Overview (All Levels)

The Excel 2007 Course contains three levels: Beginner, Intermediate and Advanced. You can view the topics by level by clicking the links below:

Level 1: Beginner

Level 2: Intermediate

Level 3: Advanced

Excel 2007 Beginner Course Overview

Part of the Microsoft Office 2007 suite, Excel 2007 is Microsoft’s powerful spreadsheet program whose primary purpose is to help you crunch numbers – both big and small. This beginner-level course will familiarize you with the fundamentals of Excel 2007 to help you get started using the commanding program quickly.



Specific topics include:



Getting Started

    Launching Excel 2007

    Touring the Excel Window

    Using the Office Menu

    Using the Quick Access Toolbar

    Save vs. Save As

    File & Folder Management

    Opening & Closing Files

    Getting Help



Entering Data

    Navigation & Selection Techniques

    Data Entry Techniques

    AutoFill

    AutoComplete

    Undo & Redo

    Exiting Excel



Changing Worksheet Layout

    Inserting Rows, Columns & Cells

    Deleting Rows, Columns & Cells

    Adjusting Column Widths & Row Heights

    Hiding Columns & Rows

    Moving & Copying Data

    Create, Modify & Delete Named Ranges

    Go To, Find & Replace



Entering Formulas

    Anatomy of a Formula

    Using the Formula Tab

    AutoSum

    Basic Functions

    Copying Formulas



Formatting

    Using the Home Tab

    Using the Quick Format Mini Toolbar

    Number Formats

    Format as a Table

    Merging & Splitting Cells

    Applying Worksheet Backgrounds



Using Themes & Styles

    Applying Themes

    Creating Custom Themes

    Applying Styles

    Creating Custom Styles



Printing

    Using the Page Layout Tab

    Changing Margins & Page Orientation

    Exploring Worksheet Views

    Adding Headers & Footers

    Adding Print Titles and a Print Area

    Viewing & Setting Page Breaks

    Printing



Charts

    Using the Insert Tab

    Creating a Chart

    Using the Chart Contextual Tabs

    Creating a Chart Sheet

    Adding & Removing Chart Data

    Format & Resize Charts



Return to Top



Excel 2007 Intermediate Course Overview

Part of the Microsoft Office 2007 suite, Excel 2007 is Microsoft’s powerful spreadsheet program whose primary purpose is to help you crunch numbers – both big and small. This intermediate-level course will cover the following topics:



Managing Workbooks

    Creating New Workbooks from a Template

    Rename & Move Workbook Tabs

    Insert & Delete Worksheets

    Copy & Paste Worksheets

    Using the View Tab

    Splitting Your Worksheet View

    Freezing & Unfreezing Your View



Tables & Data Management

    Table Guidelines

    Using the Data Tab

    Sorting

    Grouping & Outlining Data

    AutoFilter

    Advanced Filter Using Single Criteria

    Advanced Filter Using Multiple Criteria

    Automatic Subtotals



Using Cell References

    Using Relative Cell References

    Using Absolute Cell References

    Using Mixed Cell References



Auditing

    About Auditing

    Tracing Precedents

    Tracing Dependents

    Tracing Errors



Creating Web Pages from Workbooks

    Publishing a Web Page

    Viewing Your Published Web Page



Using Excel with Other Applications

    Importing Data to Excel

    Exporting Data from Excel

    About XML



Customizing Excel

    Customizing the Quick Access Toolbar

    Modifying Excel Options



Using Scenarios & Watching Cells

    Creating & Displaying Scenarios

    Editing & Removing Scenarios

    Summarizing Scenarios

    Using the Watch Window



PivotTables & PivotCharts

    About PivotTables & PivotCharts

    Creating a PivotTable

    Modifying a PivotTable

    Creating a PivotChart

    Modifying a PivotChart



Return to Top



Excel 2007 Advanced Course Overview

Part of the Microsoft Office 2007 suite, Excel 2007 is Microsoft’s powerful spreadsheet program whose primary purpose is to help you crunch numbers – both big and small. This advanced-level course will cover the following topics:



Collaborating

    Inserting & Deleting Comments

    Viewing & Printing Comments

    Protecting Workbooks, Worksheets & Cells

    Enabling Workbook Security

    Sharing Workbooks



Advanced Formulas & Functions

    IF Functions

    Nested IF Functions

    Using the VLOOKUP Function

    Using the HLOOKUP Function

    Using the DSUM Function



Data Consolidation

    About Data Consolidation

    Three Dimensional Formulas

    Data Consolidation by Position

    Data Consolidation by Category



SmartArt

    About SmartArt

    Creating a List

    Creating a Hierarchy

    Creating a Pyramid

    Editing SmartArt



Track Revisions

    Tracking Changes

    Accepting & Rejecting Changes



Data Validation & Conditional Formatting

    Working with Data Validation Rules

    Set Conditional Formatting

    Use Expressions in Conditional Formatting



Creating Templates

    Using Excel Pre-Defined Templates

    Creating & Modifying a Template



Macros

    Create a Macro

    Run a Macro

    Edit a Macro



Return to Top