Excel 2007 Training

Excel 2007 Demo

Start learning now.

Sign up for Microsoft Office training, SharePoint training and more.

100% spam free.

What's Included:

Interactive Tutorials
Bite-sized software simulations.
Interactive Quizzes
Accurately test your staff's skills.
Customizable Courseware
Training manuals with unlimited printing rights.
FREE Cheat Sheets
Just sign up, download, and share.
Multiple Platforms
  • Desktop
  • Tablet / mobile

Excel 2007 Courses

The Fundamentals

Length: 32 minutes

Microsoft Excel is a product used by individuals and business professionals around the world, ranging from biologists to accounting professionals and students. Excel has something for everyone! In this Excel 2007 Training course you will learn everything from using contextual menus and the mini toolbar to understanding the Ribbon.

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

Length: 45 minutes

Worksheets are the primary foundation to the Excel program and in this Excel 2007 Training course we will cover topics such as creating new workbooks, entering formulas, using cell references, and why using Autofill is your new best friend!

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

Length: 31 minutes

Ready to roll your sleeves up and start building a spreadsheet? In this Excel 2007 Training course you will learn how to enter and edit cell data, fix typos, remove data you no longer need, hide rows and columns, and tracking changes.

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

Length: 25 minutes

I bet you're wondering how to make this boring pile of data into a visually appealing pile of data that is easy to understand. Well, not to worry because in this Excel 2007 Training course you will learn how to format values, alignment, create background colors and patterns, apply cell styles, format painter, and other document themes. Who said data had to be boring?

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

Length: 23 minutes

Excel 2007 offers a variety of charts and options that will save you time while keeping your data organized and easier to understand. In this Excel 2007 Training course you will learn how to create a chart, apply built-in chart layout styles, work with chart backgrounds, and how to work with chart labels and axes.

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

Length: 28 minutes

It is no surprise that most of your time will be spent managing your worksheets, which is why it is important that you understand how to navigate them properly. In this Excel 2007 Training course you will learn how to view, move, rename worksheets, split and freeze workbooks, and how to create a template.

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

Length: 14 minutes

To print and distribute your worksheets you will need to configure a few settings to make sure your worksheets dont print out the wrong way. In this Excel 2007 Training course you will learn about adjusting page size and scale, using page breaks, adding print titles and headlines, creating headers and footers, and adjusting page margins and orientation

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

Length: 22 minutes

To further enhance your worksheet, Excel 2007 offers functions and formulas that will give your technical side a challenge. In this Excel 2007 Training course you will learn about topics such as AutoCalculate and Manual Calculation, defining names, displaying and tracing formulas, and much more!

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

Length: 17 minutes

Data, Data, Data. All data has to have some type of organization and Excel 2007 Training offers features that allow you to sort by multiple columns, colors, and even icons! You can also create custom lists and custom AutoFilters.

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

Length: 23 minutes

Tables are a simple, fast way to create an organized view of your data and in this Excel 2007 Training course you will learn all about tables such as creating tables, summarizing a table with a PivotTable, table styles, and working with table data.

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

Length: 17 minutes

PivotTables are not just for geeks, they are for anyone who has a large amount of data that needs consolidation. It's a useful and powerful data analysis tool that will summarize, analyze, and present you data. In this Excel 2007 course you will learn how to create PivotTables and PivotCharts, specify data, change calculations, group data, and how to work with timelines.

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

Working with the Web and External Data

Length: 15 mintues

Do you have a lot of data that's from an external source, such as the Internet? No problem, in this Excel 2007 Training course we have developed lessons that show you how to import data from the web and other sources, create a web page from a workbook, and how to work with existing data connections.

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

Length: 22 minutes

I bet you're wondering what a Marco is and how you can use it in your worksheet? In this Excel 2007 course you will learn about all things Marcro, such as recording a Macro, playing and deleting a Macro, declaring variable and adding remarks to the VBA Code, using the If Then Else Statement, and prompting for user input. Things are about to get a lot more interesting!

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

Length: 36 minutes

You may be asking, what is an object and how does it relate to Excel? Good question! In this Excel 2007 Training course you learn about Clip Art, WordArt, SmartArt, and applying special effects to Objects. You will also learn how to inset an embedded object and insert symbols.

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

Advanced Topics

Length: 21 minutes

You have the option to customize Excel to your likings, and in this course we have developed lessons that will teach you how to accomplish the more advanced topics. You will learn about customizing the Quick Access Toolbar, creating a custom AutoFill list, and changing Excels default options just to name a few.

Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel's Default Options
Recovering Your Documents
Using Microsoft Office Diagnostics
Viewing Document Properties and Finding a File
Saving a Document as PDF or XPS
Adding a Digital Signature to a Workbook
Preparing Documents for Publishing and Distribution
Publishing a Workbook to a Document Workspace
Creating a Custom AutoFill List
Creating a Custom Number Format

Appendix of Common Functions

Length: 10 minutes

Now that you're an expert on all things Excel, we thought we would give you a farewell goodbye by giving you an appendix of common functions. You will learn about Logical Functions (IF), Financial Functions (PMT), Database Functions (DSUM), and Lookup Functions (VLOOKUP).

Using Logical Functions (IF)
Using Financial Functions (PMT)
Using Database Functions (DSUM)
Using Lookup Functions (VLOOKUP)