There's a new add-in for Excel called Data Explorer. Currently it's in preview (beta), so use at your own discretion and risk. What is it? Well the name really does say it all – it lets you explore data. Think of the current mechanisms we have in Excel for getting data (that doesn't require [...]
MS Excel Pivot Table Deleted Items Remain - Fix Microsoft Excel Pivot Tables and Pivot Charts, an advanced Data Visualization Tool. We can help you to become a Pivot Table expert. Microsoft Pivot Tables & Pivot Charts should be in every data visualization toolbox as they are one of [...]
Slicers were introduced in Excel 2010 for PivotTables. What are slicers you ask? If you don't know, well, you're in for a treat. Here is some background information to bring you up to speed. Introducing Excel 2010 Slicers Use slicers to filter PivotTable data PivotTable Slicers by Jan Karel Pieterse So you should know that [...]
TEMPLATES Have you seen them? Well, if you have Excel 2013 there's no doubt you have, because it's the opening screen when you open Excel now. Microsoft took a new direction in their featured templates, and has developed hundreds of them which are useful and time-saving. When Excel is opened to the New [...]
This is applicable to Excel 2007-2013. Styles are wonderful, and I've loved having them in Excel. If you're not familiar with styles, check out these links: http://office.microsoft.com/en-us/word-help/style-basics-in-word-HA010230882.aspx (Word 2007+) http://office.microsoft.com/en-us/word-help/all-about-themes-quick-styles-cell-styles-and-background-styles-HA010178624.aspx (Excel 2007+) http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx (Excel 2003) Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become [...]
This was written with Excel 2010 in mind, but will work in 2007-2013. Version differences are pointed out where applicable. Screenshots are using 2010. In the spirit of working with tables via VBA, sometimes you may need to check the range of a table. This is fairly straight-forward in most cases, but sometimes it has [...]
This blog post will be based on working with tables via VBA. They present some unique issues, which has to do with how their structured in the object model. Good or bad, it's what we have. These are based on my trial and errors, so hopefully this will help somebody out there. That being [...]
Tables were introduced in Excel 2007 and are a spin-off from the lists feature of previous versions. This blog post will be based on working with structured formulas in tables, as opposed to standard relative/absolute referencing. I consider this a basic level post. If you're not up to speed with tables, here is some reference [...]
Running Total in an Excel Table INTRODUCTION Tables were introduced in Excel, 2007. I love them, they’re very handy. Along with them we were introduced to Table referencing. This made it easy to identify parts of a Table. It’s called “structured referencing”. Here is pretty much the best resource for identifying structured referencing in Excel [...]
