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 create—data and formulas, with the occasional chart—so moving to more advanced levels of Excel usage seems 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 hacks—quick and dirty solutions to problems, or clever ways of doing things—were 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.
0 comments:
Post a Comment