Teach Yourself VISUALLY Excel 2013 [NOOK Book]

Overview

Are you a visual learner? Do you prefer instructions that show you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 160 Excel 2013 tasks. Each task-based spread ...

See more details below
Teach Yourself VISUALLY Excel 2013

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$16.49
BN.com price
(Save 45%)$29.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Are you a visual learner? Do you prefer instructions that show you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 160 Excel 2013 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 2013 in no time.

You'll learn to:

  • Enter text or numbers into a cell
  • Work with ranges and range names
  • Build formulas and add functions
  • Format and print workbooks
  • Visualize data with charts

Designed for visual learners

  • Two-page lessons break big topics into bite-sized modules
  • Succinct explanations walk you through step by step
  • Full-color screen shots demonstrate each task
  • Helpful sidebars offer practical tips and tricks
Read More Show Less

Product Details

  • ISBN-13: 9781118526675
  • Publisher: Wiley
  • Publication date: 1/28/2013
  • Series: Teach Yourself VISUALLY (Tech)
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 352
  • Sales rank: 664,317
  • File size: 43 MB
  • Note: This product may take a few minutes to download.

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

Paste a List of Range Names 80

Chapter 5 Formatting Excel Ranges

Change the Font and Font Size 84

Apply Font Effects 86

Change the Font Color 88

Align Text Within a Cell 90

Center Text Across Multiple Columns 92

Rotate Text Within a Cell 94

Add a Background Color to a Range 96

Apply a Number Format 98

Change the Number of Decimal Places Displayed 100

Apply an AutoFormat to a Range 102

Apply a Conditional Format to a Range 104

Apply a Style to a Range 106

Change the Column Width 108

Change the Row Height 110

Wrap Text Within a Cell 112

Add Borders to a Range 114

Copy Formatting from One Cell to Another 116

Chapter 6 Building Formulas

Understanding Excel Formulas 120

Build a Formula 122

Understanding Excel Functions 124

Add a Function to a Formula 126

Add a Row or Column of Numbers 128

Build an AutoSum Formula 130

Add a Range Name to a Formula 132

Reference Another Worksheet Range in a Formula 134

Move or Copy a Formula 136

Switch to Absolute Cell References 138

Hide the Formula Bar or Ribbon 140

Troubleshoot Formula Errors 142

Chapter 7 Manipulating Worksheets

Navigate a Worksheet 146

Rename a Worksheet 147

Create a New Worksheet 148

Move a Worksheet 150

Copy a Worksheet 152

Delete a Worksheet 154

Change the Gridline Color 156

Toggle Worksheet Gridlines On and Off 158

Toggle Worksheet Headings On and Off 159

Set the Worksheet Tab Color 160

Set the Worksheet Background 162

Zoom In on or Out of a Worksheet 164

Split a Worksheet into Two Panes 166

Hide and Unhide a Worksheet 168

Chapter 8 Dealing with Workbooks

Create a New Blank Workbook 172

Create a New Workbook from a Template 174

Save a Workbook 176

Open a Workbook 177

Arrange Workbook Windows 178

Find Text in a Workbook 180

Replace Text in a Workbook 182

Check Spelling and Grammar 184

Close a Workbook 186

Chapter 9 Formatting Workbooks

Modify the Workbook Colors 190

Set the Workbook Fonts 192

Choose Workbook Effects 194

Apply a Workbook Theme 196

Add a Workbook Header 198

Add a Workbook Footer 200

Chapter 10 Printing Workbooks

Adjust the Workbook Margins 204

Change the Page Orientation 206

Insert a Page Break 207

Choose a Paper Size 208

Set the Print Area 210

Configure Titles to Print on Each Page 212

Preview the Printout 214

Print a Workbook 216

Chapter 11 Working with Tables

Understanding Tables 220

Get to Know Table Features 221

Convert a Range to a Table 222

Select Table Data 224

Insert a Table Row 226

Insert a Table Column 227

Delete a Table Row 228

Delete a Table Column 229

Add a Column Subtotal 230

Convert a Table to a Range 232

Apply a Table Style 233

Build a Custom Table Style 234

Create a PivotTable 236

Chapter 12 Analyzing Data

Sort a Range or Table 240

Filter a Range or Table 242

Set Data Validation Rules 244

Create a Data Table 246

Summarize Data with Subtotals 248

Group Related Data 250

Analyze Data with Goal Seek 252

Analyze Data with Scenarios 254

Remove Duplicate Values from a Range or Table 258

Load the Excel Analysis ToolPak 260

Chapter 13 Visualizing Data with Charts

Examine Chart Elements 264

Understanding Chart Types 265

Create a Chart 266

Create a Recommended Chart 268

Add Chart Titles 270

Add Data Labels 271

Position the Chart Legend 272

Display Chart Gridlines 273

Display a Data Table 274

Change the Chart Layout and Style 275

Select a Different Chart Type 276

Change the Chart Source Data 278

Move or Resize a Chart 280

Add a Sparkline to a Cell .282

Chapter 14 Adding Worksheet Graphics

Draw a Shape 286

Insert a Clip Art Image 288

Insert a Photo 290

Insert a WordArt Image 292

Insert a SmartArt Graphic 294

Move or Resize a Graphic 296

Crop a Picture 298

Format a Picture 300

Chapter 15 Collaborating with Others

Add a Comment to a Cell 304

Protect a Worksheet’s Data 306

Protect a Workbook’s Structure 308

Share a Workbook with Other Users 310

Track Workbook Changes 312

Accept or Reject Workbook Changes 314

Save a Workbook to Your SkyDrive 316

Send a Workbook as an E-Mail Attachment 318

Save Excel Data as a Web Page 320

Make a Workbook Compatible with Earlier Versions of Excel 322

Mark Up a Worksheet with a Digital Pen 324

Collaborate on a Workbook Online 326

Chapter 15 Collaborating with Others

Index 328

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)