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
Politicians are fond of pitching to the “average Australian” but judging by the income of Australians, whether you are middle class depends on where you live. And where we live tells a rich story of who we are as a nation – socially, culturally and economically.
Welcome to Wednesday! Get over the hump with some retail therapy. This week's best deals include $111 off Nintendo Switch, $2 Flights with Jetstar, Catch's huge Christmas tech sale and heaps more!