Excel 2007

Introduction to Excel

• 1

  Setting Up Your Excel Environment

  

  • Introduction

  • Exploring and setting up your Excel environment

  • Challenge!

  

  • Discover Excel 2007

    Take a quick tour of Excel 2007 and learn about the Microsoft Button and the Ribbon

    05:286,498 views
• 2

  Starting a Workbook

  

  • Introduction

  • Your first workbook

  • Compatibility mode

  • Challenge!

  

  • Create a Spreadsheet in Excel 2007

    A tutorial about creating a Microsoft Excel 2007 spreadsheet

    05:2210,650 views
• 3

  Modifying Columns, Rows, and Cells

  

  • Introduction

  • Columns, rows, and cells

  • Challenge!

  

  • Adjusting Columns, Rows, & Cells in Excel 2007

    Simple ways to move columns, rows, and cells in Microsoft Office Excel 2007

    06:298,369 views
• 4

  Formatting Text

  

  • Introduction

  • Formatting cells

  • Challenge!

  

  • Customize your Spreadsheet in Excel 2007

    Explore ways to customize a Mircrosoft Excel 2007 spreadsheet

    08:424,482 views
• 5

  Creating Simple Formulas

  

  • Introduction

  • Simple Formulas

  • Using cell references

  • Challenge!

  

  • Simple Calculations in Excel 2007

    Helpful ways to use basic math formulas in a Microsoft Excel 2007 spreadsheet

    09:08119,240 views
• 6

  Working with Cells

  

  • Introduction

  • Working with cells

  • Challenge!

  

  • Using Cells in Excel 2007

    A quick look at how to copy and paste cells in this Microsoft Office Excel 2007 tutorial

    06:222,890 views
• 7

  Printing Workbooks

  

  • Introduction

  • Preparing to print and printing

  • Challenge!

  

  • Printing an Excel 2007 Spreadsheet

    Discover a simple way to prepare a Microsoft Office Excel 2007 spreadsheet for printing

    

Excel Basics

• 8

  Creating Complex Formulas

  

  • Introduction

  • Complex formulas

  • Complex formulas

  • Creating complex formulas

  • What is an absolute reference?

  • Challenge!

  

  • Using Complex Formulas in Excel 2007

    Find out how to create a complex formula using basic math in Mircrosoft Office Excel 2007

    
• 9

  Working with Basic Functions

  

  • Introduction

  • Basic functions

  • Excel's different functions

  • Accessing Excel 2007 functions

  • Challenge!

  

  • Basic Functions in Excel 2007

    Learn how to use Functions in Microsoft Office Excel 2007

    
• 10

  Sorting, Grouping, and Filtering Cells

  

  • Introduction

  • Sorting, grouping, and filtering

  • Grouping cells using the Subtotal command

  • Filtering cells

  • Challenge!

  

  • Organizing Data in Excel 2007

    Explore ways to analyze and work with a large amount of data in Mircrosoft Excel 2007

    
• 11

  Formatting Tables

  

  • Introduction

  • Formatting tables

  • Challenge!

  

  • Formatting Tables in Excel 2007

    A tutorial of how to format information inside an Excel 2007 spreadsheet as a table

    03:563,501 views
• 12

  Aligning Text

  

  • Introduction

  • Formatting cells

  • Changing vertical cell alignment

  • Changing text control

  • Challenge!

  

  • Aligning Text in Excel 2007

    Helpful ways to fine-tune text in this Microsoft Excel 2007 Tutorial

    05:275,337 views
• 13

  Working with Worksheets

  

  • Introduction

  • Worksheets

  • Inserting worksheets

  • Grouping and ungrouping worksheets

  • Freezing worksheet panes

  • Challenge!

  

  • Working with Worksheets in Excel 2007

    Learn trouble-free ways to navigate through multiple worksheets in Microsoft Excel 2007

    09:092,594 views

Doing More with Excel

• 14

  Using Templates

  

  • Introduction

  • Templates

  • Challenge!

  

  • Using Templates in Excel 2007

    Discover quick ways to create and add data to a template in Microsoft Excel 2007

    03:422,957 views
• 15

  Using What-If Analysis

  

  • Introduction

  • What-if analysis

  • What-If Analysis Tools

  • Challenge!

  

  • Using What-If Analysis in Excel 2007

    Using What-If Analysis in Excel 2007

    05:323,198 views
• 16

  Working with Charts

  

  • Introduction

  • Charts

  • Identifying the parts of a chart

  • Chart tools

  • Challenge!

  

  • Working with Charts in Excel 2007

    Advanced tutorial of how to insert and modify charts in Microsoft Office Excel 2007

    09:382,762 views
• 17

  Using Conditional Formatting

  

  • Introduction

  • Conditional formatting

  • Challenge!

  

  • Using Conditional Formatting in Excel 2007

    Apply formatting to cells based on the value of the cell in Microsoft Excel 2007

    05:303,133 views
• 18

  Creating Pivot Tables

  

  • Introduction

  • PivotTable reports

  • Challenge!

  

  • Creating Pivot Tables in Excel 2007

    Advanced tutorial of inserting & working with pivot tables in Microsoft Office Excel 2007

    

Extras

• What's New in Excel 2007?

• What are Reference Styles?

• More Resources

• Quiz

Learn More

• Excel Formulas

• Excel 2013

• OneDrive and Office Online

• Google Sheets