Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | December 5, 2014

    William Gibson: IMG William Gibson: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer
Qualifying orders ship free.
$19.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Microsoft Windows- Applications
2 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2010 Visual Quick Tips

by

Excel 2010 Visual Quick Tips Cover

 

Synopses & Reviews

Publisher Comments:

Work smarter and faster in Excel 2010 with this quick, practical guide!

Want quick answers to your Excel 2010 questions? This handy guide breaks down big tasks into bite-sized how-tos that quickly show you how to accomplish what you want to do. Full-color screenshots and numbered steps clearly explain dozens of features and functions-while shortcuts, tips, and tricks help you save time and boost productivity. There's no fluff-these nuggets are pure gold Excel essentials. And the book's handy 6" x 9" size makes it even easier for you to find what you need.

  • Demystifies the 2010 version of Excel, the world's leading spreadsheet application that is part of Microsoft Office 2010
  • Walks you through dozens of new features and functions
  • Helps you migrate from older versions of Excel and ramp up to new Excel functionality in no time
  • Uses straightforward descriptions and explanations, full-color screenshots, and easy-to-follow numbered steps to help you glean what you need, fast
  • Boosts your productivity with shortcuts, tips, and tricks that help you work smarter

Make Excel 2010 work for you with the invaluable quick tips in Excel 2010 Visual Quick Tips.

Synopsis:

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.
  • Straightforward task descriptions

  • Succinct explanations

  • Full-color screen shots

  • Numbered steps

Learn How To:

  • Use Excel Formulas more effectively

  • Open workbooks automatically at Startup

  • Import data from XML files or Web pages

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.

Table of Contents

Chapter 1: Making Excel More Effecient.

Customize the Quick Access Toolbar.

Customize the Ribbon.

Export Ribbon Customizations to a File.

Configure Excel to Use the Mouse Wheel for Zooming.

Move in a Different Direction When You Press Enter.

Automatically Insert a Decimal Point.

Configure When Excel Warns You About Long Operations.

Pin Excel to the Windows 7 Taskbar.

Make a Workbook Faster by Saving it as Binary.

Open a New Window for a Workbook.

Allow Only Certain Values in a Cell.

Apply Text or Formatting to Multiple Worksheets.

Quickly Display the Office Clipboard.

Use Dialog Box Controls to Input Data.

Check for Accessibility Problems.

Chapter 2: Making It Easier to Manage Workbooks.

Increase the Number of Recent Documents.

Open Workbooks Automatically at Startup.

Create a Workspace of Workbooks.

Specify a New Default File Location.

Set the Default Font and Font Size for New Workbooks.

Set the Default Number of Worksheets for New Workbooks.

Repair a Corrupted Workbook File.

Convert a Workbook to a PDF File.

Create a Workbook Template.

Create a New Workbook from an Existing File.

Compare Two Workbooks Side by Side.

Check for Features Not Supported by Earlier Excel Versions.

Chapter 3: Customizing Worksheet Presentation.

Create Custom Numeric Formats.

Create Custom Date and Time Formats.

Set the Default Width for All Columns.

Hide Columns and Rows.

Create a Custom Fill List.

Maximize Work Space by Turning Off Window Elements.

Create a Custom Cell Style.

Build a Custom Table Style.

Create a Custom Color Scheme.

Create a Custom Font Scheme.

Save a Custom Workbook Theme.

Build a Custom Header and Footer.

Customize the Excel Status Bar.

Minimize the Ribbon.

Chapter 4: Getting More Out of Formulas.

Paste a Formula's Result.

Show Formulas Instead of Results.

Use a Watch Window to Monitor a Cell Value.

Use Absolute Cell References in a Formula.

Create an Array Formula.

Apply Range Names to Formulas.

Create a Link to Another Worksheet.

Combine Two Ranges Arithmetically.

Troubleshoot a Formula by Stepping Through Each Part.

Skip Data Tables When Calculating Workbooks.

Turn On Iterative Calculations.

Display Text Rather than Error Values.

Check for Formula Errors in a Worksheet.

Audit a Formula to Locate Errors.

Chapter 5: Analyzing Excel Data.

Highlight Cells That Meet Some Criteria.

Highlight the Top or Bottom Values in a Range.

Analyze Cell Values with Data Bars.

Analyze Cell Values with Color Scales.

Analyze Cell Values with Icon Sets.

Create a Custom Conditional Formatting Rule.

Calculate Multiple Solutions to a Formula.

Plug Multiple Input Values into a Formula.

Calculate the Break-Even Point.

Consolidate Data from Multiple Worksheets.

Filter Table Data.

Remove Duplicate Values from a Table.

Create an Outline Automatically.

Enable the Analysis ToolPak Add-In.

Chapter 6: Analyzing Data with PivotTables.

Build a PivotTable from an Excel Table.

Create a PivotTable from External Data.

Refresh PivotTable Data.

Add Multiple Fields to the Row or Column Area.

Add Multiple Fields to the Data Area.

Move a Field to a Different Area.

Apply a Report Filter.

Apply a PivotTable Quick Style.

Change the PivotTable Summary Calculation.

Customize the PivotTable Field List.

Create a PivotChart from a PivotTable.

Chapter 7: Importing Data into Excel.

Understanding External Data.

Import Data from a Data Source.

Import Data from an Access Table.

Import Data from a Word Table.

Import Data from a Text File.

Import Data from a Web Page.

Import Data from an XML File.

Refresh Imported Data.

Separate Cell Text into Columns.

Chapter 8: Querying Data Sources.

Understanding Microsoft Query.

Define a Data Source.

Start Microsoft Query.

Tour the Microsoft Query Window.

Add a Table to the Query.

Add Fields to the Query.

Filter the Records with Query Criteria.

Sort the Query Records.

Return the Query Results.

Chapter 9: Protecting Excel Data.

Open a Read-Only Version of a Workbook.

Mark a Workbook as Final to Avoid Accidental Editing.

Protect Workbooks by Shortening the AutoRecover Interval.

Specify the Cells that Users Can Edit.

Hide a Formula.

Protect a Range with a Password.

Protect the Data in a Worksheet.

Protect a Workbook’s Windows and Structure.

Restore a Previous Version of a Workbook.

Hide a Worksheet.

Track Workbook Changes.

Chapter 10: Maximizing Excel Security and Privacy.

Open a Workbook in Protected View.

Block Dangerous Excel File Types.

Set the Macro Security Level.

Digitally Sign Your Excel Macros.

Create a Trusted Location for Opening Files.

Inspect a Workbook for Private Data.

Assign a Password to a Workbook.

Turn On Parental Control in Excel.

Disable External Data Connections and Links.

Apply a Digital Signature to a Workbook.

Chapter 11: Learning VBA Basics.

Record a Macro.

Open the VBA Editor.

Explore the Excel Object Model.

Add a Macro to a Module.

Run a Macro.

Assign a Shortcut Key to a Macro.

Assign a Macro to the Quick Access Toolbar.

Assign a Macro to the Ribbon.

Index.

Product Details

ISBN:
9780470577769
Author:
Mcfedries, Paul
Publisher:
Visual
Author:
McFedries, Paul
Author:
McFedr
Author:
ies, Paul
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Microsoft Excel
Subject:
Books on Excel, guide to Excel 2010, guide to Excel, how to use Excel, how to use Excel 2010, instructions on Excel 2010, Excel 2010, Excel PivotTables, Microsoft Office 2010, how to use spreadsheets, quick tips on Excel, excel tutorials
Subject:
Books on Excel, guide to Excel 2010, guide to Excel, how to use Excel, how to use Excel 2010, instructions on Exc
Subject:
el 2010, Excel 2010, Excel PivotTables, Microsoft Office 2010, how to use spreadsheets, quick tips on Excel, excel tutorials
Subject:
Medicine
Subject:
icrosoft Excel
Copyright:
Publication Date:
20100406
Binding:
TRADE PAPER
Language:
English
Pages:
304
Dimensions:
9.00x6.00x.50 in. 1.20 lbs.

Other books you might like

  1. Story of My Life (Vintage... Used Trade Paper $4.50
  2. Not for Profit: Why Democracy Needs... Used Hardcover $12.00
  3. Yves Saint Laurent New Hardcover $65.00
  4. Libertarianism, from A to Z Used Trade Paper $10.95
  5. The Ghosts of Martyrs Square: An... Used Hardcover $13.46

Related Subjects

Business » General
Business » Investing
Business » Management
Business » Writing
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Humanities » Philosophy » General
Science and Mathematics » Chemistry » Chemical Engineering

Excel 2010 Visual Quick Tips New Trade Paper
0 stars - 0 reviews
$19.99 In Stock
Product details 304 pages Visual - English 9780470577769 Reviews:
"Synopsis" by , 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.
  • Straightforward task descriptions

  • Succinct explanations

  • Full-color screen shots

  • Numbered steps

Learn How To:

  • Use Excel Formulas more effectively

  • Open workbooks automatically at Startup

  • Import data from XML files or Web pages

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.