Microsoft Office Tutorials and References
In Depth Information
Use the Microsoft Excel 2013 program to organize and calculate numerical data.
Excel 2013 enables you to build a calculation by creating a formula that speciﬁ es the values
to calculate and which mathematical operators to use to perform the calculation. Excel also
offers functions — predesigned formulas that perform more complex calculations, such
as calculating accrued interest. Excel not only provides tools to assist you in building and
error-checking spreadsheet formulas, but it also gives you many easy choices for formatting
the data to make it more readable and professional. You’fill learn these Excel essentials later
in the book, as well as more about these key Excel features:
Worksheets: Within each ﬁ le, you can divide and organize a large volume of data
across multiple worksheets or pages of information in the ﬁ le.
Ranges: You can assign a name to a contiguous area on a worksheet so that you can
later select that area by name, or use the name in a formula to save time.
Number and Date Value Formatting: You can apply a number format that deﬁ nes
how Excel should display a cell’s contents, indicating details such as how many
decimal points should appear and whether a percentage or dollar sign should be
included. You can also apply a date format to determine how the date appears.