What we’re about
Do you love Excel?
Or maybe just like it (that's ok) and want to know more.
This meetup will consist of a talk from 1 or more speakers, whom will share some knowledge and tips.
There will be time before and after the talks to connect with other attendees and the speakers. More time to chat, share knowledge and help each other.
This is an informal and relaxed environment. Come along for a cup of tea or coffee, meetup with other like-minded people and learn and share some Excel magic.
This event is hosted by Datel Productions. We meet monthly at one of two venues in London. We have a venue at Victoria and one at Vauxhall.
We alternate between the two venues. Both offer great facilities for sharing knowledge and also relaxing with a drink.
Upcoming events (3)
See all- Power Query Magic: Crafting a Custom Splitter from Scratch | Melissa De KorteLink visible for attendees
In this meetup, we have Melissa De Korte showcasing some Power Query Magic.
Description:
Let's tackle a real head-scratcher together: what to do when standard M functions just don't cut it, especially with the pesky case sensitivity issue in Power Query. If you've ever found yourself wrestling with the need to split data but dreaded the thought of messing up your letter casing to achieve it, this session has got you covered. We will build a custom splitter that tackles case variations with ease. This is for all data heroes out there who are looking to overcome these types of limitations, expanding their toolkit with a shiny new tool and the know-how to wield it. Get ready to level up your data game!
About:
Melissa de Korte is a passionate problem-solver known for her ability to simplify complex problems with Power Query and M. With an impressive track record as an Enterprise DNA Expert and Fabric Community Super User, Melissa has become an asset to the data community, actively engaging, supporting, and inspiring others.
She posts regularly on LinkedIn using the hashtag #pqtodaysmenu and is co-author of "The Definitive Guide to Power Query (M)," a comprehensive resource essential for both beginners and seasoned professionals. Her work demystifies complex concepts and empowers users to harness the full potential of Power Query and the M language.
Connect with Melissa:
https://www.linkedin.com/in/melissa-de-korte-64585884/
https://www.amazon.com/Definitive-Guide-Power-Query-Transformation/dp/1835089720Links to attend the event on Zoom or YouTube will appear closer to the event.
The event is recorded on the Computergaga YouTube channel.
RSVP to this event to receive the recording and other event communication.See you all there.
- Excel 365: The Subtle Art of Overcomplicating LAMBDAs | Marco FilocamoLink visible for attendees
In this meetup, we welcome my friend Marco Filocamo, a passionate Excel trainer and consultant.
Description: You create a convoluted formula that gets the job done. You wonder—should this become a LAMBDA? Like that box of electrical cables in the basement covered by dust, you cannot miss the opportunity to create one “just in case this specific need arises again in the future.”
Dive into the labyrinthine world of Excel 365 with us as we explore the most comprehensive Excel function ever created. Friend or foe? Let’s discover it together by taking inspiration from training courses and consulting projects. If you like to overcomplicate your workbook to craft fantastic functions that none of your peers would care about, you cannot miss this one.
About: Marco Filocamo has over ten years of experience creating complex spreadsheets for businesses and individuals. As a consultant, he supports multinationals and startups, helping to optimise internal processes and improve business efficiency through data. Beyond his consultancy work, Marco offers tailored training courses for companies and is incredibly passionate about sharing his knowledge through his website, www.marcofilocamo.it. Here, you can find over 150 free guides and tutorials focused on Excel - explicitly tailored for Italian-speaking business users.Links to attend the event on Zoom or YouTube will appear closer to the event.
The event is recorded on the Computergaga YouTube channel.
RSVP to this event to receive the recording and other event communication.See you all there.