Please ensure Javascript is enabled for purposes of website accessibility

Ultimate Excel Bracket Round 2: Sweet 16 Revealed

Suuweeetttt! Here’s the sixteen that you’ll be voting for next:
#13 LEFT
#1 Ctrl-S
#2 Ctrl-Z
#4 Ctrl-Tab
#11 F5
Data Analysis Tools
#12 Filter
Other Features
#10 Linked Workbooks
Oh! You’re still here? Read on for the nitty-gritty on how we’ve gotten here thus far:
Worksheet Functions
None of the top 5 seeds survived the second round:
  • #8 Seed SUMPRODUCT snuck past  #1 seed MATCH/INDEX. SUMPRODUCT had already smashed the PMT function, and slides up to round 3 to take on #13 seed LEFT.
  • #13 seed LEFT figuratively left #12 seed DATEVALUE in its dust. LEFT leapt over #4 seed TRIM in round 1.
  • #6 seed SUMIF smashed #3 seed SUBTOTAL in round 2, as well as #11 seed INDIRECT in round 1. We shall see how SUMIF stacks up against #10 seed VLOOKUP in round 3.
  • #10 seed VLOOKUP vaulted over #2 seed IFERROR in round 2, as well as #7 seed SUM in round 1.
Keyboard Shortcuts
The #1, #2, and #4 seeds advance to round 3:
  • #1 seed Ctrl-S stormed its way past #9 seed Ctrl-Enter in Round 2, as well as #16 seed Alt-Enter in Round 1. Next up, #4 seed Ctrl-Tab will try to unseat this perennial keyboard favorite in its march to the Final Four.
  • #4 seed Ctrl-Tab polished off #5 seed Ctrl-Page Up in a battle of the navigation keys. Ctrl-Tab also zipped past #13 seed Ctrl-0 (zero) in round 1.
  • #11 seed F5 felled #3 seed Ctrl-Home in Round 2 after finishing off #6 seed Alt-= in round 1. F5 now finds itself up against #2 seed Ctrl-Z in Round 3.
  • #2 seed Ctrl-Z alphabetically upended #7 seed Ctrl-A in round 2, after zipping past #15 seed Alt-Down Arrow in round 1.
Data Analysis
Of the top 5, only the #1 and #2 seeds advance to round 3:
  • #1 seed Pivot Table has powered its way past #9 seed Slicers in Round 2, as well as #16 seed Solver in Round 1. Pivot Table will now parry with #12 seed Filter in Round 3.
  • #12 seed Filter found its way past #4 seed Text to Columns in Round 2, and flipped over #5 seed Remove Duplicates in Round 1.
  • #6 seed Pivot Chart pummeled  #4 seed Text to Columns in Round 2, as well as #11 seed Advanced Filter in round 1. In Round 3 Pivot Chart will take on #2 seed Table.
  • #2 seed Table toppled with #7 seed Chart in Round 2, after tanking Consolidate in Round 1.
Other Excel Features
#5 Group remains thanks to winning a tie-breaker, the remaining top 5 seeds have been taken out:
  • #8 seed Format Cells flitted past #16 seed Merge Cells in Round 2, as well as #9 seed Center Across Selection in round 1. Format Cells will tackle #4 seed Group in Round 3.
  • #4 seed Group actually tied #5 seed Text Box in round2. Since only one feature can advance we totaled the votes for these features from rounds 1 and 2, which means Text Box goes home and Group advances to Round 3.
  • #6 seed Format Painter fought off #3 seed Quick Access Toolbar in Round 2, after fixing #11 seed Hyperlink in Round 1. Format Painter figures on finishing #10 seed Linked Workbooks in Round 3.
  • #10 Linked Workbooks upset #2 seed Range Names in Round 2, after comfortably cruising past #7 seed Custom Views in Round 1.
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

3d rendering. Smiling chatbot and mockup empty bubbles, text messages with answers. Artificial intelligence helping human to generate ideas and create. Concept of AI and communication illustration

EY’s New Payroll Chatbot Just Has to Be Slightly Less Sucky Than HR to Be a Success

No doubt proud of its partnership with a massive professional services organization that is mostly prestigious unless some scandal or embarrassing internal falling out is afoot, Microsoft has written a long and complementary blog post about EY’s new toy the ‘EY Intelligent Payroll Chatbot‘. Speaking of EY and payroll, the great “just kidding!” payroll snafu […]

old man giving thumbs down

Former Partner Who Got His Says Aussie Government Should Stop Using Outside Consultants

*not the actual partner in photo The PwC tax scandal (AFR coverage) has brought to light the government’s liberal use of outside consultants (that’s “liberal” as in “a lot” not the political leaning so spare the comments) and amplified the voices of people who believe the government should be doing a lot of this work […]