Playing with Data Query
|

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

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

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

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…

Another Microsoft Update

Another Microsoft Update

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…