Learn how to free up your time by automating your processes, as Microsoft MVP Mark Proctor hosts this special in-depth 6-hour Masterclass.
Office Scripts is the new, simple and intuitive language designed specifically for non-programmers who wish to automate Excel. When combined with Power Automate, you can build cross application automated processes that run in the background (you don’t even need to click a button — it runs when you sleep!).
This Masterclass starts with the fundamentals and through practical examples demonstrates how all the pieces fit together to build robust solutions. By the end of the Masterclass, you will be confident to write your own scripts from scratch and build simple end-to-end automation processes.
This Masterclass is for professionals concerned about dedicating excessive time to routine, error-prone tasks and would prefer to use AI to automate these processes, rather than facing the risk of AI rendering their roles obsolete.
Additionally, professionals uncertain about how the rise of AI affects their career paths — whether it necessitates evolving into more technical roles or stepping back from the technical aspects of their jobs, considering AI integration as a potentially insurmountable challenge.
This could be those in:
This Masterclass is for any finance professionals who want to stop working late at month end by automating their work. The typical roles/teams that could benefit from this masterclass are:
If you create Data Models in Excel or Power BI, then this Masterclass is for you.
This Mastercass is for anyone who wants to make the most of their data using next-generation features. Typical job titles who could particularly benefit include:
This Masterclass is for anyone using Excel 365 who wants to learn more about Office Scrips and Power Automate. By the end of this class, you will be able to build self-running automation processes that run in the background of Excel.
This Masterclass is for people who already know and have worked with Microsoft Excel’s user interface and want to explore more advanced and dashboard functionalities:
This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem solving using the M Language.
No Day 1 sessions included in this ticket type.
No Day 2 sessions included in this ticket type.
✔︎ ChatGPT in Excel: Match made in heaven or hell..?
✔︎ Corporate charts inspired by social media
✔︎ A bank's perspective on Excel and AI
✔︎ Combine data in Excel like a pro
✔︎ Dynamic dashboard creation for KPI reporting using Power BI
✔︎ Expert Battles by FMWC
✔︎ Panel discussion: Does being Excel certified matter?
✔︎ Panel discussion: The future of Excel in an AI world
✔︎ And more...
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
✔︎ What's new in Excel and how it can help with our dashboards
✔︎ The new data handling features for dashboarding - Power Query
✔︎ The new functions for dashboarding - Dynamic Arrays, Lambda Helpers and IMAGE
✔︎ The new charts for dashboarding - Box plots, treemaps, forecasts
✔︎ The new pivots for dashboarding - data model & DAX Putting them all together for a KPI dashboard
✔︎ Making the dashboard interactive with Slicers & Timelines
✔︎ Updating the dashboard when you get new data
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
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
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
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
✔︎ What is “extract, transform, load,”?
✔︎ We’ll look at how this process works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data.
✔︎ How do you avoid memory-draining “Frankentables” and build relational data models and reports right from Excel?
✔︎ We’ll look at Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Where is data analytics headed, and can Excel keep up?
✔︎ Learn how to use predictive analytics and artificial intelligence inside and outside of Excel to make the most of your data
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn how to automate boring processes with Python
✔︎ Learn how to build compelling analyses with this programming language
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
Attendees will need an Office Scripts compatible licence in Office 365. Check the current compatible licences. If have the Automate tab in Excel, then you have a compatible licence.
There is no previous coding experience required to attend this Masterclass.
Mark Proctor is a qualified accountant, consultant and blogger who has been applying spreadsheet-based solutions to solve real-world problems for over 20 years. Whilst working in the media, food, retail, and manufacturing sectors, he has built extensive dashboard, reporting, and process automation tools, to achieve greater business insight and efficiency.
Mark Proctor is also the owner of Excel Off the Grid, which started in October 2016. The site focuses on teaching intermediate and advanced Excel techniques so workplace warriors can become more efficient in Excel.
I am very happy to have found Excel off the Grid. I recently implemented an Office Scripts project and I owe my success to it.
Mark explains everything really well with lots of great examples to start automating tasks, and even includes a whole section on Power Automate.
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 data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
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 insights complete the Tech & Innovation Track!
✔︎ Keynote by Microsoft: Transforming Excel through research and AI
✔︎ Keynote by Leila Gharani
✔︎ Actionable Data Storytelling in Excel with Zebra AI
✔︎ AI: Sorting fact from fiction
✔︎ Python in Excel: First Steps
✔︎ Teaching Excel with AI
✔︎ Is AI taking over the role of the data analyst?
✔︎ How to build re-usable Excel automations with AI
✔︎ Empowering learners to Excel with digital skills certifications
✔︎ Kids meet spreadsheets
✔︎ Corporate charts inspired by social media
✔︎ ChatGPT: Match Made in Heaven or Hell..?
✔ Turn Excel models into Web apps: features, sharing, monetization
✔ Panel discussion: The future of Excel in an AI world
✔ Panel discussion: Does being Excel-certified matter?
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!
✔ Client's perspectives on quality — lessons from a career in financial modelling and what that means for the future
✔ Dynamic Arrays - A financial modelling game changer
✔Upgrading financial modelling — how, who, and why?
✔ Fivecasting: One Better than Forecasting
✔ A bank’s perspective on Excel and AI
Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, intuitive analytic experiences, and write DAX expressions for true flexibility!
✔ Is this an Excel chart?!? - 5 ways to take your boring charts to the NEXT Level
✔ Interactive Data Visualisation for decision support using Excel
✔ How to create an intuitive analytic experience in Excel using Script Labs
✔ Dynamic dashboard creation for KPI reporting using Power BI
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.
✔ Why use Power Query to solve practical data cleaning problems?
✔ 5 Things every Excel user should know about Power BI
✔ Using Git in Power BI for effective teamwork and version control
✔ Overcoming real-world problems with Power BI
✔ Power Query on Excel for Mac
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!
✔ Optimising the Monetisation of Spreadsheets
✔ LAMBDA - There is no stopping you
✔The *NEVER SEEN* Tips & Tricks by Bob Umlas
✔ Converting spreadsheets into web apps; 3 apps in fifteen minutes
✔ 5 ways for analysts to leverage 'Analyze Data’ in Excel
✔Combine Data in Excel Like A Pro
✔ Why VLOOKUP when there is Power Query?
The Global Excel Summit event and course content is for YOU if...
The Global Excel Summit event and course content is for YOU if...