Microsoft's Excel is a Spreadsheet application that allows user to enter, analyze and
calculate data. The Excel files are Workbooks where the work is stored.
Worksheets are electronic ledgers in a Workbook where one actually lists and
analyzes data. This course teaches the participant the skills required to
effectively work with application software. In addition, we cover the following topics:
Chapter 1: Introduction to Excel
- Introduction
- What is Excel?
- Starting Excel
- Opening a Workbook
- Getting to know the Excel Screen
- Moving Around the Excel Screen
- Saving a Workbook
- Closing a Workbook
- Opening a Recently Used Workbook
- Exiting Excel
Chapter 2: Creating and Editing Workbooks
- Introduction
- Creating New Workbooks
- Entering Data
- Introduction to Formulas
- Working with AutoComplete
- Selecting and Moving Cells
- Inserting and Deleting Cells
- Cut, Copy, and Paste
- Find and Replace
- Using Undo and Redo
- Working with Worksheets
Chapter 3: Formatting Workbooks
- Introduction
- Adjusting Column and Row Sizes
- Changing Cell Alignment
- Using Number Formatting
- Formatting Text
- Using the Format Painter
- Using Styles and AutoFormatting
- Find and Replace Formats
- Getting to know the Spelling Checker
- Working with AutoCorrect
- Using AutoFill
Chapter 4: Viewing and Printing
- Introduction
- Viewing the Worksheet
- Splitting and Freezing a Worksheet
- Using AutoFilter
- Adding Headers and Footers
- Working with Page Setup
- Setting a Print Area
- Using Print Preview and Printing
- Saving a Workbook as a Web Page
- Adding Comments
- E-mailing a Workbook
Chapter 5: Using Formulas and Functions
- Introduction
- Copying Formulas
- The Error Checking Smart Tag
- Using AutoCalculate
- Inserting Functions
- Supplying Function Arguments
- Controlling Calculations
- Using Financial Functions
- Specifying Conditions with IF
- Using Date Functions
Chapter 6: Adding Charts and Pictures
- Introduction
- Creating a Chart
- Formatting Charts
- Modifying Chart Data
- Changing Chart Types
- Using Drawing Tools
- Inserting Graphics
- Printing a Chart
- Adding Hyperlinks
Would you like to learn MS Word 2000/XP? We provide
home tutoring service.
Please
contact us
for any additional information.
