Category: Microsoft Excel

Sorting (and beyond!)

Post Views: 6 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…


Read More

How to Hide and Show Rows and Columns in Excel

Post Views: 9 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…


Read More

Excel Shortcuts

Post Views: 1 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…


Read More

Dates and Times in Excel

Post Views: 54 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…


Read More

Advanced Filtering in Excel

Post Views: 22 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…


Read More

Basic Filtering in Excel

Post Views: 4 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…


Read More

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

Post Views: 14 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…


Read More

The Page Layout Tab, Part 3 of 3

Post Views: 8 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…


Read More

The Page Layout Tab, Part 2 of 3

Post Views: 8 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…


Read More

The Page Layout Tab, Part 1 of 3

Post Views: 5 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…


Read More