Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Microsoft Excel is well known for creating charts for marketing purposes, and it has features to perform various calculations. Charts are a graphical representation of your data, and they make showing ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

Microsoft Excel’s Data Analysis Toolpak is an invaluable add-in for those who require complex statistical or engineering analyses. This powerful feature allows users to execute a variety of data ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a story, ...

Q. My supervisor wants me to include more data visualizations in my projects. Do you have any suggestions? A. Data visualization transforms raw data into graphical representations, making complex ...

Q. Could you explain how the AGGREGATE function works in Excel? A. AGGREGATE is possibly the most versatile function in Excel. Think of it as an advanced version of the SUBTOTAL function that offers ...