Svetkom
  • Home
  • Services
    • Homologation Services
    • Mystery shopping
    • Audit Execution
    • Project Management
    • Service Advisor Training
    • Business Process Management
    • Building Relationships for Success in Sales
    • Conflict Resolution
    • On-Site Coaching
    • Excel beginner course
    • Excel advanced course
  • Products
    • Audatex
    • Autodata
    • Movon
    • Geotab >
      • Sledilnanaprava.si
    • AUTOONLINE
  • Blog
  • Contact
  • About
  • Domov
  • STORITVE
    • Excel za obrtnike
    • Homologacije
    • Skrivnostni nakup
    • Revizija
    • Vodenje projektov
    • Izobraževanje Servisnih Svetovalcev
    • Učinkovito Upravljanje Poslovnega Procesa
    • Vzpostavljanje odnosov za uspeh v prodaji
    • Reševanje Konfliktov
    • Coaching
    • Excel začetni tečaj
    • Excel napredni tečaj
  • Produkti
    • Audatex >
      • Audatex-prijava
      • Audatex Navodila
    • Autodata >
      • Autodocta
    • Movon
    • Geotab >
      • Sledilnanaprava.si
    • AUTOONLINE >
      • Odkup poškodovanega vozila
  • Blog
  • Kontakt
  • O nas
EXCEL - advanced course

On 12h course you will get to learn:

Picture
  • 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

Picture
Picture
Picture

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 >>>

ŽELIMO SI DA NAS PONOVNO KMALU OBIŠČETE!


Svetkom d.o.o

Letališka cesta 27
SI-1000 Ljubljana

DELOVNI ČAS:
PON-ČET: 8.00 - 16.00
​PET: 8.00 - 14.00

TELEFON: +386 1 235 55 40
EMAIL: [email protected]
Autodata
Audatex
AUTOonline
Mobileye
Geotab
Trackimo

Homologacije
Skrivnostni nakup
Projektno vodenje
Revizja
Izobraževanje
Coaching

 Prijava na e-novice:

Splošni pogoji poslovanja
Politika zasebnost
Picture
© 2010 - 2024 | SVETKOM  d. o. o. | Vse pravice pridržane.
WE'RE LOOKING FORWARD TO YOUR VISIT AGAIN!

SVETKOM D.O.O.

Letališka cesta 27
SI-1000 Ljubljana
OPENING HOURS:
MON-THU: 8am - 4pm
FRI: 8am - 2pm

PHONE: +386 1 235 55 40
EMAIL: [email protected]
Autodata
Audatex
AUTOonline
Mobileye
Geotab
Trackimo

Homologation
Mystery shopping
Project management
Audit
Trainings
Coaching

 SUBSCRIBE TO NEWSLETTER:

Terms and conditions
Privacy policy
Picture
© 2010 - 2024 | SVETKOM  d. o. o. | All rights reserved.
  • Home
  • Services
    • Homologation Services
    • Mystery shopping
    • Audit Execution
    • Project Management
    • Service Advisor Training
    • Business Process Management
    • Building Relationships for Success in Sales
    • Conflict Resolution
    • On-Site Coaching
    • Excel beginner course
    • Excel advanced course
  • Products
    • Audatex
    • Autodata
    • Movon
    • Geotab >
      • Sledilnanaprava.si
    • AUTOONLINE
  • Blog
  • Contact
  • About
  • Domov
  • STORITVE
    • Excel za obrtnike
    • Homologacije
    • Skrivnostni nakup
    • Revizija
    • Vodenje projektov
    • Izobraževanje Servisnih Svetovalcev
    • Učinkovito Upravljanje Poslovnega Procesa
    • Vzpostavljanje odnosov za uspeh v prodaji
    • Reševanje Konfliktov
    • Coaching
    • Excel začetni tečaj
    • Excel napredni tečaj
  • Produkti
    • Audatex >
      • Audatex-prijava
      • Audatex Navodila
    • Autodata >
      • Autodocta
    • Movon
    • Geotab >
      • Sledilnanaprava.si
    • AUTOONLINE >
      • Odkup poškodovanega vozila
  • Blog
  • Kontakt
  • O nas