Excel 2007

Introduction to Excel

• 1

  Setting Up Your Excel Environment arrow_forward_ios ✓ Familiarize yourself with the Excel 2007 environment.
• 2

  Starting a Workbook arrow_forward_ios ✓ Learn how to create a new workbook, insert and delete text, navigate a worksheet, and save.
• 3

  Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel.
• 4

  Formatting Text arrow_forward_ios ✓ Learn all about formatting text in Excel.
• 5

  Creating Simple Formulas arrow_forward_ios ✓ Learn how to create a simple formula in Excel.
• 6

  Working with Cells arrow_forward_ios ✓ Learn how to cut, copy, and paste, as well as how to drag and drop data in Excel.
• 7

  Printing Workbooks arrow_forward_ios ✓ Learn how to preview your spreadsheet, modify margins, change page orientation, and print.

Excel Basics

• 8

  Creating Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
• 9

  Working with Basic Functions arrow_forward_ios ✓ Learn how to use functions to find values for a range of cells.
• 10

  Sorting, Grouping, and Filtering Cells arrow_forward_ios ✓ Learn how to sort, group, and filter cells in Excel.
• 11

  Formatting Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel.
• 12

  Aligning Text arrow_forward_ios ✓ Learn how to align text, merge and center cells, and apply different types of text control.
• 13

  Working with Worksheets arrow_forward_ios ✓ Learn how to name, add, delete, group and ungroup, and freeze worksheets.

Doing More with Excel

• 14

  Using Templates arrow_forward_ios ✓ Learn how to create a new workbook using an Excel template.
• 15

  Using What-If Analysis arrow_forward_ios ✓ Learn how to use a what-if analysis tool called Goal Seek.
• 16

  Working with Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to communicate information.
• 17

  Using Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel.
• 18

  Creating PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis.

Extras

• 19

  What's New in Excel 2007? arrow_forward_ios ✓ Learn about the features available in Excel 2007.
• 20

  What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel.
• 21

  More Resources arrow_forward_ios ✓ Use these free resources to better work with and manipulate data in Excel.