Category: Microsoft

Excel Grand Totals: You DON’T Need Long Formulas

By Bob Umlas, Excel MVP Still using long formulas to create grand totals in Excel? There is a better way! Suppose you have a worksheet which looks something like this: Clearly, what’s needed…


Read More

How to Hide and Unhide Columns and Rows

By Bob Umlas, Excel MVP Here we’ll be exploring the various ways to hide and unhide rows and columns in Excel. The bulk of the discussion will address columns, but it applies to rows as well (unless…


Read More

Excel’s JUSTIFY Command

By Bob Umlas, Excel MVP Have you heard of the Justify command? Let’s take a look at it here. Suppose you have the data below: and you’d like to make it look like this: You may not know that Excel…


Read More

20 Custom Filters for Schedule Analysis [Microsoft Project]

By Aaron J. Parham, PMP, CSM, MS Project Orange Belt 2013 Associate, Booz Allen Hamilton Interested in submitting a guest blog? Here’s how. Here is a list of 20 custom filters and criteria for…


Read More

Demystifying Excel VLOOKUP

By Bob Umlas, Excel MVP Using VLOOKUP in Excel seems to be a mystery to many. But you do it all the time in real life—you look up a word in a dictionary and scan a little to the right to read the…


Read More

Key Drivers to Scheduling Success with Microsoft® Project 2013

By Keith Wilson, B.Comm., PMP, MCT, MCTS Project Server Black Belt Senior Trainer and Consultant, IIL  Project success means delivering your goods, service or result by meeting the expectations with…


Read More

Excel Basics: Separating First and Last Names in One Cell

By Bob Umlas, Excel MVP Here in my first blog post, I’m going to show you how to separate first and last names in one cell using Excel. Imagine you have this worksheet, where the name is in column…


Read More

Can Microsoft® Project Be Used for Agile Projects?

By Keith Wilson, B.Comm., PMP, MCT, MCTS  |  Senior Trainer and Consultant, IIL  Can Microsoft Project be used for Agile projects? Yes! Customizable fields and custom groups can be used effectively…


Read More