Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. My client produces ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Our company creates ...

Want to get more out of Excel? At Microsoft’s inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016. Here are 10 of the best. ...

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. Everyone knows Microsoft Excel as a ...

Excel 2016’s many new features include six new chart types. We’ll go over Histogram, Pareto, and Waterfall and talk about how they could be used with your data. We covered Treemap, Sunburst, and Box & ...

Use Excel data validation to prevent duplicate values in a column Your email has been sent Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in ...

How to combine and analyze data from multiple data sets using Excel Power Pivot Your email has been sent If you've have lots of data and lots of analysis to do, but little time or skill, you need ...