Select Page

Resources & Blog: Microsoft Project

Why You Should Take a PMI Exam Prep Class

Why You Should Take a PMI Exam Prep Class Don’t Fail: Take a PMI Exam Prep Class at the DWC Project management is a growing and diverse field with many disciplines. In order to be an effective project manager, there are an array of skills that are needed to organize and streamline a project. From initiating, planning, and executing to controlling and closing the work of your team, there are many essentials to meeting goals and achieving success in this capacity. Due to the intense and varied nature of project management, there are a...

read more

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

Custom Excel Visual Basic Application – Project Review – Meeting Services Request Form Project Description A Colorado 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...

read more

Custom Excel Visual Basic Application – Project Review – NM Industrial Service

Custom Excel Visual Basic Application – Project Review – NM Industrial Service Creating a custom solution for a better Excel workflow Project Description Nate Martinez Industrial Services (NMIS), an industrial construction services company out of Denver, recently reviewed their workflows and found some deficiencies in the ways in which they were using Microsoft Excel to create their submittal forms.  Digital Workshop Center stepped in to create a custom Excel and Visual Basic Application (VBA) to help streamline their processes and help save them tremendous amounts of...

read more

Custom Excel Visual Basic Application – Project Review – Hensel Phelps

Custom Excel Visual Basic Application – Project Review – Hensel Phelps Designed a custom construction project management application Project Description Hensel Phelps, a large construction giant across the US, hired Digital Workshop Center to design a project management application using Microsoft Excel.  The project required a high degree of customized Visual Basic for Applications (VBA) code, as well as tapping into some of Excel’s advanced reporting, pivot table, and pivot report features. The project’s goal was to allow project managers and...

read more

Gantt charts help manage business progress

Gantt charts help manage business progress Construction, health care and engineering are among the common industries that consistently have long-term project plans in place. At Digital Workshop Center, we’re lucky to work with some of the biggest regional names in these industries to help them improve their project management and software skills. One of the major reporting views that long-term projects utilize is called a Gantt chart. As the default chart view in Microsoft Project, and available in other project management...

read more

SmartArt a hidden gem for business publications

SmartArt a hidden gem for business publications Business processes, hierarchies and goals can be difficult to effectively communicate. While many applications on the market can help you in the design process, the cost of entry for these can far outweigh the need. For example, you might have a medium to large business hierarchy diagram that is constantly changing. With employees constantly coming and going, you need an easy way be sure that the information in the graphic is kept up to date. If this is a need that your business has, Microsoft...

read more