Loading
Store.Tips.Net Tips.Net Store

Excel 2013 Serious Sorting (Table of Contents)

Summary: Sorting data means that you organize it in whatever order you desire. Excel's sorting feature can be used in a variety of ways, depending on the data you are working with. This is the table of contents for Excel 2013 Serious Sorting.

Excel 2013 Serious Sorting (Table of Contents)

Excel 2013 Serious Sorting includes 70 information-packed pages that will help you master the sorting capabilities of Excel.
The following is the Table of Contents:

Introduction

  • A Word about Versions
  • Need More Tips?
  • Sharing this E-Book

Basic Sorting

  • Excel's Sorting Tools
  • Sorting an Entire List
  • Understanding Ascending and Descending Sorts
  • Recognizing a Header Row when Sorting
  • Differentiating a Header Row
  • Sorting a Range of Cells
  • Controlling Sorting Order
  • Sorting Columns Instead of Rows

Sorting Challenges

  • Sorting Letters and Numbers
  • Sorting Dates and Times
  • Fixing Odd Sorting Behavior
  • Sorting Huge Lists
  • Performing Complex Sorts
  • Too Many Formats when Sorting
  • Incomplete and Corrupt Sorting
  • Sorting while Ignoring Leading Characters
  • Ignoring Selected Words when Sorting
  • Sorting Data on Protected Worksheets
  • Sorting Data Containing Merged Cells
  • Can't Sort Imported Data
  • Incorrect Links after Sorting Hyperlinks

Sorting Non-Traditional Items

  • Non-standard Sorting
  • Sorting with Graphics
  • Sorting by Colors
  • Separating Cells Based on Text Color
  • Moving Cell Borders when Sorting
  • Sorting Files
  • Use Filenames that Sort Properly
  • Ordering Worksheets Based on a Cell Value
  • Sorting or Filtering by Conditional Format Results
  • Sorting Data in a PivotTable
  • Clearing Only Filtering Settings

Working with Custom Sort Orders

  • Understanding and Using Custom Sort Orders
  • Creating a Sort Order
  • Importing Custom Lists
  • Deleting Custom Lists
  • Sorting Dates by Month

Sorting Cookbook

  • Sorting Decimal Values
  • Sorting ZIP Codes
  • Deleting Blank Columns
  • Easily Adding Blank Rows
  • Getting Rid of Empty Rows after Importing
  • Getting Rid of All Rows Except the One for the Latest Date
  • Determining Sorting Criteria
  • Storing Sorting Criteria
  • Sorting for a Walking Tour
  • Selecting Random Names
  • Randomly Assigning Names to Items
  • Playing with a Full Deck
  • Determining Combinations to Make a Total
  • Automatically Sorting as You Enter Information

Description CD Download
Excel 2013 Serious Sorting Buy on CD
ISBN 978-1-61359-288-5 (70 pages)
$24.99
Buy Download
ISBN 978-1-61359-287-8 (1.1 MB)
$19.99
Excel 2010 Serious Sorting Buy on CD
ISBN 978-1-61359-286-1 (68 pages)
$24.99
Buy Download
ISBN 978-1-61359-285-4 (1.6 MB)
$19.99
Excel 2007 Serious Sorting Buy on CD
ISBN 978-1-61359-284-7 (68 pages)
$24.99
Buy Download
ISBN 978-1-61359-283-0 (1.6 MB)
$19.99
Excel Serious Sorting Ribbon Pack
 
Great deal! Three versions
(Excel 2007, 2010, and 2013)
for the price of two (you get one free).
Buy on CD
ISBN 978-1-61359-290-8 (206 pages)
$49.98
Buy Download
ISBN 978-1-61359-289-2 (4.2 MB)
$39.98

You can also order our Excel Serious Sorting titles by calling our order line: 307-200-0450.

 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.