If you haven't modernised your reporting processes in Excel, you're missing out on big productivity gains. And if you're looking to conduct more rigorous analysis of your data, more can be done in Excel than you think. In this Masterclass, we’ll look at a variety of tools to conduct repeatable and sophisticated analytics in Excel:
Becomesuper-efficient in Excel through intensive use of keyboard shortcuts and bestpractices to efficiently build an effective and robust model.
Create afinancial model based on real-world financial modelling challenges. Incorporate current economic uncertaintiesinto the model in order to take more calculated risks and make more informedbusiness decisions.
Identifycorrect economic inputs to model and deal with fluctuations. Quantifyuncertainty in forecasting models with stress-testing, what-if analysis andrisk analysis techniques.
Explorethe several different ways to perform scenario and sensitivity analysis inExcel and learn to model in detail the complex but most commonly used methodsof showing scenarios using a combination of formulas and drop-down boxes.
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Becomesuper-efficient in Excel through intensive use of keyboard shortcuts and bestpractices to efficiently build an effective and robust model.
Create afinancial model based on real-world financial modelling challenges. Incorporate current economic uncertaintiesinto the model in order to take more calculated risks and make more informedbusiness decisions.
Identifycorrect economic inputs to model and deal with fluctuations. Quantifyuncertainty in forecasting models with stress-testing, what-if analysis andrisk analysis techniques.
Explorethe several different ways to perform scenario and sensitivity analysis inExcel and learn to model in detail the complex but most commonly used methodsof showing scenarios using a combination of formulas and drop-down boxes.
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Click on the link below for full details of our Financial Modelling in Excel course
https://globalexcelsummit.com/
product/financial-modelling-in-excel
Click on the link below for full details of our Budget and Forecast Modelling in Excel course
globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Get to grips with Excel’s advanced features in a series of beginner-friendly sessions. You’ll grasp the basics of VBA, PivotTables, and Power BI to automate tasks and build dashboards.
Introduction to VBA
Check out the introductory keynotes from Microsoft and world-renowned MVP Leila Gharani. Software developers showcase add-ins that transcend Excel's limitations, plus robust panel discussions and expert battles complete the day!
Opening keynote by Microsoft
Opening keynote by Leila Gharani
Top 5 tips & tricks for actionable reporting in Excel
How to use Excel as a no-code app builder
Excel beyond expectation: glimpse the future of Excel
Panel discussion: Excel in education
Going Rogue in Excel: doing what you gotta do to get
what you gotta get
Harness the power of Excel and Power BI for budgeting, forecasting, and modelling. You'll master dashboards, P&L statements, and learn to build bullet-proof models that won't disintegrate!
Beyond expectations: financial modelling with dynamic arrays
The must-have Excel formulas in the finance Industry
Error checking for financial models; Or how to avoid being the next reporting disaster
Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, 3D animated wireframes, and write DAX expressions for true flexibility!
Advanced sales analytics using Data Analysis Expressions (DAX) in Microsoft Excel.
Improve your dashboards with custom charts
The power of colour in data visualisation
How to build a 3D wireframe animation in MS Excel?
Expand your understanding of Power Query, Power Pivot, Power BI, and Power Automate. You'll arm yourself with the latest time-saving functionalities, powerful visualisations & expert techniques.
50 Shades of Dirty Data - How Power Query is the best laundry powder there is
Tearing down the 5 pillars of Excel inefficiency
Power Pivot and Power Query, the dynamic duo in data analysis
Implementing key design & DAX techniques in Power BI to enhance business insights
Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!
Panel discussion: Is VBA dead or alive?
The end of PivotTables in Excel
Copy/paste chart settings with VBA
Power up with 10 NEW Excel functions
Dynamic arrays, a LIFE changer
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
-min.png){kind=logo}
The Global Excel Summit event and course content is for YOU if...
