Excel 2016 Introduction.pdf

(14343 KB) Pobierz
STEPHEN MOFFAT
EXCEL 2016
INTRODUCTION
Download free eBooks at bookboon.com
2
Excel 2016 Introduction
1
st
edition
© 2016 Stephen Moffat &
bookboon.com
ISBN 978-87-403-1340-6
Download free eBooks at bookboon.com
3
EXCEL 2016 INTRODUCTION
Contents
CONTENTS
1
1.1
2
2.1
2.2
3
3.1
3.2
3.3
3.4
4
4.1
4.2
4.3
Introduction
How to use this guide
The basics
Window elements
Getting help
Basic movement and usage
Movement
Data entry
Editing
Selection
Formulae and functions
Formulae
Functions
Absolute and relative references
6
6
8
8
19
21
21
27
33
35
46
46
54
63
www.sylvania.com
We do not reinvent
the wheel we reinvent
light.
Fascinating lighting offers an infinite spectrum of
possibilities: Innovative technologies and new
markets provide both opportunities and challenges.
An environment in which your expertise is in high
demand. Enjoy the supportive working atmosphere
within our global group and benefit from international
career paths. Implement sustainable ideas in close
cooperation with other specialists and contribute to
influencing our future. Come and join us in reinventing
light every day.
Light is OSRAM
Download free eBooks at bookboon.com
4
Click on the ad to read more
EXCEL 2016 INTRODUCTION
Contents
5
5.1
6
6.1
6.2
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
9
9.1
9.2
9.3
9.4
9.5
9.6
10
10.1
10.2
10.3
10.4
10.5
10.6
10.7
11
11.1
File operations
Working with files
Moving and copying data
Cut, copy and paste
Moving and copying between files
Formatting
Font group formats
Number group formats
Format cells dialog
Formatting columns and rows
Insert and delete cells, rows, columns or sheets
Names
Naming cells and ranges
Name box
Working with sheets
Working with individual worksheets
working with multiple sheets
Protect worksheet data
Views and windows tools
Useful tools for large sheets
Advanced navigation
Printing
Printing options
Printing data (file print)
Views
Page set up dialog
Margins tab
Header/footer tab
New methods for headers and footers in 2016
Customising Excel
Set Excel options
Table of figures
Table of tables
About the author
66
66
75
75
82
86
86
96
99
111
118
125
125
126
138
138
145
152
157
166
170
173
173
177
179
185
189
191
195
201
201
213
222
223
Download free eBooks at bookboon.com
5

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin