Excel

Go beyond the basic chart type

Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts. Though these charts aren’t available in the list of predefined chart types, don’t worry. There are ways to create them in Excel.

Excel

Apollo 11 & Excel 2010 – Watch History Reimagined for a chance to win

That got us thinking – what would it have been like if Excel had been around back then? How might things have been different? Then we thought – what better moment in time to illustrate the point than the Apollo 11 mission to the moon. I mean, it literally is Rocket Science. So, we decided to create a video to see how Excel might’ve helped the team at NASA work…

Excel

Where to begin: PowerPivot for Excel

By now, you’ve probably read about PowerPivot in one of our many posts about it (such as  Introducing PowerPivot, Using PowerPivot with Excel 2010, or Supercharge your budget sheets with PowerPivot for Excel 2010), and you totally get how powerful this feature is. Its ability to process massive amounts of data from various data sources so that you can analyze it right in Excel 2010 is truly promising! But how do…

Excel

Avoid losing the state of the global IRibbonUI ribbon object

Excel MVP Ron de Bruin provides a solution for a common problem that occurs when you use RibbonX and VBA to customize the ribbon. You can find more tips and links to Excel add-ins at Ron’s website: http://www.rondebruin.nl/. There is a common problem when you are working with the ribbon by using RibbonX and VBA. The ribbon object (which is initialized when Excel loads your file) can lose its reference…