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 ...

The simplest use of the FORMULATEXT function is straightforward formula auditing.

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

My favorite use of the hyperlink function is to create a table of contents or navigation buttons in Excel sheets. It helps ...

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 ...