|
Course Outline For:
Microsoft Excel 2003
Start learning Microsoft Excel 2003 right away, Free!
Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems
viewing the lessons, click here Introduction To Excel 2003 Installing Excel 2003 Getting Assistance With Excel 2003 More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00
|
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 Ò 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 Pt.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 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 | 
Learn Microsoft Excel 2003
