LOADING
 
 
 
  • Microsoft Excel Tutorials | Excel 2003 | Category Based
This page contains a list of all our Excel 2003 tutorials in a Category based format. Click the orange links to view samples of some of the tutorials in a new browser window. The average video file size is 0.5MB and the average download time is less than 30 seconds. All our tutorials are based on a Flash video platform - if you experience any difficulty when attempting to view any of the sample videos, simply download the latest version of the Adobe Flash Player. Access to all our Excel training tutorials can be obtained by registering for an training membership and learning time can be verified by printing an online certificate. Our tutorials can also be listed in a course based format and a full range of Excel 2010 and Excel 2007 tutorials are also included in our training membership.
  • Links
  • View the Excel 2003 video file specifications (PDF)
  • More about the Features and Functions that are covered
  • Try our Skills Test
  • Training Membership Cost: R600 ($79 £50 €60)
  • Register for a training membership
 
  Select Version:
Excel 2010
Excel 2007
Excel 2003
Select Layout:
Category Based
Course Based
 
  • Using Excel Files
  • The Excel Environment
  • Opening Microsoft Excel
  • Opening a new workbook
  • Opening an existing workbook
  • Save a workbook
  • Copy a workbook
  • Close a workbook
  • Protect a workbook
  • E-mail Excel Files
  • Exit Excel
  • Viewing Options
  • Windows Taskbar Properties
  • Using the Task Pane
  • Minimize / Maximize files
  • Customize your Toolbar (SAMPLE)
  • Change Worksheet Size
  • Page Break Preview
  • Page Header & Footer
  • Edit Data
  • Enter Data
  • Enter Data into Multiple Cells
  • Auto Complete Data
  • Edit Data
  • Clear Cell Contents
  • Move Cells
  • Move Cells - Other Worksheets
  • Undo and Redo
  • Find Data
  • Replace Data
  • Remove Duplicate Records
  • Insert / Delete Data
  • Insert / Delete Cells
  • Insert / Delete Rows
  • Insert / Delete Columns
  • Insert / Delete Comments
  • View / Hide Comments
  • Insert / Delete Pictures
 
 
  • Copy & Paste Data
  • Copy Workbook
  • Copy Worksheet
  • Selecting Cells (SAMPLE)
  • Selecting Multiple Cells
  • Copy Cells
  • Paste Cells (default)
  • Paste Values
  • Paste Formulas
  • Paste Formats
  • Paste Special - Options
  • Paste Options Button
  • Paste Text Orientation
  • Auto Fill
  • Format Cells
  • Selecting Cells
  • Format Fonts
  • Bold / Italic / Underline
  • Format Text Size
  • Format Text Colors
  • Format Text Alignment
  • Format Numbers
  • Format Dates
  • Format Cell Borders
  • Format Cell Background
  • Wrapping Text
  • Merge / Unmerge Cells
  • Protect Cells
  • General Formatting
  • Format Row Height
  • Autofit Rows
  • Format Column Width
  • Autofit Columns
  • Hide / Unhide Rows
  • Hide / Unhide a Column
  • Using Autoformat
  • Add Conditional Formatting
  • Remove Conditional Formatting
  • Conditional Formatting Formulas
  • Formulas & Links
  • Enter a Formula
  • Create a Link
  • Link to other Worksheets
  • Relative / Absolute References
  • Copy & Paste to Create Links
  • Link Cells to other Workbooks
  • Edit Links to other Workbooks
  • Break Links
  • Insert Hyperlink
 
 
  • Worksheets
  • Insert
  • Delete
  • Rename
  • Copy
  • Move
  • Hide / Unhide
  • Change Tab Color
  • Selecting Multiple Worksheets
  • Using Functions
  • Insert a Function
  • Select a Function
  • Help with Functions
  • Enter a Function
  • Edit a Function
  • Analysis Toolpack
  • * Formula Wildcard (SAMPLE)
  • ? Formula Wildcard
  • Common Formula Errors
  • Pivot Tables & Pivot Charts
  • Source Data Layout
  • Create a Pivot Table (SAMPLE)
  • Format Pivot Tables
  • Pivot Table Column Width
  • Refresh a Pivot Table
  • Change Source Data
  • Change Pivot Table Layout
  • Filter Pivot Table Data
  • Pivot Table Data Drill-Down
  • Create a Pivot Chart
  • Importing External Data
  • Define Data Sources
  • New Database Queries
  • Edit Database Queries
  • Refresh Database Queries
  • New Pivot Table Queries
  • Edit Pivot Table Queries
  • Refresh Pivot Table Queries
 
   
 
  • Data Tools
  • Sort Data
  • Auto Filter Data
  • Advanced Filter
  • Removing Filters
  • Data Forms
  • Create Subtotals
  • Add Subtotal Level
  • Remove Subtotals
  • Insert Drop-Down List
  • Add Data Validation
  • Remove Data Validation
  • Text to Columns
  • Charts
  • Create a Chart (SAMPLE)
  • Chart Options
  • Edit Source Data
  • Format Chart Title
  • Format Chart Legend
  • Format Chart Plot Area
  • Format Gridlines
  • Change Chart Type
  • Change Chart Location
  • Format Axis
  • Using a Secondary Axis
  • Multiple Source Data Ranges
  • Save a Chart as an Image File
  • Using Named Ranges
  • Define Named Ranges
  • Create Multiple Names
  • Paste Names into Formulas
  • Enter Names in Formulas
  • Edit Names of Ranges
  • Edit Named Range Cells
  • Apply Named Ranges
  • Delete Named Ranges
  • General Excel Tools
  • Check Spelling
  • Customize
  • Auditing Formulas
  • Protection
  • Error Checking
  • Track Changes
  • Auto Correct Options
  • Change Default Excel Settings
 
 
  • What-if Tools
  • Using Data Tables
  • Using Goal Seek
  • Create Scenarios
  • Show Scenarios
  • Edit Scenarios
  • Delete Scenarios
  • Compare Scenarios
  • Window Options
  • Freeze Panes (SAMPLE)
  • Switch Between Open Files
  • Create New Window
  • Arrange Windows
  • Hide / Unhide a Workbook
  • Compare Side by Side
  • Split Window
  • Printing
  • Define Page Set-up
  • Set Page Orientation
  • Fit Worksheet to Printed Pages
  • Set Print Margins
  • Repeat Rows on All Pages
  • Repeat Columns on All Pages
  • Set Page Breaks
  • Using Print Preview
  • Print a Worksheet
  • Print Multiple Worksheets
  • Print a Selection
  • Set Print Area
  • Clear Print Area
  • Math Functions
  • Auto Sum
  • Sum Values
  • Sum Filtered Data
  • Absolute Values
  • Rounding Values
  • Integer Values
  • Random Values
  • Square Roots
 
 
  • Date Functions
  • Background on Dates
  • Entering Dates & Times
  • Current Date
  • Date Components
  • Convert Dates to Month End Dates
  • Using Month Names
  • Using Weekdays
  • Using Week Numbers
  • Convert Text to Dates
  • Work Days
  • Year Fractions
  • Text Functions
  • Convert Text, Dates and Numbers
  • Combine Text from Multiple Cells
  • Text Display (upper/lower case)
  • Remove Spaces from Text
  • Determine Text Length
  • Extract Characters from Text
  • Find Characters in Text
  • Replace Characters in Text
  • Search for Characters in Text
  • Logical Functions
  • IF Function
  • Nesting IF Functions
  • AND Function
  • OR Function
  • NOT Function
  • Lookup Functions
  • Lookup Cell Values
  • Lookup Cell Values by Column
  • Lookup Cell Values by Row
  • Link Cells and Change Orientation
  • Offset Cell References
  • Cell Position in Array
  • Column Number
  • Row Number
 
 
  • Information Functions
  • Use Error Types
  • Replace Blank Cells
  • Replace Errors in Cells
  • Replace #N/A Error
  • Identify Logical Values
  • Identify Numeric Values
  • Identify Text Values
  • Identify Non-Text Values
  • Identify Data Type
  • Statistical Functions
  • SUMIF Function
  • COUNTIF Function
  • SUMPRODUCT Function
  • Sum Based on Multiple Criteria
  • Counting Data
  • Average Value
  • Minimum Value
  • Maximum Value
  • Median Value
  • Mode Value
  • Financial Functions
  • Loan Repayment (SAMPLE)
  • Loan Principle Amount
  • Interest Rate
  • Loan Period
  • Principle Portion of Repayment
  • Interest Portion of Repayment
  • Cumulative Principle Repayment
  • Cumulative Interest Repayment
  • Future Value of Investment
  • Savings Annuity
  • Net Present Value
  • Internal Rate of Return
  • Database Functions
  • Syntax of Database Functions
  • Count Records
  • Average Field Value
  • Maximum Field Value
  • Minimum Field Value
  • Single Record Values
  • Sum Field Value
  • Using Formulas in Sum Criteria