Excel has been bringing out so many new features lately it’s enough to make your head spin. Join us to hear from Excel MVP Oz Du Soleil as he introduces us to the latest and most useful functions such as XLOOKUP, LET and maybe a few more. Once you get the hang of these sexy new tools, you’ll wonder why you had to suffer so long without them. So, come experience the easy, peaceful future and find out what Excel has got in store for us! (more…)
With the importance of remote working in the present climate, we will look at how Excel & Google Sheets handle collaborative tasks, from co-authoring to comment threads to maintaining tables which multiple people need to access with tools including data validation, grouping, spreadsheet locking, slicers etc. We will focus on Excel Desktop & Google Sheets, but also incorporate Excel Online & Mobile apps too. (more…)
Power BI is a fabulous new tool that is getting a lot of attention in the business world, particularly amount Excel users. But there are a lot of things that business users can do quickly and easily in Excel that somehow seem so much harder in Power BI. The reason is that you have to think differently about your data when using Power BI. (more…)
It’s hard to pick formula favourites but we’re going to give it a go. Excel trainer Alan Murray streaming live from London explains what he loves about the SUMPRODUCT, SUMIFS and INDEX functions (and maybe a few more!)
Alan is an Excel trainer, YouTuber and freelance writer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. (more…)
Come and meet the new Excel superheroes – FILTER, SORT, UNIQUE etc. These dynamic array functions are going to change the way you look at Excel. Join Excel MVP and Power BI specialist Chandoo (a.k.a. Purna Duggirala) to learn all about these new DA functions with plenty of examples.
Please visit us here for a list of other webinars and virtual meetups happening over the next few weeks
Download the files here
Register here for more virtual meetup events.
Financial Modeling in Excel For Dummies is now available on Amazon! Here’s what Amazon have to say about the book:
I am just completing the final edits of my new book, Financial Modeling in Excel for Dummies and one of the finishing touches is to make sure we have the spelling right!
(more…)
I am very excited to announce that I’ve just signed with my existing publisher, Wiley to start work on a new book Financial Modeling in Excel For Dummies. Yes, that’s not how I normally spell “modelling” I know, but they tell me a large part of the world spells it that way. And apparently that’s a pretty big market 🙂
