Register
A1
A B C D E F G H I J K L M N O P R S T U V Z

Conference

Inspiring Excel sessions from industry leading experts.

accordion
Expand all
Ellipse-green
9:00 – 9:30 Keynote
accordion
Details
Ellipse-grey
Gašper Kamenšek

Session description:

The keynote and official opening of the 2019 Excel Olympics conference presented by Gašper Kamenšek

About Gašper Kamenšek:

Gašper Kamenšek is a BI Professional and an MVP for Excel from Slovenia. In addition to providing training and speaking at conferences in Slovenia, he travels the World spreading the Excel and Power BI love.

Ellipse-green
9:35 – 10:25 What’s new in Excel
accordion
Details
Ellipse-grey
Guy Hunkin
coffee
Coffee break
Ellipse-green
10:40 – 11:30 Making The Impossible Possible With Dynamic Arrays
accordion
Details
Ellipse-grey
Liam Bastick

Session description:

Want to see the future of Excel? Not currently available to everybody, dynamic arrays will be with Office 365 in the near future. You have Office 365? Get excited. You don’t have Office 365? Get Office 365, then get excited.
If you have ever wanted to:

  • generate a sorted list of unique items in a dataset using a very simple short formula
  • filter data using a formula rather than employ filter buttons manually
  • create a PivotTable that doesn’t need to be refreshed
  • unpivot a Pivot Table without having to refresh
  • create a model that will automatically extend both horizontally and vertically
  • find a more efficient alternative to what-if? analysis using Data Tables.

then dynamic arrays are for you. Excel’s moving on. Will you be?

About Liam Bastick:

Liam has over 30 years’ experience in financial model development / auditing, valuations, M&A, strategy, training and consultancy. He has headed Ernst & Young’s modelling team in Melbourne and was a Director in their strategic valuations team in London. He has worked in the UK, Australia, Belgium, Denmark, France, Germany, Hong Kong, Indonesia, Italy, Malaysia, Netherlands, New Zealand, Singapore, Switzerland, United States and Vietnam, with many internationally recognised clients, constructing and reviewing strategic, operational and valuation models for many high-profile IPOs, LBOs and strategic assignments.

Ellipse-green
11:35 – 12:25 Excel’s Evil And Hero Worksheet Functions
accordion
Details
Ellipse-grey
Charles Williams
lunch
Lunch break
Ellipse-green
13:25 – 14:15 From Excel To Power BI
accordion
Details
Ellipse-grey
Matt Allington
Ellipse-green
14:20 – 15:10 Work Smarter With Advanced Formulas
accordion
Details
Ellipse-grey
Leila Gharani

Session description:

This set of advanced Excel formulas is all you need to solve complex lookup problems. When we’re pressed for time, we solve our problems by copying & pasting formulas from Excel forums or our colleague’s files but we rarely take the time to understand the engine behind the formula. In this session you will learn a handful of Excel formulas that will enable you to work faster & smarter:

INDEX for Flexible Lookups

SUMPRODUCT for the Experts

Dynamic Arrays to the rescue

About Leila Gharani:

Leila Gharani is an Microsoft Excel MVP and instructor specializing in dashboards and visualization techniques. She is a Microsoft Certified Excel Expert and has over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature.

Session description:

A review of Excel’s most evil functions and most heroic functions, and the reasons they are evil or heroic.
The best ways to exploit the power of these functions and avoid evil consequences.

About Charles Williams:

Independent Excel consultant for over 20 years: fanatical about Excel calculation performance and extensibility.
Author of the Microsoft MSDN white papers on Improving performance of your Workbooks.
Author of the FastExcel, SpeedTools multi-threaded function library, Manager Pro and Name Manager addins.
Microsoft Excel MVP since 2009.

coffee
Coffee break
Ellipse-green
15:25 – 16:15 M Is For Data Monkeys
accordion
Details
Ellipse-grey
Ken Puls

Session description:

One of the things we love about Power Query is that you can do amazing things with just a few button clicks. But did you know that behind the scenes, Power Query performs Magic via a coding language called M? In the perfect world, you’d never need to look at this code at all but – as with all coding languages – you can do much more if you’re willing to get your hands dirty.
In this session Ken will provide some simple M tricks to do amazing things. Building a calendar table in seconds, numbering grouped rows, and speeding up a table with a little buffer action.

About Ken Puls:

Ken Puls, FCPA, FCMA, is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.
Ken has held the Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. He is also one of about 4% of CPA’s to be recognized as a Fellow of his accounting body.

Session description:

All business users that work with data have used Excel, but despite this, many people still find it hard to get started with Power BI. This session will show you how to get started with Power BI so you can take your Excel worksheets to the next level. This is an absolute beginner lesson where I cover tips and tricks to get started using Power BI from the mind set of an Excel user. I explain the differences between the tools and how you should approach using Power BI compared to Excel.

About Matt Allington:

Matt Allington is a career expert in BI and has 30+ years’ experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Pivot for Excel and Power Query. He brings his business and IT experience to the table to get fast and effective results through training, consulting and general business data problem solving. Matt is the author of the book “Supercharge Power BI – Power BI is Better When You Learn to Write DAX”.

Session description:

During this session you will learn about new and exciting ways to explore and analyze your data in Microsoft Excel, including the ability to ask questions and get answers using Natural Language, new additions to the “Excel Ideas” feature powered by ML based engine, and cloud-connected geography & stocks data types. Unlock new scenarios and simplify the creation of your spreadsheets with the latest core capabilities like multi-user collaboration, brand-new Dynamic Arrays, latest XLOOKUP function and more.

About:

Guy is a Principal Program Manager in Microsoft. Since joining Microsoft Guy has been working in the Excel team, focusing on improving of business analytics experience and integration of Power BI tools in Excel. For the last couple of years Guy was mostly busy working on the next generation of Data Import and Shaping experience in Excel. Prior to joining Microsoft, Guy was a Director of Product Management in a gaming industry and held various engineering positions before that.

Registration
Register

For the proper functioning of this site, sometimes small data files, called cookies, are loaded onto your device. System cookies that are necessary for operation are already allowed. However, your choice is to allow or deny analytics and marketing cookies that offer a better user experience, easier use of the page, and an overview of the offer that is relevant to you. About cookies