Microsoft Excel 2003 Tutorial Video

Introduction To Excel 2003

• First Glance at Excel 2003
• Why Choose Excel 2003?
• About Spreadsheets
• Touring Excel Pt.1
• Touring Excel Pt.2
• Features New to Excel 2003

Installing Microsoft Excel 2003

• Recommendations Before You Install
• Minimum System Requirements
• Using Excel Setup
• Troubleshooting Excel 2003 Installation
• Performance Issues with Excel 2003

Getting Assistance With Excel 2003

• Ways to Increase Your Aptitude
• Exploring the Assistance Menu
• Type a Question for Assistance
• Using Microsoft Office Online

We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.

$99.95

Excel 2003 Basic Concepts

• Worksheets and Workbooks
• Organization
• Differences Between Text & Data Values
• Labels and Names
• More About Labels
• More about Cells and Cell Ranges
• About Mathematical Operators & Operands
• About Formulas & Calculations
• The Role of Functions
• Types of Charts
• Forms/Including Data Forms
• The Job of Queries
• What are Workbook Audits
• Importing and Exporting
• Linking and Embedding
• Absolute vs Relative Cell References
• What About Smart Tags?
• What is XML?
• Locking/Freezing Cells/Splitting Work Area
• About Excel Security

First Hands On In Excel

• Launching Excel 2003
• Planning Your Worksheet or Workbook
• Labeling & Naming Worksheet/Workbook
• A Look at Our Example Layout
• Naming and Saving Your Workbook
• Renaming and Deleting a Workbook
• Printing Your Workbook
• Double Check Workbook & Exit
• Opening an Existing Workbook

Customizing Excel 2003

• About Excel Customization
• Customizing Excel Menu Bar
• Customizing Excel Toolbars
• Changing Page Setup
• Modifying Default Location of Saved Work
• Setting Up Options Tutorials Pt.1
• Setting Up Options Pt.2

Entering Your Information

• About Entering Your Information
• Entering Labels and Values
• More About Multiple Entries
• Understanding Multiple Selections
• Inserting/Deleting Rows & Columns
• Copying & Pasting Columns/Rows & Cells
• Moving Columns/Rows & Cells
• Adding a Smart Tag
• Editing Your Work

Formatting Your Work

• Introduction to Formatting
• Formatting Text & Data Tutorials 1
• Formatting Text & Data Pt.2
• Using AutoFormat
• Changing AutoFormat Options
• Adding Colors and Patterns
• Adding Borders
• What is Conditional Formatting?
• Applying Conditional Formatting
• Copying Cell Formatting
• About Styles
• Creating a Style
• Applying and Modifying a Style

Adding Elements To A Workbook

• Introduction to Adding Elements
• Adding Images to a Workbook
• Modifying Images Inserted in Workbook
• Adding Clips
• Diagramming in Excel
• Adding an Organizational Chart
• Changing an Organizational Chart
• Adding WordArt
• Adding a Hyperlink
• Inserting Objects Such as AutoShapes

Calculation With Formulas and Functions

• About Formulas and Calculation
• Creating a Formula Pt.1
• Creating a Formula Pt.2
• Spotting Problems & Editing a Formula
• More About Functions

Managing Data With Microsoft Excel

• Use it or Lose it
• Using Forms/Particularly Data Forms
• Entering Data Using a Data Form
• Managing Data from a Data Form
• About Using Excel as a Database
• What are Lists?
• Creating a List
• Entering Data into a List
• Sorting Data in a List
• Using Filters to Sort Lists
• Auditing Excel Data
• Other Validation and Error Checking
• More About Validation for Data Entry
• Performing Queries
• Exporting Data from Excel
• Linking Data Pt.1
• Linking Data Pt.2

Working With Charts

• About Charts
• Creating Your Chart
• Modifying & Relocating Your Chart
• Other Changes to Your Chart

Sharing & Collaborating With Excel 2003

• Sharing Your Worksheet or Workbook
• Sending Your Workbook for Review
• Using Online Collaboration
• Protecting Your Workbook
• Change Different Versions of a Workbook
• Adding/Editing/Deleting Comments
• Creating & Sharing a Workbook Template

Credits

• About this Author