Home » Archive by Category "Microsoft"

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

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

Setting up an Excel Workbook? What Should Be Avoided.

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

Advanced Formatting Ideas for Microsoft Word

If you work in Microsoft Word, formatting is critical to help get your ideas across and improve the readability of your projects. While even novice users utilize formatting options, more experienced Microsoft Word users can take advantage of a range of advanced formatting options.

Advanced formatting allows you to do unique things in your word documents to ensure that your work stands out from the crowd more efficiently than ever before.

read more

Excel Developer Tools – Checkbox Controls

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