Create a quick and effective dashboard using Excel’s PivotChart and Slicer objects Your email has been sent Learn how you can combine PivotChart and Slicer objects to create an easy-to-use and dynamic ...

Switch from manual entries to automated generators that keep your spreadsheets clean, consistent, and error-free.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. If you ask me, Excel’s what-if analysis tools are under-used. I often respond to ...

Excel's PivotTable feature lets you organize and summarize data into a meaningful report format without changing the data set. Beyond reporting, PivotTables offer a quick and easy way to analyze ...

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a single ...

A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of employee scores and want to display the frequency of ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

If you ask me, Excel's what-if analysis tools are under-used. I often respond to readers with "Have you tried a data table?" Invariably, they don't know how to implement the feature--sometimes, they ...