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 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

I’ve just started exploring Excel 2016. As one of the tentpole applications for the new Office 2016, it has a raft of new features for lucky upgraders. Take a closer look with me and see what you ...

10 defaults you can change to make Excel 2016 work your way Your email has been sent Excel, like Word, has an out-of-the-box environment that might not provide the most efficient setup for the way you ...

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. ...

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 & ...

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Is it possible in ...

Excel PivotTables replace manual percentage formulas with built-in tools for totals, trends, and nested analysis.

How to combine data ranges with Microsoft Power Query in Excel Your email has been sent Microsoft Power Query showed up in Excel 2016, though earlier versions can ...

Back in 2013 John Gagnon continued his popular series of posts about powerful spreadsheet use with a handy how-to guide for using the add-in GeoFlow for Excel. Back in 2013 John Gagnon continued his ...

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 ...