Conference agenda

Beyond expectations: financial modelling with dynamic arrays

An introduction to building a financial model using just dynamic arrays.

The must-have Excel formulas in the finance Industry

Understand how and when to use some of the most useful financial functions in Excel.

Error checking for financial models; Or how to avoid being the next reporting disaster

A demonstration of how to integrate a dynamic error checking system into a financial model.

Advanced sales analytics using Data Analysis Expressions (DAX) in Microsoft Excel.

Learn how to build a responsive, interactive, and impressive Excel dashboard in less than one hour.

Web apps & granular sharing – get the basics

Airrange enables you to collaborate faster and more efficiently with Excel.

P&L statements in data modeling (Excel and Power BI)

Gašper shows you how to create a profit and loss statement in Power BI in less than one hour. Oh yeah…and then he does it in Excel.

Improve your dashboards with custom charts

The power of colour in data visualisation

Discover the ins and outs of colour and how you can use it to improve your data visualisations and storytelling.

Creating a dynamic Cash Flow Forecast in a flash

Learn how to set up a robust cash flow forecast using the latest Excel features.

How to build a 3D wireframe animation in MS Excel?

Get ready for something special! George pushes the boundaries of Excel and shows how to create a 3D wireframe animation.

Panel discussion: The future of data visualisation

Which tool creates the most insightful visuals? We will examine growing trends like storytelling, virtual reality, and AI.

Why we should treat Excel more like PowerPoint?

Unlock the secrets to presenting data in a visually-pleasing manner that goes way beyond how your stereotypical spreadsheet looks.

Excel for the Mac: A guide for Windows switchers

Just bought a new Mac? Understand the differences, gotchas and workarounds of Excel for Mac compared to the Windows version.

Get ready for the Microsoft Office Specialist (MOS) exam

Tricks, tips, and practice tasks on how to pass the Excel MOS exam.

Transforming your boring Power BI reports to AWESOME data stories

Expand your Power BI skills and start using the advanced features.

Data analytics in modern Excel

Discover a variety of tools to conduct repeatable and sophisticated analytics in Excel.

Impactful data visualisation in Excel for powerful communication

Enlighten your audience by creating charts that effectively communicate the message you want to convey.

Panel discussion: Is VBA dead or alive?

Does VBA still have a place in the modern world?

50 Shades of Dirty Data - How Power Query is the best laundry powder there is

Do you wish there is a detergent powerful enough to clean your data for good? Well there is. It is called POWER QUERY.

Tearing down the 5 pillars of Excel inefficiency

What are the 5 time-wasting activities that Excel users do without even thinking about it?

The end of PivotTables in Excel

Break through the PivotTable ceiling with formulas.

Web apps based on Excel models

Find out how to create apps with drag & drop based on complex Excel spreadsheets.

The magic of names in Excel

A collection of surprising examples, from basic to more complex scenarios, of how names are the must-have piece for certain Excel solutions.

Power Pivot and Power Query, the dynamic duo in data analysis

Learn why Power Query and Power Pivot are the best combination for a reliable Data Model and an extremely powerful Data Analysis solution.

How to build ready-to-use templates? With Some Insider Tricks

All pro tricks about building a template from scratch. From research to workflow, from navigation to other design tips. You’ll master your dashboard skills.

Copy/paste chart settings with VBA

How to use VBA to make report charts faster, easier, and less prone to error.

Implementing key design & DAX techniques in Power BI to enhance business insights

Extend your analytical insights with Power BI functionalities and improve your data storytelling with DAX.

Easy Excel automation with Power Automate

Discover how to automate processes using Power Automate, including reading and writing data from and to Excel.

Power up with 10 NEW Excel functions

Immediately improve your daily work with these 10 NEW Microsoft Excel functions.

Dynamic arrays, a LIFE changer

Victor demonstrates how to harness the power of dynamic arrays.

Excel automation: Which tool to use?

Discover the types of automation within Excel (Power Query/Power Pivot, LAMBDA, VBA, Office Scripts) and when one should be used over another.

The *NEVER SEEN* Tips & Tricks

Get ready for the Microsoft Office Expert (MOE) exam

Tricks, tips, and practice tasks on how to pass the Excel MOE exam.