Excel 2007 Training

Excel 2007 Training


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

Course Outline

The Fundamentals

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.
  1. Starting Excel 2007
  2. What’s New in Excel 2007
  3. Understanding the Excel Program Screen
  4. Understanding the Ribbon
  5. Using the Office Button and Quick Access Toolbar
  6. Using Keyboard Commands
  7. Using Contextual Menus and the Mini Toolbar
  8. Using Help
  9. Exiting Excel 2007

Worksheet Basics

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!
  1. Creating a New Workbook
  2. Opening a Workbook
  3. Navigating a Worksheet
  4. Entering Labels
  5. Entering Values
  6. Selecting a Cell Range
  7. Overview of Formulas and Using AutoSum
  8. Entering Formulas
  9. Using AutoFill
  10. Understanding Absolute and Relative Cell References
  11. Using Undo, Redo and Repeat
  12. Saving a Workbook
  13. Previewing and Printing a Worksheet
  14. Closing a Workbook

Editing a Worksheet

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.
  1. Editing Cell Contents
  2. Cutting, Copying, and Pasting Cells
  3. Moving and Copying Cells Using the Mouse
  4. Using the Office Clipboard
  5. Using the Paste Special Command
  6. Checking Your Spelling
  7. Inserting Cells, Rows, and Columns
  8. Deleting Cells, Rows, and Columns
  9. Using Find and Replace
  10. Using Cell Comments
  11. Tracking Changes

Formatting a Worksheet

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?
  1. Formatting Labels
  2. Formatting Values
  3. Adjusting Row Height and Column Width
  4. Working with Cell Alignment
  5. Adding Cell Borders, Background Colors and Patterns
  6. Using the Format Painter
  7. Using Cell Styles
  8. Using Document Themes
  9. Applying Conditional Formatting
  10. Creating and Managing Conditional Formatting Rules
  11. Finding and Replacing Formatting

Creating and Working with Charts

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.
  1. Creating a Chart
  2. Resizing and Moving a Chart
  3. Changing Chart Type
  4. Applying Built-in Chart Layouts and Styles
  5. Working with Chart Labels
  6. Working with Chart Axes
  7. Working with Chart Backgrounds
  8. Working with Chart Analysis Commands
  9. Formatting Chart Elements
  10. Changing a Chart’s Source Data
  11. Using Chart Templates

Managing Workbooks

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.
  1. Viewing a Workbook
  2. Working with the Workbook Window
  3. Splitting and Freezing a Workbook Window
  4. Selecting Worksheets in a Workbook
  5. Inserting and Deleting Worksheets
  6. Renaming, Moving and Copying Worksheets
  7. Working with Multiple Workbooks
  8. Hiding Rows, Columns, Worksheets and Windows
  9. Protecting a Workbook
  10. Protecting Worksheets and Worksheet Elements
  11. Sharing a Workbook
  12. Creating a Template

Working with Page Layout and Printing

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
  1. Creating Headers and Footers
  2. Using Page Breaks
  3. Adjusting Margins and Orientation
  4. Adjusting Size and Scale
  5. Adding Print Titles, Gridlines and Headings
  6. Advanced Printing Options

More Functions and Formulas

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!
  1. Formulas with Multiple Operators
  2. Inserting and Editing a Function
  3. AutoCalculate and Manual Calculation
  4. Defining Names
  5. Using and Managing Defined Names
  6. Displaying and Tracing Formulas
  7. Understanding Formula Errors

Working with Data Ranges

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.
  1. Sorting by One Column
  2. Sorting by Colors or Icons
  3. Sorting by Multiple Columns
  4. Sorting by a Custom List
  5. Filtering Data
  6. Creating a Custom AutoFilter
  7. Using an Advanced Filter

Working with Tables

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.
  1. Creating a Table
  2. Working with Table Size
  3. Working with the Total Row
  4. Working with Table Data
  5. Summarizing a Table with a PivotTable
  6. Using the Data Form
  7. Using Table Styles
  8. Using Table Style Options
  9. Creating and Deleting Custom Table Styles
  10. Convert or Delete a Table

Working with PivotTables

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.
  1. Creating a PivotTable
  2. Specifying PivotTable Data
  3. Changing a PivotTable’s Calculation
  4. Filtering and Sorting a PivotTable
  5. Working with PivotTable Layout
  6. Grouping PivotTable Items
  7. Updating a PivotTable
  8. Formatting a PivotTable
  9. Creating a PivotChart

Working with the Web and External Data

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.
  1. Inserting a Hyperlink
  2. Creating a Web Page from a Workbook
  3. Importing Data from Access or Text Files
  4. Importing Data from the Web and Other Sources
  5. Working with Existing Data Connections

Working with Macros

I bet you’re wondering what a Macro is and how you can use it in your worksheet? In this course you will learn about all things Macro, 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!
  1. Recording a Macro
  2. Playing and Deleting a Macro
  3. Adding a Macro to the Quick Access Toolbar
  4. Editing a Macro’s Visual Basic Code
  5. Inserting Copied Code in a Macro
  6. Declaring Variables and Adding Remarks to VBA Code
  7. Prompting for User Input
  8. Using the If…Then…Else Statement

Working with Objects

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.
  1. Inserting Clip Art
  2. Inserting Pictures and Graphics Files
  3. Formatting Pictures and Graphics
  4. Inserting Shapes
  5. Formatting Shapes
  6. Resize, Move, Copy and Delete Objects
  7. Applying Special Effects to Objects
  8. Grouping Objects
  9. Aligning Objects
  10. Flipping and Rotating Objects
  11. Layering Objects
  12. Inserting SmartArt
  13. Working with SmartArt Elements
  14. Formatting SmartArt
  15. Using WordArt
  16. Inserting an Embedded Object
  17. Inserting Symbols

Advanced Topics

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.
  1. Customizing the Quick Access Toolbar
  2. Using and Customizing AutoCorrect
  3. Changing Excel’s Default Options
  4. Recovering Your Documents
  5. Using Microsoft Office Diagnostics
  6. Viewing Document Properties and Finding a File
  7. Saving a Document as PDF or XPS
  8. Adding a Digital Signature to a Workbook
  9. Preparing Documents for Publishing and Distribution
  10. Publishing a Workbook to a Document Workspace
  11. Creating a Custom AutoFill List
  12. Creating a Custom Number Format

Appendix of Common Functions

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).
  1. Using Logical Functions (IF)
  2. Using Financial Functions (PMT)
  3. Using Database Functions (DSUM)
  4. Using Lookup Functions (VLOOKUP)