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 (https://www.datelproductions.com/). 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)

Data Cleanup with Power Query - Beyond the UI | Chandeep Chhabra

Link visible for attendees

In this session, you'll learn to solve simple to complex practical data cleaning problems using the M language in Power Query.

We are delighted to welcome Chandeep Chhabra back to the London Excel Meetup group for his second presentation.

• Chandeep is a consultant and trainer. He helps small and large companies create and automate BI-Dashboards, Excel Reports and Process Automations.
• Prior to starting Goodly (his solo venture), he worked as a Financial Analyst for an Investment Bank in Mumbai (India).
• Check out his blog - https://goodly.co.in/blog/ and YouTube - https://www.youtube.com/goodlychandeep

Join Zoom Meeting:
https://us02web.zoom.us/j/87401234553?pwd=4LnhTMXgyL2pyG5_HgNAu29UjyfXyw.1

Meeting ID:[masked]
Passcode:[masked]

YouTube live stream and replay link
https://youtu.be/o7OETzMn4N0

Excel GOTCHAS and How To Overcome Them | Alan Murray

Needs a location

In this meetup, your friendly organiser himself (Alan Murray) will be presenting on Excel GOTCHAS and how to overcome them.

This is a change to the scheduled program. Some of you attending may have noticed this. I thought I would draft myself in as I am easy to remove if needed. We will get the originally scheduled event booked for later in the year.

There are many surprising little booby traps in Excel, which even seasoned Excel users get caught by. We would ideally like to avoid these.

An animated series in the UK in the 1980's taught us to 'Don't open that Trapdoor'. But sometimes it is left open, so we fall in and we need to know how to get ourselves out.

This session will demonstrate numerous GOTCHAS and how to avoid or overcome them, including:

a. Simple pitfalls
b. Data Validation traps
c. Power Query catches
d. Some Excel formula naughtiness
e. Tense moments with Tables
f. Copying craziness and pasting perils

This is an in-person only event in London. It is not recorded or streamed online.

It will start at 18:00 sharp. Please arrive beforehand to enter the building, grab a drink, and get settled in time.

I look forward to seeing you there.

2
Autofilter and its Secrets | Malina Cierzniewska-Skweres

Link visible for attendees

In this meetup, we welcome back Malina Cierzniewska-Skweres to present on "Autofilter and its Secrets".

There is much more to the different features of Excel than many people realise. And Autofilter - is there an analysis tool in Excel used more than this one? But how well do you know it?

Here are a few words from Malina.

"Excel was my passion since my first job. I was, and still am, astonished by what it could do: everything!

As I was working as sales analyst, I discovered, that no matter what complex BI system companies are using - Excel is always the main tool. And it's awesome! Especially with VBA.

I just couldn't keep it to myself so that's why I started to teach Excel (2008) and decided to write a blog about this amazing program (2013). To help Excel users make their jobs easier and faster. And... pleasant.

I share Excel's power with other users on my blog (malinowyexcel.pl) and YouTube channel (www.youtube.com/c/malinac). I also organize webinars, training and Excel online courses."

This is an online event. The Zoom and YouTube links will appear here shortly before the event.

Photos (85)