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
- "You want to be greedy when others are fearful, and you want to be fearful when others are greedy." Warren Buffett
- "Let no feeling of discouragement prey upon you, and in the end you are sure to succeed." Abraham Lincoln
- "We are what and where we are because we have first imagined it." Donald Curtis
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
Shift key and the toolbarReduce the number of toolbar icons The Shift key has many uses in Excel, not just changing lower case to upper case. If you hold the Shift key down and click some toolbar icons, Excel will do the opposite of what the icon says ... Phantom LinksFinding phantom links Have you ever opened an Excel file and had the question come up - Do you want to update links? You say - there shouldn't be any links to other sheets in the workbook ... Copying visible cells onlyVisible cells only If you copy a range that has hidden rows or hidden columns and then paste it, you will find that Excel pastes even the hidden values ... Thousands formatDisplay values as thousands If you need to display numbers as thousands in a report you don't need to divide all the numbers by 1000, you can apply a Custom format to the cells and have Excel display the values as thousands ... Multi-criteria SUMIFI use SUMIF to sum a range based on one condition. Is there a way to sum a range based on two or more conditions? One way is to use SUMPRODUCT. The following formula will sum the range C1:C10 based on the contents of A1:A10 and B1:B10 ... |
Share This:
