Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...

This simple function acts as a critical safety net for your workbooks.

Microsoft Excel isn't just for work. In fact, by leveraging just three single, powerful formulas, I use the popular ...

This could be the key to making your Excel sheets more useable.

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package. R has a number of quick, elegant ways to join data ...