Microsoft Excel Parts & Definitions
Microsoft Excel is spreadsheet software whose parts integrate to create a powerful tool for presenting financial information. The parts of the programs make gathering and presenting information easier and also allow for advanced spreadsheet functions.
The main part of Microsoft Excel is the worksheet. This is the space where all of the activity occurs in Excel. There are usually three worksheets in each Excel workbook by default.
Formulas and Data Analysis
Microsoft Excel has built-in formulas that allow for quick and easy calculations. The formulas available in Excel can be used for dates and times, accounting, statistics, financials, etc. Some formulas that would be very complex if calculated by hand can be calculated quickly using Excel. You can also link formulas across worksheets and workbooks. Data analysis can also be performed in Excel. What-if modeling is especially useful for testing scenarios.
Data entered and calculated in Excel can be used to create charts. The types of charts that can be created include: column, line, bar and pie charts, just to name a few.
Excel allows for the formatting of cells for number formats, conditional formatting according to calculation results and print formatting. Cells can be displayed as currency or dates. When a calculation results in a specified calculation, those cells can be highlighted with with different colors or fonts. When the worksheets need to be printed, the user can change the layout of the sheet to make it printer-friendly.
There is a developer section in Excel that allows the user to create macros. This section also allows for advanced programming using Visual Basic.