|
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: The Fundamentals
Starting Excel
What's New in Excel 2003?
Understanding the Excel Program Screen
Using Menus
Using Toolbars and Creating a New Workbook
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening a Workbook
Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and Selecting a Cell Range
Calculating Value Totals with AutoSum
Entering Formulas
Using AutoFill
Previewing and Printing a Worksheet
Getting Help
Changing the Office Assistant and Using the Help Button
Closing a Workbook and Exiting Excel
Chapter Two: Editing a Worksheet
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Collecting and Pasting Multiple Items
Working with Absolute and Relative Cell Referencesv Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Finding and Replacing Information
Advanced Printing Options
File Management
Inserting Cell Comments
Understanding Smart Tags
Recovering Your Workbooks
Chapter Three: Formatting a Worksheet
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colors and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Creating, Applying, and Modifying a Style
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Finding and Replacing Formatting
Chapter Four: Managing Your Workbooks
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
Splitting and Freezing a Window
Referencing External Data
Creating Headers, Footers, and Page Numbers
Specifying a Print Area and Controlling Page Breaks
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows and Sheets
Viewing Workbooks and Comparing Side by Side
Saving a Custom View
Working with Templates
Consolidating Worksheets
Chapter Five: Advanced Topics
Hiding, Displaying, and Moving Toolbars
Customizing Excel's Toolbars
Creating a Custom AutoFill List
Changing Excel's Options
File Properties and Finding a File
Using Detect and Repair
Student Practice Files for this class are located here.
| 
