Excel

  • Third Time’s a Charm

    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…

  • |

    Playing with Data Query

    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…

  • A Review of Sharepoint

    Now that I’ve worked with SharePoint for a couple of weeks, it’s time for me to put down what I’ve noticed thus far. I think it has the potential to be really cool but we might need to learn some new habits. I have worked with SharePoint as far back as 2007 or 2008 and…

  • Excel Trick for Texts

    I just learned a neat new trick in Excel from an Excel guru Leila Gharani. It’s the Fill Justify and the embedded YouTube video describing it is embedded below. It’s such a neat trick that you can use when you write up notes or instructions in excel. Generally, when I write instructions or a checklist,…

  • Twisted Foot, Twisted Week

    Okay, this week was not a good week. I’ve been working on a plan to move our macro files from Dropbox to SharePoint with an eye towards maintaining simplicity of reporting process. Most of the macro works except at the point of creating a new file and saving it: saving in SharePoint does not quite…