Category: Microsoft Excel
Sorting (and beyond!)
Post Views: 77 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…
How to Hide and Show Rows and Columns in Excel
Post Views: 340 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…
Excel Shortcuts
Post Views: 30 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…
Dates and Times in Excel
Post Views: 1,659 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…
Advanced Filtering in Excel
Post Views: 608 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…
Basic Filtering in Excel
Post Views: 97 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…
Three Charts to Avoid: Help Your Audience, Don’t Confuse Them
Post Views: 205 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…
The Page Layout Tab, Part 3 of 3
Post Views: 127 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…
The Page Layout Tab, Part 2 of 3
Post Views: 82 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…
The Page Layout Tab, Part 1 of 3
Post Views: 67 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…