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

Shape Your Accounting Career Your Way with the Intuit Expert Network

Looking to grow your professional experience, engaging with new clients in new situations? Ready for the next challenge as your accounting career revs up or winds down, or seeking a full-time job as a bookkeeping professional? The Intuit Expert Network offers the perfect opportunity to shape your career—transforming your journey to fit your wants, goals, […]