Customized Microsoft Office Excel 2007 Training

Do know that you can have the Microsoft Excel 2007 training the way you want it? Here is how:

Step 1) Highlight and email us the topics you are interested in;
Step 2) Include your preferred training format: hands-on or presentation-based and estimate number of attendees;
Step 3) Tell us your preferred training modality: onsite at your office, live online, off site at Solartech or third party locations.

The Fundamentals

Starting Excel 2007

What’s New in Excel 2007

Understanding the Excel Program Screen

Understanding the Ribbon

Using the Office Button and Quick Access Toolbar

Using Keyboard Commands

Using Contextual Menus and the Mini Toolbar

Using Help

Exiting Excel 2007

Worksheet Basics

Creating a New Workbook

Opening a Workbook

Navigating a Worksheet

Entering Labels

Entering Values

Selecting a Cell Range

Overview of Formulas and Using AutoSum

Entering Formulas

Using AutoFill

Understanding Absolute and Relative Cell References

Using Undo, Redo and Repeat

Saving a Workbook

Previewing and Printing a Worksheet

Closing a Workbook

Editing a Worksheet

Editing Cell Contents

Cutting, Copying, and Pasting Cells

Moving and Copying Cells Using the Mouse

Using the Office Clipboard

Using the Paste Special Command

Checking Your Spelling

Inserting Cells, Rows, and Columns

Deleting Cells, Rows, and Columns

Using Find and Replace

Using Cell Comments

Tracking Changes

Formatting a Worksheet

Formatting Labels

Formatting Values

Adjusting Row Height and Column Width

Working with Cell Alignment

Adding Cell Borders, Background Colors and Patterns

Using the Format Painter

Using Cell Styles

Using Document Themes

Applying Conditional Formatting

Creating and Managing Conditional Formatting Rules

Finding and Replacing Formatting

Creating and Working with Charts

Creating a Chart

Resizing and Moving a Chart

Changing Chart Type

Applying Built-in Chart Layouts and Styles

Working with Chart Labels

Working with Chart Axes

Working with Chart Backgrounds

Working with Chart Analysis Commands

Formatting Chart Elements

Changing a Chart’s Source Data

Using Chart Templates

Managing Workbooks

Viewing a Workbook

Working with the Workbook Window

Splitting and Freezing a Workbook Window

Selecting Worksheets in a Workbook

Inserting and Deleting Worksheets

Renaming, Moving and Copying Worksheets

Working with Multiple Workbooks

Hiding Rows, Columns, Worksheets and Windows

Protecting a Workbook

Protecting Worksheets and Worksheet Elements

Sharing a Workbook

Creating a Template

Working with Page Layout and Printing

Creating Headers and Footers

Using Page Breaks

Adjusting Margins and Orientation

Adjusting Size and Scale

Adding Print Titles, Gridlines and Headings

Advanced Printing Options

More Functions and Formulas

Formulas with Multiple Operators

Inserting and Editing a Function

AutoCalculate and Manual Calculation

Defining Names

Using and Managing Defined Names

Displaying and Tracing Formulas

Understanding Formula Errors

Working with Data Ranges

Sorting by One Column

Sorting by Colors or Icons

Sorting by Multiple Columns

Sorting by a Custom List

Filtering Data

Creating a Custom AutoFilter

Using an Advanced Filter

Working with Tables

Creating a Table

Working with Table Size

Working with the Total Row

Working with Table Data

Summarizing a Table with a PivotTable

Using the Data Form

Using Table Styles

Using Table Style Options

Creating and Deleting Custom Table Styles

Convert or Delete a Table

Working with PivotTables

Creating a PivotTable

Specifying PivotTable Data

Changing a PivotTable’s Calculation

Filtering and Sorting a PivotTable

Working with PivotTable Layout

Grouping PivotTable Items

Updating a PivotTable

Formatting a PivotTable

Creating a PivotChart

Analyzing and Organizing Data

Creating Scenarios

Creating a Scenario Report

Working with Data Tables

Using Goal Seek

Using Solver

Using Data Validation

Using Text to Columns

Removing Duplicates

Grouping and Outlining Data

Using Subtotals

Consolidating Data by Position or Category

Consolidating Data Using Formulas

Working with the Web and External Data

Inserting a Hyperlink

Creating a Web Page from a Workbook

Importing Data from Access or Text Files

Importing Data from the Web and Other Sources

Working with Existing Data Connections

Working with Macros

Recording a Macro

Playing and Deleting a Macro

Adding a Macro to the Quick Access Toolbar

Editing a Macro’s Visual Basic Code

Inserting Copied Code in a Macro

Declaring Variables and Adding Remarks to VBA Code

Prompting for User Input

Using the If...Then...Else Statement

Working with Objects

Inserting Clip Art

Inserting Pictures and Graphics Files

Formatting Pictures and Graphics

Inserting Shapes

Formatting Shapes

Resize, Move, Copy and Delete Objects

Applying Special Effects to Objects

Grouping Objects

Aligning Objects

Flipping and Rotating Objects

Layering Objects

Inserting SmartArt

Working with SmartArt Elements

Formatting SmartArt

Using WordArt

Inserting an Embedded Object

Inserting Symbols