Benefits of Using MS Excel
What are the benefits of Microsoft Excel? The advantages of MS Excel are many--especially to users who take some time to get acquainted with Excel's features.
One benefit is timesavings. Excel saves you time by offering an intuitive GUI (graphical user interface). A key feature of this interface is the Ribbon, which prominently displays icons for the tools you'll likely use most often.
When you think of what Excel excels at, you likely think of data manipulation first: sorting, filtering, tabulating and calculating data. Each of the tools to do these tasks is immediately available on the Home tab of the Ribbon.
Locate the sorting icon in the "Editing" tool grouping, and locate the filter tool through the same icon. To use this tool, create a list of numbers on a worksheet. Type a "1" in any worksheet cell, then a "2" in the cell below it. Select both cells together, then drag their lower right corner down for several cells. Click "Sort & Filter" on the toolbar, followed by "sort largest to smallest." Excel will resort the list to progress from 10 to 1.
Timesavings from other tabs
Excel's other tabs display tools as commonly used in their area as the Home tab. Click the toolbar's "Insert" tab to see icons for objects you can insert in your worksheets. These objects include charts, tables, artwork, and links to other, non-spreadsheet documents like Word files and web pages.
Select "Page layout" tab for the layout options you use most: fonts and styles for individual cells, and themes for unifying your workbook's whole appearance. Set your page's margins with tools in the "Page setup" group, and arrange your charts and art with the "Arrange" group's tools.
Formulas and more
Click the "Formulas" tab to insert statistical, text, date and other types of formulas -- including your own, custom formulas. (See this article for details.) Find functions for importing text from the Web, Word, Access and other data sources in the "Data" tab.
Spell check your workbook with the "Spelling" icon in the "Review" tab--and translate your workbook to another language in this tab.
Arrange your workbook's workspace with the "Arrange all" and related icons in the "View" tab, and extend Excel with macros and GUI controls in the "Developer" tab.