Round 2 of the Excel World Championship 2022 is happening today, so don’t miss it! There are details below, and the Final round is on November 12th. And for those of us who have personal competitions with Excel every day, at the office/school/home, Excel expert David Ringstrom has some great tips for you.
Hidden Treasures in Excel
How often do you run into strange things when you’re working in Excel? Are they quirks, or bugs, or features? Sometimes it’s hard to decide!
David Ringstrom has been a spreadsheet consultant since 1991, helping clients and teaching courses. Tapping into his decades of experience, David has just released a new book – Exploring Microsoft Excel’s Hidden Treasures.
The subtitle gives us more details on what’s in his book:
- Turbocharge your Excel proficiency with expert
tips, automation techniques, and overlooked features
Useful Tips and Interesting Quirks
David’s publisher sent me a digital copy of the book to review, and I was impressed by its contents, and enjoyed diving into several of the chapters. I learned a few quirks about my favourite Excel topics, and discovered things I didn’t know about Excel’s newest features.
And be sure to follow David’s advice in Chapter 1, and use the Feedback command on the Excel Ribbon’s Help tab. You can let Microsoft know what you like, or don’t like, and make suggestions for new features (or vote on other people’s suggestions).
I fully support the suggestion to add the “Center Across Selection” command to the Excel Ribbon!
Who Is the Book For?
David’s book is for intermediate and advanced Excel users who want to save time, build better workbooks, and avoid Excel’s pitfalls and problems. You might think, “I don’t need an Excel book — the internet answers all my questions.”
But this book can help you find useful Excel features that are so well-hidden you didn’t even have questions about them! For example, thanks to a tip in the book, I remembered Full Screen View, that was removed from the Ribbon in Excel 2013, and put it back on the Ribbon.
And unlike the internet, Excel’s Hidden Treasures (Amazon link) is well organized, with a detailed table of contents, and a comprehensive index.
Also, every chapter has a companion Excel file to download, so you can easily try each technique. The files are well constructed, and you’ll get ideas from them too!
Video: Excel’s Hidden Treasures
If you’d like to see one of David’s presentations, before you decide to buy his book, here you go! This video shows his “Excel Quirks and Nuances” presentation to the London Excel Meetup, on October 26, 2022.
Video Timeline
- 00:00:00 Welcome
- 00:07:42 David Ringstrom – Self Introduction
- 00:10:00 Main Presentation
- 01:12:00 Questions
Excel World Championship on ESPN
The Excel World Championship 2022 started last Saturday (October 29th), and you can see Round 1 on YouTube, if you missed it.
TODAY, you can watch Round 2, live on ESPN3 (and live stream on the ESPN app):
- Date: Thursday, November 3, 2022
- Time: 1 AM Pacific Time
- Event: Round 2
- Hosts: Excel MVPs Danielle Stein Fairhurst and Tim Heng
- Watch it live, or catch it later at these links:
- Watch on ESPN
- Watch on YouTube
Round 2 Matches to Watch
In today’s show, you can watch the following Round 2 matches :
- Michael Clarke vs. Steyn Wolmarans Alfons
- Oliver Altes vs. Willem Gerritsen
- Anup Agarwal vs. Matthew Fried
- Liam Bastick vs. Ryan Bains
Final Round
The Excel World Championship finals take place on Saturday, November 12, 2022, starting at 9 AM Pacific Time
The finals are hosted by Excel MVPs Jon Acampora and Oz du Soleil, featuring special guest host, Microsoft’s Excel PM, Johnnie Thomas.
- NOTE: No links are available yet, but you can check the Financial Modeling World Cup YouTube channel. They’ll post the Final Round links there soon.
__________________________
Microsoft Excel Quirks and Competitions
__________________________