January 2011 - The Excel Team Blog

Today’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel’s website: http://www.jkp-ads.com/ . Juggling the SlicerCaches collection For each slicer you add to your workbook, Excel adds a SlicerCache object too, which controls which pivot table(s) your slicer controls. So suppose we have three sheets, Sheet1, Sheet2...

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 PivotTables. ...( read more ) Read More...

Excel is perhaps the most revolutionary tool for looking at numbers since the invention of the digital calculator. It has dramatically changed the way we analyze data and has improved productivity for everyone. Last year marked the 25th Anniversary of the Microsoft Excel franchise, and though I have only been the Excel Product Manager for the last two years, I have a clear memory of the early days of Excel and how it changed the way people work back in 1985. Keep reading to learn more about Excel's...

Today's blog post on repairing numbers that are formatted as text is brought to you by Gary Willoughby, who writes Help content for Microsoft Excel. A few months ago, my new manager e-mailed us (that is, her team of Excel writers). She had a spreadsheet with some columns of numbers that she wanted to total, and the answer was resolving to 0. When you have lots of values in a column and their total is 0, you have a problem: Those numbers may not be numbers at all ! (cue the scary music). Keep...