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.read more
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 long term.read more
With new small businesses coming on to the scene daily, it can be intimidating for any entrepreneur to jump into the fray. There are many skills that you need to know in order to be successful in today’s tech-savvy marketplace, and it’s hard to know where to start. For most companies, from the design sector to the financial sector, there are several key software programs that must be mastered for maximum efficiency and workflow. Luckily, you can get all the training you need to launch your own business right from the comfort of your own couch!read more
When beginning to use Microsoft Excel, there are several key mistakes that all students should avoid in order to be successful for the long term of a project. Depending on your industry and specific Excel needs, this list of pitfalls can certainly become a long one. I’ve narrowed down the top 3 mistakes that all beginning Excel users should avoid.read more
Download the Microsoft Excel Cheat Sheet for FREE! The Digital Workshop Center provides free cheat sheets on many popular software applications. If you are looking for a quick Microsoft Excel reference sheet, then we’ve got just the thing for you! The Excel cheat sheet includes several useful shortcuts and common commands to help you be more efficient and confident while working in Excel. Several of these commands are included in our hands-on Excel Level 1 training class, so if you need more Excel help please contact the Digital Workshop office. Stay tuned for more cheat sheets coming soon! Click the link to download the cheat sheet in PDF format: Microsoft Excel Cheat Sheet...read more