Category: Microsoft

By Bob Umlas, Excel MVP For the final part of the Page Layout tab series, we’ll complete the discussion of what’s available on the tab and a few other items. The Header/Footer tab of the page setup dialog is where we left off. Let’s look at this again. Click the dialog launcher below the Print

By Bob Umlas, Excel MVP Last time with the Page Layout tab, we left off with the “Breaks” icon. Next is the “Background” icon. This puts a graphic in the background of the sheet. This background does not print, it merely shows on the physical viewing of the sheet on your computer screen. When you

By Bob Umlas, Excel MVP It seems not much has been written about Excel’s Page Layout tab so I’ll cover the items shown here (which do not include all the commands) up until the Breaks icon. In parts 2 of 3 and 3 of 3, I’ll cover the icons from Background to the end, as

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 the list. The formula in cell B9, for

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 column width by dragging the column separator (the

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 the right side

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: If you wanted

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 respect to the project constraints (Scope, Quality, Resources, Time and Cost). A recent study of technology projects found that 94% of projects had to go through a restart,

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

ABOUT IIL

IIL is a global leader in training, consulting, coaching and customized course development, and is proud to be the educational provider of choice for many top global companies. IIL’s core competencies include Project, Program and Portfolio Management, Business Analysis, Microsoft® Project and Project Server, Lean Six Sigma, PRINCE2®, ITIL®, Agile, Leadership and Interpersonal Skills, Corporate Consciousness and Sustainability.