XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
It was fantastic to meet everyone at the Summit
|
I just got back from the Global Excel Summit in London, and wow - what an experience! It was incredible to connect with so many talented and driven people. We talked about everything from Excel to course design, freelancing, and running a business. Everyone brought their own unique background and approach to Excel, which made for some amazing conversations. I had the honor of kicking off the summit, talking about all the new Excel features from the past year. I had to trim a lot to fit the time slot (turns out, Excel had a busy year). All sessions were insightful and inspiring, and we’ve got tons of exciting tips lined up for you in the coming weeks. But first, here are some highlights… 🔹 Chris Webb (THE go-to person for Power Query, Power Pivot, and Power BI at Microsoft) gave us hope that fully functional Power Query in Excel Online is finally within reach! 🔹 Liam Bastick kept us entertained with an impromptu game of Deal or No Deal... just to prove that nobody reads workbook instructions. He shared some great tips on how to change that and build error-free financial models. 🔹 Ian Schnoor came in with the ultimate quality check - his methodology for reviewing financial models. Whether you’re checking a budget, a report, or a colleague’s formulas, this was solid gold. 🔹 We also got a lesson on presenting financial information in Excel and PowerPoint from Danielle Stein Fairhurst - because numbers should look good too. 🔹Carlos Barboza shared with us his takeaways from Guerrilla Data Analysis by Oz du Soleil and Bill Jelen (a must-read!) and how he applied them in some real-life scenarios. 🔹 George Mount explored the possibilities (and limitations) of using Python in Excel with Copilot. 🔹 Melissa de Korte gave us a masterclass on baby-proofing Power Query code to avoid dreaded errors. 🔹 Chandeep Chhabra showed us how far he can take the CONCATENATEX function in DAX to make even the most demanding boss happy. 😉 🔹 Mark Proctor took us to the future of no-click automation with Office Scripts and Power Automate. Just because VBA isn’t fully replaceable (yet!), doesn’t mean you should overlook these tools. 🔹 Alan Murray showed us just how versatile the new GROUPBY and PIVOTBY functions can be. We also had two interesting panels: 📌 Raising spreadsheet standards: How to avoid the next disaster with Kenny Whitelaw-Jones, Ian Pay, and Israel Ngombo. 📌 Rethinking beginner, intermediate and advanced Excel - some great insights from Ken Puls and Oz du Soleil. (Turns out, most people call themselves a "7" on a scale of 1-10. Safe. Too safe. Ken and Oz had thoughts on that.) AwardsThe Global Excel Awards were announced - voted by the community, for the community. Here’s who took home the glory: 🏆 Rising Star in the Excel Industry: Susana Pinto 🏆 Best Microsoft Excel Add-in: ASAP Utilities 🏆 Most Innovative Use of Excel: Mohammad El Medawar (for the Excel Simulator) 🏆 Best LAMBDA: Erik Oehm for Unpivot 🏆 Best Presentation (voted live at the summit): Chandeep Chhabra, The Magic of the CONCATENATEX function in Power BI Congrats to all the winners (and to all the amazing nominees)! 🎉 I’m buzzing with ideas from all the brilliant speakers - and from all the chats in between. It’s an amazing community, and I’m grateful to be part of it. More detailed insights coming in future newsletters! 🤓 Geeky NewsWhile Excel folks were having fun, other 💻 New in SharePointMicrosoft just upgraded the Edit in Grid experience for SharePoint Document Libraries. It offers faster loading, inline editing, and infinite scrolling. Now you can edit files, assign tasks, and manage images without leaving the grid. They also revamped SharePoint's Hero web part with a sleek Carousel layout, offering a dynamic and engaging way to showcase content. This update lets you display up to five rotating slides, each customizable with background media, headlines, and descriptions. New style options add visual flair, while features like auto-play enhance user interaction. 👥 New in TeamsMicrosoft Teams has introduced Super Resolution, an AI-powered feature that enhances video quality during calls, especially under poor network conditions. Initially available for Snapdragon X-based Copilot+ PCs, this feature improves clarity by restoring video resolution beyond traditional upscaling methods. The new Teams calendar is now generally available, offering a unified experience with Outlook. It includes features like delegating access, expanded settings, filtering, and time zone support. 📅 New in PlannerMicrosoft Planner has introduced the Board view to the My Tasks and My Day sections. This highly requested feature allows users to categorize and prioritize tasks using customizable columns. 👏 Power StoriesThe Global Summit agenda always includes the Power Stack. Power Query and Power Pivot are crucial data analysis tools in modern Excel. As Stuart discovered when he completed both of our Excel Power Bundle courses and improved his reports. I'm so happy he got the deserved praise and recognition from his boss. Upskilling yourself can really make a difference to your career. I'm amazed at how much ground was covered by the [Power Pivot & DAX] course, and the clearly presented lectures and examples made the learning experience a real joy.
I did the course in parallel with the Power Query course, and now I have completed both. The techniques I have learnt have taken my report writing and data analysis skills to a different league!
The new reports I've been able to produce and the speed with which these are now available each month were praised by my boss at my recent appraisal. I believe this was a big factor in the favourable outcome of our talks. Thank you, Leila, for your help here!
Stuart Docherty, Group Financial Controller
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. 📨 If you were forwarded this message, you can get the free weekly email 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! |
Leila Gharani - XelPlus
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
The good thing about Excel is formulas update automatically. Change an input, the output adjusts. Ok. You know that. But what if you want the output to be a specific number. What should the input be? Let's say, your boss is standing right by your shoulder, staring at your spreadsheet. "We need to reach $2,500 in revenue this month. How many units do we need to sell?" You could keep tweaking the units cell until you get close. Guess, check, guess again. Pleasant enough if you're alone. Not so...
Most people open ChatGPT, drop in an Excel file, and type two words. Analyze this. What comes back looks good. The numbers, the insights, the tidy summary. But how do you actually know if it's right? Last week I put ChatGPT through a proper test. A messy, multi-sheet sales file with codes, lookups, and calculations it had to figure out on its own. Then I verified the results myself with a data model in Excel. There's a specific workflow that makes the difference between trusting AI blindly...
I always build my formulas the same way. I include extra rows below my data, just in case someone adds more next month. And every time, I get a column with zeros. A blank row that should be invisible suddenly shows up as zero in the spilled list. Annoying, but there are ways around it. My go-to was to wrap in a FILTER. Recently it got a lot simpler. One function. Or even better, one character. Add a dot before or after the colon in your range, like A2:.A100, and Excel quietly drops the blank...