101 Excel 2013 Tips, Tricks & Timesavers

In this Book

• Introduction
• Changing the Look of Excel
• Customizing the Quick Access Toolbar
• Customizing the Ribbon
• Understanding Protected View
• Understanding AutoRecover
• Using a Workbook in a Browser
• Saving to a Read-Only Format
• Generating a List of Filenames
• Generating a List of Sheet Names
• Using Document Themes
• Understanding Excel Compatibility Issues
• Where to Change Printer Settings
• Working with Merged Cells
• Indenting Cell Contents
• Using Named Styles
• Creating Custom Number Formats
• Using Custom Number Formats to Scale Values
• Creating a Bulleted List
• Shading Alternate Rows Using Conditional Formatting
• Formatting Individual Characters in a Cell
• Using the Format Painter
• Inserting a Watermark
• Showing Text and a Value in a Cell
• Avoiding Font Substitution for Small Point Sizes
• Updating Old Fonts
• Resizing the Formula Bar
• Monitoring Formula Cells from Any Location
• Learning Some AutoSum Tricks
• Knowing When to Use Absolute and Mixed References
• Avoiding Error Displays in Formulas
• Creating Worksheet-Level Names
• Using Named Constants
• Sending Personalized E-Mail from Excel
• Looking Up an Exact Value
• Performing a Two-Way Lookup
• Performing a Two-Column Lookup
• Calculating Holidays
• Calculating a Person's Age
• Working with Pre-1900 Dates
• Displaying a Live Calendar in a Range
• Returning the Last Nonblank Cell in a Column or Row
• Various Methods of Rounding Numbers
• Converting Between Measurement Systems
• Counting Nonduplicated Entries in a Range
• Using the AGGREGATE Function
• Making an Exact Copy of a Range of Formulas
• Using the Background Error-Checking Features
• Using the Inquire Add-In
• Hiding and Locking Your Formulas
• Using the INDIRECT Function
• Formula Editing in Dialog Boxes
• Converting a Vertical Range to a Table
• Selecting Cells Efficiently
• Automatically Filling a Range with a Series
• Fixing Trailing Minus Signs
• Restricting Cursor Movement to Input Cells
• Transforming Data with and Without Using Formulas
• Creating a Drop-Down List in a Cell
• Comparing Two Ranges by Using Conditional Formatting
• Finding Duplicates by Using Conditional Formatting
• Working with Credit Card Numbers
• Identifying Excess Spaces
• Transposing a Range
• Using Flash Fill to Extract Data
• Using Flash Fill to Combine Data
• Inserting Stock Information
• Getting Data from a Web Page
• Importing a Text File into a Worksheet Range
• Using the Quick Analysis Feature
• Filling the Gaps in a Report
• Performing Inexact Searches
• Proofing Your Data with Audio
• Getting Data from a PDF File
• Understanding Tables
• Using Formulas with a Table
• Numbering Table Rows Automatically
• Identifying Data Appropriate for a Pivot Table
• Using a Pivot Table Instead of Formulas
• Controlling References to Cells Within a Pivot Table
• Creating a Quick Frequency Tabulation
• Grouping Items by Date in a Pivot Table
• Creating Pivot Tables with Multiple Groupings
• Using Pivot Table Slicers and Timelines
• Understanding Recommended Charts
• Customizing Charts
• Making Charts the Same Size
• Creating a Chart Template
• Creating a Combination Chart
• Handling Missing Data in a Chart
• Using High-Low Lines in a Chart
• Using Multi-Level Category Labels
• Linking Chart Text to Cells
• Freezing a Chart
• Creating a Chart Directly in a Range
• Creating Minimalistic Charts
• Applying Chart Data Labels from a Range
• Grouping Charts and Other Objects
• Taking Pictures of Ranges
• Changing the Look of Cell Comments
• Enhancing Images
• Saving Shapes, Charts, and Ranges as Images
• Discovering Some Useful Shortcut Keys
• Resetting the Used Area of a Worksheet
• Hiding Columns or Rows
• Hiding Cell Contents
• Limiting the Usable Area in a Worksheet
• Using an Alternative to Cell Comments
• Making a Worksheet Very Hidden
• Moving the Cell Pointer After Entering Data
• Keeping Titles in View
• Working with Fractions
• Controlling Automatic Hyperlinks
• Controlling the Office Clipboard
• Displaying Times That Exceed 24 Hours
• Adding a Frame to a Range
• Dealing with Gridlines, Borders, and Underlines
• Seeing All Characters in a Font
• Annotating a Formula Without Using a Comment
• Displaying and Printing Formulas
• Creating a List of Names
• Rounding Time Values
• Converting Temperatures
• Calculating Roots
• Calculating a Remainder
• Creating Sparkline Graphics
• Using Images as Line Chart Markers
• Randomizing a List
• Displaying a Workbook's Full Path
• Closing All Workbooks
• Copying Page Setup Settings Across Sheets
• Printing Cell Comments