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.
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.
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.
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.
Want to see how we can really help you?
Version history of Excel
Changes introduced in the different versions of Microsoft Excel
Excel 2007 new features
A look at the major upgrade brought about with Excel 2007
Excel 2010 new features
Excel 2010: building on the new interface from 2007
Excel 2013 new features
Excel 2013: improvements in usability and collaboration
GET IN TOUCH
Call us on:
0333 6000 111
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 ?