Excel 2019 in easy steps will help you get to grips with the latest version of this popular spreadsheet application. Areas covered include:
Creating, editing and manipulating worksheetsFormulas, Functions and Pivot TablesHandy templates to give you a head startMacros for everyday tasks to save timeCharts to get an overview of your dataLinking workbooks for automatic updatesUsing the Excel Online app to share and collaborate on spreadsheets and workbooksAdding images and illustrations to your spreadsheet to impress your colleagues! Whether youre upgrading to Excel 2019 or new to the spreadsheet concept, use this guide to learn the key features constructively and get more out of Excel 2019 in easy steps!
This book will help the reader to get to grips with Microsoft Excel 2019 quickly - whether they are new to this popular spreadsheet application, or just upgrading from an older version.
|
|
|
7 | (14) |
|
|
|
8 | (2) |
|
|
|
10 | (1) |
|
|
|
11 | (1) |
|
|
|
12 | (1) |
|
|
|
13 | (1) |
|
Excel 2019 and Windows 10 |
|
|
14 | (2) |
|
|
|
16 | (2) |
|
|
|
18 | (2) |
|
|
|
20 | (1) |
|
|
|
21 | (18) |
|
|
|
22 | (2) |
|
|
|
24 | (1) |
|
Add Data to the Worksheet |
|
|
25 | (1) |
|
|
|
26 | (2) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (1) |
|
|
|
31 | (1) |
|
|
|
32 | (2) |
|
|
|
34 | (1) |
|
|
|
35 | (1) |
|
|
|
36 | (1) |
|
|
|
37 | (2) |
|
|
|
39 | (18) |
|
|
|
40 | (2) |
|
|
|
42 | (2) |
|
|
|
44 | (2) |
|
Scroll with the Wheel Mouse |
|
|
46 | (1) |
|
|
|
47 | (1) |
|
|
|
48 | (1) |
|
|
|
49 | (1) |
|
|
|
50 | (2) |
|
|
|
52 | (1) |
|
|
|
53 | (1) |
|
Freeze Headers and Labels |
|
|
54 | (1) |
|
|
|
55 | (1) |
|
|
|
56 | (1) |
|
|
|
57 | (14) |
|
|
|
58 | (2) |
|
|
|
60 | (1) |
|
|
|
61 | (1) |
|
|
|
62 | (1) |
|
|
|
63 | (1) |
|
|
|
64 | (1) |
|
|
|
65 | (1) |
|
|
|
66 | (2) |
|
|
|
68 | (1) |
|
|
|
69 | (1) |
|
|
|
70 | (1) |
|
|
|
71 | (16) |
|
|
|
72 | (2) |
|
|
|
74 | (1) |
|
|
|
75 | (1) |
|
|
|
76 | (1) |
|
|
|
77 | (1) |
|
|
|
78 | (1) |
|
|
|
79 | (1) |
|
|
|
80 | (2) |
|
|
|
82 | (1) |
|
|
|
83 | (1) |
|
|
|
84 | (2) |
|
|
|
86 | (1) |
|
|
|
87 | (18) |
|
|
|
88 | (1) |
|
|
|
89 | (1) |
|
Lookup/Reference Functions |
|
|
90 | (2) |
|
|
|
92 | (2) |
|
|
|
94 | (2) |
|
|
|
96 | (2) |
|
|
|
98 | (2) |
|
|
|
100 | (1) |
|
|
|
101 | (1) |
|
|
|
102 | (1) |
|
|
|
103 | (1) |
|
|
|
104 | (1) |
|
|
|
105 | (18) |
|
|
|
106 | (2) |
|
|
|
108 | (1) |
|
|
|
109 | (2) |
|
|
|
111 | (1) |
|
|
|
112 | (1) |
|
|
|
113 | (1) |
|
|
|
114 | (1) |
|
|
|
115 | (1) |
|
|
|
116 | (2) |
|
|
|
118 | (1) |
|
|
|
119 | (1) |
|
|
|
120 | (1) |
|
|
|
121 | (2) |
|
|
|
123 | (16) |
|
|
|
124 | (2) |
|
|
|
126 | (1) |
|
|
|
127 | (1) |
|
|
|
128 | (1) |
|
|
|
129 | (1) |
|
|
|
130 | (2) |
|
|
|
132 | (1) |
|
|
|
133 | (1) |
|
|
|
134 | (1) |
|
|
|
135 | (1) |
|
|
|
136 | (1) |
|
|
|
137 | (1) |
|
|
|
138 | (1) |
|
|
|
139 | (16) |
|
|
|
140 | (1) |
|
|
|
141 | (1) |
|
|
|
142 | (2) |
|
|
|
144 | (1) |
|
|
|
145 | (1) |
|
|
|
146 | (2) |
|
|
|
148 | (1) |
|
|
|
149 | (1) |
|
|
|
150 | (2) |
|
Add Macros to the Toolbar |
|
|
152 | (2) |
|
|
|
154 | (1) |
|
10 Templates and Scenarios |
|
|
155 | (16) |
|
|
|
156 | (2) |
|
|
|
158 | (2) |
|
|
|
160 | (2) |
|
|
|
162 | (2) |
|
|
|
164 | (2) |
|
|
|
166 | (1) |
|
|
|
167 | (1) |
|
|
|
168 | (1) |
|
|
|
169 | (2) |
|
|
|
171 | (16) |
|
|
|
172 | (2) |
|
Create External References |
|
|
174 | (2) |
|
|
|
176 | (1) |
|
|
|
177 | (1) |
|
|
|
178 | (1) |
|
|
|
179 | (1) |
|
|
|
180 | (2) |
|
Using the Excel Online App |
|
|
182 | (2) |
|
|
|
184 | (2) |
|
|
|
186 | (1) |
| Index |
|
187 | |
Michael Price is an accomplished author, IT journalist and systems consultant with a wide experience of computing systems ranging from mainframes to personal computers. He's also a successful author with several best-selling In Easy Steps books to his credit, including earlier editions of Excel in easy steps.
Daugiau apie elektronines knygas