Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Excel offers different spreadsheet, basic text and Web page file formats to save your work. Often, saving a spreadsheet in a different format can lead to missing data.

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.

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.

Unfortunately, there’s scant little formatting. In this Excel tutorial, I’ll show you how to run subtotals on a simple data set and then quickly apply formatting that will make those totals ...

In Microsoft Excel, Concatenate is a text function, and its purpose is to combine two are more text strings into one string.The Concentrate function can improve the way your data is aligned in ...

When the Format Cells dialog box opens, it's automatically set to display Excel's numeric-data format options. Select a format category that matches your data type.

How to reverse and transpose Excel data with this powerful but simple solution (TechRepublic) Video: How to highlight rows in Excel with conditional formatting (TechRepublic) ...

Since Excel doesnt automatically format data perfectly for printing, I had to reprint multiple times, wasting ink, time, and moneynot to mention the frustration.

The Number format in Microsoft Excel is quite powerful, but sometimes it will fail to work, and that’s a problem for advanced users. When this happens, Excel will not recognize values as numbers.