Insight for business users of Microsoft Excel
Posts tagged as:
Bad spreadsheet designs can hurt your career. I’ve seen it happen.
So in Don’t Let Bad Spreadsheet Design Hurt Your Career, Part 1, I began to discuss problems in a workbook sent to me by an Excel user I call Randy. I hope this will help you to find and fix similar problems in your own workbooks.
Randy’s workbook has more than a dozen worksheets, [click to continue...]
{ Comments on this entry are closed }
In Excel Bug Deletes Some External Range Names Automatically I discussed a bug that exists in Excel 2007 and in the beta of Excel 2010. Here’s the summary of that entry:
When Excel range names in a report workbook reference sheet-scoped names in a database workbook, if the report workbook is opened first and the database workbook is opened second, Excel deletes all sheet-scoped names that the report workbook references in the database workbook.
This advice doesn’t mean much if you don’t use sheet-scoped names. So let’s talk about the scope of range names by first talking about print ranges… [click to continue...]
{ Comments on this entry are closed }
Just after I finished How to Report and Analyze Variable-Length Databases in Excel a visitor asked how to use formulas to show subtotals in a sorted list. From her description, she wants to do something like this: [click to continue...]
{ Comments on this entry are closed }
Get smart with the Thesis WordPress Theme from DIYthemes.
