Excel 2016

Playing with Excel 2016

I’m working on a bunch of new projects, one of which led to an installation of 2016 Office. Oops, that wasn’t the intent but it became necessary to do so after an inadvertent purchase of a 2016 application. So now I’m getting an advance preview of 2016 products, one of which is Excel. Already, I…

Data Model
|

Discovering Data Model

Before I left on a retreat, I was playing around with Access and data model. Pivot tables have something called data model and I was playing around with it to see how it works. What I found was that it allows you to combine two tables, kind of like Access’ joining of tables and/or queries….

Tapping Into Macros

More Macro Fun

This is a continuation of a prior post but this time, I will talk about a really interesting kind of macro that I have recently been learning. I knew that you could record macros, you could have a button for starting macros, you could use ctrl+key to start a macro, you could have a macro…