Differences in Use between Calc and Excel. This chapter summarizes the differences in use between OpenOffice.org Calc 2.0 and Microsoft Excel (various versions).
The information in this chapter builds upon the information given in Chapter General Differences in Use between OpenOffice.org and Microsoft Office. The Calc interface The main Calc workspace is shown below. Terminology. The Imposing INDEX - Excel Hero Blog. From my perspective, the Excel INDEX function is the single most important in the roster of Microsoft Excel functions.
Now that might be surprising considering the function's humdrum name, but please pay close attention, because INDEX is one of the magical secrets of how to use Excel! So what's so great about the INDEX function? It's nonvolatile, sprightly, agile, and versatile. Excel INDEX can return one value or an array of values; it can return a reference to one cell or to a range of cells. Excel functions (by category) Worksheet functions are categorized by their functionality.
If you know the category of the function that you are looking for, you can click that category. Tip You can also search the page by pressing CTRL+F, typing the first few letters of a function or a word that describes what you are looking for, and then clicking Next. ExcelRibbon.Tips.Net - Powerful tips on using Microsoft Excel. Five Excel Nightmares & How to Fix Them.