101 Excel 2013 Tips, Tricks & Timesavers

  • 3h 41m
  • John Walkenbach
  • John Wiley & Sons (US)
  • 2013

Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks.

  • Reveals ways to maximize the power of Excel to create robust applications
  • Draws on John Walkenbach's years of experience using Excel and writing more than 50 books
  • Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation
  • Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables

101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including the bestselling Excel Bible, Excel Formulas, and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at spreadsheetpage.com.

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
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Rating 4.1 of 14 users Rating 4.1 of 14 users (14)
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)