Microsoft Excel 2003 - Basic

Course Outline

Getting to know Excel
Workbooks, Worksheets, and Datalists
Navigating rows, columns, and cells
Zeroing in on data in a list
Creating a Workbook
Checking and Correcting Data

Setting up a Workbook
Making workbooks easier to work with
Making data easier to read
Adding graphics to documents

Performing Calculations on Data
Naming Groups of Data
Creating formulas to calculate values
Finding and correcting Errors in Calculations

Changing Document Appearance
Changing the Appearance of Data
Applying an Existing Format to Data
Making Numbers Easier to Read
Changing Data’s Appearance Based on Its Value

Focusing on Specific Data using Filters
Limiting the data that appears on the screen
Performing calculations on filtered data
Defining a Valid Set of Values for a Range of Cells

Reordering and Summarizing Data
Sorting a Data List
Organizing Data into Levels

Creating Charts
Creating a Chart
Customizing Chart Labels and Numbers
Finding Trends in Your Data
Creating a Dynamic Chart Using PivotCharts
Creating Diagrams

Printing
Making Printouts Easier to Follow / Positioning Data on a Printout
Printing Data Lists
Printing Part of a Data List
Printing a Chart

Working with Other Microsoft Office Programs
Including an Office Document in an Excel Worksheet
Storing an Excel Document as Part of Another Office Document
Creating a Hyperlink
Pasting a Chart into Another Document