Xem mẫu
Excel 2016 Introduction
Stephen Moffat, The Mouse Training Company
Download free books at
STEPHEN MOFFAT
EXCEL 2016 INTRODUCTION
Download free eBooks at bookboon.com
2
Excel 2016 Introduction 1st 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 Introduction 6 1.1 How to use this guide 6
2 The basics 8 2.1 Window elements 8 2.2 Getting help 19
3 Basic movement and usage 21 3.1 Movement 21 3.2 Data entry 27 3.3 Editing 33 3.4 Selection 35
4 Formulae and functions 46 4.1 Formulae 46 4.2 Functions 54 4.3 Absolute and relative references 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 Click on the ad to read more 4
EXCEL 2016 INTRODUCTION Contents
5 File operations 66 5.1 Working with files 66
6 Moving and copying data 75 6.1 Cut, copy and paste 75 6.2 Moving and copying between files 82
7 Formatting 86 7.1 Font group formats 86 7.2 Number group formats 96 7.3 Format cells dialog 99 7.4 Formatting columns and rows 111 7.5 Insert and delete cells, rows, columns or sheets 118
8 Names 125 8.1 Naming cells and ranges 125 8.2 Name box 126
9 Working with sheets 138 9.1 Working with individual worksheets 138 9.2 working with multiple sheets 145 9.3 Protect worksheet data 152 9.4 Views and windows tools 157 9.5 Useful tools for large sheets 166 9.6 Advanced navigation 170
10 Printing 173 10.1 Printing options 173 10.2 Printing data (file print) 177 10.3 Views 179 10.4 Page set up dialog 185 10.5 Margins tab 189 10.6 Header/footer tab 191 10.7 New methods for headers and footers in 2016 195
11 Customising Excel 201 11.1 Set Excel options 201
Table of figures 213
Table of tables 222
About the author 223
Download free eBooks at bookboon.com
5
...
- tailieumienphi.vn
nguon tai.lieu . vn