Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. Excel was developed to feature calculation, graphing tools, pivot tables, organize data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data, and many more. Many people need help with Microsoft Excel because they don’t know how to use some other Microsoft office software, Microsoft Excel is just a simple application software.
Brief history and Microsoft help on Microsoft Excel by releasing new versions
Before Microsoft Excel was developed, Microsoft developed a spreadsheet called Multiplan in the year 1982. The Multiplan was a very popular application software but later on, it lost popularity to Lotus 1-2-3 systems.
Microsoft also launched the first version of Excel for Mac in 1985 and the first version for Windows was released in November 1987.
Lotus 1-2-3, was first sold by the Lotus Development Corporation in 1982, dominated the mid-1980s spreadsheet market for personal computers (PCs) that ran MS-DOS, an operating system sold by Microsoft Corporation.
Lotus was too slow to bring 1-2-3 to Windows and by 1988 Excel had started to outsell 1-2-3 and helped Microsoft achieve the position of leading PC software developer.
This accomplishment, dethroning the king of the software world, solidified Microsoft as a valid competitor and showed its future of developing graphical software.
Microsoft also pushed its advantage with regular new releases, every 2 years or so.
Help on Microsoft Excel
Understanding Microsoft Excel’s Interface
When one upgrades from an older version of Microsoft Excel to 2010, he/she will notice that there are lots of changes. But the good thing is that it becomes easier and more user-friendly.
In the 2010 version of Excel, tab menus are displayed across the top-left of the window. When you select a particular tab, the tools/options in the ribbon changes with text labels and picture icons based on the tab menu you clicked on.
Also, the ribbon contents are organized under the tabs in groups of related tools/features. You can also expand the groups by clicking on a small arrow at the bottom-right of the group box.
To get some idea of the purpose of an icon, place the mouse pointer over that icon (without clicking) and a tooltip will appear to provide some information about the icon.
Title bar – shows the application name and the name of an open file.
Menu bar – provides access to various functions of the spreadsheet.
A toolbar – in icon form – it offers direct access to the main functions. It is interesting to note that this bar can be personalized to allow shortcuts to the most used functions
A formula bar – shows the coordinates of the selected cell and its contents. The formula bar allows data to be entered in cells.
The status bar – provides information about required actions. By default, the message ready is shown in the status bar.
The worksheet – is the key to the spreadsheet – it is the table that contains all the cells. Tabs that allow the user to switch between worksheets are located at the bottom of the worksheet.
Office Button (an icon on the upper left side of the Excel 200) allows one to open, save and print workbooks. When a user clicks on the office button or File menu, he/she will be presented with a menu of options. In addition to opening, saving, and printing workbooks, there is a button called Excel Options. Clicking on this button displays a dialog box that offers one the ability to change various configuration parameters. It also contains the Add-In option.
You will notice that the latest versions of Excel do not use the Office Button. Instead, they provide the same functionality using the File tab. The section that opens is called The Backstage view