Microsoft Excel

>Tag:Microsoft Excel

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

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

Running Total in a Microsoft Excel Table

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

July 12th, 2012|Tags: , , , , |7 Comments