Excel XP

Excel Basics

• 1

  Identifying Basic Parts of the Excel Window

  

  • The Excel Window

  • Workbooks and Worksheets

  • The Cell

  • Moving around the worksheet

  • Challenge

• 2

  Create, Open, and Save Workbooks

  

  • Introduction

  • Understanding File Terms

  • Creating a workbook

  • Saving a workbook

  • Opening a workbook

  • Closing a Workbook

  • Challenge

• 3

  Enter, Edit, and Delete Data

  

  • Introduction

  • Entering Text in a Cell

  • Editing Information in a Cell

  • Deleting Information in a Cell

  • Performing Undo and Redo

  • Selecting Multiple Cells

  • Challenge

• 4

  Moving, Copying, and Deleting Cell Contents

  

  • Introduction

  • Cut, copy, paste defined

  • Copy and Paste Cell Contents

  • Cut and Paste Cell Contents

  • Moving Information Using Drag-and-Drop

  • Challenge

• 5

  Creating Simple Formulas

  

  • Introduction

  • About Formulas

  • Creating a Simple Addition Formula

  • Creating a Simple Addition Formula (continued)

  • Creating a Simple Subtraction Formula Using the Point-and-Click Method

  • Creating Simple Multiplication Formulas

  • Creating Simple Division Formulas

  • Challenge

• 6

  Creating Complex Formulas

  

  • Introduction

  • Complex Formulas Defined

  • Complex Formulas Defined (continued)

  • Creating Complex Formulas

  • Filling Formulas to Other Cells

  • Copy and Paste Formulas

  • Revising Formulas

  • Creating an Absolute Reference

  • Challenge

• 7

  Using Functions

  

  • Introduction

  • Using Functions

  • Excel's Different Functions

  • Finding the Sum of a Range of Data

  • Finding the Average of a Range of Numbers

  • Accessing Excel XP Functions

  • Challenge

Worksheet Layout and Management

• 8

  Working with Multiple Worksheets

  

  • Introduction

  • Naming Worksheets

  • Inserting Worksheets

  • Deleting Worksheets

  • Grouping and Ungrouping Worksheets

  • Moving Worksheets

  • Copying Worksheets

  • Challenge

• 9

  Inserting and Deleting Rows and Columns

  

  • Introduction

  • Inserting a row

  • Inserting a column

  • Deleting columns and rows

  • Challenge

• 10

  Changing Column Width and Row Height

  

  • Introduction

  • Adjusting column widths

  • Adjusting row height

  • Challenge

• 11

  Inserting and Deleting Cells

  

  • Introduction

  • Inserting a cell

  • Deleting a cell

  • Merging cells

  • Challenge

• 12

  Text and Cell Alignments

  

  • Introduction

  • Using the Standard Toolbar to Align Text and Numbers in Cells

  • Changing Horizontal Cell Alignment

  • Changing Vertical Cell Alignment

  • Changing Text Control

  • Changing Text Orientation

  • Challenge

• 13

  Formatting Numbers

  

  • Introduction

  • Formatting Numbers in the Format Cells Dialog Box

  • Formatting Date in the Format Cells Dialog Box

  • Formatting Time in the Format Cells Dialog Box

  • Formatting Percentage in the Format Cells Dialog Box

  • Challenge

• 14

  Applying Font, Color, and Borders to Cells

  

  • Introduction

  • Change font type, size and color

  • Change font type, size and color (continued)

  • Change font type, size and color (continued)

  • Underline, italics and bold

  • Design and apply styles

  • Adding a border to cells

  • Adding Color to Cells

  • Challenge

Charting, Printing, and Page Setup

• 15

  Creating a Chart

  

  • Introduction

  • Understanding the Different Chart Types

  • Identifying the Parts of a Chart

  • Creating a Chart Using the Chart Toolbar

  • Creating an Embedded Chart

  • Creating a chart sheet

  • Challenge

• 16

  Moving, Resizing, and Deleting Charts

  

  • Introduction

  • Moving a chart

  • Resizing a Chart

  • Deleting a Chart

  • Challenge

• 17

  Editing Charts

  

  • Introduction

  • Changing Chart Data

  • Changing Chart Data (continued)

  • Changing the Chart Title

  • Changing the Data Series Names or Legend Text

  • Changing the Chart Type

  • Challenge

• 18

  Formatting a Chart

  

  • Introduction

  • Formatting the Chart Title

  • Formatting the Chart Legend

  • Formatting the Axis Labels

  • Changing the Data Series Color

  • Challenge

• 19

  Defining Page Setup Options

  

  • Introduction

  • Setting Page Margins

  • Changing the Page Orientation and Paper Size

  • Creating Headers and Footers

  • Creating Sheet Settings

  • Challenge

• 20

  Print Management

  

  • Introduction

  • Specify a print area

  • Preview a page before printing

  • Inserting and Removing a Page Break

  • Printing a Worksheet or Workbook

  • Challenge

Extras

• What's new in Microsoft Excel XP

• Planning your Excel XP spreadsheet

• Writing Formulas in Microsoft Excel XP

• Quiz

Learn More

• Excel Formulas

• Office XP Basics

• Excel 2013

• Google Sheets