How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

If you already have Excel worksheets containing employee data, like overtime hours or production reports, you don't have to re-enter this information in a performance tracker.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Learn how to use one of the most powerful tools Microsoft Excel has to offer.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

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.