This site under reconstruction.
A couple of posts ago, I outlined some ideas on how you can creatively use Excel to solve some problems or to automate your work. That post took so long to create I decided to break it up into two posts. This one will be the second post. So, here’s a few more examples….. Idea…
Note: This post took forever to develop. Creating examples took a lot of out me so I’m thinking of doing the second half next weekend. Over the holidays I was thinking over the conversations I had with others about using Excel and it got me thinking about ways I use Excel that others don’t. It…
Sometimes simple is all you need. Last month I was asked to help out in automating an activity that was needlessly taking up time. Usually when people come to me, they think “program” but sometimes formulas or pivot tables will do the job just as well. In this instance, they needed to restructure some reporting…
A few weeks ago, I did a post “Playing with Data Query” on pulling in data from websites such as Wikipedia or government sites. I believe most sites give data in the form of tables. Wikipedia or the government site showing you the names of House of Representatives or Senators are good examples where you…
Or so the saying goes. For a couple of years, I’ve been asked to help create a program to automate the gathering of data from a different system and roll it into our current system and each time the effort got bogged down in the corporate blackhole. I always got stuck at the point where…
I thought since I’m on Thanksgiving holiday that I would go back to my climate files where I had gathered data from the web and see if I can update the data using the embedded data query. The one I was really interested in was the file pulling in temperature data history for each state…
You must be logged in to post a comment.