LOADING
Click here to view your shopping cart contents and to proceed to the Checkout. All prices are once-off and there is no time limit on the use of our templates.
 
  • Excel 2003 Tutorials | Excel Features
Our more than 260 Excel 2003 tutorials cover all the core functionality that is included in Microsoft Excel 2003. The tutorials can be viewed in a category or course based format and are suitable for novice and advanced users. We recommend that novice users start with the basic Excel course before progressing to the advanced Excel course and that advanced users also view the tutorials on basic Excel features because some of these tutorials contain guidance that can significantly increase your efficiency when working in Excel. This page provides information on the main Excel features that are covered in each tutorial category.
 
 
  • Using Excel Files
  • Learn how to:
This category covers basic Excel features like opening and exiting the Excel application, opening a new or existing workbook and saving, copying and closing a workbook. It also includes a tutorial for novice users with basic information on the Excel application environment and guidance on advanced features like how to protect a workbook and e-mail Excel files.
  • Viewing Options
  • Learn how to:
This category includes guidance on how to display individual Excel files in the Windows Status Bar, how to use the Excel Task Pane as a resource for opening recently used files or accessing the Excel Help function and how to adjust the scale (zoom) of a worksheet. Printing features such as page break preview and headers & footers are also covered and there is an extremely useful tutorial on how to customize the standard Excel toolbar.
  • Edit Data
  • Learn how to:
This category includes guidance on basic features like entering and editing data, clearing cell values and/or formatting, moving cells and how to use the undo and redo features. Guidance on the useful find and replace features are also included in this category as well as guidance on more advanced features like simultaneously entering data into a range of cells and using the cut feature to move cells to another worksheet.
 
 
  • Insert / Delete Data
  • Learn how to:
This category includes guidance on how to insert cells, delete cells, insert new rows, delete rows, insert new columns and delete columns. We also show you how to enter a comment into a cell, how to view, hide or delete comments and how to insert or delete pictures.
  • Copy & Paste Data
  • Learn how to:
This category starts with guidance on how to copy a workbook or a worksheet. Then, we cover a number of different techniques that can be used to select cells and we have a thorough look into the paste options that are available after copying cells. The category also includes a tutorial on the Auto Fill feature.
  • Format Cells
  • Learn how to:
This category includes comprehensive guidance on formatting cells. The formatting features that are covered include basic features like text font, size, colour, alignment, number formats and date formats as well as more advanced features like merging cells, wrapping text and locking cells in order to implement worksheet protection.
 
 
  • General Formatting
  • Learn how to:
This category includes general formatting features like row heights, column widths, hiding or unhiding rows or columns and guidance on how to auto fit rows or columns. Also included is guidance on how to apply conditional formatting to a range of cells and how to use formulas when specifying conditional formatting criteria.
  • Formulas & Links
  • Learn how to:
This category includes guidance on essential basic features like how to enter a formula and how to create a link between cells. Also included is a comprehensive illustration of absolute and relative cell references which is an essential concept for all novice Excel users to understand. We also show you how to create links to other workbooks.
  • Worksheets
  • Learn how to:
This category covers only worksheet features. You will learn how to insert, delete, copy, move and rename worksheets as well as hiding or unhiding worksheets. We'll also show you how to change the tab colour of a worksheet and how to select multiple worksheets simultaneously which is quite useful when printing only selected worksheets.
 
 
  • Using Functions
  • Learn how to:
This category includes important basic guidance on Excel functions like how to insert, enter, select or edit a function as well as how to obtain help on specific functions. It also includes guidance on how to install the Analysis Toolpack and advanced guidance on working with wildcard characters and understanding function errors.
  • Data Tools
  • Learn how to:
This category starts with tutorials on sorting and filtering data. It also includes guidance on using data forms, adding subtotals to a data range and adding data validation to a cell range, including an illustration on how to create drop down list boxes for data entry. We'll also show you how to convert text to columns which is useful when copying data from text based applications.
  • Charts
  • Learn how to:
This category includes comprehensive guidance on Excel charts from how to structure the source data of a chart to tutorials on customizing individual chart elements. After viewing these chart tutorials, users should be able to create and customize any Excel chart. Also included is guidance on advanced chart features like using secondary axes and copying an Excel chart as an image file.
 
 
  • Pivot Tables & Pivot Charts
  • Learn how to:
This category includes guidance on pivot tables - one of the most useful data analysis features in Excel. We show you how to create, format, refresh and edit pivot tables. Techniques used for filtering pivot table data and drilling down to the source data that makes up pivot table totals are also illustrated. Also included is guidance on how to create a pivot chart.
  • Importing External Data
  • Learn how to:
This category covers importing data from external data sources into Excel. The techniques that are illustrated in this category add significant value in terms of productivity and efficiency. We start with some basic guidance on setting up a data source that can be used for database queries and we then illustrate how to create, edit and refresh database queries and pivot table based database queries.
  • Using Named Ranges
  • Learn how to:
This category covers named ranges. If you have not used this Excel feature before, you will learn more about a feature that will save you a lot of time when entering formulas or adjusting the cell ranges that are referred to in multiple formulas. We'll show you how to create, edit, copy & paste, rename and apply named ranges in formulas.
 
 
  • General Excel Tools
  • Learn how to:
This category includes guidance on customizing the default Excel settings to your requirements, using Excel features to check the spelling in a workbook and to trace the cells that are included in formulas as well as resolving formula errors and tracking changes.
  • What-if Tools
  • Learn how to:
This category includes a number of useful features that you may not be aware of. We'll show you how to use data tables, the goal seek feature which can be used instead of performing time consuming trial & error calculations and the scenarios feature that is used to analyze data according to a number of different scenarios.
  • Window Options
  • Learn how to:
This category covers Excel windows. We'll show you how to open the same workbook in two separate windows, how to arrange open windows, split windows and use the freeze panes feature to control scrolling on a worksheet. These features are especially useful when linking or copying cells between two or more workbooks.
 
  More about our Excel Function tutorials      
You have 0 templates in your cart