لطفا منتظر باشید ...
• Table of Contents• Reviews• Reader Reviews• Errata• AcademicExcel HacksBy
David Hawley, Raina HawleyPublisher: O''ReillyPub Date: March 2004ISBN: 0-596-00625-XPages: 304The tips and tools in Excel Hacks
include little known "backdoor" adjustments for everything
from reducing workbook and worksheet frustration to hacking
built-in features such as pivot tables, charts, formulas and
functions, and even the macro language. This resourceful,
roll-up-your-sleeves guide shows you new ways to make Excel
do things--from data analysis to worksheet management to
import/export--that you never thought possible.
Excel Hacks increases productivity with
Excel and gives you hours of "hacking" enjoyment along the
way.
Chapter 2. Hacking Excel's Built-in Features
Hacks #16-38
Section 16.
Validate Data Based on a List on Another Worksheet
Section 17.
Control Conditional Formatting with Checkboxes
Section 18.
Identify Formulas with Conditional Formatting
Section 19.
Count or Sum Cells That Meet Conditional Formatting Criteria
Section 20.
Highlight Every Other Row or Column
Section 21.
Create 3D Effects in Tables or Cells
Section 22.
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Section 23.
Support Multiple Lists in a ComboBox
Section 24.
Create Validation Lists That Change Based on a Selection from Another List
Section 25.
Force Data Validation to Reference a List on Another Worksheet
Section 26.
Use Replace... to Remove Unwanted Characters
Section 27.
Convert Text Numbers to Real Numbers
Section 28.
Customize Cell Comments
Section 29.
Sort by More Than Three Columns
Section 30.
Random Sorting
Section 31.
Manipulate Data with the Advanced Filter
Section 32.
Create Custom Number Formats
Section 33.
Add More Levels of Undo to Excel for Windows
Section 34.
Create Custom Lists
Section 35.
Boldface Excel Subtotals
Section 36.
Convert Excel Formulas and Functions to Values
Section 37.
Automatically Add Data to a Validation List
Section 38.
Hack Excel's Date and Time Features
