لطفا منتظر باشید ...
• 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.
Hacks #60-80
Formulas and functions provide the logic that powers spreadsheets.
Managing programming logic is always a challenge, but keeping track
of programming logic across multiple cells, sheets, and workbooks can
be particularly difficult, especially as spreadsheets grow and are
reused. What's more, the formula and function
capabilities built into Excel might not always be what you want,
further complicating the situation. Fortunately, there are a lot of
ways you can keep your formulas and functions sane.
