Most people know about the famous keyboard shortcuts for copying (Ctrl+C) and pasting (Ctrl+V) items in Excel. However, fewer people know that you can copy several items from various sources at the ...

This goes past being a glorified Ctrl + F command because you can use XLOOKUP to populate data on a separate table. It's one ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

See the screenshot below of the Excel spreadsheet after using Data Table for this example. I do not like one thing about this display — the reference in B9. I feel like it is confusing to a user ...

As an example, you might have a list of employee scores and want to display the frequency of scores within certain ranges. Using Excel 2013's Frequency function as an array quickly compiles the ...