When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

For example, when I’m dealing with data from webmaster tools or Screaming Frog, there’s just too much data to analyze with charts. That’s where conditional formatting comes in handy.

Fortunately, a few quick formatting tricks will make them stand out, loud and clear. How to format subtotals in Excel. What this list needs is some formatting to make those vendor subtotals stand out.

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Excel tables use named columns, ... By concatenating array values into a single cell, you can effectively display complex data within a table format.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.