Excel 2013 For Dummies

( 1 )

Overview

Learn to:

  • Use the new features of Excel 2013
  • Create and edit spreadsheets
  • Share workbooks via SkyDrive
  • Format cells, create formulas, and fix data entry errors

Need to use Excel 2013? Get just what you need to know and get on with your life!

That's what this little book is for. Here's the necessary ...

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

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (22) from $13.00   
  • New (15) from $13.00   
  • Used (7) from $13.40   

Overview

Learn to:

  • Use the new features of Excel 2013
  • Create and edit spreadsheets
  • Share workbooks via SkyDrive
  • Format cells, create formulas, and fix data entry errors

Need to use Excel 2013? Get just what you need to know and get on with your life!

That's what this little book is for. Here's the necessary information to get you up and running with Excel 2013 on your desktop, laptop, touchscreen tablet, or smartphone. It's not about becoming a spreadsheet guru. It's about gaining a working knowledge of Excel 2013 so you can use it in your studies or on the job — right now.

  • The user experience — get acquainted with the program window, Backstage view, and Ribbon interface
  • Build that spreadsheet — create workbooks and worksheets, enter data, correct errors, and use AutoFill
  • The magic formula — learn to create, enter, and edit formulas
  • Lookin' good — make your spreadsheets easy to understand by formatting cells, cell ranges, columns, and rows
  • Share your stuff — link your worksheets to other Office documents, share them, and edit them with Excel Web Apps
  • Let us print — preview your pages and print a report that makes you look good

Open the book and find:

  • Methods for starting Excel 2013
  • Tips on fixing data entry errors
  • How to recover your workbooks in case of a crash
  • Secrets of formatting data tables
  • Ways to automate Excel with Office apps and add-ins
  • Techniques for adding hyperlinks to your worksheets
Read More Show Less

Product Details

  • ISBN-13: 9781118510124
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 1/29/2013
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 408
  • Sales rank: 51,246
  • Product dimensions: 7.40 (w) x 9.20 (h) x 0.90 (d)

Meet the Author

Greg Harvey, PhD, is President of Mind Over Media, an online media company. He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

Read More Show Less

Table of Contents

Introduction 1

About This Book 1

Conventions Used in This Book 1

Icons Used in This Book 2

Chapter 1: The Excel 2013 User Experience 3

Excel’s Ribbon User Interface 4

Going Backstage 7

Using the Excel Ribbon 8

Customizing the Quick Access Toolbar 14

Using the Quick Access Toolbar button 15

Adding Ribbon commands 17

Adding non-Ribbon commands 18

Having Fun with the Formula Bar 19

Working in the Worksheet Area 20

Moving around the worksheet 21

Showing off the Status Bar 29

Launching and Quitting Excel 30

Starting Excel in Windows 8 30

Starting Excel in Windows 7 31

Adding an Excel 2013 shortcut to your Windows 7 desktop 32

Exiting Excel 33

Help Is on the Way 33

Chapter 2: Creating a Spreadsheet from Scratch 35

So What Ya Gonna Put in That New Workbook of Yours? 36

The ins and outs of data entry 38

You must remember this 39

Doing the Data-Entry Thing 39

It Takes All Types 42

The telltale signs of text 43

How Excel evaluates its values 43

Fabricating those fabulous formulas! 49

If you want it, just point it out 52

Altering the order of operations 53

Formula flub-ups 54

Fixing Data Entry Flub-Ups 57

You really AutoCorrect for me 57

Cell editing etiquette 58

Avoiding Data Entry Drudgery 60

I’m just not complete without you 60

Fill’er up with AutoFill 61

Fill it in a flash 66

Inserting special symbols 69

Making Formulas Function Better 70

Inserting a function into a formula 71

I’d be totally lost without AutoSum 75

Sums via Quick Analysis Totals 79

Making Sure Data Is Safe 80

Chapter 3: Making It All Look Pretty 83

Choosing a Select Group of Cells 84

Point-and-click cell selections 85

Keyboard cell selections 88

Using the Format as Table Gallery 90

Cell Formatting from the Home Tab 94

Formatting Cells Close to the Source with the Mini-bar 98

Using the Format Cells Dialog Box 100

Understanding the number formats 101

The values behind the formatting 108

Make it a date! 109

Ogling some of the other number formats 110

Calibrating Columns 112

Rambling rows 113

Now you see it, now you don’t 114

Futzing with the Fonts 117

Altering the Alignment 119

Intent on indents 120

From top to bottom 121

Tampering with how the text wraps 122

Reorienting cell entries 124

Shrink to fit 126

Bring on the borders! 127

Applying fill colors, patterns, and gradient effects to cells 129

Doing It in Styles 131

Creating a new style for the gallery 131

Copying custom styles from one workbook into another 132

Fooling Around with the Format Painter 133

Chapter 4: Printing the Masterpiece 135

Previewing Pages in Page Layout View 137

Using the Backstage Print Screen 138

Printing the Current Worksheet 142

My Page Was Set Up! 143

Using the buttons in the Page Setup group 144

Using the Scale to Fit buttons 153

Using the Print buttons in the Sheet Options group 154

From Header to Footer 154

Adding an Auto Header and Footer 155

Creating a custom header or footer 157

Solving Page Break Problems 162

Letting Your Formulas All Hang Out 165

Chapter 5: The Ten Commandments of Excel 2013 167

Read More Show Less

Customer Reviews

Average Rating 3
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(1)

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
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted May 13, 2013

    J

    It is o.ok.

    1 out of 3 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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