Category: Microsoft Excel
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…