Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Not all courses are the same – this is ExcelGuru education!
The courses offered by ExcelGuru were created as a result of many years of experience of a professional analyst, who worked as a chief analyst in a multinational company and today works as a consultant for leading companies. Each course is carefully designed to impart practical knowledge and skills that are actually used in business.
That’s why we are proud to say that ExcelGuru courses have a TASTE OF KNOWLEDGE – because knowledge comes from real experience.
These courses are intended primarily for analysts. If you also belong to that group, then you are in the right place.
Knowing how to work in Excel is the ultimate today!
Knowing this tool will open many doors and opportunities for you.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Excel je postao standard koji se podrazumeva poput osnovnog poznavanja engleskog jezika. Danas nije moguće zamisliti neki posao a da nema bar povremenih dodira sa upotrebom excel-a, čak ga i arhitekte koriste za pravljenje projektne dokumentacije. Pre ili kasnije susrešćete se sa njim. Ovaj kurs je logičan prvi korak u ponudi excel kurseva. Trudili smo se da na jednom mestu sažmemo i struktuiramo neophodno početno znanje kako bi Excel za vas bio alat koji ćete voleti.
Excel Guru I je osnovni kurs Excel-a i namenjen je onima koji se sa ovim alatom susreću po prvi put ili onima koji ovaj alat koriste povremeno i sada žele da to znanje utvrde i prošire. Ovaj kurs za cilj ima da vas dobro upozna sa interface-om ovog alata i njegovim osnovim funkcionalnostima. Kako da se brzo i lako u njemu snalazite i da vam osnovni rad u ovom alatu ne bude prepreka već zadovoljstvo i inspiracija da o Excel-u što više naučite i da se dalje usavršavate.
Kroz karijeru dugu 16 godina susretao sam se sa raznim problemima i zadacima koje je trebalo rešiti. Takodje mnoge kolege i prijatelji su mi dolazili sa svojim excel fajlovima da im pomognem. Bez obzira na različitost zadataka, kojih je bilo veoma mnogo, uočio sam da za rešavanje većinje njih je potreban jedan isti skup znanja i veština. Tako je nastao kurs Excel Guru II koji u sebi sadrži skup znanja i veština koji omogućava rešavanje poslovnih zadataka širokog spektra. Ovo je kurs srednjeg nivoa.
Ovaj kurs je namenjen onima koji već vladaju osnovama ovog moćnog alata i sada žele da svoje znanje nadograde za jedan nivo više koji će im omogućiti da obavljaju brže i bolje većinu poslovnih zadataka na pozicijama asistenata u prodaji, logistici, marketingu, finansijama i svim drugim pozicijama gde je druženje sa Excel-om svakodnevno. Na ovom kursu učimo još mnogo toga novog o Excel-u, a u centru svega toga je praktična primena tog znanja.
Teme i materijal su pažljivo birani kako bi se pokrile sve neophodne tehnike i funkcionalnosti za rad sa tabelama i podacima. Sve vežbe su realni primeri iz prakse. Predavanja su koncipirana tako da se prvo prodje teorijski deo, zatim kratke praktične vežbe kako bi se teorijski deo na primerima provežbao i na kraju realni scenariji u vidu konkretnih zadataka.
Nije čest slučaj da ljudi dobro poznaju Excel kao alat ali kada treba nešto da urade nastaje problem – jednostavno ne znaju odakle da krenu.
Pored dobrog poznavanja alata veoma je važan analitički pristup kod rešavanja poslovnih zadataka, stoga ništa manje važno, na ovom kursu pažnja će se poklanjati i načinu na koji treba razmišljati kada se rešeavaju poslovni zadaci.
U ovom modulu prolazi se kroz 40-tak najvažnijih funkcija iz svih grupa – Text, Date & Time, Lookup & Reference, Math, Statistical, Information & Logical. Nakon upoznavanja sintakse i osnovne funkcionalnosti svake funkcije, prelazi se na vežbe kako bi se videla prava upotrebna moć ovih funkcija. Kroz realne prumere i zadatke polaznici stiču neophodno iskustvo koje će im pomoći da u budućem radu samostalno mogu da prepoznaju koje funkcije će da upotrebe i na koji način.
Takodje, kroz realne primere polaznici se uče da prvo problem reše logički, ne Excel-ovski, pa tek onda da pristupe izvodjenju tehničkog rešenja kroz Excel koje treba da bude u koracima tj. parcijalno jer se tako lakše uočavaju greške.
Svaku “običnu” tabelu moguće je prevesti u Excel tabelu. Šta se ovim dobija? Ovako dobijena tabela sada ima proširene mogućnosti. Tabela dobija svoje ime kao i svaka kolona, zapravo tabela se pretvara u malu bazu sa kojom je lakše raditi nego sa “običnim” tabelama, na primer pisanje formula nad Excel tabelom je izuzetno jednostavno.
Ovaj modul vrlo detaljno pokriva ovu veoma važnu a malo poznatu i u praksi malo korišćenu Excel funkcionalnost.
VLOOKUP je verovatno pored SUM najkorišćenija funkcija u Excel-u.
To je verovatno jedna od prvih složenijih funkcija koju svako ko dodje u dodir sa Excel-om nauči.
Ova funkcija je veoma korisna i moćna, zato je jedan ceo modul posvećen njoj.
Pored osnovnog oblika korišćenja Vlookup-a, polaznici će naučiti i kompleksnije oblike i složenije varijante korišćenja ove funkcije.
Volim da kažem: PIVOT je veoma moćan ali ne i SVEMOĆAN!
Ovaj modul pokriva osnovni rad sa pivot tabelama koji zapravo pokriva 90% onoga što pivot može.
Polaznici će naučiti kako da naprave pivot, na koji način da ga dizajniraju, kako da manipulišu podacima, razne transformacije, sortiranja kao i pivot grafikon koji pruža neverovatno laku mogućnost da vaše analize ožive.
Kako, gde i kada treba koristiti Pivot tabele, koje su prednosti a koji nedostaci su teme o kojima će se diskutovati.
Da, pivot je moćan i treba ga znati!
Na kraju kursa sledi trenutak da svako vidi koliko je naučio – Test!
Test je koncipiran kao jedan veliki zadatak koji objedinjuje sve glavne elemente kursa.
Test se ne ocenjuje već vaš predavač ExcelGuru daje vam na kraju procenu vaše uspešnosti.
Test nije lak, nije tako ni zamišljen, to je momenat da stvarno proverite da vreme i novac koji ste uložili nije samo još jedna stavka u vašem budzetu.
Kao i Guru II ovaj kurs je nastao iz mog ličnog iskustva. Volim da kažem – na ovom kursu upoznaćete PRAVU MOĆ EXCEL-a! Poslednjih 7 godina moje karijere proveo sam na poziciji glavnog analitičara u Philip Morris-u. Savladavanje tehnika i veština pravljenja dinamičkih izveštaja koji će se u nekoliko sekundi osvežiti je bilo od krucijalne važnosti za mene. Ovaj kurs u sebi sadrži fantastične stvari, jedna neverovatna čarolija koju ćete i vi posedovati.
Ovaj kurs je namenjen svima onima koji svoju karijeru žele da profilišu u pravcu analitike. Pravljenje dinamičkih izveštaja i dashboard-a u Excel-u je danas ništa manje interesantno, iako su alati poput Tableau i Power BI upravo namenjeni ovom polju analitike – automatizaciji . Excel je bio i verujem da će uvek biti nezamenljiva alatka svakog ozbiljnog analitičara, zato dobro poznavanje ovog alata je preduslov svemu ostalom na vašem putu bavljenja podacima.
Ako želite da stvarno ovladate Excel-om, onda dinamičko korišćenje formula je neizostavna stvar.
Dinamičko pisanje formula je zapravo uvod u automatizaciju, to je zapravo mesto gde počinje Excel čarolija! Index, Match i Offset su tri funkcije za koje volim da kažem da čine “srce” automatizacije u Excel-u. Tu su naravno još neke funkcije kao što su već dobro poznat Vlookup ali ove tri funkcije zajedno zaista čine da vaši izveštaji prosto ožive. Pojedinačno gledano one nemaju takvu moć i jedva da mogu da se mere sa Vlookup-om ali zajedno daju magiju automatizacije i dinamičkog izveštavanja.
Ovaj deo kursa pokriva napredno korišćenje Index-Match, Offset i drugih funkcija, koje se mogu medjusobno kombinovati i uz dinamičko referenciranje omogućiti kompleksne kalkulacije i neverovatnu automatizaciju izveštaja koje možete pretvoriti u veoma lepe i funkcionalne dashboard-e.
Od ove sezone (maj 2020) Power Pivot i Power Query su sastavni deo Guru III kursa.
PQ daje Excel-u dodatnu moć i podiže lestvicu na visine koju nijedan drugi alat sličnih namena teško da može da dosegne. PQ omogućava proces izvođenja, transformacije i učitavanje podataka (ETL proces) na lak i jednostavan način.
Power Pivot je prava revolucija i na neki način on je uvod u Power BI. Na ovom kursu naučićemo osnove u čijem centru će biti CUBE formule koje omogućavaju jedan novi vid automatizacije.
Tema poslovno izveštavanje (Business Intelligence) poslednjih godina dobija sve više na značaju. Stotinak alata postoji i nude razna rešenja ali od maja 2019. godine na tron se popeo Power BI. U poredjenu sa drugim alatima njegova popularnost je od samoga početka rasla ogromnom brzinom. Potreba za analitičarima koji znaju da DAX-uju i rade u ovom alatu je sve veća.
Zato je ExcelGuru za vas pripremio ovaj kurs koji će vas uvesti u jedan novi neverovatni svet analitike.
Za svakog ko želi de sebe profiliše u analitičara ovo je nezaobilazna stanica. Poznavanje alata poput Tableau i Power BI se sve više traži. U raznim oglasima za posao analitičara ovi alati su gotovo postali standard u opisu zahtevanih veština.
Svako ko želi put profesionalnog analitičara moraće da savlada pravljenje dashboard-a i njihovu automatizaciju bilo da je to Excel, Tableau ili Power BI.
PQ pruža neverovatnu lakoću učitavanja podataka, njihovo transformisanje i kombinovanje. Broj i način na koje se mnoge transformacije mogu izvesti značajno olakšava posao i značajno ga ubrzava.
Mogućnost da se svi koraci zapamte i ponove u svakom trenutku kao i da se promene je jedna fantastična fleksibilnost koju ovaj alat pruža.
Kada jednom uradite spajanje jedne ili više tabela u PQ prosto ćete zaboraviti na VLOOKUP koji ste toliko dugi koristili u Excel-u.
Nekoliko tehnika spajanja tabela pružaju sve što vam treba i ono što je do pojave PQ bilo nezamislivo izvesti ili krajnje teško uz programiranje kroz VBA, sada ćete raditi uz svega par klikova.
Pored neverovatne funkcionalnosti ono što ga možda njaviše krasi je potrebno vreme da se nauči – bićete iznenađeni jednostavnošću!
Upoznavanje sa interface-om alata je naravno prvi korak nakon čega sledi upoznavanje sa raznim funkcionalnostima. Akcenat je na samom alatu tj. grafičkim elementima ali upoznaćemo se i sa osnovama DAX jezika. Dax jeste od krucijalne važnosti ali njemu je posvećen poseban kurs.
Dizajn je nova komponenta koja se sada javlja i o kojoj ćete morati da razmišljate. Napraviti dobar izveštaj u kojem ćete kroz dobar dizajn prikazati ključne informacije i trendove, u današnje vreme digitalne revolucije poprima dimenziju umetnosti.
Tips & Tricks: neke tehnike koje će omogućiti izvodjenje nekih efekata koji će vaš dashboard učiniti dodatno interaktivnijim.
Susret sa AI do sada nikoga nije ostavio ravnodušnim pa smo prilično sigurni da neće ni VAS! Kako PBI koristi AI kroz Q&A je prava čarolija.
U osnovi DAX jezika leži zapravo princip pivota tj. osobine i ponašanje pivot tabele. Ali DAX jezik kroz Power Pivot sve to još podiže na viši nivo.
Iako mi u ExcelGuru volimo da kažemo da je DAX čaroban jezik, tu zapravo nema nikakve magije. Uvek je i gotovo uvek u pitanju KONTEKST KALKULACIJE i on je centralno mesto samoga jezika i krucijalni deo u razumevanju kako ovaj jezik deluje.
Kada jednom ovladate DAX-om, magija će se ipak pojaviti jer mogućnost manipulisanja čitavim setovima podataka koju ovaj jezik poseduje jeste čarolija koju ćete i vi posedovati.
Bez dobrog razumevanja osnovnih, a ujedno i krucijalnih, pojmova kao što su kalkulaciona kolona, kalkulaciono polje, kontekst kalkulacije i kako radi CACLULATION funkcija, nije moguće dobro raditi u PP & PBI. Zato za sve one koji žele da nastave svoje usavršavanje savladavanje DAX jezika je nešto što ne bi trebalo zaobići. Dobro DAX-ovanje je nešto što će vašoj profesionalnoj karijeri kao analitičara dati kompetitivnu prednost. Ako vašu karijeru želite da usmerite u pravcu profesionalne analitike onda je pored SQL-a, DAX još jedan jezik koji treba da imate u svom portfoliu veština koje posedujete.
Kao i svi naši kursevi i SQL kurs je naše lično iskustvo.
Poznavanje SQL jezika daje vam odredjenu samostalnost i nezavisnost u radu. Sami možete čitati podatke iz baze, organizovati ih u odgovarajuće tabele koje se dalje mogu koristiti za pravljenje izveštaja. Dinamički izveštaji i dashboard-i poznavanjem SQL-a i mogućnošću povezivanja, direktno ili indirektno, na bazu dobijaju potpuno novu dimenziju i punu snagu automatizacije.
Ovaj kurs je namenjen onima koji nemaju prethodno iskustvo sa SQL programskim jezikom i žele da saznaju zašto i kako da koriste SQL za oblikovanje podataka za ciljane analize.
Za svakog ko želi svoju karijeru da usmeri u data science, AI (Artificial intelligence), ML (Machine learning) SQL je jedan od osnovnih koraka koji se mora savladati. Čak i ako se želi ostati na nivou klasičnog analitičara SQL je nešto što ne bi trebalo da se zaobiđe.
Kurs je pažljivo osmišljen i dizajniran tako da vas voditi kroz korake kako biste sa sigurnošću mogli napisati i testirati SQL upite.
Kurs pokriva onaj deo SQL jezika koji je potreban analitičarima bez ulaženje u deo koji služi za administriranje baza podataka kao i arhitekturu DWH i ETL procesa. Skup znanja i tehnika koje dobijete na ovom kursu pokriva onaj deo koji će omogućiti da se sa podacima i tabelama manipuliše na željeni način. Da tako dobijene podatke uvezete u Excel, Power BI ili Tableau gde će te ih dalje koristiti za pravljenje izveštaja.
Okruženje u kojem se radi SQL kurs je Microsoft SQL Server Management Studio (SSMS).
Excel has become a standard that is taken for granted like basic knowledge of the English language. Today, it is impossible to imagine a job without at least occasional contact with the use of Excel, even architects use it to create project documentation. Sooner or later you will meet him. This course is a logical first step in the offer of Excel courses. We have tried to summarize and structure the necessary initial knowledge in one place so that Excel is a tool you will love.
Excel Guru I is a basic Excel course and is intended for those who encounter this tool for the first time or those who use this tool occasionally and now want to establish and expand their knowledge. This course aims to familiarize you with the interface of this tool and its basic functionalities. How to find your way around it quickly and easily and to make basic work in this tool not an obstacle but a pleasure and an inspiration to learn as much as possible about Excel and to improve yourself further.
Throughout my 16-year career, I encountered various problems and tasks that needed to be solved. Also, many colleagues and friends came to me with their excel files to help them. Regardless of the variety of tasks, which were very many, I noticed that solving most of them requires the same set of knowledge and skills. That’s how the Excel Guru II course was created, which contains a set of knowledge and skills that enables solving a wide range of business tasks. This is an intermediate level course.
This course is intended for those who already know the basics of this powerful tool and now want to upgrade their knowledge to a level higher that will enable them to perform faster and better most business tasks in the positions of assistants in sales, logistics, marketing, finance and all other positions where socializing with Excel is daily. In this course, we learn a lot more about Excel, and at the center of it all is the practical application of that knowledge.
Topics and material have been carefully selected to cover all the necessary techniques and functionalities for working with tables and data. All exercises are real examples from practice. The lectures are designed so that the theoretical part is covered first, followed by short practical exercises in order to practice the theoretical part with examples, and finally realistic scenarios in the form of concrete tasks.
It is not often the case that people know Excel well as a tool, but when they need to do something, a problem arises – they simply do not know where to start.
In addition to a good knowledge of tools, an analytical approach is very important when solving business tasks, therefore no less important, in this course, attention will also be paid to the way one should think when solving business tasks.
In this module, you go through about 40 of the most important functions from all groups – Text, Date & Time, Lookup & References, Math, Statistical, Information & Logical. After getting to know the syntax and basic functionality of each function, move on to exercises to see the real power of use of these functions. Through realistic tests and tasks, participants gain the necessary experience that will help them to independently recognize which functions they will use and in what way in their future work.
Also, through real examples, the participants are taught to first solve the problem logically, not Excel-wise, and only then approach the implementation of the technical solution through Excel, which should be in steps, i.e. partially because mistakes are easier to spot.
Any “ordinary” table can be converted into an Excel table. What does this gain? The table obtained in this way now has expanded possibilities. The table gets its name like every column, in fact the table turns into a small database that is easier to work with than with “ordinary” tables, for example writing formulas over an Excel table is extremely simple.
This module covers in great detail this very important but little-known and in practice little-used Excel functionality.
VLOOKUP is probably next to SUM the most used function in Excel.
It is probably one of the first more complex functions that anyone who comes into contact with Excel learns.
This feature is very useful and powerful, so an entire module is dedicated to it.
In addition to the basic form of using Vlookup, participants will learn more complex forms and variants of using this function.
I like to say: PIVOT is very powerful but not ALMIGHTY!
This module covers basic work with pivot tables which actually covers 90% of what Pivot can do.
Attendees will learn how to create a pivot, how to design it, how to manipulate data, various transformations, sorting, and a pivot chart that provides an incredibly easy way to bring your analysis to life.
How, where and when to use Pivot Tables, what are the advantages and what are the disadvantages are topics that will be discussed.
Yes, pivot is powerful and should be known!
At the end of the course, there is a moment for everyone to see how much they have learned – the Test!
The test is designed as one big task that combines all the main elements of the course.
The test is not graded, but your ExcelGuru teacher gives you an assessment of your performance at the end.
The test is not easy, it is not designed that way, it is the moment to really check that the time and money you have invested is not just another item in your budget.
Like Guru II this course was born from my personal experience. I like to say – in this course you will get to know the REAL POWER of EXCEL! I spent the last 7 years of my career as a Chief Analyst at Philip Morris. Mastering the techniques and skills of creating dynamic reports that will refresh in a few seconds was of crucial importance for me. This course contains fantastic things within it, an incredible magic that you too will possess.
This course is intended for all those who want to profile their career in the direction of analytics. Creating dynamic reports and dashboards in Excel is no less interesting today, although tools like Tableau and Power BI are specifically intended for this field of analytics – automation. Excel has been and I believe will always be an indispensable tool for any serious analyst, so a good knowledge of this tool is a prerequisite for everything else on your way to dealing with data.
If you want to really master Excel, then using formulas dynamically is a must.
Dynamic formula writing is actually an introduction to automation, it’s actually where the Excel magic begins! Index, Match and Offset are the three functions that I like to say make up the “heart” of automation in Excel. There are of course other functions such as the already well-known Vlookup, but these three functions together really make your reports come alive. Individually, they don’t have that power and can hardly match Vlookup, but together they provide the magic of automation and dynamic reporting.
This part of the course covers the advanced use of Index-Match, Offset and other functions, which can be combined with each other and with dynamic referencing enable complex calculations and incredible automation of reports that you can turn into very beautiful and functional dashboards.
As of this season (May 2020), Power Pivot and Power Query are an integral part of the Guru III course.
PQ gives Excel extra power and raises the bar to heights that no other tool for similar purposes can hardly reach. PQ enables the process of derivation, transformation and data loading (ETL process) in an easy and simple way.
Power Pivot is a real revolution and in a way it is an introduction to Power BI. In this course, we will learn the basics, in the center of which will be CUBE formulas that enable a new type of automation.
The subject of business reporting (Business Intelligence) has gained more and more importance in recent years. Hundreds of tools exist and offer various solutions, but since May 2019, Power BI has ascended to the throne. Compared to other tools, its popularity has grown at a tremendous speed since its inception. The need for analysts who know how to DAX and work in this tool is increasing.
That’s why ExcelGuru has prepared this course for you, which will introduce you to a new incredible world of analytics.
For anyone who wants to profile themselves as an analyst, this is an essential stop. Knowledge of tools like Tableau and Power BI is increasingly in demand. In various analyst job postings, these tools have become almost standard in describing required skills.
Anyone who wants to be a professional analyst will need to master the creation of dashboards and their automation, be it Excel, Tableau or Power BI.
PQ provides incredible ease of loading, transforming and combining data. The number and manner in which many transformations can be performed significantly ease the job and speed it up.
The ability to remember and repeat all the steps at any time as well as to change them, is a fantastic flexibility that this tool provides.
Once you join one or more tables in PQ, you will simply forget about VLOOKUP, which you used for so long in Excel.
Several techniques for joining tables provide everything you need, and what was unthinkable or extremely difficult to do with VBA programming until the advent of PQ, you can now do with just a few clicks.
In addition to its amazing functionality, what perhaps best adorns it is that it takes time to learn – you will be surprised by its simplicity!
Familiarity with the tool’s interface is of course the first step, followed by familiarization with various functionalities. The emphasis is on the tool itself, ie. graphic elements, but we will also get acquainted with the basics of the DAX language. DAX is of crucial importance, but a separate course is dedicated to it.
Design is a new component that is emerging now that you will need to think about. Creating a good report in which you will present key information and trends through a good design, in today’s digital revolution takes on the dimension of art.
Tips & Tricks: Some techniques that will allow you to perform some effects that will make your dashboard even more interactive.
The meeting with the AI has not left anyone indifferent so far, so we’re pretty sure YOU won’t either! How PBI uses AI through Q&A is real magic.
At the base of the DAX language lies the pivot principle, ie. features and behavior of a pivot table. But the DAX language through Power Pivot takes it all to a higher level.
Although we at ExcelGuru like to say that DAX is a magical language, there really isn’t any magic to it. It is always and almost always about the CALCULATION CONTEXT and it is the central place of the language itself and a crucial part in understanding how this language works.
Once you’ve mastered DAX, the magic will still happen because the ability to manipulate entire sets of data that this language possesses is a magic that you will possess as well.
Without a good understanding of basic, and at the same time crucial, concepts such as calculation column, calculation field, calculation context and how the CACLULATION function works, it is not possible to work well in PP & PBI. Therefore, for all those who want to continue their training, mastering the DAX language is something that should not be bypassed. DAXing well is something that will give your professional career as an analyst a competitive edge. If you want to direct your career in the direction of professional analytics, then in addition to SQL, DAX is another language that you should have in your portfolio of skills that you possess.
Like all our courses, the SQL course is our personal experience.
Knowing the SQL language gives you a certain autonomy and independence in your work. You can read the data from the database yourself, organize them into appropriate tables that can be further used to create reports. Dynamic reports and dashboards, with knowledge of SQL and the ability to connect, directly or indirectly, to the database gain a completely new dimension and the full power of automation.
This course is intended for those who have no previous experience with the SQL programming language and want to learn why and how to use SQL to shape data for targeted analysis.
For anyone who wants to direct their career in data science, AI (Artificial Intelligence), ML (Machine learning) SQL is one of the basic steps that must be mastered. Even if one wants to stay at the level of a classic analyst, SQL is something that should not be bypassed.
The course is carefully thought out and designed to guide you through the steps to confidently write and test SQL queries.
The course covers the part of the SQL language that is needed by analysts without going into the part that serves to administer databases as well as the architecture of DWH and ETL processes. The set of knowledge and techniques that you get in this course covers the part that will allow data and tables to be manipulated in the desired way. To import the data obtained in this way into Excel, Power BI or Tableau, where it will be used to create reports.
The environment in which the SQL course is conducted is Microsoft SQL Server Management Studio (SSMS).
