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
If you eat to improve your health, here are five foods to put in your supermarket trolley every week. All pack a proven punch in terms of health gains if you have them regularly.
Changing up your hairstyle is fun, and if you’ve never seen yourself with short hair, you might be wondering what you look like with a cute bob. Sure, there are plenty of apps that will help you visualize it, but as it turns out, there’s an even easier, low-tech way to figure it out: following the 2.25 inch rule.