Category: Microsoft

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…


Read More

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…


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…


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…


Read More

Advanced Filtering in Excel

By Bob Umlas, Excel MVP In this blog I’ll continue the discussion from my last blog on basic filtering. This one is on advanced filtering. Let’s continue with the same worksheet used from the last…


Read More

Basic Filtering in Excel

By Bob Umlas, Excel MVP  In this blog I’ll discuss filtering. In another continued blog, I’ll talk about advanced filtering. First, what is filtering? We’ll define it by looking at a very simple…


Read More

Three Charts to Avoid: Help Your Audience, Don’t Confuse Them

By Harry Rever, MBA, PMP, CSSMBB, CQM, CQC    |   Director of Six Sigma, IIL  I want you to stand up. Yep, get out of your chair and stand up straight, put your right arm out to the side with your…


Read More

The Page Layout Tab, Part 3 of 3

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…


Read More

The Page Layout Tab, Part 2 of 3

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…


Read More

The Page Layout Tab, Part 1 of 3

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…


Read More