tailieunhanh - Ebook Excel 2016 Introduction

Ebook Excel 2016 Introduction should be used as a point of reference following attendance of the introductory level Excel 2016 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course. It may also be used as a self-help tutorial following the sections in the order presented will allow the user to build their skills in a logical fashion and by the end of this manual allow them to use Excel in a reasonably competent fashion. | Excel 2016 Introduction Stephen Moffat, The Mouse Training Company Download free books at STEPHEN MOFFAT EXCEL 2016 INTRODUCTION Download free eBooks at 2 Excel 2016 Introduction 1st edition © 2016 Stephen Moffat & ISBN 978-87-403-1340-6 Download free eBooks at 3 EXCEL 2016 INTRODUCTION Contents CONTENTS 1 Introduction 6 How to use this guide 6 2 The basics 8 Window elements 8 Getting help 19 3 Basic movement and usage 21 Movement 21 27 Data entry Editing 33 Selection 35 4 46 Formulae and functions Formulae 46 Functions 54 63 Absolute and relative references 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 4 Click on the ad to read more EXCEL 2016 INTRODUCTION Contents 5 File operations 66 Working with files 66 6 Moving and copying data 75 Cut, copy and paste 75 Moving and copying between files 82 7 Formatting 86 Font group formats 86 Number group formats 96 Format cells dialog 99 Formatting columns and rows 111 Insert and delete cells, rows, columns or sheets 118 8 Names 125 Naming cells and ranges 125 Name box 126 9 Working with sheets 138 Working with individual worksheets 138 working with multiple sheets 145 Protect worksheet data .