Excel 2010 Visual Quick Tips


Would you like to discover what's new in Excel 2010, find all the best ways to analyze and secure your data, and start saving time by using macros? Then this Visual Quick Tips book is for you. This book will increase your productivity by providing you with shortcuts, tricks, and tips to help you work smarter and faster.

Read More Show Less
... See more details below
Other sellers (Paperback)
  • All (16) from $1.99   
  • New (12) from $1.99   
  • Used (4) from $5.19   
Sending request ...


Would you like to discover what's new in Excel 2010, find all the best ways to analyze and secure your data, and start saving time by using macros? Then this Visual Quick Tips book is for you. This book will increase your productivity by providing you with shortcuts, tricks, and tips to help you work smarter and faster.

Read More Show Less

Product Details

  • ISBN-13: 9780470577769
  • Publisher: Wiley
  • Publication date: 6/28/2010
  • Edition number: 1
  • Pages: 304
  • Sales rank: 1,446,892
  • Product dimensions: 6.00 (w) x 9.00 (h) x 0.70 (d)

Meet the Author

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991 and he has more than 70 books to his credit. Paul’s books have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010; Excel PivotTables and PivotCharts Visual Blueprint, Second Edition; Teach Yourself VISUALLY Windows 7; and Teach Yourself VISUALLY Office 2008 for Mac. Paul is also the proprietor of Word Spy (www.wordspy.com and twitter. com/wordspy), a Web site that tracks new words and phrases as they enter the language. Paul invites you to drop by his personal Web site at www.mcfedries.com or to follow him on Twitter at twitter.com/paulmcf.

Read More Show Less

Table of Contents

Chapter 1 Making Excel More Efficient

Customize the Quick Access Toolbar 4

Customize the Ribbon 6

Export Ribbon Customizations to a File 10

Configure Excel to Use the Mouse Wheel for Zooming 12

Move in a Different Direction When You Press Enter 14

Automatically Insert a Decimal Point 16

Configure When Excel Warns You About Long Operations 18

Pin Excel to the Windows 7 Taskbar 20

Make a Workbook Faster by Saving it as Binary 22

Open a New Window for a Workbook 24

Allow Only Certain Values in a Cell 26

Apply Text or Formatting to Multiple Worksheets 28

Quickly Display the Office Clipboard 30

Use Dialog Box Controls to Input Data 32

Check for Accessibility Problems 36

Chapter 2 Making It Easier to Manage Workbooks

Increase the Number of Recent Documents 40

Open Workbooks Automatically at Startup 42

Create a Workspace of Workbooks 44

Specify a New Default File Location 46

Set the Default Font and Font Size for New Workbooks 48

Set the Default Number of Worksheets for New Workbooks 50

Repair a Corrupted Workbook File 52

Convert a Workbook to PDF File 54

Create a Workbook Template 56

Create a New Workbook from an Existing File 58

Compare Two Workbooks Side by Side 60

Check for Features Not Supported by Earlier Excel Versions 62

Chapter 3 Customizing Worksheet Presentation

Create Custom Numeric Formats 66

Create Custom Date and Time Formats 68

Set the Default Width for All Columns 70

Hide Columns and Rows 72

Create a Custom Fill List 74

Maximize Work Space by Turning Off Window Elements 76

Create a Custom Cell Style 78

Build a Custom Table Style 80

Create a Custom Color Scheme 82

Create a Custom Font Scheme 84

Save a Custom Workbook Theme 86

Build a Custom Header and Footer 88

Customize the Excel Status Bar 90

Minimize the Ribbon 91

Chapter 4 Getting More Out of Formulas

Paste a Formula's Result 94

Show Formulas Instead of Results 96

Use a Watch Window to Monitor a Cell Value 98

Use Absolute Cell References in a Formula 100

Create an Array Formula 102

Apply Range Names to Formulas 104

Create a Link to another Worksheet 106

Combine Two Ranges Arithmetically 108

Troubleshoot a Formula by Stepping Through Each Part 110

Skip Data Tables When Calculating Workbooks 112

Turn On Iterative Calculations 114

Display Text Rather than Error Values 116

Check for Formula Errors in Worksheet 118

Audit Formula to Locate Errors 120

Chapter 5 Analyzing Excel Data

Highlight Cells That Meet Some Criteria 124

Highlight the Top or Bottom Values in a Range 126

Analyze Cell Values with Data Bars 128

Analyze Cell Values with Color Scales 130

Analyze Cell Values with Icon Sets 132

Create a Custom Conditional Formatting Rule 134

Calculate Multiple Solutions to a Formula 136

Plug Multiple Input Values into a Formula 138

Calculate the Break-Even Point 142

Consolidate Data from Multiple Worksheets 144

Filter Table Data 148

Remove Duplicate Values from a Table 150

Create an Outline Automatically 152

Enable the Analysis ToolPak Add-In 154

Chapter 6 Analyzing Data with PivotTable

Build a PivotTable from an Excel Table 158

Create a PivotTable from External Data 160

Refresh PivotTable Data 164

Add Multiple Fields to the Row or Column Area 166

Add Multiple Fields to the Data Area 168

Move a Field to a Different Area 170

Apply a Report Filter 172

Apply a PivotTable Quick Style 174

Change the PivotTable Summary Calculation 176

Customize the PivotTable Field List 178

Create a PivotChart from a PivotTable 179

Chapter 7 Importing Data into Excel

Understanding External Data 182

Import Data from a Data Source 184

Import Data from an Access Table 186

Import Data from a Word Table 188

Import Data from a Text File 190

Import Data from a Web Page 194

Import Data from an XML File 196

Refresh Imported Data 198

Separate Cell Text into Columns 200

Chapter 8 Querying Data Sources

Understanding Microsoft Query 204

Define a Data Source 206

Start Microsoft Query 210

Tour the Microsoft Query Window 211

Add a Table to the Query 212

Add Fields to the Query 214

Filter the Records with Query Criteria 216

Sort the Query Records 218

Return the Query Results 220

Chapter 9 Protecting Excel Data

Open a Read-Only Version of a Workbook 224

Mark a Workbook as Final to Avoid Accidental Editing 226

Protect Workbooks by Shortening the AutoRecover Interval 228

Specify the Cells that Users Can Edit 230

Hide a Formula 232

Protect a Range with Password 234

Protect the Data in a Worksheet 236

Protect a Workbook's Windows and Structure 238

Restore a Previous Version of a Workbook 240

Hide a Worksheet 242

Track Workbook Changes 244

Chapter 10 Maximizing Excel Security and Privacy

Open a Workbook in Protected View 248

Block Dangerous Excel File Types 250

Set the Macro Security Level 252

Digitally Sign Your Excel Macros 254

Create a Trusted Location for Opening Files 256

Inspect a Workbook for Private Data 258

Assign a Password to a Workbook 260

Turn On Parental Control in Excel 262

Disable External Data Connections and Links 264

Apply a Digital Signature to a Workbook 266

Chapter 11 Learning VBA Basics

Record a Macro 270

Open the VBA Editor 272

Explore the Excel Object Model 274

Add a Macro to a Module 276

Run a Macro 278

Assign a Shortcut Key to a Macro 280

Assign a Macro to the Quick Access Toolbar 282

Assign a Macro to the Ribbon 284

Index 286

Read More Show Less

Customer Reviews

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

5 Star


4 Star


3 Star


2 Star


1 Star


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


  • - 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)