On 12h course you will get to learn:

  • Conditional formatting and Data validation
  • Relative, absolute and mix references (usage of $ sign)
  • Advanced usage of charts
  • Logical functions: IF, OR, AND
  • Date and date functions
  • Text functions: LEFT, RIGHT, MID, LEN, REPLACE, PROPER, UPPER, CLEAN, TRIM
  • Search functions: VLOOKUP, HLOOKUP, XLOOKUP
  • Conditional functions: SUMIF, COUNTIF, AVERAGEIF
  • Data analysis: What is analysis, usage of scenarios, pivot tables - advanced

Difficulty level

The advanced course is recommended for participants who already have a basic knowledge of Excel and want to upgrade it in a structured form.
To attend this course, you need a basic knowledge of working with Excel, spreadsheets and calculations
The goal of the course is to train participants for more advanced work with spreadsheets and data analysis

Difficulty level

The advanced course is recommended for participants who already have a basic knowledge of Excel and want to upgrade it in a structured form.
​To attend this course, you need a basic knowledge of working with Excel, spreadsheets and calculations.
The goal of the course is to train participants for more advanced work with spreadsheets and data analysis

METHOD OF COURSE CONDUCT

The courses are structured in the way to present individual topic, including the presentation on practical examples, followed by  exercises. We use practical examples, so that participants can also use them later in their areas.
 
Begginer courses are specifically tailored for new users who want to use Excel in day-to-day tasks such as inventory management, invoicing, work inventory, and hours records.

Courses are taught by experienced and certified trainers.

In the case of larger live groups (7+), in addition to the lecturer, there is also an assistant present, who actively helps all participants.

APPLY >>>