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
Speculative fiction is the literature of change and discovery. But every now and then, a book comes along that changes the rules of science fiction for everybody. Certain great books inspire scores of authors to create something new. Here are 21 of the most influential science fiction and fantasy books.
The recipe for KFC chicken used to be a closely guarded secret. However, a former KFC employee recently leaked the alleged "11 secret herbs and spices" to the world - and after extensive testing, the recipe checks out. This video shows you how to make bona fide KFC chicken at home. (The good news is, you probably have most of the ingredients in your cupboard already.)