08 6210 8500
Pay my invoice
Find Unique Entries
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Easy Group/Outline Of Rows And Columns
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Removing Macros
Removing Macros Q: I have an Excel file and for some reason, every time I open it, it asks me if it's OK to run macros ... but there aren't any! How do I stop this annoying message from appearing? By Jeff Robson This message means that somewhere in your file there must be [...]
Getting Great Margins
Getting Great Margins Print Margins By Jeff Robson You have a beautiful spreadsheet that really needs to be on one page, but it just doesn't quite fit properly. You just need an extra 0.5cm (or three sixteenths of an inch if you're with the Imperial forces) to make your page complete and allow people [...]
SUMIF – More Than One Condition
SUMIF - more than one condition Q: I know how to use SUMIF with one matching criteria, but how can I use more than one? By Jeff Robson Short Answer: you can't. SUMIF only accepts one criteria. Use the SUMIFS formula instead as it allows this (Excel 2007+) Long Answer: you can still use [...]
Changing Signs Quickly
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Rounding Via Formats
Rounding via formats Custom formats By Jeff Robson When you're doing your budgets or annual reports, you often need to switch easily between dollars and cents, whole dollars, and thousands. Switching between dollars and cents, and whole dollars is easy: just use Excel's built in formats (either the "$" or "," buttons) and increase [...]
Grouping Columns And Rows
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Valuing Assets & Cash Flows
Valuing Assets & Cash Flows When I do a company valuation, I've heard that I should model the value based on cash flows then add the asset values to get the total value. Is this correct? By Jeff Robson Valuation Models There are two main types of valuation models: asset-based and flow based. [...]
Alternative To IF
Alternative to IF I use an IF function to compare two values to confirm they balance and put a 1 if they don't balance and a 0 if they do balance. Something like =IF(A1=B1,0,1). I then SUM the 1's to see how many don't balance. Is there an easier way? By Neale Blackwood In [...]
Paste Hyperlink
Paste Hyperlink Quick way to create a hyperlink By Neale Blackwood Hyperlinks (as on the internet) are a useful way to navigate around large spreadsheets. Using Ctrl + k to create a hyperlink take a few clicks to link to a specific cell in a specific sheet. It can be easier to copy the cell you want to [...]
Last Used Cell In A Row
Last Used Cell in a Row Find the reference of the last used cell in a row By Neale Blackwood One of the articles on our site allows you to find the cell reference of the last used cell in a column. You can see it below in the related articles. One of our [...]
