Dashboards in Modern Excel now available online
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. 
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. 
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. 
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!)
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.
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?
As 2020 is a leap year, this month we have an extra day in the calendar. Those who are on a fixed monthly salary are complaining that they are not getting paid for working the extra day, but I do hope you are enjoying your day anyway, as this is something that only happens once every four years!
