BN.com Gift Guide

Excel 2013 Simplified

Overview

A friendly, visual approach to learning the basics of Excel 2013

As the world's leading spreadsheet program, Excel is a spreadsheet and data analysis tool that is part of the Microsoft Office suite. The new Excel 2013 includes new features and functionalities that require users of older versions to re-learn the application. However, whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide gets you going with Excel ...

See more details below
Paperback
$18.18
BN.com price
(Save 27%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (13) from $4.58   
  • New (11) from $4.58   
  • Used (2) from $8.49   

Overview

A friendly, visual approach to learning the basics of Excel 2013

As the world's leading spreadsheet program, Excel is a spreadsheet and data analysis tool that is part of the Microsoft Office suite. The new Excel 2013 includes new features and functionalities that require users of older versions to re-learn the application. However, whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide gets you going with Excel 2013 quickly and easily. Numbered steps as well as full-color screen shots, concise information, and helpful tips, all contribute to a clear, comfortable learning experience.

  • Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more
  • Walks you through using Flash Fill, representing your data in a variety of ways, and maximizing a more interactive interface
  • Demonstrates how to share workbooks, collaborate with others, and embed portions of your spreadsheets on social network pages

Excel 2013 Simplified is a quick and easy way to get up to speed on Excel 2013 for both novice users and those upgrading from an earlier version.

Read More Show Less

Product Details

  • ISBN-13: 9781118505427
  • Publisher: Wiley
  • Publication date: 4/1/2013
  • Series: Simplified Series , #38
  • Edition number: 1
  • Pages: 288
  • Sales rank: 217,784
  • Product dimensions: 8.40 (w) x 9.90 (h) x 0.70 (d)

Table of Contents

Chapter 1 Working with Excel

Getting to Know Excel 4

Start Excel 6

Tour the Excel Window 8

Work with the Excel Ribbon 9

Work with the Excel Galleries 10

Customize the Quick Access Toolbar 12

Customize the Ribbon 14

Change the View 16

Configure Excel Options 18

Add Excel to the Windows Taskbar 20

Quit Excel 21

Chapter 2 Entering Data

Learning the Layout of a Worksheet 24

Understanding the Types of Data You Can Use 25

Enter Text into a Cell 26

Enter a Number into a Cell 28

Enter a Date or Time into a Cell 30

Insert a Symbol 32

Edit Cell Data 34

Delete Data from a Cell 36

Chapter 3 Working with Ranges

Select a Range 40

Fill a Range with the Same Data 42

Fill a Range with a Series of Values 44

Flash Fill a Range 46

Move or Copy a Range 48

Insert a Row or Column 50

Insert a Cell or Range 52

Delete Data from a Range 54

Delete a Range 56

Hide a Row or Column 58

Freeze Rows or Columns 60

Merge Two or More Cells 62

Transpose Rows and Columns 64

Chapter 4 Working with Range Names

Understanding the Benefits of Using Range Names 68

Define a Range Name 70

Use Worksheet Text to Define a Range Name 72

Navigate a Workbook Using Range Names 74

Change a Range Name 76

Delete a Range Name 78

Chapter 5 Formatting Excel Ranges

Change the Font and Font Size 82

Apply Font Effects 84

Change the Font Color 86

Align Text Within a Cell 88

Center Text Across Multiple Columns 90

Rotate Text Within a Cell 92

Add a Background Color to a Range 94

Apply a Number Format 96

Change the Number of Decimal Places Displayed 98

Apply an AutoFormat to a Range 100

Apply a Conditional Format to a Range 102

Apply a Style to a Range 104

Change the Column Width 106

Change the Row Height 108

Wrap Text Within a Cell 110

Add Borders to a Range 112

Chapter 6 Building Formulas

Understanding Excel Formulas 116

Build a Formula 118

Understanding Excel Functions 120

Add a Function to a Formula 122

Add a Row or Column of Numbers 124

Build an AutoSum Formula 126

Add a Range Name to a Formula 128

Reference Another Worksheet Range in a Formula 130

Move or Copy a Formula 132

Chapter 7 Manipulating Worksheets

Navigate a Worksheet 136

Rename a Worksheet 137

Create a New Worksheet 138

Move a Worksheet 140

Copy a Worksheet 142

Delete a Worksheet 144

Change the Gridline Color 146

Toggle Worksheet Gridlines On and Off 148

Toggle Worksheet Headings On and Off 149

Chapter 8 Dealing with Workbooks

Create a New Blank Workbook 152

Create a New Workbook from a Template 154

Save a Workbook 156

Open a Workbook 157

Arrange Workbook Windows 158

Find Text in a Workbook 160

Replace Text in a Workbook 162

Chapter 9 Formatting Workbooks

Modify the Workbook Colors 166

Set the Workbook Fonts 168

Choose Workbook Effects 170

Apply a Workbook Theme 172

Add a Workbook Header 174

Add a Workbook Footer 176

Chapter 10 Working with Tables

Understanding Tables 180

Get to Know Table Features 181

Convert a Range to a Table 182

Select Table Data 184

Insert a Table Row 186

Insert a Table Column 187

Delete a Table Row 188

Delete a Table Column 189

Add a Column Subtotal 190

Convert a Table to a Range 192

Apply a Table Style 193

Build a Custom Table Style 194

Chapter 11 Analyzing Data

Sort a Range or Table 198

Filter a Range or Table 200

Set Data Validation Rules 202

Create a Data Table 204

Summarize Data with Subtotals 206

Group Related Data 208

Analyze Data with Goal Seek 210

Analyze Data with Scenarios 212

Remove Duplicate Values from a Range or Table 216

Chapter 12 Visualizing Data with Charts

Examine Chart Elements 220

Understanding Chart Types 221

Create a Chart 222

Create a Recommended Chart 224

Add Chart Titles 226

Add Data Labels 227

Position the Chart Legend 228

Display Chart Gridlines 229

Display a Data Table 230

Change the Chart Layout and Style 231

Select a Different Chart Type 232

Change the Chart Source Data 234

Move or Resize a Chart 236

Chapter 13 Collaborating with Others

Add a Comment to a Cell 240

Protect a Worksheet’s Data 242

Protect a Workbook’s Structure 244

Share a Workbook with Other Users 246

Track Workbook Changes 248

Accept or Reject Workbook Changes 250

Save a Workbook to Your SkyDrive 252

Send a Workbook as an E-Mail Attachment 254

Save Excel Data as a Web Page 256

Make a Workbook Compatible with Earlier Versions of Excel 258

Mark Up a Worksheet with a Digital Pen 260

Collaborate on a Workbook Online 262

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)