Over two days, the largest ever collection of the world’s best Excel experts – most recognised by Microsoft as their own staff or else coveted ‘MVPs’ or ‘Most Valuable Professionals’ – will show you how to really up your Excel game.

DISCOVER FRESH AND EXCITING WAYS TO UNLOCK THE FULL POTENTIAL OF YOUR DATA

Pose your most challenging problems to Microsoft’s Excel developers and experts
Find out how to visualise and present data so that it tells a clear story
Learn to create flexible financial models that enable rapid scenario analysis and sound decision making
Effectively manage and analyse large quantities of data from multiple data sources

PROGRAM

Time (UTC)

Presentation

Presenter

Language

00:00

TBC

Tim Heng

More details to follow.

Tim Heng

English

01:00

Inclusive and Accessible Excel

Glenna Shaw

How to make Excel files inclusive and accessible to everyone, including people that use assistive technology.

Glenna Shaw

English

02:00

The Perfect Data Input Table for Modern Excel

David Benaim

We all build data input tables but they can cause issues such as misspelling, manual colours and formula errors.  David will talk through the dozens of rarely used Excel features which help us to avoid these issues.  He will explore the new searchable data validation, the new TEXTSPLIT function, the “Format as table” feature and conditional formatting.  He will also explain how to best order your columns, and how to protect your formula cells without the cumbersome “Protect sheet” options.

David Benaim

English

03:00

TBC

Henrique de Albuquerque

More details to follow.

Henrique de Albuquerque

Portuguese

04:00

Build a Stock Portfolio Tracker with Excel

Indira Bandari

If you are a person who buys and sells shares and would like automated tracking of your stock performance then this is the right session for you.

In this session you will  learn how to build a stock portfolio tracker using Excel.

Indira Bandari

English

05:00

Sharing is Caring!

Sai Prasad B

We put in lots of effort building dashboards, reports, datasets, dataflows and much more in Power BI and struggle to share it with others.  Sharing the content to the wrong audience or with wrong permissions has a substantial impact on the business.  I will walk you through several options to show who can share items, with whom it can be shared, in what format items can be shared and how to share them.

Sai Prasad B

English

06:00

Human Resources Reporting Dashboard with Power BI & Power Query

Vincent Lacomme

In many cases Human Resources (HR) reporting is required internally for management as well as internal communication.  Accountants, auditors, HR and financial divisions can use Power Query and Power BI to automate this reporting and generate insightful indicators.

This session will guide you to use the main functions of Power Query and Power BI to produce effective reporting.  Many time-consuming tasks can be eliminated.
An example case will be used to show how you can use the main functions of M in Power Query and DAX in Power BI to process a payroll journal.

Vincent Lacomme

English

07:00

Excel VBA 101 - Automation Beyond the Macro Recorder

Mike Thomas

VBA is Microsoft’s programming and automation language that is built in to all the Office applications.  Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where it’s functionality and power ends.  To be able to anything more, you need to harness the power of VBA.

VBA is a fully-featured programming language which includes functionality such as conditional logic (IF..THEN..ELSE), Looping (the ability to perform a set of instructions a given number of times and variables (a fast way to process information).

At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows, accept user input and control and interact with other applications.

This training session is the first step in your VBA learning journey.  It is aimed at advanced users of Excel who have little or no programming experience and who wish to “dip their toe into the VBA water”.

Mike Thomas

English

08:00

Office Scripts and Power Automate Demo

Jan Karel Pieterse

Join Jan Karel for this session and learn how to:

  • Get started with writing Office Script
  • Write a script that adds a table of content to any workbook
  • Create a Power Automate flow that applies that script to all Excel files in a folder

Jan Karel Pieterse

English

09:00

Full Circle of Data with the Power Platform

Gašper Kamenšek

This session will take us through the creation of a Form to gather data.  Then we will use Power Automate to push that data into Power BI live.  Then we will also use Power BI to connect to the original Excel file that the Form is populating.  And finishing off, we are going to create a Power App that will enable us to change the data, which will allow us to change the dataset straight from Power BI and therefore complete the circle.

Gašper Kamenšek

English

10:00

How to Become a DAX Master: Context in Power BI

Henk Vlootman

Working in Power BI involves working with DAX, relationships management and calculations over multiple tables. In a Power BI or Power Pivot model lives different kinds of context, depending on the DAX calculation within or without a visualization. Recognizing this context is crucial for very in-depth calculations over different tables. This session explains the different kind of context and how to work within them.

 

Five bullets:

  • The different kind of context: Query, Filter and Row context
  • Filter context: CALCULATE
  • Table functions: watch the X
  • Mixing the context
  • Bringing it all together: demo of a FTE model

Henk Vlootman

English

11:00

Synchronise Planner Plans into Power BI using Power Automate

Ben Howard

Microsoft Planner is a fantastic tool to help track and manage projects, unfortunately it is a reporting black hole; this frustrates enterprises and organisations worldwide.  To solve this problem we can use Power Automate, SharePoint and Power BI to create a unique solution that not only provides a rich reporting solution that enables organisations to see the status of the tasks in all of their plans, but it also does this automatically!!  Join me in this session to learn how to build this solution, where to download it, and hands on demos to show you how to set it all up.  Delegates will be able to download the files necessary to configure their own solution.
Learn how to use Power Automate to access Planner Plans
Learn how to update Excel files using Power Automate
Learn how to link a Power BI template into Planner data to obtain an organisation-wide view.

Ben Howard

English

12:00

DAX: Common Questions and How to Tackle Them

Miguel Felix

The usage around Power BI brings a lot of doubts, especially when talking about DAX we get to the conclusion that DAX is simple, but it is not easy.  In the community, every day there are new questions however some are recurrent, and in this session, we will talk about some of the most common questions in the community and how we can solve them.

Miguel Felix

English

13:00

Creating a Dynamic Actual versus Budget Report using Power Query & Power Pivot

Tony de Jonker

Actuals are administered at a deeper granularity than Budget numbers.  In addition, the method of recordkeeping is different.  During this session you will see how to deal with these problems and use the power of Power Query and Power Pivot to create one all-encompassing dynamic Excel Model.

Tony de Jonker

English

14:00

Creating Excel charts that are easy to update and re-use

Dave Paradi

Excel charts are a key way to communicate financial analysis and results.  Often the charts we create need to be updated each month or quarter.  And often one chart needs to be duplicated for each product, region, or segment we report on.  This can take a lot of time unless you plan how to create a chart that is easy to update and re-use.  In this session you will learn how to structure the chart worksheet, and techniques to make re-use of the chart for similar data much easier.  The session will cover the approaches and demonstrate them using real-world examples.

Dave Paradi

English

15:00

PivotTables and Dashboards

Nabil Mourad

Creating dashboards using PivotTables and PivotCharts with charts simulating Power BI reports; chart cross-filtering and charts in a Tooltip on hovering the mouse.

Nabil Mourad

English

16:00

Special Uses for Go To in Excel

Bill Jelen

Take a deep dive into the ‘Go To’ and ‘Go To Special’ dialogs in Excel.  When can you use them?  What secret powers are unlocked with ‘Go To Special’?

Bill Jelen

English

17:00

Become a Modern Excel User

Yolanda Cuesta

Get to know the most current Excel tools such as the LET functions, LAMBDA, the BI add-ins in Excel, the integration with the Microsoft Power Platform (specifically in Power Apps) as well as the characteristics of the new Low Code programming language called Power FX (Spanish: Conoce las herramientas más actuales de Excel como son las funciones LET, LAMBDA, los complementos BI en Excel, la integración con la Power Platform de Microsoft ( en concreto en Power Apps) así como las características del nuevo lenguaje de programación Low Code llamado Power FX).

Yolanda Cuesta

Spanish

18:00

Cleaning data with Power Query is Something from Real Life

Ana Maria Bisbe York and Natalia Gómez Ríos

A BI project begins with data processing.  In this session, we will look at the steps I had to take to clean the data in a real customer scenario using Power Query in Excel.  Data quality problems will be solved, the structure will be adjusted according to an excellent tabular model, and the different business requirements we face will be met.

Ana Maria Bisbe York and Natalia Gómez Ríos

English

19:00

Creating an Income Statement Dashboard

Bernard Obeng Boateng

The goal of this session is to show participants how to create a dynamic Income Statement dashboard.  From a simple trial balance, we will model our Income Statement using Power Query, Power Pivot and CUBEFUNCTIONS and then create a stunning visual that will bring all the lines in the Income Statement to life.

Bernard Obeng Boateng

English

20:00

Classic Power Query & PivotTable Advanced Tricks

Abiola David

In this Power Query presentation, we will learn how to import multiple tables, create snowflake merging and write classic Power Query formula using M Code.  The presentation will also cover advanced PivotTable Tricks.

Abiola David

English

21:00

Excel Charting - Smoke and Mirrors

Jon Peltier

This presentation will share powerful but non-obvious techniques that enable you to produce special visual effects in Excel Charts.

Jon Peltier

English

22:00

Custom functions in Power Query - How they can improve your game!

Alejandra Horvath

    • What custom functions (CFs) are  and how to create them
    • How CFs can work for you!
    • Example connecting and transforming several messy reports from Excel, by creating a CF
    • Q & A

Alejandra Horvath

English

23:00

Quick Tricks with New Excel Functions

Cristiano Galvao

Microsoft Excel has been the undisputed leader in spreadsheet software over decades.  We do all kinds of reports with it and Microsoft is listening to us to make the software even better.  Check out, in this talk, the latest releases in terms of new functions.  Cristiano Galvao will show you different examples of formulas in action, by using 18 new Excel functions that will unleash the power of your reports and controls.  If you love Excel formulas, you cannot miss it!

Cristiano Galvao

English

Time (UTC)

Presentation

Presenter

Language

0:00

TBC

Talia Cao

More details to follow.

Talia Cao

English

1:00

Excel Charts with Dynamic Arrays

Carlos Barboza

Learn how to build interactive Excel charts using Excel’s new functions: Dynamic Arrays.  With these new friends, the implementation of making interactive charts is easier than before.

Carlos Barboza

English / Spanish

2:00

What’s New in Excel

Elisabetta Caldesi

What’s new in Excel!!

Elisabetta Caldesi

English

3:00

Seven Sanity Savers: Avoid being tied to your Power Queries forever

Kathryn Newitt

If you’ve ever had to fix a bug in someone else’s Power Query or even tried to go back to that clever code you created months ago, you’ll know that it can be hard to fathom what that M code is doing.  I’ll run through seven tips to ensure that anyone can pick up your queries and understand the purpose of each step.

Kathryn Newitt

English

4:00

Better Data Visualization in Excel

Jon Schwabish

Everyone who works with data needs to communicate their findings, their analysis, and their conclusions.  It could be in an internal briefing or memo, a management report, an annual report or a scientific article.  Though there are more and more tools available to analyze and visualize data, Excel continues to be the leader in the field, used by millions around the world every day.  In this presentation, I lay out the basic philosophy of how to expand the capabilities of Excel to create better, more effective data visualizations.

Jon Schwabish

English

5:00

When Excel meets Power Automate desktop (PAD) or Exploring Excel's union with Power Automate Desktop

Victor Momoh

The session will explore some creative uses of Power Automate desktop in automating some excel tasks.  This would range from performing a find and replace across multiple worksheets and workbooks in a folder, quickly renaming worksheets across multiple workbooks and sending emails through outlook with data stored on the Excel workbook.  This will all be achieved by writing very minimal code.

Victor Momoh

English

6:00

Financial Modelling in Power BI (An Overview)

Liam Bastick

More details to follow.

Liam Bastick

English

PLEASE NOTE

The following agenda has been put together in good faith with the topics and presenters as cited.  However, we do reserve the right to change the order, the timing, the topic or presenter for circumstances beyond our reasonable control (e.g. presenter sickness, transportation issues, change of functionality in Excel, etc.).  If you have any concerns, please contact us.

Excel Virtually Global is an independent conference and is neither sponsored nor approved by Microsoft.

OUR PARTNERS

Any Questions?

SUBMIT