Excel

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…

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…

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,…

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…

Okay, over the weekend my machine just basically stopped working for over a day until the machine stopped doing whatever it was doing in the background. I don’t know if Microsoft was trying to do an update or if Dropbox was doing an update. It looks like Microsoft was trying to do an update and…