Sorting (and beyond!) By Bob Umlas, Excel MVP In this blog, I’ll discuss sorting, likely beyond features you knew were available! We’ll start with this screenshot of a file: It needs sorting. There are many ways to sort data. There are 3 ways to access sorting from the Data tab: 1– 2–You can right-mouse click …
How to Hide and Show Rows and Columns in Excel By Bob Umlas, Excel MVP In this blog we’ll explore the various ways to hide and show rows and columns. The bulk of the discussion will address columns, but it applies to rows as well (unless otherwise noted). You can change a column width by …
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 is the grand total in cell B38. Notice that there are several subtotals in …
Excel Grand Totals: You DON\’T Need Long Formulas 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 otherwise noted). How to Hide Columns You can change a …
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 has this ability already built-in! It’s called the Justify command, found on …
![20 Custom Filters for Schedule Analysis [Microsoft Project]](https://blog.iil.com/wp-content/uploads/2016/01/featured-20-custom-filters-1024x683.jpg)
20 Custom Filters for Schedule Analysis [Microsoft Project] By Aaron J. Parham, PMP, CSM, MS Project Orange Belt 2013Associate, Booz Allen Hamilton Interested in submitting a guest blog? Here’s how. Here is a list of 20 custom filters and criteria for creating them. You can use these filters to analyze schedules for completeness, find common scheduling errors, …
20 Custom Filters for Schedule Analysis [Microsoft Project] 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 definition. Well, it could be the same thing in Excel: …
Key Drivers to Scheduling Success with Microsoft® Project 2013 By Keith Wilson, B.Comm., PMP, MCT, MCTSProject Server Black BeltSenior Trainer and Consultant, IIL Project success means delivering your goods, service or result by meeting the expectations with respect to the project constraints (Scope, Quality, Resources, Time and Cost). A recent study of technology projects found that …
Key Drivers to Scheduling Success with Microsoft® Project 2013 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 A: Your job is to separate …
Excel Basics: Separating First and Last Names in One Cell 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 to create an Agile template. Custom fields allow you to add project-specific information, which can be used …
Can Microsoft® Project Be Used for Agile Projects? Read More »
