Recent Posts

Excel

Merging and splitting cells or data

The title of this post sounds simple. Should be easy to do, right? But customers tell us that it’s very confusing and not at all clear where to find the features to get the results they want. It all depends on what you want to merge or split. For example, you may want to create a large header cell by splitting the cells below it into a number of smaller…

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

Speed up data-entry tasks by using End Mode

The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells. To save time, I used something called End mode in combination with the arrow keys on my keyboard to quickly select all the cells I needed to change. Many of my own coworkers have never heard of End mode, so I thought you might not know about it…

Excel

Line or scatter chart?

Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference in the way each of these chart types plots data along the horizontal and vertical axes. Let 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…

Excel

You asked about pivot tables (video)

So many Office customers ask about “pivot table” that we’ve gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that can help summarize and analyze your data. Or you already have your data in a PivotTable report and are looking for information about how to pivot it.

Excel

Count your values with the COUNT function (video)

The process of manually counting values in Excel is time-consuming and error-prone, especially when you have a lot of data. Fortunately, there are a few automated ways to count values. From the questions we get from our customers about counting, it’s clear that not everyone knows how to go about it. There are different methods, depending on what you want to count.

Excel

Excel table or PivotTable?

In Excel there are tables and PivotTables. You may wonder why you’d need to create a table when the whole worksheet already looks like one. And you’ve heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use one or the other. Continue reading to learn more about the differences between tables and…