Select Page

Working with Larimer County to provide professional development classes

Two hour classes for Larimer County, City of Fort Collins, Poudre Fire Authority, Poudre School District and more When Larimer County looked to hire an outside provider for Microsoft Office training, they called the Digital Workshop Center (DWC) and we were excited to help.   In the past, DWC has worked with several government entities for training including Centers for Disease Control, State of Colorado employees, and several local municipalities. However, Larimer County had specific needs...

read more

When is the right time to learn Visual Basic for Applications?

Decide when to use the built-in Visual Basic for Applications tools or take your projects to the next level If you’ve ever tried to tackle a Microsoft Office Visual Basic for Applications (VBA) project yourself, then you know how daunting that can be.  While there are built-in Office tools to help you create macros and perform advanced data analysis, at some point you may realize that the default tools are not good enough.  By learning Visual Basic for Applications on your own, you can...

read more

From Excel Tables to PivotTables

The evolution of 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? At this point, it’s time to get involved with more Excel tools for data analysis.  As you get more creative with data analysis, you can extract useful information...

read more

Advanced Excel Data Analysis – Data Table

Data Tables can help you save time in Excel data analysis 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. Let’s consider an investment analysis example to start.  Suppose that you want to see the future value of an investment with the annual deposit varying between $6,000 and $11,000.  You could...

read more

Setting up an Excel Workbook? What Should Be Avoided.

Common mistakes when setting up a Microsoft Excel workbook Let’s imagine that you are able to create a Microsoft Excel workbook from scratch.  You want to set it up for long-term, future success, right? If the amount of data is going to grow over time, you need to think a few steps ahead to make sure that you are “future-proofing” how you will work with your workbook and the data.  There are some easy steps you can take to ensure that the workbook is effective now and for the...

read more

Excel Developer Tools – Checkbox Controls

How do I use a checkbox in Microsoft Excel projects? As you add more efficiency into your daily workflow, you can look to developer tools for even more help. Developer Tools are an additional tab of the Microsoft Excel ribbon that will give you access to advanced features of the program.  These features include Macros, Visual Basic code, and form controls. This post is focused on how to use a Checkbox form control in your Microsoft Excel projects.  Checkbox controls will help to make your...

read more