Please ensure Javascript is enabled for purposes of website accessibility

Ultimate Excel Bracket Round 3: The Great Eight

Oh, snap! #1 seed Pivot Tables is out! Here’s a rundown of the standings:

Worksheet Function
#10     VLOOKUP
#13     LEFT

Keyboard Shortcut
#1    Ctrl-S
#2     Ctrl-Z

Data Analysis Tools
#2     Table
#12     Filter

Other Features
#6     Format Painter
#8     Format Cells

Don’t get too comfortable folks, only half of these contenders will advance to the Final Four.  Read on to partake from our buffet of bracket analysis:

Round 3 – Worksheet Functions

Only one top 10 seed survived the third round:

  • #10 seed VLOOKUP vanquished #8 seed SUMPRODUCT in the third round. VLOOKUP vilified #2 seed IFERROR and #15 seed DATEDIF in earlier rounds.
  • #13 seed LEFT continues to leave carnage in its wake, lopping off #8 seed SUMPRODUCT, #12 seed DATEVALUE, and #5 seed OFFSET.

Up next in Round 4: VLOOKUP versus LEFT—nothing to see here folks, move along.

Round 3  – Keyboard Shortcuts

The #1 and #2 stay in after the third round:

  • #1 seed Ctrl-S stomped #4 seed Ctrl-Tab, after safely surpassing #9 seed Ctrl-Enter, and #16 seed Alt-Enter in the earlier rounds.
  • #2 seed Ctrl-Z zeroed out #11 seed F5, which had dominated its opponents in the earlier rounds. Ctrl-Z has also zipped past #7 seed Ctrl-A, as well as #15 seed Alt-Down Arrow.

Poised for battle in Round 4: Ctrl-S versus Ctrl-Z—choose wisely, my friends.

Final Four Preview: The winners of VLOOKUP vs. LEFT and Ctrl-S vs. Ctrl-Z will be taking the gloves off.

Round 3 – Data Analysis

Too much! The #2 and #12 seeds remain after the third round:

#12 seed Filter fought a battle royale against #1 seed Pivot Table to advance to the 4th round. Filter also forced out #4 seed Text to Columns and #5 seed Remove Duplicates in the earlier rounds.
#2 seed Table tangled with #6 seed Pivot Chart and lives to tell the tale. In earlier rounds Table took out #7 seed Chart and #15 seed Consolidate.

It’s practically a circular reference for Round 4: Filter vs. Table—no lo contendere.

Round 3 – Other Excel Features

It seems incomprehensible, but only #6 and #8 remain:

  • #8 seed Format Cells fixed #4 seed Groups wagon, that’s for sure. Format Cells has also fitted #16 seed Merge Cells and #1 seed Fill Handle into a box.
  • #6 seed Format Painter feasted on #10 Linked Workbooks. Format Painter also pummeled #3 seed Quick Access Toolbar and #11 seed Hyperlink in earlier rounds.

I didn’t see this Round 4 coming: Format Cells vs. Format Painter.  Fantastic!

Final Four Preview: The stronger of Filter vs. Table and Format Cells vs. Format Painter will survive to fight another day.

 

David H. Ringstrom, CPA @excelwriter on Twitter — heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm.

Latest Accounting Jobs--Apply Now:

Have something to add to this story? Give us a shout by email, Twitter, or text/call the tipline at 202-505-8885. As always, all tips are anonymous.

Related articles

sketch of a robot among business people to signify AI replacing workers

PwC Chief Products & Technology Officer Says Not to Worry, They Don’t Want to Replace You With AI

A couple days ago, NYT published a piece asking an important question: Who will protect the workers losing their jobs to AI? The article references a May 16 senate subcommittee hearing chaired by Senator Richard Blumenthal at which OpenAI’s Sam Altman is told Mr. Blumenthal’s greatest nightmare is AI causing massive job loss. ‚ÄúThere will […]

man holding a phone speaking to a chatbot

ChatGPT Can Pass the CPA Exam But Here’s What It Can’t Do (Yet)

If the headlines are to be believed, humanity is mere months away from being enslaved by artificial intelligence or, at the very least, being permanently unemployed (cue sounds of the Going Concern audience celebrating here). You may have seen clickbait articles about entire marketing departments being turfed in favor of ChatGPT (we never liked the […]