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
Timeslot TBD 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.

coffee
Coffee break
Ellipse-green
Timeslot TBD 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.

Ellipse-green
Timeslot TBD Excel’s Evil And Hero Worksheet Functions
accordion
Details
Ellipse-grey
Charles Williams

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.

lunch
Lunch break
Ellipse-green
Timeslot TBD 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.

Ellipse-green
Timeslot TBD From Excel To Power BI
accordion
Details
Ellipse-grey
Matt Allington

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”.

coffee
Coffee break
Ellipse-green
Timeslot TBD TBA
accordion
Details
Ellipse-grey
TBA

Session description:

TBA

About:

TBA

LinkedIn Facebook  Twitter 

The order above is not final. One session is to be announced.

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