Inhouse Excel Training in English all over Europe

With our Inhouse Excel Training in English we strive to improve Excel efficiency and proficiency, so that employees can get much more out of theis essential tool. As a result, the newly acquired skills lead to enhanced staff competence, confidence and productivity.

Methodology

Inhouse Excel Training

We offer tailored step by step Excel trainings in Englsh for corporations all over Europe

We use case studies, with close practical relevance and directly applicable use cases, to develop methodological and technical competences. This means that all taught functions and features are put in a specific context of a use case to raise interest by appealing to the curiosity of the participants. This creation of inherent interest forms the foundation for motivated participants and sustainable adaption of new skills.

Inhouse Excel Training in English

Examples of what participants will learn:

  • Table formatting options
  • Using filters in Excel
  • How to pull specific data out of lists
  • VLOOKUP
  • INDEX function
  • Pivot tables: Learn how to analyse in seconds large data sets in many different ways
  • Conditional formatting to highlight data
  • CountIf
  • SumIf
  • AverageIf
  • Drop-down menus
  • Sparklines
  • Text to columns
  • What if analysis in data tables to show the results for many different possible scenarios at once
  • Creating column, bar, pie, line, area, and scatter charts (and what to use when)
  • Easily adding and removing data from charts
  • Working with a secondary axis
  • Working with Excel’s built-in chart styles
  • Customizing colours and cleaning up default formats
  • Applying custom number formatting to chart axes
  • 12 Essential Excel shortcuts
  • How to create histograms to summarize data into groups
  • How to pull specific data out of lists
  • Using advanced filters in Excel
  • How to create and modify heat maps
  • Building charts for marketing data
  • How To Chart Data Sets With Long Labels
  • Using text boxes and shapes in charts
  • Special paste options
  • Formatting dates in excel
  • How to make custom chart templates
  • Link Excel charts and data in Word and PowerPoint, so that they update automatically
  • What if analysis in data tables

Training material

Participants will receive access to a password protected online document, which cover all topics of the training and provide a step-by-step reference for daily usage. Moreover, we provide an overview of useful resources for further reference.

Excel Trainer

Excel Trainer Joern Steinz (MBA)

Excel Trainer Joern Steinz (MBA)

Joern Steinz (MBA), born 1975, used to live in Excel  when he worked in consulting and corporate development positions at Accenture, XING and the Freenet Group. Now he is sharing all his favourite tips and tricks in practical workshops. In 2014 he founded the training agency SkillDay where he is also teaching WordPress, Content Marketing, Business Modelling and Time Management. His clients encompass leading organizations, such as BCG, Gruner & Jahr, Lingen, NDR, GRAVIS.

Get a quote now

Please use our form below, to reach out to us. We usually get back to you within a few hours.