Excel Hacks Ebook [Electronic resources] نسخه متنی

Why Excel Hacks?

Although it's possible to accomplish an enormous
amount of work using a relatively simple subset of
Excel's capabilities, the software offers a lot of
powerful techniques that can leapfrog your work beyond the ordinary
without requiring that you spend years using and studying Excel.
However, most people focus on the content they createdata and
formulas, with the occasional chartso moving to these more
advanced levels of Excel usage looks difficult.

There are lots of ways to take advantage of Excel's
capabilities to greatly extend your ability to create great
spreadsheets, but that don't require years of study.
These tools, or hacksquick and dirty
solutions to problems, or clever ways of doing thingswere
created by Excel users looking for simple solutions to complex
issues. The hacks in this book are designed to show you
what's possible and how to make them work
immediately.

You can benefit from these hacks in two important ways. First, you
can use the hacks directly as you build and improve your
spreadsheets. Second, by studying the hacks and possibly learning a
little Visual Basic for Applications (VBA) code, you can customize
the hacks to meet your needs precisely.