Category: Microsoft
February 24, 2016
Excel Grand Totals: You DON’T Need Long Formulas
Post Views: 1,578 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…
February 15, 2016
How to Hide and Unhide Columns and Rows
Post Views: 537 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,…
January 25, 2016
Excel’s JUSTIFY Command
Post Views: 122 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…
January 19, 2016
20 Custom Filters for Schedule Analysis [Microsoft Project]
Post Views: 1,071 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…
Project Management,Microsoft,Project
December 21, 2015
Demystifying Excel VLOOKUP
Post Views: 43 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…
December 15, 2015
Key Drivers to Scheduling Success with Microsoft® Project 2013
Post Views: 87 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…
December 9, 2015
Excel Basics: Separating First and Last Names in One Cell
Post Views: 395 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…
October 23, 2015
Can Microsoft® Project Be Used for Agile Projects?
Post Views: 447 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…
Project Management,Microsoft,Project,Agile and Scrum