Microsoft Excel is composed of different features that make it very effective as a spreadsheet program. The built-in formulas, charting capabilities and advanced features save time when gathering and presenting information.
Video of the Day
Microsoft Excel is composed of worksheets. Within each worksheet is a series of rows and columns. The rows are numbered and the columns are delineated by a letter. For example, rows are numbered 1, 2, 3 while columns are lettered A, B and C.
Formulas and Data Analysis
Microsoft Excel has built-in formulas used for engineering, statistics and to look up information, just to name a few. Excel also has a feature that allows for analyzing data. Scenarios and "what-if" analysis is possible with Excel.
Data in Excel can be presented using bar charts, column charts or even histograms and pareto charts. The charts are created using wizards that guide the user through each step of the process.
Excel can format cells, charts and printouts of the data. Cells can be formatted for percentages, decimal places and even colors. Charts are formatted to include the proper title, x and y axis labels, the scale used in the chart and the chart's size. If the data needs to be sent to another party, the print preview feature allows the user to make the information printer-friendly.
The Developer section contains macros and an area for Visual Basic programming. Macros are used to automate tasks and Visual Basic is for advanced programming.