Format your data as an Excel table (more on that later). Essential Microsoft Excel functions to streamline your everyday tasks ...

An AutoFormat option in Excel will format your table and allow you to choose from several options.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Excel provides some powerful formatting tools to help you produce visually compelling tables. Follow along to see how I created mine.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.