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
One of the more popular form controls is the checkbox. The checkbox form control is a simple control that you can use when you want to assign a Boolean (true or false) value to a cell. In other words, when you check the box you can assign one value, but when you un-check the box you assign another value.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
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 Word, the most popular word processing program, has many features that can help you get started. There is a graphic feature called SmartArt that can help you create simple, flexible diagrams. Going beyond Microsoft Word, SmartArt is also available in several of the other Microsoft Office programs including Excel, Visio and PowerPoint. SmartArt includes a graphic solution for lists, processes, cycles, hierarchies, relationships and more. After you decide the appropriate format, SmartArt includes two contextual tabs that allow you to control the design and format of the graphic. The items in the graphic are controlled through the Text Pane and work similar to a bullet list, where you can create top-level items and then sub-items as needed. The individual shapes of a SmartArt graphic can be designed independently, or you can control the overall design to maintain a consistent look. In addition, when you change a font size of one SmartArt object, all related items will change their size proportionally. One of the best ways I have implemented SmartArt at the Digital Workshop Center is to create a simple infographic to help explain our certification programs. An infographic is a graphical way to describe our services, combining text and graphic elements to convey the information in a unique way. SmartArt allows me to create a simple infographic within an existing Office document and avoid the time involved with using a graphics program such as Adobe Photoshop. SmartArt is one of the many tools that are underutilized in the Microsoft Office suite. One of the comments about SmartArt I regularly hear in our classes is “I had no idea that existed in Microsoft Office!” I encourage you to try inserting it into your next Office document and start creating a SmartArt diagram for...read more