The Thought section is a list of topics suggested by visitors to the site. If you would like to suggest a future topic please drop us a line at contact@sumproduct.com.
| Title | Date | Description |
|---|---|---|
| A Debt to Repay | 04.08.2011 | How to model debt repayment calculations transparently (without using Add-In functions). |
| A Modicom of MOD | 15.08.2011 | When to use this divisive and what to be careful of... |
| Array of Light | 04.04.2010 | Providing an overview of array formulae in Excel. |
| Asking for a Date | 03.08.2011 | Dealing with dates for files used with both Excel 2003 and Excel 2007. |
| Automated File Names | 05.08.2011 | How to get the file name to appear in a spreadsheet automatically. |
| Concatenation | 03.08.2011 | Can you see the join? |
| Conditional Formatting | 04.04.2010 | How to change the appearance of a cell; comparing the new Excel 2007 features with earlier incarnations. |
| Consistent Formulae | 04.08.2011 | How to seek out inconsistencies consistently. |
| Creating a Timestamp | 05.08.2011 | Letting your date leave a mark on your spreadsheet. |
| Data Tables | 05.08.2011 | How to use one of Excel's built-in features to undertake sensitivity analysis in seconds. |
| Depreciation Appreciation | 19.03.2010 | How do you model the total depreciation charge for a given period? |
| File Style | 03.04.2010 | How to make the most of Excel's styles, in contrast to simple cell formats. |
| Forecasting Tips | 04.08.2011 | Trendy methods in Excel. |
| Hiding Formulae | 05.08.2011 | How to hide and protect formulae used in a spreadsheet. |
| Hyperlinking Chart Sheets | 04.04.2010 | You can't hyperlink to and from chart sheets in Excel. Or can you..? |
| INDEX MATCH | 03.04.2010 | Consideration of one of the most powerful combinations of functions for Excel modelling. |
| Interest Received | 28.03.2010 | How to calculate interest received on the average cash balance for the period. |
| Irreverent IRR | 03.08.2011 | Understanding some of the issues associated with the Internal Rate of Return (IRR) in Excel. |
| Keyboard Shortcuts | 03.04.2010 | One of the most comprehensive lists of Excel shortcuts available on the Internet. |
| Linking to PowerPoint | 03.08.2011 | Presenting Excel in a new light. |
| Locating Links | 03.04.2010 | How to locate and remove unintended links in spreadsheets. |
| Locating Links #2 | 05.08.2011 | More on this popular topic: how to generate a list of links in an Excel file using a transferable macro. |
| Model Construction Tips | 04.04.2010 | Advice on the do's and don't's of putting a financial model together. |
| Modelling Actual versus Budget | 15.08.2011 | How to keep track of actual data versus the original budgeted / forecast information. |
| Multiple Criteria | 04.04.2010 | How to deal with summarising data based upon multiple criteria. |
| Names | 15.08.2011 | Highlighting the pros and cons of using names in Excel. |
| Number Formatting | 04.04.2010 | Demystifies the #@?*ing syntax associated with number formatting. |
| Onset of OFFSET | 03.04.2010 | Explaining how useful the displacement function OFFSET can be for modellers. |
| Pivotal PivotTables | 04.04.2010 | How to use PivotTables to turn data into information. |
| Tables | 05.08.2011 | Summary of the new feature introduced in Excel 2007. |
| Tornado Charts | 05.08.2011 | A step-by-step guide on how to construct one of the most commonly used sensitivity charts. |
| Waterfall Charts | 19.04.2010 | How to create charts that depict key movements period on period. |