Excel 2010 Visual Quick Tips
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.
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.