Have you ever wondered whether it’s better to use OFFSET or INDEX? Or how about SUMIFS or SUMPRODUCT, which is faster? Should you be using the new XLOOKUP or sticking with INDEX-MATCH (or even VLOOKUP).
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…)
We are very excited to announce that the very popular “Dashboard Reporting in Modern Excel” is now available online as a live, webinar-style workshop! This interactive dashboards course will be run LIVE over three days from 10th – 12th November 2020, so you can join us wherever you are in the world. Download the brochure.
With the huge amount of data available to us every day, a well-built and designed dashboard report is one of the best ways to interpret and communicate large quantities of information. Using new Modern Excel tools, learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs using Excel or Power BI.
Creating a financial model created for obtaining project finance for a long-term infrastructure project is one of the most complex and intricate types of modelling which can typically take many weeks or months to build. (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…)
Who doesn’t love a shortcut? With all the hours we Excel users spend on the computer, a huge amount of time can be saved every day by learning the keyboard shortcut commands. Did you know that for every mouse click on your computer, it takes several times longer than the equivalent keyboard shortcut? (If you don’t believe me, try creating a new document with the mouse versus the shortcut Control-N!)
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.
Excel’s new Dynamic Array functions are now generally available and will be appearing in your Office 365 toolset any day now. What are they and why should you care?
They’re self-replicating formulas that allow you to build models the way they always should have been built: with consistent formulas that don’t allow anyone to “just change this value”, and which automatically extend themselves.
