How-To Geek on MSN

How to Insert and Use a PivotChart in Microsoft Excel

So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split "PivotChart" button.
TechRepublic

3 Quick and Easy Ways to Summarize Excel Data

Learn how to quickly summarize Excel data on-the-fly using these easy-to-implement features. Summarizing data is one of Microsoft Excel’s main functions. The good news is that a lot of number ...
Hosted on MSN

How to Use the GROUPBY Function in Excel

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...
Slate

The Excel Formatting Shortcuts You Need Most

This video originally appeared on Business Insider. Excel can intimidate even the most computer literate and savvy. These quick formatting tips will help you easily enter and organize dates, currency, ...
TechRepublic

How to parse data in Microsoft Excel

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...