28 Using Microsoft CE Applications
Pocket Excel: Creating Workbooks 3
You can use Pocket Excel to create workbooks, such as expense reports (see Figure
3-2) and mileage logs. You can also use Pocket Excel to open and edit workbooks
created in the desktop version of Excel. When you are ready to save a workbook you
created or edited, you can save it in a variety of formats, including Pocket Excel (.pxl)
and Excel (.xls). If you plan to send the document through e-mail to someone who
will be using Excel, not Pocket Excel, be sure to save it in the Excel (.xls) format.
Pocket Excel provides fundamental spreadsheet tools, such as formulas, functions,
sorting, and filtering. You can split panes to easily view different areas of a large
worksheet. You can also “freeze” the top and left-most panes in a worksheet to keep
row and column labels or other data visible as you scroll through a sheet.
To log expenses using Pocket Excel: 3
1.Select File, New, and then Workbook from Template.
2.Select Expense Report and then OK.
3.Select File and then Save.
4.Enter a name, choose a storage location, and then select OK.
5.Replace the text in the template.