Arrays (7)- "I've never come across consultants with the level of knowledge and proficiency that Access Analytic staff have. The things they can make... Stephen Smith more »
- The complex spreadsheet models we developed were used by the bank to test new areas of functionality in the banks' lending applications.... Susan D Evans more »
- Testing and documentation of key business spreadsheets using Spreadsheet Professional "The services Access... Darren Gordon more »
Knowledge
Client Success Stories
Famous Quotes
- "Life is either a daring adventure or nothing." Helen Keller
- "The difference between the impossible and the possible lies in a person's determination." Tommy Lasorda
- "Life is pretty simple: You do some stuff. Most fails. Some works. You do more of what works. If it works big, others quickly copy it. Then you do something else. The trick is the doing something else." Tom Peters
Subscribe Newsletter
Knowledge
Featured White Papers |
|
Financial Modelling Best Practice Guidelines
Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy. Is This The Right Version? Version Control, like an insurance policy, is an expense (of time and effort) that hopefully is never required. But what's the best way to control all the versions that sometimes multiply out of control? | |
Featured Research Articles
Stop zeroes displaying on line ChartsI have a line chart which has all the months of the year displayed. Each month is linked to a data cell. This means that future months display zero values. The line chart drops down to zero for these future months. Instead of having to change the chart range each month I want to stop the chart plotting the zero values for the future months. Is this possible? You can use Excel's feature of not plotting error values on charts to stop it displaying the zero values. You need to modify the formula to display #N/A if the value is zero ... Auto OutlineAutomated grouping If you use the Group feature frequently in your sheets, then consider using the Auto Outline feature. This automatically adds the Grouping buttons based on the SUM and SUBTOTAL formulas in your sheet ... Paste LinkingI use Paste Link frequently. Is there a quick way to access it instead of going through Paste Special each time? Unfortunately Paste Link doesn't have a toolbar icon. However, when you drag a selection with the right mouse button there is a "Link here" option, which is the same as Paste Link ... Lessons from EuropeHow the Debt Crisis can Improve Your Management Reporting & Modelling Lessons from Europe: How the Debt Crisis can Improve Your Management Reporting You can't have missed events in Europe this year as the Eurozone countries grappled with an unprecedented sovereign debt crisis ... Multi-line VLOOKUPI have a data base that has five separate rows for each item. I can use VLOOKUP to find the first row's details, but how do I access the details in the other four lines? This is an ideal situation to use the INDEX / MATCH function combination. These two functions work well together and allow you to do flexible lookups ... |
Share This:
