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 employee scores and want to display the frequency of ...

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.