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 (GMT)

Presentation

Presenter

Language

17:00

Welcome / Dynamic Charts

Liam Bastick

This session welcomes you all to the event and also considers common issues in charting, such as:

  • Extending ranges
  • Hiding data
  • Dynamic labelling of titles
  • Dynamic labelling of, er, labels.

Liam Bastick

English

 

18:00

Reading Real-Time Data into Excel with Data Streamer

Cristiano Galvao

In this session, we will discover a very little explored feature of Excel: the Data Streamer. Using an Arduino board connected to a computer and some sensors, we can make data flow into Excel in real-time reading them with Data Streamer. By creating some formulas and charts, we can produce a powerful data visualization tool to give us instant metrics and insights. As a bonus, you will see that with Data Streamer we can also control external devices using Excel.

Cristiano Galvao

English

19:00

Excel Tips and Tricks

Bob Umlas

A potpourri of miscellaneous Excel tips and tricks.

Bob Umlas

English

20:00

Cheating with Charts

Jon Peltier

I was emailing a colleague about “charting”, but AutoCorrect changed it to “cheating”.  That made me realise that so much of what I do with Excel charts is somehow cheating, using smoke and mirrors to achieve the visual effects I need.  This presentation will cover a number of ways in which I cheat with my charts, e.g.

  • how do I draw lines where I want them
  • how do I put a label where it makes most sense
  • how do I highlight important individual points in a chart.

Jon Peltier

English

21:00

Collaboration

Adam Callens

Adam Callens

English

22:00

Easier Excel BI Modeling with Monkey Tools

Ken Puls

HOW MONKEY TOOLS HELP EXCEL BI MODELLERS

This session will demonstrate how Ken’s Monkey Tools add-in can help you build better Excel BI models faster, and audit models that you receive from others.

Ken Puls

English

23:00

Pleb vs Pros: How to Look Like You use Excel for a Living

Tim Heng

This session is all about taking typical, “basic” approaches to solving problems and making a few small tweaks to make it look like an Excel pro has put it together.  We are going to show you how the way you use functions and features in Excel can make you look like a pleb, and what you can do instead to look like a pro.

Tim Heng

English

Time (GMT)

Presentation

Presenter

Language

0:00

Mind-Blowing PowerPoint for Effective Visual Storytelling

Richard Goring

Excel is an awesome tool for calculations, formulas and managing data.  But what about when you need to share it with others?  You’ll often do a presentation, and that’s where PowerPoint comes in.  PowerPoint is such an essential tool for all types of communication, but it’s badly used.

RevolutioniSe your content with amazing visuals, engage your audience with compelling animations, and impress them with beautiful, professional design.  All using only PowerPoint.  You’ll see a host of visual storytelling techniques, all demonstrated live, that you can use immediately to create amazing presentations or interactive content.  It will contain ways to improve upon Excel-based charts with formatting and animation for better storytelling, and then into more custom charting and more in-depth visual storytelling.  All using only PowerPoint (well, and a bit of Excel).

Participants will be able to:

  • Create dynamic visuals that support persuasive stories to engage your audience
  • Develop professional looking designs for presentations and other content
  • Become a PowerPoint legend with techniques to make effective presentations quickly and easily.

Richard Goring

English

1:00

The Sensual Six: All of Power Query's Joins Explained

Oz du Soleil

If you work with datasets that need to be merged, compared or segmented, Power Query’s joins are important to know.  They are designed to simplify and automate those needs.

These can be a little tough to understand, but this session is designed to go step-by step to give you a solid foundation for understanding and using these hot tools.

The session will cover:

  • all six joins
  • when to use a join instead of VLOOKUP or XLOOKUP
  • ways to be efficient with joins
  • real world complexities and warnings.

So relax.  Get mellow while Oz guides you on this journey through all of the six joins in Excel’s Power Query.

 

Outline

  • Overview of joins:
    • Full Outer Join
    • Inner Join
    • Left Outer Join
    • Left Anti-Join
    • Right Outer Join
    • Left Outer Join
  • Complex Joins
  • Multiple criteria
  • Merge for Categories instead of Exact Matches
  • Using a Reference Table for Inconsistent Entries
  • Real World Examples.

Oz du Soleil

English

2:00

Excel跨平台扩展解决方案

Raymond Lu

介绍Excel Add-in平台。通过Add-in平台来构建解决跨平台方案,可以使用熟悉的 Web 技术,例如 HTML、CSS 和 JavaScript 来扩展Excel,并与其进行交互。解决方案的优势包括可以跨多个平台运行,包括Windows、Web、Mac 和iOS;借助单一登录, Add-in可以与用户的 Office 365 帐户轻松集成; 通过将代码托管在开发者所指定的Web服务器上,可以轻松地对它进行维护和更新;另外开发者可以将Add-in上传到Office Add-in Store,也可以由管理员在整个组织内集中部署,以便更多的用户下载使用。

本课程还邀请到Oracle的研发经理George Huang来给大家介绍Oracle使用Excel Add-in的真实解决方案案例。

大纲:

  • 什么是Office add-ins
  • Office Add-in优势
  • 真实解决方案案例介绍和演示
  • 如何快速上手?

 

Using the Office JavaScript APIs and capabilities like custom functions, learn how you can build powerful and rich experiences for users across Excel for web, Mac and Windows, and build / make your solutions available through Microsoft App Source and the Office Store.

Outline:

  • Learn about Office add-ins
  • Learn about what’s new
  • Demos / example customer solutions

See how easy it is to get started with great tools such as Script Lab and Visual Studio Code.

Raymond Lu

Mandarin

3:00

Excel妙招搞定数据处理与分析 (Tips for Data Processing and Analysis in Excel)

Qinglin Zhou

Outline:

介绍最新版本中Excel关于数据处理与分析的几个重要技巧,包括多表格合并汇总生成数据透视表,数据表格快速美化,借助PowerMap生成数据地图等

(To introduce some key methods of data processing and analysis in the latest version of Excel, including multi-table consolidation to generate PivotTables, quick beautification of data tables, generation of data maps with PowerMap, and more.)

In Mandarin.

Qinglin Zhou

Mandarin

4:00

Introduction to DAX

Matt Allington

Power BI is a powerful tool to help you analyse your data.  While it is possible to simply drag columns of numbers into a report, this approach only scratches the surface of what is possible.  If you want to be good at using Power BI, you must learn to write DAX.  In this session, Matt Allington will provide an overview of how to use Power BI with and without the DAX language, and explains the benefits of learning to do more than just the basic drag and drop of columns.

Matt Allington

English

5:00

Create a Basic Quiz in Excel with Conditional Formatting

Indira Bandari

Data Validation and Conditional Formatting are great features in Microsoft Excel.  In this session, you will learn to create an interactive quiz in Microsoft Excel using these features.  You will also calculate the score based on the values selected.

Indira Bandari

Telugu

6:00

Charting a Virus - Dashboard Challenges in Excel and Power BI

Ingeborg Hawighorst

When COVID-19 case numbers were still low in New Zealand, there were no visuals to illustrate how the virus was spreading. I set out to build a dashboard using the official data from the government web site.  I’ll walk you through the challenges I faced and the workarounds I used with Excel and Power BI.  If you’ve ever looked at a COVID-19 chart, this session is for you.

Ingeborg Hawighorst

English

7:00

Top 15 Tips and Tricks in Excel

Medha Bandari

In this session you will learn the below tips and many more

  • How to insert multiple lines
  • Move rows and columns easily
  • Lists
  • Freeze Panes
  • Filter
  • Flash and auto fill
  • Text to columns
  • Conditional formatting

Medha Bandari

English

8:00

Lists in Power Query - A Hidden Gem

Gasper Kamensek

To clarify, they are not as much hidden as nobody uses them to even half of their ability.  This demo driven session will be all about using lists in different scenarios in Power Query. 

Gasper Kamensek

English

9:00

Excel vs Google Sheets: Crazy Cool Features Available in One but Not the Other

David Benaim

Google sheets has some mind blowing functionality that will shock even the most advanced Excel users.  Since unlocking the power of Google Sheets last year, many of the spreadsheet solutions I create relies on both mediums to do different things.

Despite simultaneous editing being available in Excel, Sheets is still shining above and it is especially important during the pandemic.

Collaboration benefits are just one thing which Sheets does better including data validation, protection and use of images.  On the flip side, modern Excel has some great things that google doesn’t.

This talk is applicable to daily users of Excel & google sheets from beginner to advanced.  This article I wrote might give you an idea of what’s to come. https://ion.icaew.com/itcounts/b/weblog/posts/excel-tip-of-the-week-240—6-things-google-sheets-does-better-than-excel

We will also discuss the revolutionary new “Dynamic Array” functionality (and how that differs between Google and Excel).  Each app does it differently and each offers advantages the other cannot.

David Benaim

English

10:00

How to build a check list using Excel? - Excel లో చెక్ లిస్ట్ చెయ్యడం ఎలా?

Purna Chandra Rao Duggirala

The session will do exactly what it says on the tin, showing you how to build a checklist in Excel.  In Telugu.

Purna Chandra Rao Duggirala

Telugu

11:00

Integrating Python and Excel

Tony Roberts

How to write Excel add-ins in Python and seamlessly integrate Python into Excel. Learn why Python is the leading programming language for data science, machine learning and AI, and how you can leverage that power from Excel.

In this session, Tony will introduce you to Python and explain why it has taken the world by storm. We will also look at how Python and Excel can work together, including writing and using Excel add-ins written in Python.

 

Session outline

  • Introduction to Python
  • Overview of Python tools for Excel
  • Writing UDFs and Macros in Python
  • Demos of Python-powered Machine Learning and AI in Excel.

Tony Roberts

English

12:00

Mapping Your Data Using 3D Maps or the Filler Map Chart

Bill Jelen

Course Outline:

Using Geography Data Types to Retrieve Data

A) Filled Map Charts

  • Filled Map Charts by Country
  • Filled Map Charts by State
  • Filled Map Charts by Postal Code
  • Filled Map Charts using text instead of numbers

B) 3D Maps

  • Creating a map from a single data set
  • Assigning colours by category
  • Navigating in the map (Zoom, Rotate, Perspective)
  • Animating data over time
  • Understanding the time options
  • Layer options for individual house addresses
  • Real estate mapping
  • Building a Tour and a video
  • Creating a map from multiple data sets

Bill Jelen

English

13:00

Excel Blueprint: How to use the Modern Power Tools to Become an Excel Hero

Jon Acampora

Learn what the new “Power Tools” (Power Query, Power Pivot, Power BI) are and how they work.  I share my 5-Step Blueprint for Excel which explains how existing tools like formulae, PivotTables, macros and VBA might fit into your workflow.  You will learn ways to automate Excel, save time with your job and become the Excel Hero of the office.

Jon Acampora

English

14:00

Testing Spreadsheets - Quality Assurance in Excel and VBA

Patrick O’Beirne

This 45-minute session is based on current concerns about risks from the uncontrolled use of spreadsheet-based information systems.  Real statistics on error rates are presented which will provide you with evidence for the case for better control.  Good practices are presented for error detection, correction and prevention. These are appearing in new syllabuses for skills certification.  I cover how to assess risk in the context of spreadsheet criticality, and a process of high level and detailed reviews.  I conclude with a review of software tools on the market to facilitate the audit process.

Contents

    1. Current concerns – spreadsheet hell
    2. What’s the problem? – what happened
    3. Metrics for Error & Rework Rates
    4. How to manage risks & user training syllabus
    5. Good practice: Prevention, Data Control, Detection
    6. Risk assessment, scoping, questions, maturity model
    7. High level & detailed review and testing
    8. Management process, what not to do
    9. Software tools, VBA analysis, some product screenshots
    10. Summary

ADDITIONAL RESOURCES TO BE PROVIDED (the take-aways):

    • List of references to useful web sites
    • Articles on spreadsheet risk management
    • Access to evaluation version of XLTEST tool for spreadsheet audit

Patrick O’Beirne

English

15:00

Building Excel Chart Worksheet Templates

Dave Paradi

Regularly updating charts with new data every month takes a lot of time. In the coronavirus pandemic, many financial professionals were forced to be updating charts every day and the normal monthly workload was multiplied many times over. This session shows you how to build a chart worksheet so that when the new data is available, the chart is automatically updated. It will cover structure of the worksheet, approaches to chart creation, and some of the helpful functions that are used.

Dave Paradi

English

16:00

Excel-DNA in Perspective

Govert van Drimmelen

The .NET development platform is embraced by millions of programmers across industries and throughout the world.  Excel is the most popular computing power tool, and with its built-in VBA language brings an approachable programming environment tightly coupled to the functional spreadsheet modelling interface. Excel-DNA is an integration library that glues .NET into Excel, bringing together these tools and also their respective user communities.

I will share some of my perspectives on what happens when these worlds interact – both the joys and the tensions.  VBA enthusiasts might like to approach the contemporary development ecosystem without leaving the end-user agility and power of Excel – even if they find Visual Studio overly complicated, or GitHub and the NuGet package manager are strangers.  Likewise, .NET developers can reach a new power-user audience for their back-end services and software libraries by embracing Excel as a powerful presentation and interaction front-end.

Govert van Drimmelen

English

17:00

Create Dashboards in Excel with Data from MS Project

Raphael Santos

Join us on this hands-on session to learn how you can use Microsoft Excel to obtain data from multiple MS Project schedules, creating a report that consolidates the portfolio of projects and their performance.

Raphael Santos

English

18:00

Building Faster Excel Solutions

Charles Williams

  • Learn how to build fast Excel solutions
  • Understand the available Excel extensibility technologies
  • Speed up slow VBA solutions 100 or 1000 times
  • Object model extensions for Dynamic Arrays and new Data Types

Charles Williams

English

19:00

Matrizes Dinâmicas, Novas Funções e seus Equivalentes nas Funções Nativas

Alessandro Trovato

(Dynamic arrays, new functions and their equivalents in native functions)

Microsoft has released many functions for Excel Insider, but we may replace most of them with the functions already in the application.  In my talk, I will demonstrate how these resources may be used, even for those who do not have the functions of Insider.

In Portuguese.

Alessandro Trovato

Portuguese

20:00

Build Add-ins for Microsoft 365

Keyur Patel

Using the Office JavaScript APIs and capabilities like custom functions, learn how you can build powerful and rich experiences for users across Excel for web, Mac and Windows, and build / make your solutions available through Microsoft App Source and the Office Store.

Outline:

  • learn about Office add-ins
  • learn about what’s new
  • demos / example customer solutions
  • see how easy it is to get started with great tools such as Script Lab and Visual Studio Code.

Keyur Patel

English

21:00

Calling OAuth2 API's in Excel or Power BI using Power Automate

John MacDougall

Power Query can’t handle OAuth 2 API’s, but we’ll see how we can use Power Automate’s custom connectors to call any OAuth2 API and return data.

John MacDougall

English

22:00

Advanced Data Validation (using Classic Functions or Dynamic Arrays)

Nabil Mourad

Data Validation allows us to control what can be entered in sheet and what cannot. There are eight options to select from. Dropdown lists are one of them.

Dropdown lists can be a game changer to add interactivity to our worksheets.  We can use them to switch Charts, to turn Conditional Formatting On and OFF, to pick up pictures, to switch functions, change source files for Power Query or even to change a Dashboard.

In this session, I’ll be exploring different types of dropdown lists (remember the 5 Ds):

  • Dynamic
  • Dependent
  • Diminishing
  • Discoverable
  • Drop Lists.

Nabil Mourad

English

23:00

A little Python + A little Azure SQL + A Little Excel JS API + A little Power BI = A National Magic

Michael Olafusi

After being disappointed by too many software developers, I decided to create the financial markets and macro-economic data interactive app I wanted using a little bit of Python, a little bit of Azure SQL, a little bit of Office JavaScript API and a little bit of Power BI. I ended up with an Office Add-in and a live Power BI dashboard that is the most popular in its category in my country and used by many financial/research analysts. I will walk you through how I achieved this and hopefully expand your mind on how much magic (even a national magic) that can be achieved by mixing Excel and/or Power BI with other tools.

Michael Olafusi

English

Time (GMT)

Presentation

Presenter

Language

0:00

Intelligence

Mar Gines Marin

Join this session to learn more how we are using intelligence to unlock the power of Microsoft Excel for more users.  We’ll cover capabilities such as Natural Language Queries, Recommended Charts, PivotTables, and Ideas, as well as how our approach aligns with Microsoft’s Responsible AI standards.

Mar Gines Marin

English

1:00

The Rise of XLOOKUP – The 3rd and Best in the Trilogy of VLOOKUP and INDEX MATCH

Wyn Hopkins

XLOOKUP is the new killer Excel feature, it will kill off VLOOKUP and INDEX MATCH. As at the end of July 2020, everyone on Microsoft 365 should have XLOOKUP available.

In May 2016, Wyn posted an Excel User Voice suggestion for a simpler and safer version of VLOOKUP and INDEX match.

Four years on he’s now demonstrating on why we needed XLOOKUP, how to use it and highlighting the true potential of this awesome new function.

Wyn Hopkins

English

2:00

Date Based Calculation with DAX: Time Intelligence

Reza Rad

Year to date, Quarter to date, Previous Year to date, Rolling 12 months sales, sales same period last year and many other date-based calculations can be implemented using DAX functions in Power BI or Excel.  In this session, you will learn how to write DAX measures that give you date-based calculation results.

Reza Rad

English

3:00

Visualising Time

Glenna Shaw

  • Visualizing time in PowerPoint
    • Timelines
  • Formatting time in Excel
  • Visualizing time in Excel
    • Line charts
    • Timelines
    • Gantt charts
    • Clock charts.

Glenna Shaw

English

4:00

Most Comprehensive Excel Example. Ever.

Liam Bastick

This session takes an age-old Excel problem for making lists more manageable by combining the new (dynamic arrays, new functions and operators), with the old (data validation, custom number formatting, conditional formatting), the ugly (deliberately creating errors, and using non-auditable functions like INDIRECT) and the under-used (Tables, text functions and TRANSPOSE).

Whether the example strikes a chord is not the issue; the emphasis is showing how many different areas may be brought together to work collaboratively.  Bring your best speed-reading glasses, a healthy sense of humour and a seat belt, because you are going to have to strap in for this ride, baby.

Liam Bastick

English

5:00

How to Convert Address to GPS Coordinates

Frederic le Guen

Here’s how to convert address to GPS coordinate, and the other way round. It’s so easy to visualise data on a map when you have the GPS coordinates but when you have just the address, the localisation may not be accurate.

This session will show you how to convert your address to GPS with just two Excel formulae.

 

Convertir ses adresses en coordonnées GPS et l’inverse.

Il est très simple de visualiser la position de ses contacts sur une carte quand on dispose de coordonnées GPS. Par contre, avec une adresse standard, la position sur une carte est plus compliquée.

Cette session va vous apprendre à convertir vos adresses en coordonnées GPS avec seulement 2 formules Excel.

Frederic le Guen

English and French

6:00

Dynamic Report Using CUBE Functions

David Abiola

Brief Outline:

  1. Data Prep and formatting
  2. Loading data into the Data Model
  3. Create Relationship
  4. DAX Measures
  5. Cross Tabular Report using CUBEMEMBER, CUBERANKEDMEMBER & CUBEVALUE Functions

David Abiola

English

7:00

Understanding Ranges and Tables: the Key to Building Structured Excel Models

Henk Vlootman

Building an Excel model is a highly disciplined game.  It doesn’t matter whether it is an easy or complex model, structuring your data is the base of creating efficient and reliable models. Getting to know how ranges and tables work will give you a design head start.  The five layers of modelling model is used to understand the nature and structure of data in an Excel model.

In this session, Henk shows you the basics of modelling in Excel with ranges and tables, the way formulae work, and a lot of tips and tricks on how to use them.

Session outline:

  • Five layers modeling in Excel
  • Definition of ranges and tables in Excel
  • Working with cell references and names.

Henk Vlootman

English

8:00

Scenario Calculations with Power Query

Imke Feldmann

Power Query has some neat options to make scenario calculations in Excel or Power BI very convenient.  In this session, the benefits and basic building blocks will be shown.

Imke Feldmann

English

9:00

What's New in Microsoft Excel

Guy Hunkin, Danielle Rifinski Fainman & Jonathan Kahati

Join this session to discover how modern Excel can help you tackle the challenges in modern work.  Ask questions and get answers using natural language and AI, collaborate with others and do more in less time using Office Scripts.  Simplify the creation of your spreadsheets with new Dynamic Arrays and XLOOKUP, unlock new scenarios with an enhanced integration with Power BI and more.

Guy Hunkin, Danielle Rifinski Fainman & Jonathan Kahati

English

10:00

How to Use R Language in Excel

Grzegorz Stolecki

R is a very popular programming language used by statisticians, data scientists and analysts.  With thousands of additional packages, stunning visualisations and ready-made analytical functions, it can be a very precious tool in your Excel workshop.  During this session, Grzegorz will show you how to integrate R with your spreadsheet using BERT – Basic Excel R Toolkit.  Be prepared for a lot of demos showing how R can use Excel and how Excel can use R.

Grzegorz Stolecki

English

11:00

The Magic of Conditional Formatting and More Useful Tips and Tricks in Excel

Boriana Petrova

  1. Create basic formula
  2. Highlight cell when contract finish
  3. Highlight weekends or create holiday plannner
  4. Compare profit by year

Boriana Petrova

English

12:00

Storytelling con datos en Excel

Yolanda Cuesta

Learn how to give greater customisation to your reports and charts with Excel and its Power add-ons to be able to stand out in your profession.

Do your work with memorable Excel spreadsheets and help the easy interpretation of data to make better decisions.

In Spanish.

Yolanda Cuesta

Spanish

13:00

Financial Modelling Tools

Tony de Jonker

During this session you will see how to use new and existing Excel tools to assist you with all kinds of financial reports.  The following topics will be addressed:

  • how to automatically allocate forecast numbers to a variable future time horizon based on several drivers using a minimum of unique formulae
  • create an attractive break-even analysis using a dynamic chart that automatically displays the number of units and the break-even point while changing variables
  • tips and tricks.

Tony de Jonker

English

14:00

Building Truly Effective Charts & Graphs

Boris Hristov

Many people nowadays use Excel to visualise data.  They create charts and then present them in PowerPoint.  However, many times they leave them as they are and miss a huge opportunity – an opportunity to tune the chart just a little bit more and thus make it way more effective.  This demo-only session presents the steps and the algorithm that everyone can follow to create and present effective data visualisations with the help of Excel and PowerPoint.

Boris Hristov

English

15:00

The Excel Charts Microsoft Forgot to Add

Jordan Goldmeier

In this session, Jordan will show you some amazing tricks, interactivity, and design to take your data visualisation to the next level.  We’ll build three interactive charts you can use right away.  This session will emphasise important concepts like data visualisation, Power Query and just a little VBA.  Attendees will receive all the files used and can immediately begin implementing the charts into their own work.

Jordan Goldmeier

English

16:00

Creating the Ultimate Dynamic Crosstab Report with Array Formulae

Roger Govier

Whilst Roger’s first and preferred method of analysing any data tables is to use PivotTables or Power Pivot, with the arrival of the new Dynamic Array formulae, it is easy to create a crosstab report with just a few simple formulae.

In this session, he will show not only how to use these formulae, but the end result will be a template into which the user can drop any data table and with no change of any formula, be able to create crosstab reports which are just as flexible as a PivotTable.

Roger Govier

English

17:00

Solving Complex Problems with Merge in Power Query

Leila Gharani

Get creative with Power Query’s Merge functionality to solve complex problems in Excel.  Aside from using merge to lookup values from other tables, you can use it to:

  • transform messy data to proper tabular data
  • search and replace bulk values
  • compare an old version of a table to a newer version to find mismatches in data
  • approximate match lookups
  • and more!

Leila Gharani

English

18:00

Financial Reporting in Excel vs. Power BI

Rishi Sapra

In this session which is relevant to everyone (not just accountants!), Rishi will look at how financial reporting has typically done in Excel, and some of the challenges this has traditionally posed.  He will then take a comprehensive look at Power BI functionality including:

  • automatically consuming files in a folder
  • storytelling with data
  • dynamics graphs and measures
  • Waterfall charts and tables
  • Row Level Security
  • analysing data with Excel
  • reporting commenting and subscriptions
  • Q&A.

Rishi Sapra

English

19:00

Excel Speed Loop

Jeff Lenning

You need two things to work fast in Excel: a process and core Excel skills.  The process provides a formal way to approach and optimize your workbooks.  The Excel skills enable you to automate manual tasks.

In this session, I will present the Excel Speed Loop process that will help you systematically optimize your workbooks for efficiency and accuracy.  I will also demonstrate several key Excel skills (Power Query, PivotTables, Tables, MAX) that will help you automate manual tasks.

If you use Excel to update the same set of workbooks each day/week/month/quarter/year, this session will help you continuously improve your workbooks.

Jeff Lenning

English

20:00

Smart VBA Macro Recording/Slim Macro's Opnemen

Jan Karel Pieterse

Power Query can’t handle OAuth 2 API’s, but we’ll see how we can use Power Automate’s custom connectors to call any OAuth2 API and return data.

Jan Karel Pieterse

English

21:00

Office Scripts

Sudhi Ramamurthy

Sudhi Ramamurthy

English

22:00

Creating More Effective Charts

Echo Swinford

Creating effective charts can be challenging.  But you don’t have to be a trained graphic designer to make good decisions when charting.  In this session, we’ll review simple foundational techniques to help your data shine.

 

Session outline:

  • Gestalt principles
  • Pre-attentive attributes
  • Glanceable vs referenceable
  • Chart junk
  • Colour
  • Labels
  • Alternative chart types.

Echo Swinford

English

23:00

Excel and Power Automate

Harysh Menon

Harysh Menon

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 before booking.

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

OUR PARTNERS

Any Questions?

SUBMIT