In today's Between the Sheets:

• Another Excel blunder in the news
• Get your tickets to Global Excel Summit 2024
• Test drive our Power BI course for free

Excel mishaps and how to easily avoid them

It's been a while since the last Excel fiasco made the news when it reversed the results of internal party elections in Austria. Another cautionary tale recently came to light, although it dates back to 2021.

Here's what happened:

The UK office in charge of picking trainee anesthetists messed up because of Excel errors.

They had to combine score lists from seven different regions into one big list. Each region's list was different and not easy to blend together.

People in the office used different ways to put the lists together, like copying rows or using Excel's VLOOKUP function incorrectly.

The list from Wales was extra tricky because it didn't have scores, just rankings from 1 to 24. These rankings got mixed up as low scores in the big list, making it look like the Welsh candidates weren't good enough.

In total, 35 out of 400 candidates had problems because of this.

It got me thinking... All of this was easily preventable.

A consistent template with clear instructions and proper spreadsheet design would have saved everyone a headache.

If the incoming data was consistently structured, combining it would have been a breeze with the help of Power Query. No manual copy/paste needed, no risk of someone messing up a VLOOKUP formula.

Once set up, the human effort would be limited to saving the incoming results to the same folder (well, that also could be automated - for ideas on combining tasks across applications, check out our course: Automate with Power Query - Recipes to solve business data challenges).

And even with everything properly set up, it still pays to have rigorous data accuracy checks in place.

In this case, the score discrepancy was major enough that it should have been obvious but was still missed, likely due to the sheer amount of data.

Perhaps AI tools like Excel's built-in Analyze Data could have brought attention to the anomaly.

Excel is a powerful tool - as long as it's used correctly.

​

​Join the Excitement at Global Excel Summit 2024​

The Global Excel Summit 2024 is a must-attend event for all Excel professionals.

With a spotlight on Automation and AI, what you'll discover can transform how you handle data.

📅 Join us from February 6-8, either in person in London or virtually from anywhere.

I'll be in London at the event and hope to connect with you there.

Summit Highlights

💡 Discover cutting edge AI tools that are set to redefine data analysis.

🎤 Learn from 30+ global experts in Excel and Power BI.

🎓 Earn over 30 CPD credits to boost your professional standing.

👥 Network, meet, and connect with like-minded Excel enthusiasts from around the world

Special Offer Alert!

Use code LEILA on the checkout page and enjoy a 20% discount.

​Join the Event and let's geek out over Excel & AI, connect with pros, and make memories!
​

🤓 Geeky News

🐍 Python in Google Sheets

If you're using Google Sheets and missed out on the excitement of Python coming to Excel, you now also get a chance to bring Python into your spreadsheets.

Neptyne has released a Python Add-on for Google Sheets, available to download for free from Google Marketplace.

It enables you to write your own Python functions and spill the results to cells. You get to control which Python components are available via a Package Manager.

📅 Outlook Calendar to show declined invitations

You can now keep events you decline on your calendar to retain access to the attached documents and any related information, while keeping the timeslot free.

You can enable it in Settings in the *new* Outlook for Windows, Outlook on the web, Outlook for Mac. It will also work in the Teams Calendar.

📊 Excel for the Web - easier formula building

Excel for the Web introduced a bunch of new features to make writing complex formulas much easier. They include:

• Insert function dialog box - similar to the familiar Formula Wizard from the desktop version, but with a more modern feel,
• Parentheses coupling - whenever you position your cursor inside a set of brackets, the corresponding closing bracket gets highlighted,
• Monospace font for better readability (recently introduced in desktop Excel as well),
• Value Preview that displays the result of any part of a formula when you hover your mouse pointer over it.

​

💚 Newsworthy

Are you curious to try Power BI but short on time?

Good news! We've put together a FREE QuickStart Power BI course.

You'll get to see what the Power BI hype is all about and decide if it's the right tool for you to learn right now.

You can complete this course in just over an hour; Spread it over 4 days in 20-minute bursts or go all-in at once.

Your schedule, your choice! 🕒

👉 Sign up here. It's free (but we're not sure for how long we'll keep it that way!)

If you're a member of our "Fast Track to Power BI" course, you already know this content but if you have colleagues or friends who could benefit from an introduction to this awesome tool, it would be great if you share this link with them: https://link.xelplus.com/newsletter-powerbi-freecourse​

There's already been a lot of interest and enthusiastic reviews keep coming in.

We're so grateful for such an incredible community of learners. Don't miss out on this opportunity.

​

😎 New Finds

We recently found Simple Sheets, a platform with user-friendly Excel templates used by a wide community, including Fortune 500 companies. We're exploring their templates and the early signs are promising. We'll share more in the coming weeks.

You can give their free bundle a try, and when you're ready to buy, enjoy a 15% discount using the coupon code LEILA - a special perk for our "Between the Sheets" readers.

​

🚀 Power Stories

This review of the Fast Track to Power BI course from Yves Seybel really made my day:

Congratulations on successfully navigating this learning journey 🎊 and thank you for the kind words. 💚

Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇

See you next week,

Leila️

Want more?

▶️ Subscribe on YouTube​

🖇️ Follow us on LinkedIn​

🥇 Join 400,000+ students in our courses​

📣 Want to sponsor Between the Sheets? Get in touch here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support!