Ch. 1 A Foundation for Developing Best Practice
|
- Understanding alternative ways to represent cells (R1C1 & A1 style)
- Absolute, relative and hybrid cell references and when to use each
- Excel functions
- Navigation techniques in large spreadsheets
- Defining user names (in rapid fire succession)
|
|
Ch. 2 Mastering Spreadsheet Construction Techniques
|
- Fundamental concepts of creating spreadsheets
- Building a spreadsheet: A step-by-step example
- Interpreting the results and fixing problems
- Making the spreadsheet look professional
- Issues and techniques for working with complex spreadsheets
|
|
Ch. 3 Your Handy Reference for Manipulating Data
|
- Tidying up your data
- Introducing Excel functions for data manipulation
- Sorting, block-sorting, and scaffolding
- Techniques for data surgery and data manipulation
|
|
Ch. 4 Compiling, Managing, and Viewing Your Data
|
- Moving & converting data from external sources to Excel for financial statement presentation
- Grouping data in PivotTables
- Charting PivotTable data
- Using Pivot Formulas
- Preparing data for PivotTables
- Web publishing of PivotTables
|
|
Ch. 5 Scaling the Peaks of Mt. Data
|
- Introducing the art of data slogging
- Importing data, pruning unneeded data and making it uniform
- Resolving ambiguities, handling violations & anomalies
- Enabling search capabilities for your source data
- Building increasingly complex summaries
- Providing graphical summaries with drill-down details
|
|
Ch. 6 Let the Data Speak for Itself:
Viewing and Presenting Data
|
- Automatic organizing and formatting of third-party data that's regularly
- Understanding filters, including new features in Excel 2003
- Replicating content with filtered data
- Using advanced filters
- Creating Presentation Tear Sheets
- Bullet-proofing your data entry
|
|
Ch. 7 Creating and Using Smart Data
|
- Using anchor cells and Conditional Formatting
- Using the Phantom Formatting Technique and Four Color tables
- Adjusting the background color when text spills into adjacent columns
- Using the override and un-erase technique
- Creating tables with self organized borders
|
|
Ch. 8 Analyzing Data
|
- Understanding Seasonal Data with the Data Viewer Tool
- Quantifying Uncertainty: Practical Techniques
- Obtaining more precision from the Excel goal-seeking facility
- Mastering Practical Techniques for working through optimization problems
- Interpreting the Answer, Sensitivity, and Limits Reports in the Excel Solver facility
|
|
Ch. 9 How Not to Get Stuck in the MUD
(Messed-Up Data)
|
- Working with ambiguous and incomplete data
- Working with data that is inconsistent and ambiguous
- Working with data that has to be restructured
- Using a data overpass
- Spotting data mirages
|
|
Ch. 10 Going for the Facelift:
Spreadsheet Makeovers
|
- Understanding important issues in spreadsheet makeovers
- Mapping the existing spreadsheet structure, identifying important computations, and tracing dependencies
- Identifying and validating correctness, making hidden assumptions explicit, and unearthing errors
- Improving and simplifiing spreadsheet formulas
- Special techniques in date arithmetic
|
|
Ch. 11 Spreadsheet Auditing:
Challenging the Numbers of Others
|
- Understanding the basics of structural analysis of Spreadsheets
- Watching out for common spreadsheet mistakes
- Testing your skills on in spotting common spreadsheet errors
- Recognizing and coping with the dangers of "off-spreadsheet analysis"
- Testing the reasonableness of spreadsheets
|
|
Ch. 12 Spreadsheet Portals, XML, and Web Services
|
- Introducing Spreadsheet Portals and Desktop Client Portals
- Communicating an XML request to a remote server
- Connecting XML to other parts of your spreadsheet application
- Solving the XML "staircase" problem in Excel 2003
- Setting up and using a Java based personal proxy server with Excel to harness some Web Services capabilities
|
|
Ch. 13 Assistive Technologies and Assistive Portals
|
- Shattering Preconceptions about economics of making electronic information
- Leveling the playing field for individuals with disabilities
- Understanding JAWS Concepts: a training-wheel approach
- Understanding how to build an accessible spreadsheet
- Making graphical components accessible to individuals with blindness
- Using the Assistive Portal tool to make a complex spreadsheet accessible
|
|