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

Just move your cursor to the bottom of your table and enter a new record on the next available row; for example, enter Snowbird on row 17 and Alta on row 18. Excel formats the style as you type.

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

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

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

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