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 dragging the column separator (the little line between columns) left

Read More...

Dr. Harold Kerzner’s Project Management Predictions for 2020

By Harold Kerzner, Ph.D. | Senior Executive Director, International Institute for Learning (IIL) The landscape for project management changes almost every year. Some changes are relatively small or incremental, whereas other changes can be significant. Major changes to project management will occur in 2020 due to much of the new material that the Project Management

Read More...

The Grateful Agile Leader

By Susan Parente, PMP, PMI-ACP, CSM, CSPO, PSM I, CISSP, CRISC, PMI-RMP, RESILIA, ITIL, GL®CP, MS Eng. Mgmt. | Risk Management Guru – Agile Specialist – IIL Senior Instructor We know that servant leadership is an excellent match for Agile methods. For example, in Scrum, the Scrum Master is a servant leader of the Scrum

Read More...

People Innovation: A New Vision to Innovate

By Luigi Morsa, Ph.D.  Nowadays, companies are very conscious that if they want to be competitive, they have to innovate. The conquered market shares can rapidly disappear or drastically be reduced. The only way is to keep pace, to be reactive and introduce new solutions, ideally before their competitors. It is worth quoting a sentence

Read More...

Key Themes at IPM Day 2019

By J. LeRoy Ward, IIL Executive VP of Enterprise Solutions and Sander Boeije, Program Manager – IIL Online Conferences  On November 7, 2019, IIL will celebrate the 16th anniversary of International Project Management Day, also known as IPM Day. Initially conceived by Frank P. Saladis, and made possible by IIL, this important day recognizes the

Read More...

Excel Shortcuts

By Bob Umlas, Excel MVP Excel has hundreds of keyboard shortcuts. In this blog, I’ll describe some of my favorites Ctrl+Shift+ numbers 1 thru 7, and 0 (and the tilde key, ~) can be used for formatting. Let’s start with this sample worksheet, and assume A1 thru B2 is already selected and contains 12345: Ctrl+shift+1

Read More...

Developing Your Benefits Realization Plan

By J. LeRoy Ward | Executive Vice President of Enterprise Solutions, IIL  Is it possible to deliver a project on time, on budget, and to scope and still have an unsuccessful project? Now more than ever, the answer is yes – because today’s projects are all about benefits and value. A benefit is an outcome

Read More...

Dates and Times in Excel

By Bob Umlas, Excel MVP After reading this blog you should be an expert in Excel’s Dates and Times. If you enter the number 1 in cell I1, for example, then look at the Home tab’s Number Format’s dropdown, you’ll see this (without the arrows!): Notice that the number 1, formatted as a short date

Read More...