Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.
Posey's Tips & Tricks. Expanded Data Types: Microsoft Excel's Most Significant New Feature in Years. Beyond just crunching budgets, Microsoft's recent Excel overhaul will give it the intelligence. Microsoft Office Specialist Excel certification. Our cutting-edge Excel certification program gives testing candidates practical, performance-based scenarios to gauge their real-world capabilities with project and standards-based outcome testing.
Most Recent Excel Update
| VERSION | RELEASED | DESCRIPTION |
|---|---|---|
| 1 | 1985 | Version 1, for the Macintosh was released. There never was an Excel 1.0 for DOS or Windows. |
| 2 | 1987 | Excel 2.0 is the first version of Excel for Intel platform. |
| 3 | 1990 | Included Toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features. |
| 4 | 1992 | The first 'popular' version. Included lots of usability features. |
| 5 | 1993 | A major upgrade. Included multi-sheet workbooks. Visual Basic for Applications (VBA) was introduced in this version. |
| 7 | 1995 | Known as Excel 95. The first major 32-bit version of Excel. This is the first major version after Excel 5.0, as there is no Excel 6.0. Almost no external changes, but faster and more stable. |
| 8 | 1997 | Known as Excel 97. A new interface for VBA developers, UserForms, Data Validation, and lots more. This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels. |
| 9 | 2000 | Included in Microsoft Office 2000. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.Can use HTML as a native file format, 'self-repair' capability, pivot charts, modeless user forms. |
| 10 | 2002 | Known as Excel 2002. Included in Office XP. Logic para windows. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes. This version features product activation technology. Please consider the ramifications of this before deciding whether to upgrade. |
| 11 | 2003 | Known as Microsoft Office Excel 2003. The new features in this version are:
Most users will not find the upgrade worthwhile. |
| 12 | 2007 | Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being 'somewhat more negative' than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are:
|
| 14 | 2010 | Included in Microsoft Office 2010, this is the next major version after version 12, as version number 13 was skipped. Minor enhancements and 64-bit support, including the following features:
|
| 15 | 2013 | Included in Microsoft Office 2013, along with a lot of new tools included in this release:
|
Hi, is it possible to have a date function or formula that will display the date of the most recent Friday, by that I mean if today is Tues 17th Feb, I would li Excel to work out date for the most recent Friday - Microsoft: Office - Tek-Tips. Go to the recent document lists by clicking File Recent in Excel 2010, or click File Open Recent Workbooks in Excel 2013. Then in the Recent Workbooks list, right click and choose Clear unpinned Workbooks from the context menu, see screenshot: 3. And a prompt box will pop out to remind you if you want to remove all the unpinned items. Where are Recent Colors Stored? Recent Colors appear in the color dropdowns only when the file they were defined for is the active file in its Office application (in this case, the active workbook in Excel). This means they must be stored somewhere within the document. The first step in modifying the Recent Colors is to close the Office file.
Google Sheets
Adobe premiere elements portable. How many files will Excel show in the Recently Used File List? Well, it depends on the version of Excel you're using and vary between 9 and ninety-nine files.
Here is a list of Excel versions, menu navigation to the recent file list, and the max files allowed.
Excel 2010, 2007
File>Options>Advanced tab>under the Display heading:
Show this number of Recent Documents: 50 max
Excel 2003
Tools>Options>General tab
Recently used file list: 9 max
Excel for Mac 2008, 2011
Excel>Preferences>General
Show this number of recent documents: 99 max
A Related Feature in Excel 2010
Microsoft Excel Download
At the bottom of the Recent Workbooks list, Excel 2010 has an option you can check to:
Quickly access this number of Recent Workbooks: x
Checking this box adds recent files to the left pane so you can always see the file names. They're not really the most recent files because they include any files you have pinned to the top of the list, even if they haven't been opened in a while.
(I covered this feature in a microblog article on Tumblr and in a recent post with video here on this blog.)
Related posts:
