Excel Best Practices for Business
Covers Excel 2003, 2002, and 2000
Chapter One
A Foundation for
Developing Best Practices
IN THIS CHAPTER
* Understanding alternative ways to represent cells (R1C1 notation style
compared to the traditional A1 style)
* Alternative approaches to computing numbers
* Getting a firm grounding on absolute, relative and hybrid cell references
and when to use each
* Specifying cell ranges and incorporating those within functions such
as SUM
* Understanding rapid and efficient navigation techniques in large
spreadsheets
* Defining user names (in rapid fire succession)
This chapter is intended to arm you with the foundation for best practices including
basic components and spreadsheet functions you need to know. The chapter begins
with a discussion of important concepts and spreadsheet functions that you will be
working with regularly and presents the best way to use these. Included are the
gotchas, the tips, cautionary tales, and revelations that uncover new avenues for
developing your spreadsheets.
Some important and useful Excel functions are introduced, but focus is on their
usag ... read full excerpt from Excel Best Practices for Business ebook