How to Import Access Data to Excel Using the “Get External Data – From Access” Option

July 2013 Many people (especially in Finance) use Excel and Access almost interchangeably, feeding data between both applications. But if you've never done it, then how do you? There are several ways to import data from Access to Excel, and you don't even need to have Access open. You can import Tables, as well as [...]

July 26th, 2013|Tags: , , , , |1 Comment

Excel Retains Manual Calculation

There is a known issue with Excel's calculation when switching out of Automatic calculation mode. For those who don't know, let me recap the issues: The first workbook opened will use the calculation mode of its last save Any workbook created will inherit the calculation state of the first opened workbook (or current application calculation [...]

March 16th, 2013|Tags: , , , , |7 Comments

Table Slicers in Microsoft Excel 2013

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 Excel 2010 Slicers by Mike Alexander PivotTable Slicers by Jan Karel [...]

March 7th, 2013|Tags: , , , , |5 Comments

Delete styles in MS Excel

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 bloated with [...]

January 14th, 2013|Tags: , , , , |9 Comments