Powerful Excel e-Books
Tips.Net provides a variety of ExcelTips e-books. Solve a pesky problem, learn a new skill, or enhance your existing knowledge. Tips.Net e-books provide something for everyone!
- ExcelTips: Times and Dates Learn how to use Excel effectively when working with times and dates. Great resource at a low price!
- ExcelTips: Serioius Sorting Take control of your data by putting it in the order you want. Powerful sorting techniques help you discover new ways to see your data.
- ExcelTips: Custom Formats Custom formats give you the greatest flexibility in how your data is presented. Discover what custom formats can do for you!
- Excel Graphics and Charts Dress your Excel data up by adding graphics and charts. Uncover the tools, tips, and guidance you need in this handy volume.
- More e-books>>
Shipping Info
If you order a product that requires shipping, please note that all Tips.Net shipping is done via US Mail. Shipments will be sent either First Class or Media Mail, as appropriate.
We try very hard to ship orders by the next business day after receipt. Most of the time we are successful, but not always.
Our goal is to keep shipping and handling costs as low as possible. The cost will vary, depending on the number of shippable items you order. For example, if you order a single CD item, the cost will be approximately $4.34. Each additional CD item in the same order will add approximately $0.65 to the shipping and handling costs. Thus, two CD items would be $4.99, three would be $5.64, etc.
If you have any questions about shipping or handling charges, please feel free to contact us at 801-607-2035 prior to placing your order.
ExcelTips: Serious Sorting
ExcelTips: Serious Sorting
includes over 50 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
- Sorting an Entire List
- Understanding Ascending and Descending Sorts
- Recognizing a Header Row when Sorting
- Sorting a Range of Cells
- Controlling Sorting Order
Sorting Challenges
- Sorting Letters and Numbers
- Fixing Odd Sorting Behavior
- Sorting Huge Lists
- Sorting by Five Columns
- Performing Complex Sorts
- Too Many Formats when Sorting
- Incomplete and Corrupt Sorting
- Sorting while Ignoring Leading Characters
- Sorting Data on Protected Worksheets
- Sorting Data Containing Merged Cells
Sorting Non-Traditional Items
- Non-standard Sorting
- Sorting with Graphics
- Sorting by Colors
- Sorting by Fill Color
- Sorting Files
- Use Filenames That Sort Properly
- Ordering Worksheets Based on a Cell Value
- Sorting or Filtering by Conditional Format Results
Working with Custom Sort Orders
- Creating a Sort Order
- Importing Custom Lists
- Sorting Dates by Month
Sorting Cookbook
- Sorting ZIP Codes
- Deleting Blank Columns
- Easily Adding Blank Rows
- Determining Sorting Criteria
- Selecting Random Names
- Playing with a Full Deck
| Description | CD | Download | |||
|---|---|---|---|---|---|
| ExcelTips: Serious Sorting | $24.99 |  |
$19.99 |  |
(1.0 MB) |
You can also order ExcelTips: Serious Sorting by calling our order line: 801-607-2035.