Excel Skills | Excel 2010, 2007 & 2003 Training | Basic & Advanced Excel 2003 Training

This page contains a list of all our Excel 2003 tutorials in a Course 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 category based format and a full range of Excel 2010 and Excel 2007 tutorials are also included in our training membership.


	Select Version:	Excel 2010	Excel 2007	Excel 2003	Select Layout:	Category Based	Course Based


	Basic Excel
	Working With Excel Files The Excel Environment Opening Microsoft Excel Exit Excel Opening a new workbook Opening an existing workbook Save a workbook Close a workbook Using the Task Pane Minimize/ Maximize files Change Worksheet Size	Enter & Edit Data Enter Data Edit Data Auto Complete Data Selecting Cells (SAMPLE) Move Cells Clear Cell Contents Undo and Redo Insert / Delete Cells Insert / Delete Rows Insert / Delete Columns	Enter Formulas, Create Links and Copy Data Enter a Formula Create a Link Link to other Worksheets Relative / Absolute References Copy Cells Paste Cells (default) Paste Values Paste Formulas Paste Formats	Format Data Format Fonts Bold / Italic / Underline Format Text Size Format Text Colors Format Text Alignment Format Numbers Format Dates Format Cell Borders Format Cell Background Format Row Height Format Column Width
	Worksheet Features Insert Delete Rename Copy Move Hide / Unhide Change Tab Color	Excel Function Basics Insert a Function Select a Function Help with Functions Enter a Function Edit a Function Auto Sum Sum Values	Basic Date Functions Background on Dates Entering Dates & Times Current Date Date Components Convert Dates to Month End Dates	Basic Text Functions Convert Text, Dates and Numbers Combine Text from Multiple Cells Text Display (upper/lower case) Remove Spaces from Text
	Basic Statistical Functions Counting Data Average Value Minimum Value Maximum Value	Window Options Freeze Panes (SAMPLE) Switch Between Open Files Split Window	Page Layout & Printing Print a Worksheet Using Print Preview Define Page Set-up Set Page Orientation Fit Worksheet to Printed Pages Set Print Margins Set Page Breaks	Other Basic Excel Features Check Spelling Customize your Toolbar (SAMPLE) Windows Taskbar Properties Page Header & Footer Insert / Delete Comments View / Hide Comments Insert / Delete Pictures

	Advanced Excel
	Workbook, Worksheet & Window Features Copy a workbook Protect a workbook E-mail Excel Files Create New Window Arrange Windows Hide / Unhide a Workbook Compare Side by Side Selecting Multiple Worksheets	Edit, Copy & Paste Data Enter Data into Multiple Cells Move Cells - Other Worksheets Find Data Replace Data Copy Workbook Copy Worksheet Select Multiple Cell Ranges Paste Special - Options Paste Options Button Paste Text Orientation Auto Fill Remove Duplicate Records	Create & Maintain Links Copy & Paste to Create Links Link Cells to other Workbooks Edit Links to other Workbooks Break Links Insert Hyperlink	Advanced Formatting Selecting Cells Wrapping Text Merge / Unmerge Cells Protect Cells Autofit Rows Autofit Columns Hide / Unhide Rows Hide / Unhide a Column Using Autoformat Add Conditional Formatting Remove Conditional Formatting Conditional Formatting Formulas
	Page Layout & Printing Print a Selection Set Print Area Clear Print Area Repeat Rows on All Pages Repeat Columns on All Pages Print Multiple Worksheets Page Break Preview	Sorting, Filtering & Other 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	Excel 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	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
	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	What-if Tools Using Data Tables Using Goal Seek Create Scenarios Show Scenarios Edit Scenarios Delete Scenarios Compare Scenarios	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	General Excel Features Auditing Formulas Protection Error Checking Track Changes Auto Correct Options Change Default Excel Settings Customize Toolbar
	Function Features Analysis Toolpack * Formula Wildcard (SAMPLE) ? Formula Wildcard Common Formula Errors	Date Functions Using Month Names Using Weekdays Using Week Numbers Convert Text to Dates Work Days Year Fractions	Text Functions Determine Text Length Extract Characters from Text Find Characters in Text Replace Characters in Text Search for Characters in Text	Math Functions Sum Filtered Data Absolute Values Rounding Values Integer Values Random Values Square Roots
	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	Logical Functions IF Function Nesting IF Functions AND Function OR Function NOT Function	Statistical Functions SUMIF Function COUNTIF Function SUMPRODUCT Function Sum Based on Multiple Criteria Median Value Mode Value	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
	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

2012 © Excel-Skills.com. All rights reserved. \| Privacy Policy \| Submit Feedback


	Microsoft Excel Tutorials \| Excel 2003 \| Course Based This page contains a list of all our Excel 2003 tutorials in a Course 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 category 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