excel_2013_the_missing_manual.pdf
(
34894 KB
)
Pobierz
www.it-ebooks.info
www.it-ebooks.info
Excel 2013
The book that should have been in the box®
Matthew MacDonald
Beijing | Cambridge | Farnham | Köln | Sebastopol | Tokyo
www.it-ebooks.info
Excel 2013: The Missing Manual
by Matthew MacDonald
Copyright © 2013 Matthew MacDonald. All rights reserved.
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]
www.it-ebooks.info
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
www.it-ebooks.info
Plik z chomika:
Amiga7878
Inne pliki z tego folderu:
access_2007_the_missing_manual.pdf
(44664 KB)
101_excel_2013_tips_tricks_and_timesavers.pdf
(46676 KB)
(ebook - PDF) JBoss Group - JBoss All Docs Subscription.zip
(16897 KB)
(ebook - pdf) Hack Proofing Linux.pdf
(12097 KB)
(ebook-pdf) - SAMS - DB2 Developer's Guide-Fourth Edition.pdf
(19264 KB)
Inne foldery tego chomika:
Amiga Computing Magazine (UK)
Anticipation Fleuve Noir
Asimov
Buddhism
Cinefantastique
Zgłoś jeśli
naruszono regulamin