Jon Peltier Masterclass: “Advanced Charting in Excel”
Gasper Kamensek Masterclass: “Advanced DAX (become a filter context ninja)” SOLD OUT!
SECOND Gasper Kamensek Masterclass: “Advanced DAX (become a filter context ninja)”
Tim Heng Masterclass: "Financial Modeling and Analysis with Excel" SOLD OUT!
Chandoo Masterclass: "Dynamic Arrays in Excel - a Deep-dive"
Charles Williams Masterclass: “Excel Hackaton: Developing Excel VBA Addins: the LET Wizard addin”
Overview and Outline
This masterclass will cover the theory and practice of charting in Microsoft Excel. The theory of charting includes such topics as data, chart types, and formatting. Practice begins with combination charts, conditional formatting of charts, custom chart types, dynamic charts, interactive charts, with a few tricks sprinkled in.
Who should attend?
Anyone who performs data analysis and visualization in Excel will benefit from this masterclass. People who produce reports with graphical content
What will participants learn?
Masterclass attendees will learn to make effective charts. They will learn what makes efficient chart data, how to manipulate data and formatting to achieve desired chart styles. Participants will learn how to work with the different elements of charts, and how to leverage worksheet formulas and controls to make dynamic charts that reflect changing data and interactive charts that reflect user selections.
Software & Technical Requirements: Masterclass attendees should have a supported Excel version installed: 2013, 2016, 2019, 2021, or preferably Microsoft 365.
Participants will be provided with workbooks that show the lessons and allow them to work out the examples.
Overview and Outline
Once we get past the first CALCULATE statement in DAX our Excel thinking (in terms of Cells) shifts a bit. It shifts into thinking of Tables and Columns as variables. And as we try to grasp the concept of »the Filter Context« we see that it’s basically all about connections and table interactions.
Once you get to this stage that is when you start using CALCULATE (and other DAX functions) not just to add to Filter Context but to manipulate it. And this is where writing measures become an Art form. In this Masterclass we are going to learn to paint alongside the best of them.
It is necessary for the participants to have basic knowledge of Power BI and of the programming language DAX.
Software & Technical requirements
Please have at least the August 2022 version of Power BI Desktop installed. We will also be using DAX Studio for Power BI.
Overview and Outline
Have you ever burnt the midnight oil trying to get a Balance Sheet to balance? This masterclass is focused on building models efficiently and effectively. Our simple process has been adopted by many seasoned professionals without resorting to balancing figures, circulars and macros.
Starting from a simple set of assumptions, this course develops a small, straightforward model which enables our method to be demonstrated readily and practiced comprehensively. By the end of the masterclass, users will be able to repeat this process and apply it to their own model developments.
Course contents:
Software & Technical requirements: Masterclass attendees should have a supported Excel version installed: 2016, 2019, 2021, or Microsoft 365.
Overview and Outline
Excel is changing. With the arrival of Dynamic Array formulas, we can now analyze data in powerful new ways! In this in-depth & hands-on masterclass, learn how to take full advantage of Excel’s dynamic array capabilities. We are going to learn all about FILTER, UNIQUE, SORT, SEQUENCE, LAMBDA, SCAN and TEXTSPLIT. We will use these ideas to create an interactive KPI dashboard with Excel as a project.
Who should attend: This masterclass is aimed at people with intermediate to advanced Excel skills. If you work as a data professional (analyst, accountant, manager, consultant or small business owner) you will benefit from the topics covered in this session.
Software & Technical requirements: You need to have Excel 365 on your computer to follow-along during the session.
Target Audience: People with advanced skills of Excel and some experience of VBA or other programming languages.
Software & Technical requirements: Excel Microsoft 365 or Microsoft Excel 2021 is required.
Objective: Discover the advantages of VBA Addins and learn best practices to develop and distribute them.
The Masterclass will develop an Addin to analyse Excel formulas to discover duplicated expressions that could be converted to LET functions and make the changes to the formulas.
The masterclass will cover:
9, 10, 11, 12 November 2022
Central Military club, Sofia