Zurich, Switzerland: +41 - 43 434 80 33   |   US: (510) 954-3145   |   support@traininng.com

Gary Knott

Chartered Accountant and Excel Trainer at Deloitte logo,

Gary Knott is a chartered accountant and Excel trainer with over 30 years of experience including many years at Deloitte. He is the author of 'Avoid Excel Horror Stories', He was a speaker at the Global Excel Summit, and is a big fan of dynamic arrays, Power Query, and other modern Excel innovations. A sought-after trainer who makes Excel techniques easy, practical, and fun! He now works independently, helping clients improve their spreadsheets and reduce risk.

He’s a popular trainer known for clear, practical techniques and advice and who specializes in making complex tools simple, practical, and powerful.



  •  Wednesday, June 18, 2025
  • 08:00 AM PDT | 11:00 AM EDT,
  • 60 Minutes
  • ¤110.00
Complete Excel Tasks Quicker Using Dynamic Arrays Functions

In this creative and engaging webinar, we follow poor Joe, who faces increasingly complex tasks from his demanding boss.

  •  Tuesday, August 5, 2025
  • 08:00 AM PDT | 11:00 AM EDT,
  • 60 Minutes
  • ¤110.00
Unlock the Power of Power BI using My STAR Method

Power BI is a fantastic business intelligence tool that enables users to connect, clean, analyse, and visualise data from various sources to better understand your data and answer real business questions.

  •  Thursday, August 7, 2025
  • 08:00 AM PDT | 11:00 AM EDT,
  • 60 Minutes
  • ¤110.00
Prevent Excel-User Errors with These 6 Proven Techniques

This practical session shows how to prevent user errors in Excel using six proven techniques

  •  Tuesday, August 19, 2025
  • 08:00 AM PDT | 11:00 AM EDT,
  • 60 Minutes
  • ¤110.00
Keep your Excel Financial Model Balanced with a Reliable Cashflow

Learn a practical method for developing a reliable cashflow statement that ensures your balance sheet always balances.





  • Recorded
  • View Anytime
  • 60 Minutes
  • ¤150.00
Unlock the Power of Power BI using My STAR Method

Power BI is a fantastic business intelligence tool that enables users to connect, clean, analyse, and visualise data from various sources to better understand your data and answer real business questions.

  • Recorded
  • View Anytime
  • 60 Minutes
  • ¤150.00
Complete Excel Tasks Quicker Using Dynamic Arrays Functions

In this creative and engaging webinar, we follow poor Joe, who faces increasingly complex tasks from his demanding boss.

  • Recorded
  • View Anytime
  • 60 Minutes
  • ¤150.00
Unlock the Power of Power BI using My STAR Method

Power BI is a fantastic business intelligence tool that enables users to connect, clean, analyse, and visualise data from various sources to better understand your data and answer real business questions.

  • Recorded
  • View Anytime
  • 60 Minutes
  • ¤150.00
Prevent Excel-User Errors with These 6 Proven Techniques

This practical session shows how to prevent user errors in Excel using six proven techniques