Home » Posts Tagged "microsoft office"

Top Three Long Document Time-Savers in Microsoft Word

For your next book, magazine, research paper, or really long document you need to know these three time saving tricks in Microsoft Word to save you enormous amounts of time.  There are many built-in features of Word that you may not be properly taking advantage of, but the ones below have been some of the most overlooked.

read more

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

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 extend the functionality of your Office programs.

read more

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

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