Home » Archive by Category "Workshop Blog Posts"

Custom Excel Visual Basic Application – Project Review – Meeting Services Request Form

A local utilities company has been managing meeting room requests across multiple campuses on a regular basis.  Their method for organizing and working with these requests was a manual, time intensive process with many user errors throughout.

Digital Workshop Center (DWC) was hired to create a custom Visual Basic Application (VBA) in Microsoft Excel and connected to Outlook.  The goals of the project was to reduce the time of manual entry, to reduce the time needed for each user to create a meeting request, and to standardize the process so that requests would be consistent across the company.

read more

DWC Celebrates 11 Year Anniversary

Since I started this business out of my house, I wanted to build a community center for education and professional development that I thought was missing in Northern Colorado.  With minimal outside funding and a small savings to invest, the company has continued with organic growth, limited debt, and amazing partnerships with local government and businesses.   We have found success with our focus on “skills, not degrees”.  Furthermore, coworking and community events have now become a sustainable part of the DWC model as well.

I am beyond proud of DWC.  In fact, there are not enough ways for me to express how thankful I am for the opportunity to build DWC from the ground up and have you all come along for the ride.  

read more

July 4th – Free class for Veterans!

Once back to the civilian workforce, Veterans are trainable, creative problem solvers, resilient, and responsible members of any team. However, if there is a gap in the technology skills needed in the current workforce, that is where DWC can help the most.

Starting today until July 15th, 2017, DWC is giving away 10 FREE classes of $300 each to Veterans!

read more

Connecting with alumni on LinkedIn

At Digital Workshop Center, we have been working closely with LinkedIn to build out our official school page. The goal is to create a central place for DWC alumni to connect and network, as well as employers to filter our alumni by the candidates specific skills.

read more

From Excel Tables to PivotTables

You (and, more importantly, your boss) love what you’ve created thus far in Excel. You’ve spent hours entering your data into your worksheets, organizing the data using best practices, and creating advanced formulas to calculate what you need to see. So, what have you learned about your data?

read more

Advanced Excel Data Analysis – Data Table

While working in Microsoft Excel on data analysis, there are a handful of built-in analysis tools available. If you’re interested in studying the effect that a range of values has on the formula, you should consider setting up a data table.

read more