Simply Excel 2010. Wiley

by Paul McFedries

Publisher’s Acknowledgements

Some of the people who helped bring this book to market include the following:

Editorial and Production
VP Consumer and Technology Publishing
Director: Michelle Leete
Associate Director – Book Content
Management: Martin Tribe
Associate Publisher: Chris Webb
Executive Commissioning Editor: Birgit Gruber
Publishing Assistant: Ellie Scott
Production Manager: Amie Jackowski Tibble
Project Editor: Juliet Booker
Development Editor: Shena Deuchars

Composition Services:
Layout: Beth Brooks, Andrea Hornberger
Series Designer: Patrick Cunningham
Indexer: Potomac Indexing, LLC

Senior Marketing Manager: Louise Breinholt
Marketing Executive: Chloe Tunnicliffe

e-bookss shop
Simply Excel 2010

About the Author
Paul McFedries is a technical writer who has been authoring computer books since 1991. He has more than 60 books to his credit, which together have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010, Teach Yourself VISUALLY Microsoft Office 2008 for Mac, Excel 2010 Visual Quick Tips, and Excel 2010 PivotTable and PivotCharts Visual Blueprint. Paul also runs Word Spy, a Web site dedicated to tracking new words and phrases (see Please visit Paul’s personal Web site at

Author’s Acknowledgments
The book you hold in your hands is not only an excellent learning tool, but it is truly beautiful, as well. I am happy to have supplied the text that you will read, but the gorgeous layout comes from Wiley’s crack team of designers and screen artists. The layout of the tasks, the accuracy of the spelling and grammar, and the veracity of the information are all the result of hard work performed by project editor Lynn Northrup and technical editor Namir Shammas. Thanks to both of you for your excellent work. My thanks, as well, to executive editor Jody Lefevere for asking me to write this book.

How to Use This Book
Who Needs This Book
This book is for the reader who has never used this
particular technology or software application. It is also for
readers who want to expand their knowledge.

The Conventions in This Book
This book uses a step-by-step format to guide you easily
through each task. Numbered steps are actions you must
do; bulleted steps clarify a point, step, or optional feature;
and indented steps give you the result.
Notes give additional information – special conditions
that may occur during an operation, a situation that you
want to avoid, or a cross reference to a related area of the book.
Icons and Buttons
Icons and buttons show you exactly what you need to click to perform a step.
Tip and Warning Icons
Tips offer additional information, including tips, hints, and
tricks. You can use the tip information to go beyond what
you have learned in the steps. Warnings tell you about
solutions to common problems and general pitfalls to avoid.
Bold type shows command names, options, and text or numbers you must type.
Italic type introduces and defines a new term.

Table of Contents
4 Getting to Know Excel
6 Start Excel
8 Tour the Excel Window
9 Work with Excel’s Ribbon
10 Customise the Quick Access Toolbar
12 Customise the Ribbon
14 Work with Smart Tags
16 Change the View
48 Configure Excel Options
22 Learning the Layout of a Worksheet
23 Understanding the Types of Data You Can Use
24 Enter Text into a Cell
26 Enter a Number into a Cell
28 Insert a Symbol
30 Edit Cell Data
32 Delete Data from a Cell
36 Select a Range
38 Fill a Range with the Same Data
40 Fill a Range with a Series of Values
42 Move or Copy a Range
44 Insert a Row or Column
46 Insert a Cell or Range
48 Delete Data from a Range
50 Hide a Row or Column
52 Freeze Rows or Columns
54 Merge Two or More Cells
56 Transpose Rows and Columns
58 Define or Change a Range Name
60 Use Worksheet Text to Define a Range Name
62 Navigate a Workbook Using Range Names
66 Change the Font and Font Size
68 Apply Font Effects
70 Change the Font Colour
72 Align Text Within a Cell
74 Center Text Across Multiple Columns
76 Rotate Text Within a Cell
78 Add a Background Colour to a Range
80 Apply a Number Format
82 Apply an AutoFormat to a Range
84 Apply a Conditional Format to a Range
86 Apply a Style to a Range
88 Change the Column Width
90 Change the Row Height
92 Wrap Text Within a Cell
94 Add Borders to a Range
98 Understanding Excel Formulas
100 Build a Formula
102 Understanding Excel Functions
104 Add a Function to a Formula
106 Add a Row or Column of Numbers
108 Build an AutoSum Formula
110 Add a Range Name to a Formula
112 Reference Another Worksheet Range in a Formula
114 Move or Copy a Formula
118 Create a New Worksheet
120 Move a Worksheet
122 Copy and Rename a Worksheet
124 Delete a Worksheet
126 Change the Gridline Colour
128 Toggle Worksheet Gridlines On and Off
129 Toggle Worksheet Headings On and Off
132 Create a New Blank Workbook
134 Create a New Workbook from a Template
136 Save a Workbook
137 Open a Workbook
138 Arrange Workbook Windows
140 Find and Replace Text in a Workbook
142 Modify Workbook Colours
144 Set Workbook Fonts
146 Choose Workbook Effects
148 Apply a Workbook Theme
152 Sort a Range
154 Filter a Range
156 Set Data Validation Rules
158 Convert a Range to a Table
160 Create a Data Table
162 Summarise Data with Subtotals
166 Examining Chart Elements
167 Understanding Chart Types
168 Create a Chart
170 Add Chart Titles
171 Add Data Labels
172 Position the Chart Legend
173 Display Chart Gridlines
174 Display a Data Table
175 Change the Chart Layout and Style
176 Format Chart Elements
178 Customise a Chart Element Background
180 Set a Chart Element’s Outline
182 Add Effects to a Chart Element
184 Apply a Style to a Chart Element
188 Add a Comment to a Cell
190 Protect a Workbook
192 Share a Workbook with Other Users
194 Track Workbook Changes
196 Accept or Reject Workbook Changes
198 Make a Workbook Compatible with Earlier Versions of Excel
200 Collaborate on a Workbook Online


e-books shop

Purchase Now !
Just with Paypal

Product details
 2.00 USD
 226 p
 File Size
 13,529 KB
 File Type
 PDF format
 2010 by Wiley Publishing, Inc 

═════ ═════

Loading... Protection Status