Excel 2010 Visual Quick Tips

Excel 2010 Visual Quick Tips

by Paul McFedries



Temporarily Out of Stock Online

Eligible for FREE SHIPPING


Excel 2010 Visual Quick Tips by Paul McFedries

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.

Product Details

ISBN-13: 9780470577769
Publisher: Wiley
Publication date: 06/28/2010
Pages: 304
Product dimensions: 6.00(w) x 9.00(h) x 0.70(d)

About 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 an Excerpt

Click to read or download

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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews