Category Archives: Uncategorized

INDIRECT – Excel’s Most Evil Function

My choice for Excel’s most evil worksheet function is INDIRECT, for reasons outlined below. If you have a different choice you can cast your vote for your most evil function (and your favourite function) here. So what makes INDIRECT so … Continue reading

Posted in Uncategorized | 10 Comments

Special Offer for Excel Summit South

If you were thinking about joining us at Excel Summit South for what promises to be a great 2 days of Excel then register now to take advantage of a 10% discount offer. Just use coupon code LIMITED – the … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 170,000 times in 2015. If it were an exhibit at … Continue reading

Posted in Uncategorized | Leave a comment

Excel Summit South: Auckland Sydney Melbourne March 2016

I have spent the last 2 years putting together this stellar line-up of speakers (Excel MVPs – the Excel Dev Team – External speakers) for a series of 2 day conferences in Australia and New Zealand in March 2016. This … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

Excel ForceFullCalculation: Trading off Editing speed vs Calculation speed

A recent post at Stack Overflow reminded me that I have not posted about the pros and cons of Excel’s Workbook.ForceFullCalculation property. So what does Workbook.ForceFullCalculation do? The simple answer is that it switches off Excel’s smart recalculation algorithm, so … Continue reading

Posted in Calculation, Memory, Uncategorized, VBA | Tagged | 7 Comments

Timing Excel Formula Calculations

I have written a couple of posts previously about the methodology of timing Excel calculations: A Quantum of Time – measuring time accurately The XIPS Challenge – how fast does Excel calculate? But rather than focus exclusively on how to … Continue reading

Posted in Calculation, Uncategorized | Tagged , , , | 1 Comment

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 120,000 times in 2014. If it were an exhibit at … Continue reading

Posted in Uncategorized | 4 Comments

Stacking (Appending) Arrays/Ranges in Excel: Formulas versus Functions Shootout

This post is a follow up to my last post Using Constant Arrays and Expressions in Excel Formulas. I will explore how some of the general purpose array-handling functions in FastExcel SpeedTools Extras compare with formulas using native Excel functions. … Continue reading

Posted in arrays, Calculation, Lookups, Uncategorized, XLL | Tagged , , , , , , , | 4 Comments

Once in-a-lifetime Bordeaux wine Tasting: This time we made it!

Last year we had this once-in-a-lifetime wine tasting scheduled: but it did not happen. (see the ones that got away) This year we finally got our various acts together and had a terrific evening! The Wines The line-up was fantastic: … Continue reading

Posted in Uncategorized, Wine | Leave a comment

2014 MVP Summit

In the first week of November I was privileged to attend the MVP Summit at Microsoft in Redmond. I think it was the best Summit I have been to, with much more open interchange with the Excel team about things … Continue reading

Posted in Uncategorized | Tagged , | 6 Comments