2 Beginning Excel Tutorials

Excel 2003 and Excel 2000 are very comprehensive and feature-rich spreadsheet applications, and to start geting the most from them, you need to understand their fundamentals. These 2 Beginning Excel Tutorial Guides, from California State University, Northridge, demonstrate the basics of Excel so that you can start becoming proficient right away with this common spreadsheet application. These Excel tutorials will show you how to create a simple spreadsheet, move around in Excel, edit your data, enhance the look of your spreadsheet, and use some of Excels important features. Specifically they demonstrate the following Excel activities: Entering Data, Understanding Formulas, Editing Cells, Copying & Pasting Cell Content, Moving Cell Content, Deleting Cell & Range Content, Using AutoFill, Inserting & Deleting Rows and Columns, Changing Row Height and Column Widths, Naming Worksheets, Borders, Font & Fill Coloring, Creating Charts, Page Setup, and Saving and Printing These Excel tutorials can also be used by Macintosh users.


Excel 2003 Basics & Beyond - Beginner’s Guide
(628kb, 28 pages, pdf format)
Getting Started with Microsoft Excel 2003

Table of Contents:

1. Overview
• What is a Spreadsheet program
• Microsoft 2003
• Excelling at Work with Excel 2003
2. Getting Started with Microsoft Excel 2003
• Launching your Excel 2003 Application
• Understanding the Excel Environment
3. Entering Data
4. Understanding Formula Basics
5. Editing Cell Content
6. Copying & Pasting Cell Content
7. Moving Cell Content
8. Deleting Cell & Range Content
9. Using AutoFill
10. Inserting & Deleting Rows and Columns
11. Changing Row Height or Column Widths
12. Naming your Worksheet
13. Formatting with Borders
14. Font & Fill Coloring
15. Creating Basic Charts
16. Page Setup
17. Saving & Printing
18. Closing & Exiting Excel

Excel 2000 Beginner’s Guide

  1 Overview

• What is a Spreadsheet Program?
• Microsoft Excel 2000
• Excelling at Work with Excel 2000

  2 Getting Started

• Launching Your Excel 2000 Application
• Understanding the Excel Environment
• The Workbook Window
• Navigating in a Workbook
• Selecting a Range (or Block) of Cells

  3 Entering Data and Using Formulas

• Entering a Label (Text) or a Value (Number)
• Creating a Formula
• Formula Operators
• How to Enter a Formula
• Worksheet Functions
• Adding a Range Using the AutoSum Function

  4 Editing Cell Contents

• In-Cell Editing
• Formula Bar Editing
• Copying Cell Contents
• Moving Cell Contents
• Deleting the Contents of a Cell or a Range
• Copying a Formula to Other Cells Using AutoFill
• Inserting a  Column or Row
• Deleting a Column or Row

  5 Saving and Printing a Worksheet

• Saving a Worksheet
• Printing
• Printing an Entire Worksheet
• Printing a Section of a Worksheet
• Print Preview

  6 How to Learn More

• The Excel Help Menu
• Microsoft Excel Help (Office Assistant)
• What’s This?
• Office on the Web
• Lotus 1-2-3 Help
• Printed Material

  7 Closing a Worksheet and Exiting Excel

• Closing a Worksheet
• Exiting Excel

  8 Appendix: Excel 2000 Menus

Popularity: 22% [?]

Related Posts:

Training Handouts for Microsoft Office Applications

Excel Ebooks and Training Documents

Microsoft Office Workshop Tutorial Training Handouts

Excel XP Tutorial and Guide

67 PHP Tutorials

Tags for this post>> Excel | Excel 2003