How to excel in Excel

This website will help you to work effectively and efficiently in Excel.
Excel is very flexible, widely used and data is often available in Excel format. No wonder Excel is so often used for data processing and analysis as well as for financial models. However, not every user can work effectively and efficiently with Excel.

This requires Excel knowledge and skills that can be learned.
Here you are in the right place! In my blog, videos and book you can learn best practice techniques and tips and tricks for using Excel.


Here you can learn valuable tips and tricks to help you improve your Excel skills such as how to save time, navigate effectively or reduce Excel file sizes.


Here you can view useful how-to videos which explain step by step how to tackle some practical data processing, analysis and modelling challenges in Excel.


Here you can purchase my book "AVOID EXCEL HORROR STORIES". The book is packed with practical examples and screenshots to help you understand how to use Excel.

Gary Knott – experienced expert

I have over 30 years of professional work experience, thereof 21 at Deloitte in England and Germany and have been working as a freelancer since 2015, trading as Knott Consulting. I have always used spreadsheets in my work, but since 2006 I have specialized in the areas of business modelling, Excel tools, data analytics and Excel training.

I have also written a practical how2excel book so you can learn how to excel at creating reliable, user-friendly spreadsheets.

Gary Knott | how2excel - Excel Schulungen - Buch

    To submit the form, Google reCAPTCHA must be loaded.
    Google reCAPTCHA Privacy Policy

    Load Google reCAPTCHA

    * I agree that my details from the contact form will be collected and processed to answer my request. The data will be deleted after the processing of your request. Note: You can revoke your consent at any time by e-mailing to info@how2excel.com. Detailed information on handling user data can be found in our privacy policy.