If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

Next, in Excel 2016 and newer, click the Data tab on the Ribbon, and then in the Get & Transform area, click the From Table/Range button to bring up the Power Query Editor window.

Deleting blank rows in an Excel data set isn't difficult, but Excel 2016 is the only version that offers predictable results.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

How to Make a Frequency Table on Microsoft Excel. A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of ...

You have a table on paper but need the data listed in Excel? There's a simple trick for importing.

If your dataset contains formulas that reference other columns within the range, you'll need to recreate these using structured references once you've formatted the data as an Excel table.

Excel quirks like rounding errors and formula changes can ruin your data. Learn how to avoid these 5 common mistakes and improve your work ...

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.