|
The uses for Excel are limitless. Businesses use Excel for creating financial reports, scientists use Excel for statistical analysis, and families use Excel to help manage their investment portfolios. Microsoft Excel is by far the most widely used and, according to most reviews, the most powerful and user friendly spreadsheet program available.
Microsoft Excel 2003 is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a worksheet is quick and easy. Excel can instantly perform any type of calculation with data entered onto a worksheet. Excel can also make your information look sharp and professional. You have made a great choice by deciding to learn more about Excel.
Course Outline
Chapter One: Creating and Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chart's Source Data
Changing a Chart Type and Working with Pie Charts
Adding Titles, Gridlines, and a Data Table
Formatting a Data Series and Chart Axis
Annotating a Chart
Working with 3-D Charts
Selecting and Saving a Custom Chart
Using Fill Effects
Chapter Two: More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Insert Function Feature
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate
Using the IF Function to Create Conditional Formulas
Using the PMT Function
Displaying and Previewing Formulas
Fixing Formula Errors
Mathematical Functions
Financial Functions
Date and Time Functions
Statistical Functions
Database Functions
Chapter Three: Working with Lists
Creating a List
Working with Lists and Using the Total Row
Adding Records Using the Data Form and Insert Row
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Chapter Four: Working with Other Programs
Inserting an Excel Worksheet into a Word Document
Modifying an Inserted Excel Worksheet
Inserting a Linked Excel Chart in a Word Document
Inserting a Graphic into a Worksheet
Opening and Saving Files in Different Formats
Chapter Five: Advanced Topics
Hiding, Displaying, and Moving Toolbars
Customizing Excel's Toolbars
Sending Faxes
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes
Merging and Revising a Shared Workbook
Using Detect and Repair
Student Practice Files for this class are located here.
| 
