- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
Available for In-store Pickup
in 7 to 12 days
Other titles in the Visual Quick Tips series:
Excel 2010 Visual Quick Tipsby Paul Mcfedries
Synopses & Reviews
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.
Make Excel 2010 work for you with the invaluable quick tips in 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.
Learn How To:
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.
What Our Readers Are Saying
Other books you might like
Business » General