This site under reconstruction.
(Still working on the new WordPress theme so the site is still messy.) Yesterday I finished posting part I of my macro practicing which was basically the game of encrypting a phrase. Today, I will note some of the macros I developed for preparing to decrypt. I haven’t figured out how to decrypt but I…
I’ve started practicing with macros again for preparation for next year because I need to remain familiar with macro programming. And it’s just so amazing how FAST macros run. They are not foolproof though, because I think sometimes something is running in the background on my laptop and that something “jiggles” the macros, making errors pop up. So that’s…
After spending 4 or 5 weeks on developing ideas for a dashboard for an upcoming huge project, I finally have a rudimentary dashboard. With that experience behind me, here are some ideas of what to do when you are given a project to pull together something. 1. If you can, find out what the goal is. In my…
While I continue the roll out and training on the report automation project, I’m starting a new project. But before I start describing, in vague terms, my new project, I want to talk about something I learned about training on the report automation. A lot of the folks that I train are not familiar with computers…
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…
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….
You must be logged in to post a comment.