Excel 2007 Training

Excel 2007 Training

interactive-training-excel-2007

Personalized Online Training

Get answers to everyday questions and on-demand training with over 7,000 Interactive Tutorials.

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 Devices

  • Desktop
  • Tablet / mobile
  • LMS / SCORM

The Fundamentals

Length: 0:32:00

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 course you will learn everything from using contextual menus and the mini toolbar to understanding the Ribbon.

Lesson 1 Starting Excel 2007
0:03:39
Lesson 2 What’s New in Excel 2007
0:02:48
Lesson 3 Understanding the Excel Program Screen
0:01:37
Lesson 4 Understanding the Ribbon
0:03:13
Lesson 5 Using the Office Button and Quick Access Toolbar
0:04:01
Lesson 6 Using Keyboard Commands
0:01:56
Lesson 7 Using Contextual Menus and the Mini Toolbar
0:03:39
Lesson 8 Using Help
0:05:47
Lesson 9 Exiting Excel 2007
0:05:20

Worksheet Basics

Length: 0:45:00

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

Lesson 1 Creating a New Workbook
0:06:57
Lesson 2 Opening a Workbook
0:06:14
Lesson 3 Navigating a Worksheet
0:03:02
Lesson 4 Entering Labels
0:02:47
Lesson 5 Entering Values
0:01:49
Lesson 6 Selecting a Cell Range
0:01:40
Lesson 7 Overview of Formulas and Using AutoSum
0:02:20
Lesson 8 Entering Formulas
0:01:35
Lesson 9 Using AutoFill
0:01:55
Lesson 10 Understanding Absolute and Relative Cell References
0:02:16
Lesson 11 Using Undo, Redo and Repeat
0:02:46
Lesson 12 Saving a Workbook
0:04:01
Lesson 13 Previewing and Printing a Worksheet
0:05:14
Lesson 14 Closing a Workbook
0:02:31

Editing a Worksheet

Length: 0:31:00

Ready to roll your sleeves up and start building a spreadsheet? In this 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.

Lesson 1 Editing Cell Contents
0:02:58
Lesson 2 Cutting, Copying, and Pasting Cells
0:02:24
Lesson 3 Moving and Copying Cells Using the Mouse
0:01:55
Lesson 4 Using the Office Clipboard
0:02:46
Lesson 5 Using the Paste Special Command
0:03:08
Lesson 6 Checking Your Spelling
0:02:41
Lesson 7 Inserting Cells, Rows, and Columns
0:02:12
Lesson 8 Deleting Cells, Rows, and Columns
0:02:42
Lesson 9 Using Find and Replace
0:02:26
Lesson 10 Using Cell Comments
0:03:23
Lesson 11 Tracking Changes
0:04:32

Formatting a Worksheet

Length: 0:25:00

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 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?

Lesson 1 Formatting Labels
0:02:43
Lesson 2 Formatting Values
0:03:27
Lesson 3 Adjusting Row Height and Column Width
0:01:26
Lesson 4 Working with Cell Alignment
0:01:24
Lesson 5 Adding Cell Borders, Background Colors and Patterns
0:01:29
Lesson 6 Using the Format Painter
0:01:10
Lesson 7 Using Cell Styles
0:02:50
Lesson 8 Using Document Themes
0:02:19
Lesson 9 Applying Conditional Formatting
0:03:31
Lesson 10 Creating and Managing Conditional Formatting Rules
0:02:19
Lesson 11 Finding and Replacing Formatting
0:02:02

Creating and Working with Charts

Length: 0:23:00

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 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.

Lesson 1 Creating a Chart
0:02:07
Lesson 2 Resizing and Moving a Chart
0:02:19
Lesson 3 Changing Chart Type
0:02:35
Lesson 4 Applying Built-in Chart Layouts and Styles
0:01:46
Lesson 5 Working with Chart Labels
0:02:35
Lesson 6 Working with Chart Axes
0:02:30
Lesson 7 Working with Chart Backgrounds
0:01:43
Lesson 8 Working with Chart Analysis Commands
0:01:58
Lesson 9 Formatting Chart Elements
0:01:38
Lesson 10 Changing a Chart’s Source Data
0:01:11
Lesson 11 Using Chart Templates
0:02:42

Managing Workbooks

Length: 0:28:00

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 course you will learn how to view, move, rename worksheets, split and freeze workbooks, and how to create a template.

Lesson 1 Viewing a Workbook
0:03:03
Lesson 2 Working with the Workbook Window
0:02:11
Lesson 3 Splitting and Freezing a Workbook Window
0:02:32
Lesson 4 Selecting Worksheets in a Workbook
0:01:36
Lesson 5 Inserting and Deleting Worksheets
0:00:56
Lesson 6 Renaming, Moving and Copying Worksheets
0:02:02
Lesson 7 Working with Multiple Workbooks
0:02:19
Lesson 8 Hiding Rows, Columns, Worksheets and Windows
0:02:20
Lesson 9 Protecting a Workbook
0:03:15
Lesson 10 Protecting Worksheets and Worksheet Elements
0:02:42
Lesson 11 Sharing a Workbook
0:03:41
Lesson 12 Creating a Template
0:01:10

Working with Page Layout and Printing

Length: 0:14:00

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 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

Lesson 1 Creating Headers and Footers
0:02:24
Lesson 2 Using Page Breaks
0:02:35
Lesson 3 Adjusting Margins and Orientation
0:01:17
Lesson 4 Adjusting Size and Scale
0:02:07
Lesson 5 Adding Print Titles, Gridlines and Headings
0:02:34
Lesson 6 Advanced Printing Options
0:02:46

More Functions and Formulas

Length: 0:22:00

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

Lesson 1 Formulas with Multiple Operators
0:03:40
Lesson 2 Inserting and Editing a Function
0:02:57
Lesson 3 AutoCalculate and Manual Calculation
0:02:36
Lesson 4 Defining Names
0:03:19
Lesson 5 Using and Managing Defined Names
0:03:14
Lesson 6 Displaying and Tracing Formulas
0:02:54
Lesson 7 Understanding Formula Errors
0:03:04

Working with Data Ranges

Length: 0:17:00

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

Lesson 1 Sorting by One Column
0:02:40
Lesson 2 Sorting by Colors or Icons
0:02:51
Lesson 3 Sorting by Multiple Columns
0:01:52
Lesson 4 Sorting by a Custom List
0:02:56
Lesson 5 Filtering Data
0:01:35
Lesson 6 Creating a Custom AutoFilter
0:01:21
Lesson 7 Using an Advanced Filter
0:03:46

Working with Tables

Length: 0:23:00

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

Lesson 1 Creating a Table
0:02:17
Lesson 2 Working with Table Size
0:02:58
Lesson 3 Working with the Total Row
0:01:56
Lesson 4 Working with Table Data
0:03:45
Lesson 5 Summarizing a Table with a PivotTable
0:01:32
Lesson 6 Using the Data Form
0:02:30
Lesson 7 Using Table Styles
0:02:22
Lesson 8 Using Table Style Options
0:02:30
Lesson 9 Creating and Deleting Custom Table Styles
0:02:36
Lesson 10 Convert or Delete a Table
0:01:21

Working with PivotTables

Length: 0:17:00

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 course you will learn how to create PivotTables and PivotCharts, specify data, change calculations, group data, and how to work with timelines.

Lesson 1 Creating a PivotTable
0:01:18
Lesson 2 Specifying PivotTable Data
0:01:30
Lesson 3 Changing a PivotTable’s Calculation
0:01:50
Lesson 4 Filtering and Sorting a PivotTable
0:01:45
Lesson 5 Working with PivotTable Layout
0:03:19
Lesson 6 Grouping PivotTable Items
0:02:15
Lesson 7 Updating a PivotTable
0:02:01
Lesson 8 Formatting a PivotTable
0:01:35
Lesson 9 Creating a PivotChart
0:01:32

Working with the Web and External Data

Length: 0:15:00

Do you have a lot of data that’s from an external source, such as the Internet? No problem – in this 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.

Lesson 1 Inserting a Hyperlink
0:03:01
Lesson 2 Creating a Web Page from a Workbook
0:02:54
Lesson 3 Importing Data from Access or Text Files
0:02:34
Lesson 4 Importing Data from the Web and Other Sources
0:02:24
Lesson 5 Working with Existing Data Connections
0:03:21

Working with Macros

Length: 0:22:00

I bet you’re wondering what a Marco is and how you can use it in your worksheet? In this 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!

Lesson 1 Recording a Macro
0:03:53
Lesson 2 Playing and Deleting a Macro
0:02:29
Lesson 3 Adding a Macro to the Quick Access Toolbar
0:02:05
Lesson 4 Editing a Macro’s Visual Basic Code
0:01:47
Lesson 5 Inserting Copied Code in a Macro
0:03:28
Lesson 6 Declaring Variables and Adding Remarks to VBA Code
0:01:55
Lesson 7 Prompting for User Input
0:02:34
Lesson 8 Using the If…Then…Else Statement
0:03:39

Working with Objects

Length: 0:36:00

You may be asking, what is an object and how does it relate to Excel? Good question! In this 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.

Lesson 1 Inserting Clip Art
0:02:58
Lesson 2 Inserting Pictures and Graphics Files
0:02:58
Lesson 3 Formatting Pictures and Graphics
0:02:02
Lesson 4 Inserting Shapes
0:02:02
Lesson 5 Formatting Shapes
0:02:04
Lesson 6 Resize, Move, Copy and Delete Objects
0:01:51
Lesson 7 Applying Special Effects to Objects
0:01:14
Lesson 8 Grouping Objects
0:01:49
Lesson 9 Aligning Objects
0:01:58
Lesson 10 Flipping and Rotating Objects
0:02:02
Lesson 11 Layering Objects
0:01:06
Lesson 12 Inserting SmartArt
0:02:13
Lesson 13 Working with SmartArt Elements
0:02:00
Lesson 14 Formatting SmartArt
0:03:28
Lesson 15 Using WordArt
0:02:37
Lesson 16 Inserting an Embedded Object
0:01:44
Lesson 17 Inserting Symbols
0:01:16

Advanced Topics

Length: 0:21:00

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.

Lesson 1 Customizing the Quick Access Toolbar
0:02:49
Lesson 2 Using and Customizing AutoCorrect
0:02:13
Lesson 3 Changing Excel’s Default Options
0:01:11
Lesson 4 Recovering Your Documents
0:01:52
Lesson 5 Using Microsoft Office Diagnostics
0:01:16
Lesson 6 Viewing Document Properties and Finding a File
0:02:13
Lesson 7 Saving a Document as PDF or XPS
0:02:09
Lesson 8 Adding a Digital Signature to a Workbook
0:01:44
Lesson 9 Preparing Documents for Publishing and Distribution
0:00:42
Lesson 10 Publishing a Workbook to a Document Workspace
0:01:08
Lesson 11 Creating a Custom AutoFill List
0:01:38
Lesson 12 Creating a Custom Number Format
0:01:36

Appendix of Common Functions

Length: 0:10:00

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).

Lesson 1 Using Logical Functions (IF)
0:01:58
Lesson 2 Using Financial Functions (PMT)
0:02:21
Lesson 3 Using Database Functions (DSUM)
0:02:07
Lesson 4 Using Lookup Functions (VLOOKUP)
0:02:42