HP Jornada 820 HP Jornada 820/820e Handheld PC User's Guide - F1260-90001 - Page 113

Using Microsoft Pocket Excel

Page 113 highlights

Chapter 6 | Getting down to business | 109 You can make the monitor black out during a presentation. To do so, press the key. To make the screen fade to white, press the key. Press the or key again to resume the presentation. Using Microsoft Pocket Excel You can use Pocket Excel to create workbooks, such as expense reports and mileage logs. You can also use Pocket Excel to open and edit workbooks created using 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 leftmost panes in a worksheet to keep row and column labels or other data visible as you scroll through a sheet. To create a workbook using Pocket Excel 1. On the File menu, point to New, and click Workbook from Template. 2. Select a template, such as Expense Report, and then click OK. 3. On the File menu, click Save. 4. Type a name for your file, and then click OK. 5. Replace the text in the template. Chapter6.p65 0109 109 2/4/99, 4:17 PM

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178

Chapter 6
|
Getting down to business
|
109
You can make the monitor black out during a presentation. To do so, press the
key.
To make the screen fade to white, press the
key. Press the
or
key again to
resume the presentation.
Using Microsoft Pocket Excel
You can use Pocket Excel to create workbooks, such as
expense reports and mileage logs. You can also use Pocket
Excel to open and edit workbooks created using 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 leftmost panes in a worksheet to
keep row and column labels or other data visible as you scroll
through a sheet.
To create a workbook using Pocket Excel
1.
On the
File
menu, point to
New
, and click
Workbook from Template
.
2.
Select a template, such as Expense Report, and then
click
OK
.
3.
On the
File
menu, click
Save
.
4.
Type a name for your file, and then click
OK
.
5.
Replace the text in the template.
Chapter6.p65 0109
2/4/99, 4:17 PM
109