لطفا منتظر باشید ...
• 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 6. Hacking Formulas and Functions
Hacks #60-80
Section 60.
Add Descriptive Text to Your Formulas
Section 61.
Move Relative Formulas Without Changing References
Section 62.
Compare Two Excel Ranges
Section 63.
Fill All Blank Cells in a List
Section 64.
Make Your Formulas Increment by Rows When You Copy Across Columns
Section 65.
Convert Dates to Excel Formatted Dates
Section 66.
Sum or Counting Cells While Avoiding Error Values
Section 67.
Reduce the Impact of Volatile Functions on Recalculation
Section 68.
Count Only One Instance of Each Entry in a List
Section 69.
Sum Every Second, Third, or nth Row or Cell
Section 70.
Find the nth Occurrence of a Value
Section 71.
Make the Excel Subtotal Function Dynamic
Section 72.
Add Date Extensions
Section 73.
Convert Numbers with the Negative Sign on the Right to Excel Numbers
Section 74.
Display Negative Time Values
Section 75.
Use the VLOOKUP Function Across Multiple Tables
Section 76.
Show Total Time as Days, Hours, and Minutes
Section 77.
Determine the Number of Specified Days in Any Month
Section 78.
Construct Mega-Formulas
Section 79.
Hack Mega-Formulas that Reference Other Workbooks
Section 80.
Hack One of Excel's Database Functions to Take the Place of Many Functions
