Download PDF Excel Best Practices For Business by Loren Abdulezer

Sinopsis

Often, what people are taught about spreadsheets is the lowest common denominator, just enough to squeak by. These skills can be readily acquired through corporate and continuing education courses. Most people who regularly work with spreadsheets tend to adopt, learn and share common practices—which are not always synonymous with best practices. My goal in writing this book is to get you to elevate the bar, to go beyond the common denominator so that your ability to manipulate spreadsheets is on par with your natural abilities. Spreadsheets are intimidating, so many of us are afraid to go beyond what others have taught us. I
would like to reconnect your good business instincts with your ability to handle spreadsheets, and I have no doubt that you’ll be able to achieve and exceed your expectations.

This chapter introduces you to the various ways you can put to use in your formulas absolute, relative and hybrid expressions. You will also be shown the practical benefits of using one approach over another.

Also, you will find out that the built-in Excel functions are not only about performing arithmetic and mathematical calculations. You will see that Excel introduces specific functions of a spatial nature. Other Excel functions have a temporal nature to them. As I go through this list, it should not surprise you that some Excel functions perform computations specifying precision and fuzziness (and this has nothing to do with “Fuzzy Math”). Did you think I was going to end there? Would it interest you to know that there are Excel functions that can edit text? I’m not talking about functionality, as in features of the Excel product; I am specifically talking about Excel functions that utilize these features in their computations.

Content

1. A Foundation for Developing Best Practices
2. Mastering Spreadsheet Construction Techniques
3. Your Handy Reference for Manipulating Data
4. Compiling, Managing, and Viewing Your Data
5. Scaling the Peaks of Mt. Data
6. Let the Data Speak for Itself: Viewing and Presenting Data
7. Creating and Using Smart Data
8. Analyzing Data
9. How Not to Get Stuck in the MUD (Messed-Up Data)
10. Special Topics: Getting the Numbers Right
11. Going for the Facelift: Spreadsheet Makeovers
12. Spreadsheet Auditing: Challenging the Numbers of Others
13. Spreadsheet Portals, XML, and Web Services
14. Assistive Technologies and Assistive Portals

Click here to download