June 7 and 8, 2018
Dr. Liam Bastick FCA FCMA CGMA MVP
Liam has over 25 years’ experience in financial model development / auditing, valuations, M&A, strategy, training and consultancy. He has considerable experience in many different sectors (e.g. banking, energy, media, mining, oil and gas, private equity, transport and utilities).
Liam has headed Ernst & Young’s modelling team in Melbourne and was an Assistant Director in their strategic valuations team in London. He was also a senior member of the UK Post Office’s M&A and strategy teams, and has worked for / assisted various other Australian modelling companies including BPM, Corality, Navigator Project Finance, PKF and SumProduct.
He has worked in the UK, Australia, Belgium, Denmark, France, Germany, Hong Kong, Indonesia, Malaysia, New Zealand, Switzerland and Vietnam, with many internationally recognised clients, constructing and reviewing strategic, operational and valuation models for many high profile IPOs, LBOs and strategic assignments.
He is a regular contributor to the Institute of Chartered Accountants in Australia (ICAA), Certified Practising Accountants Australia (CPAA), the Chartered Institute of Management Accountants (CIMA), Finance 3.0 and various LinkedIn specialist discussion groups. He is also an experienced facilitator for ICAA.
Liam is a Fellow of the Institute of Chartered Accountants (ICAEW), a Fellow of the Institute of Chartered Management Accountants (CIMA) and is a professional mathematician.
Find Liam at www.sumproduct.com
Frédéric Le Guen
Frédéric has discovered Excel in 1996 (Excel 5) and he was immediately interested to explore the possibilities of this tool. This passion has led him to make his living out of Excel. He is now freelance consultant in Office development and Business Intelligence. He has worked for companies in France, Germany and Malta.
At the beginning of the web, he quickly realized the interest of sharing his knowledge through a website. Thus, he created his very first website in 1999 and in 2002 he has rebuilt its website to give birth to www.excel-exercice.com which is the most visited website about Excel for French speaking community. In 2005 he has created www.excel-exercise.com for English-speakers and he became an Excel MVP in 2010.
He has also written 4 books on Excel (all in French) about the way to create macros, Excel 2013, Business Intelligence with Excel and Power Query
He will present a complete solution based on Power Query to import data from the web to be integrated in a workbook. This demonstration will interest all the people who work with several currencies and who waste a lot of time converting values to their local currency.
About five years ago, David fell in love with Excel when he attended an online training program on building dashboards in Excel. Consequently, he found out about the work of data visualization expert Stephen Few (perceptualedge.com). David immediately was intrigued by overlap between data visualization, psychology and communications. Ever since, David is all about implementing data visualisation theory using bare boned Excel. David holds a Masters degree in cognitive psychology and published both his bachelor and master in the field of perception studies and real time visual feedback learning. Currently, he works as communications advisor for a large Dutch insurance company. David is the second prize winner of the state Migration Dashboard Contest, by Chandoo.org (Read more) and will launch his website www.excelusive.com during the Amsterdam Excel Summit 2016.
Tony de Jonker
Tony is a consultant and the owner of De Jonker Consultancy. He helps companies with specific knowledge on the cutting edge of business/finance and development of Office applications. Tony has over 36 years of business experience and has worked for renown national and international companies. Tony writes Excel columns for various technical magazines, among which the Dutch magazine “Tijdschrift Administratie”. Tony also features at various training classes by Kluwer: Masterclass, Dashboards, Projectmanagement and Infocharts. Tony received the Microsoft MVP Award in January 2015.
Gašper Kamenšek lives and works in Ljubljana, Slovenia. He’s a trainer at Kompas Xnet, where he tries to share his knowledge and enthusiasm about his digital love, Excel, with as many people as he can. When he’s not knee deep in Excel, he’s to be found somewhere in BI projects consisting either of PowerPivot and SQL, Excel and VBA and lately Power BI, which seems to be endless in its variations of applicability. The thing he finds most fascinating about Excel is that although he uses it every day, it still finds ways to surprise and amaze him. He has a blog at excelunplugged.com which is a testament to his amazement with Excel.
On 10.1.2016 he became a Microsoft MVP for Excel and after attending the Amsterdam summit as a bystander for two years running, this year he’ll take part in a new role, as a speaker for two sessions and is looking forward to seeing you there!
Avital is a Microsoft Program Manager, working on Excel Online and Excel Get Data. Joined Microsoft in 2017.
Prior to Microsoft Avital was a Project analyst at Intel and graduated her BSc In Industrial Engineering and Management and BA in Economics at the Technion- Israel Institute of Technology.
Before stepping into Excelguru Consulting Inc full time in May 2015, Ken spent over twenty years working in public practice accounting and industry as both Controller and an IT Director. Ken has led the installation of over a dozen systems conversions and implementations of various types, and been exposed to a vast amount of business systems, including point-of-sale systems, databases, and analysis tools, some of which he wrote from scratch.
Ken has also been an active participant in many Web forums since 2002, and hosts a website at www.excelguru.ca, which provides code samples for working with Excel, other Microsoft Office applications and free utilities. In fact, NASA has even made use of this site, using some of Ken’s PDFCreator examples to automate the production of PDF reports which monitor the power supply levels on the International Space Station.
In recognition of his contributions to the online community Ken has been recognized with the prestigious Microsoft Most Valuable Professional award every year since 2006. In March of 2013 Ken was also recognized as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island, and in November 2014, he was also recognized as a Fellow in the CMA Society; an honour given to less than 2% of CMA’s in their lifetime.
Ken has a passion for teaching people how to build business intelligence, specifically focusing on Excel and Power BI. He gets most excited about the topics he know will save YOU time and make you more efficient. Your software should work for you, and that’s his focus.
Oz du Soleil
Oz is a Microsoft Excel MVP and YouTube personality. His Excel videos are known for being bold, overly dramatic, sometimes brash, and his passion for clean data and effective use of Excel are always present.
After a layoff in 2008 Oz started freelancing as an Excel developer, and teaching Excel workshops. This exposed him to a vast array of data-related needs in businesses of all sizes, and in many industries. What eventually became clear was, “without clean data, there is nothing. No dashboards, no analysis, no insights, no nothing!” Thus, everything Oz does with data is rooted in concern for data quality and data literacy.
Oz co-authored Guerrilla Data Analysis 2nd Edition with Mr. Excel, Bill Jelen. Oz lives in Portland, OR; is a veteran of the US Navy, and is in a documentary about sriracha hot sauce, Sriracha: a Documentary by Griffin Hammond.
Tamar Tzruya Bar Zakai
Tamar Tzruya is a Principal Program Manager leading the Excel PM team at IL Dev Center. Joined Microsoft at 2009 and has worked in the Hi-Tech industry since 1995.
The Excel ILDC team is responsible for two critical Excel areas:
- Excel On line
- Get and Transform Data as part of the Excel BI strategy
Prior to joining the Excel team, Tamar worked on O365 Exchange Anti-Spam (Redmond), SQL-BI (Redmond) and UAG-DA (IL Dev Center).
Tamar has started her journey as an engineer at Rad communication, a manufacturer of xDSL Modems as part of the last mile solution, became an engineering lead. Moved to Nokia Siemens Networks Tech Israel, a manufacturer of Carrier Switches to enable convergence of Triple Play and business customer services over the same network infrastructure, claimed the management ladder and became Dev Director managing group spread over 4 countries.
She’s married has 3 kids (ages 18, 16, 10) and enjoys spending time skiing, exercise yoga, and working with clay.
Bob Umlas works for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients.
He has been using Excel since version 0.99 (on the Macintosh)!
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft every consecutive year since the very start of the MVP program, way back in 1993.
He is the author of “This isn’t Excel, it’s Magic!” which is available from http://www.iil.com/publishing as well as from Amazon.com. Another book, “Excel Outside the Box” is available from http://www.mrexcel.com and is for the very advanced Excel user. And most recently there’s “More Excel Outside the Box” also available from mrexcel.com.
He has been the technical editor for about 15 books on Excel.
At the completion of the 2013 world Excel Modeloff competition on 12/8/13, this was noted (see the last sentence):
“The winners were announced at Microsoft’s Manhattan offices Sunday afternoon. Four teams of finalists competed in four rounds of Excel Golf, trying to get the shortest formula to solve four particular problems. The Australia/New Zealand team won this event, sharing a $4000 prize. I’ll note that Excel MVP Bob Umlas was in the audience and twice offered formulas that were shorter than the winning formula”
Henk Vlootman has worked as an Excel trainer since 1992. In 2010, with the introduction of the self-service BI tools in Excel, he has taken a different path. Nowadays he is much involved in porting Excel Power pivot models to SQL Server Analysis Services and PowerBI.
Henk has been an Excel MVP since 2013. In 2016 he was awarded with a double nomination: Excel and Data Platform MVP. Henk has a great interest in the new Microsoft Power BI (desktop) product. He is board member of the Power BI User Group Holland. He has presented at Excel congresses such as the Dutch Excel Experience Days, the ModelOff congress and PowerBI meetings in The Netherlands and Canada. He also speaks at PASS SQL Saturdays in England, Germany and Holland.
Henk has written several Excel and Power Pivot books in the Dutch language. His newest book on Power Pivot (Co-author Michiel Rozema) is on the market since 2016. In 2016 Henk started a new company for Excel and Power BI training: www.NextLevelExcel.nl.