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

Microsoft Excel 2013 Templates

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

January 19th, 2013|Tags: , , , , |25 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