Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Excel 2003 Training Courses From Activia
Excel 2003 Training Courses From Activia
Search

EXCEL 2003 NEW FEATURES

What was new with Excel 2003

Background information and resources for Excel 2003 training courses that we hope you find useful

Succeeding the short-lived Excel XP, Excel 2003 was the last version of Excel that used the 'Tool Bar' (or drop-don) menu system. There were no major changes from the earlier 2000 version, and its release was met with a relatively lukewarm reception. However, it included the following additions and enhancements.

Overview

XML FORMAT

Excel caught up with Word, in that it could now save and upload data in XML format. Many people had other files coded in XML that were previously incompatible with their version of Excel, so with the 2003 version it was possible to import this data into Excel. This will, in turn, map them accordingly to the cells, ranges and nodes of the Workbook in use.

There was also a Professional version of Excel that allowed users to work with customised XML schemas. One of the main advantages of buying this package was that it allowed people to import information into a database and other applications -- obviously geared towards more advanced users.

XML Format

SMART TAGS

Excel 2003 introduced Smart Tags, the little 'tags' or icons that appear next to a cell or object to offer more options. Common examples of Smart Tags are when an error occurs in a cell (the Smart Tag offers you help with the error) and when using Autofill (the Smart Tag offers you variations on what you have filled).

Since their introduction Smart Tags have become 'the norm' and are seen as a basic feature due to their ease of use.

DATA TABLES, LIST MANAGEMENT AND SHAREPOINT INTEGRATION

Data Tables -- This feature allowed users to forecast a range of figures in the form of a table by just referencing formula and total cells from an existing spreadsheet.

Lists -- This enabled data in a spreadsheet to be stored in table form, working in the same way as a database. For example, each row works as a record and each column acts as a field, containing a particular data type. By formatting this data as a list, Excel will allow new rows (or records) to be added to the list and then be referenced and filtered by its columns and records to find particular information.
Since Excel 2003, lists have been developed further and are now simply referred to as Tables.

SharePoint Integration -- Excel lists and SharePoint sites use database principles, and Excel 2003 allows the SharePoint site's database to be referred to and managed from Excel once the correct permissions have been established.

SMART DOCUMENTS AND STATISTICAL FUNCTIONS

Smart Documents -- Excel 2003 is able to update a spreadsheet's content depending on the data sources it has been set up to work with. This is advanced work, needing specialist VBA (or other language) customisation, but can be used to ensure that various data in a spreadsheet are always accurate and up to date by connecting to source data.

Statistical Functions -- Excel 2003 also saw improvements in various statistical functions, including the LINEST, MORMSDIST and RAND functions.

OUR VERDICT

Excel 2003 was the last in a line of 'minor' improvements where there was no need to upgrade unless a specific new feature was wanted. However, the next version -- 2007 -- would change all that.

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Version history of Excel

Version history of Excel

Changes introduced in the different versions of Microsoft Excel

      Click to read more

 

Excel 2007 new features

Excel 2007 new features

A look at the major upgrade brought about with Excel 2007

      Click to read more

Excel 2010 new features

Excel 2010 new features

Excel 2010: building on the new interface from 2007

      Click to read more

 

Excel 2013 new features

Excel 2013 new features

Excel 2013: improvements in usability and collaboration

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

NEW FEATURES IN EXCEL 2003

We can enhance your skills with training for Microsoft Excel 2003 at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel 2003 courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel 2003 training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training for Excel 2003 to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Excel 2003 Training Courses From Activia.

Why not contact us today to see how we can help with providing your courses for MS Excel 2003 ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top