Google Sheets vs Excel

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

Combine Excel Sheets with Power Query

Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

Excel 3-D Formulas

With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.