Excel can perform very complicated analyses on data, but often the trickiest part of the exercise is deciding what approach will get you the results most efficiently. Microsoft's Excel blog offers a useful summary of the pros and cons of two common data analysis approaches: building formulas or using the pivot table function. The author admits his own bias towards formulas, but pivot tables also have some advantages (particularly if you're working with external data). If you've got your own rule of thumb for making choices in these kinds of situations, share it in the comments.
Choosing Between Functions And Pivot Tables In Excel
Trending Stories Right Now
The NBN is a painful political boil on the government's arse. After the promise of fast 100Mbps connections was squashed by the Abbott/Turnbull government, in favour of a program that said 25Mbps qualified as broadband, there have been all sorts of delays and issues with the service. A recent survey, albeit with a small sample size, quantified some of that pain, with many NBN customers saying they'd prefer to go back to their old ADSL connections. You know things are bad when ADSL looks like a better option. So, what can you do about it if you're on the NBN but it sucks?
Alas, my McDouble-loving friends, it appears McDonald's has sent the popular burger off into the sunset. From what we know, it won't be replaced with the McSingle, or the McTriple, leaving fans to make do with less-thrifty substitutes.