Earlier this year we started using Microsoft Planner as our project management tool and one of the biggest challenges we had was developing a workflow for project requests to enter Planner. To make a long story short, new project requests had to come in via a webform on a local server. The form then sends […]
Parameters are an incredibly powerful tool when constructing queries in Microsoft Excel. And if your source data changes frequently, parameters can come in extremely handy to change multiple file names/paths hurry. For example, I had queries set up to pull data from about 30 spreadsheets from our finance department. Every month, they ran new reports […]