Category: Microsoft
March 27, 2020
Sorting (and beyond!)
Post Views: 63 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…
January 8, 2020
How to Hide and Show Rows and Columns in Excel
Post Views: 277 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…
October 23, 2019
Excel Shortcuts
Post Views: 26 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…
August 26, 2019
Dates and Times in Excel
Post Views: 1,056 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…
June 21, 2019
Advanced Filtering in Excel
Post Views: 502 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…
May 1, 2019
Basic Filtering in Excel
Post Views: 81 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…
October 21, 2016
Three Charts to Avoid: Help Your Audience, Don’t Confuse Them
Post Views: 165 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…
September 23, 2016
The Page Layout Tab, Part 3 of 3
Post Views: 105 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…
August 4, 2016
The Page Layout Tab, Part 2 of 3
Post Views: 73 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…
April 14, 2016
The Page Layout Tab, Part 1 of 3
Post Views: 51 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…