OReilly Excel 2013, The Missing Manual.pdf

Excel 2013

The book that should have been in the box®

Matthew MacDonald

Excel 2013: The Missing Manual

by Matthew MacDonald

Printed in the United States of America.

Published by O’Reilly Media, Inc.,

1005 Gravenstein Highway North, Sebastopol, CA 95472.

O’Reilly books may be purchased for educational, business, or sales promotional use.

Online editions are also available for most titles ( http://my.safaribooksonline.com ).

For more information, contact our corporate/institutional sales department:

(800) 998-9938 or corporate@oreilly.com.

April 2013:

First Edition.

Revision History for the Nth Edition:

2013-04-10 First release

See http://oreilly.com/catalog/errata.csp?isbn=9781449357276 for release details.

The Missing Manual is a registered trademark of O’Reilly Media, Inc. The Missing

Manual logo, and “The book that should have been in the box” are trademarks of

O’Reilly Media, Inc. Many of the designations used by manufacturers and sellers to

distinguish their products are claimed as trademarks. Where those designations

appear in this book, and O’Reilly Media is aware of a trademark claim, the

designations are capitalized.

While every precaution has been taken in the preparation of this book, the publisher

assumes no responsibility for errors or omissions, or for damages resulting from the

use of the information contained in it.

ISBN-13: 978-1-449-35727-6

[LSI]

Contents

The Missing Credits ........................................ ix

Introduction .............................................. xiii

Part One: Worksheet Basics

CHAPTER 1:

Creating Your First Spreadsheet ........................... 3

Starting a Workbook ................................................3

Adding Information to a Worksheet ...................................4

Using the Ribbon .................................................. 12

Using the Status Bar. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Going Backstage ...................................................23

Saving Files .......................................................26

Opening Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

CHAPTER 2:

Adding Information to Worksheets ....................... 47

Adding Diferent Types of Data ......................................47

Handy Timesavers .................................................56

Dealing with Change: Undo, Redo, and AutoRecover ...................69

Spell-Check .......................................................75

Adding Hyperlinks .................................................80

CHAPTER 3:

Moving Data .............................................. 85

Selecting Cells .....................................................85

Moving Cells Around ...............................................92

Adding and Moving Columns or Rows ...............................103

CHAPTER 4:

Managing Worksheets ................................... 107

Worksheets and Workbooks .......................................108

Find and Replace ................................................. 118

CHAPTER 5:

Formatting Cells ......................................... 127

Formatting Cell Values ............................................128

Formatting Cell Appearance .......................................149

iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: