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 Premium Twice the tips every week, great graphics, plus huge discounts on ExcelTips archives and e-books. Step up to a Premium subscription!
- ExcelTips: Filters and Filtering Start working with large amounts of data, and you'll find filters invaluable to your work. Here's how to use both types of filters provided by Excel.
- ExcelTips: Times and Dates Learn how to use Excel effectively when working with times and dates. Great resource at a low price!
- ExcelTips: The Macros The best of ExcelTips, with a macro focus. Learn the basics of macro programming and get a great macro "cookbook."
- 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: Custom Formats
ExcelTips: Custom Formats
includes over 50 information-packed pages that will help you discover and master the custom formatting capabilities of Excel.
The following is the Table of Contents:
Introduction
- A Word about Versions
- Need More Tips?
- Sharing this E-Book
Custom Formatting Basics
- Understanding Custom Formatting
- Understanding Number Formatting Codes
- Understanding Date and Time Formatting Codes
- Understanding Color and Conditional Formatting Codes
- Adding a Custom Format to those Offered by Excel
- Saving Custom Formats
- Creating Two-Line Custom Formats
Numeric Formatting
- Displaying Negative Percentages in Red
- Altering the Displayed Format of Numbers to the Nearest 100
- Formatting Currency
- Notation for Thousands and Millions
- Incrementing Numeric Portions of Serial Numbers
- Numbers in Base 12
Date and Time Formatting
- Unique Date Displays
- Entering Dates Without Separators
- Entering Large Time Values
- Macro for Month Name
- Using an Input Mask
Formatting Techniques and Ideas
- Easy Value Hiding
- Hiding Individual Cells
- Using a Custom Format to Add Dashes
- Partially Blocking Social Security Numbers
- Superscripts in Custom Formats
- Engineering Calculations
- Inserting a Radical Symbol
- Adjusting Cell Margins for More White Space
- Labeling X-Y Scatter Plots
| Description | CD | Download | |||
|---|---|---|---|---|---|
| ExcelTips: Custom Formats | $24.99 |  |
$19.99 |  |
(1.0 MB) |
You can also order ExcelTips: Custom Formats by calling our order line: 801-607-2035.