• DE
  • EN
  • Knott Consulting Düsseldorf - Excel Schulungen

    Excel Training

    Your team needs new skills to work efficiently and effectively in Excel?
    We have the solution!

    Excel is very flexible and widely used but not everyone can use it effectively and efficiently for all purposes. This leads to poorly constructed workbooks which are hard to understand, inefficient to use and potentially unreliable. A triple whammy!

    Our solution: We train your team to perform key tasks using best practice techniques.

    We offer a variety of standard and customised courses to meet your needs.
    They vary in length from half a day to two full days.

    Excel Basics

    Beginner
    d


    Learn Excel basics incl. basic data entry and formulas, formatting and navigation

    Data preparation
    and analysis

    Intermediate
    and Expert


    Bring together data from various sources, and analyse it to produce useful outputs - for intermediate or power-users

    Planning and calculations

    Intermediate
    d


    Calculate planned sales based upon provided data and assumptions, produce useful outputs incl. pivot tables

    Business modelling - intermediate

    Intermediate
    d


    Produce a flexible cash flow using more complicated functions and produce useful outputs

    Business modelling - advanced

    Expert
    d


    Plan, develop and use a financial model with value drivers and integrated financial statements (P&L, balance sheet and cashflow)

    Customised training: We also offer training customised to your exact needs. Examples could include:

    • M&A/LBO modelling with valuation: Understand concepts, develop models including financing
    • Expert workshop: Use advanced functionality such as dynamic arrays and data tables
    • Macros (VBA): Develop and test simple macros to automate repetitive tasks
    • Old tools made new: Optimise tools and models already in use

    Your benefits

    • Relevant: we discuss your requirements and agree suitable training
    • Flexible: training can be delivered on-site or virtual
    • Effective: participants learn hands-on using realistic, practical case studies
    • Best practice: we cover essential theory and give practical tricks and tips
    • Lasting: we support participants to ensure they understand and give them helpful handouts
    • Enjoyable: our motivated trainers make learning Excel fun!

    Effective, best practice Excel training for groups large and small!

    Contact us now to arrange a free, short, no obligation call
    to discuss your needs. » contact

    What our clients say

    Rolf Martin Blume CFA
    Director Corporate Finance / M&A
    DZ Bank - corporate and investment banking

    Gary Knott's training courses have completely convinced us. He tailored the topics to be covered individually to our needs in advance, and the training content, models and tasks were both theoretically sound and extremely practical. The hand-outs contained numerous best practice tips that made every day modelling much easier. The seminar was rounded off by Gary's patient, competent and friendly way of conveying the material to the participants, so that my colleagues and I not only learned valuable things, but also had a lot of fun during the training.


    Dr. Tanja Gluding
    HR Director
    CELLS Group - real estate management

    Excel is fun but can make you despair at the same time! The Excel trainings by Knott Consulting were always well thought-out, targeted and always led to some ‘aha experiences’!


    Jeannine Hartmann
    Manager Accountant
    JLL Property Group

    Thank you very much for the great Excel training. I was able to take away many new tips and tricks that will facilitate my daily work.