The Path to Confident Excel Skills!
Tavas Excel prasmes var kļūt par Tavas karjeras atspēriena punktu.
If you want to improve your skills in working with data
Achieve your goals and your team's goals faster
Become more knowledgeable and confident
Increase your value in the labor market and climb the career ladder
Learn how to complete various tasks easier and faster!
Level of knowledge:From a beginner to a confident Excel user
Certificate: Excel Know How certificate that will prove the newly acquired knowledge
Language: Latvian language
Lectures: 200 video lectures; Excel work files for download
Suitable for training: Microsoft 365, 2013, 2016 and 2019 versions of Excel
Course length: >12h (total of 8 modules divided by topics)
KURSA PROGRAMMA: lejupielādei
Access to the course: 12 months
BONUS:12-month participation in Excel Know How master classes
Kāpēc šis kurss?
Tiešs atbalsts no ekspertu komandas: aizmirsti par laika izšķiešanu, meklējot atbildes internetā. Ja rodas jautājumi, vienkārši jautā mums – mēs palīdzēsim ar praktiskiem risinājumiem.
Efektīvas un praktiskas mācības: mūsu kurss ir izveidots, lai Tu varētu mācīties jebkurā laikā un jebkurā vietā. Katra tēma ir pārdomāti izskaidrota īsos, kodolīgos video.
Atbalsts visiem līmeņiem: neatkarīgi no tā, vai esi iesācējs vai jau esi strādājis ar Excel, šis kurss piedāvā noderīgas zināšanas, ko vari pielietot uzreiz savā darbā.
Reālas, praktiskas zināšanas: mēs nerunājam tikai par teoriju. Mēs Tev parādīsim, kā efektīvi risināt reālas problēmas, optimizēt datus un ātri izpildīt jebkuru uzdevumu.
The most important thing in one place for productive work with data!
-
The most important thing for a safe startand the basis for further work - functions and solutions for numbers, dates, text
-
Searching, finding, combining data- the most requested Excel functionality (VLOOKUP)
-
Look at data expertlyusing conditional selection functions (SUMIFS, etc.)
-
Select, filter, organize skillfully - manage with confidence
-
Display data beautifully- create graphs and dashboards professionally
-
Discover andmanage Excel's automatic designsbased on data values - an amazing data visualization experience
-
Analyzes data and displays dynamic PivotTables and PivotCharts. Everyone can do it!
-
Valuable everyday application tips at every step
If you want to feelconfident and professionalor you need to sharpen your current Excel knowledge and reduce the feeling of insecurity, this course will help you!
It is not possible to miss lectures,
because you will be able to watch them at a time and place convenient for you
ESI KURSA DALĪBNIEKS UN
PIEDALIES EXCEL DARBNĪCĀS
Iegādājies Excel Online kursu komplektā ar ikmēneša Excel tiešraides darbnīcām - meistarklasēm. Meistarklasēs tiek apskatītas dažādas papildu Excel tēmas, kuras paplašina gan kursā apgūto, gan aptver citas tēmas, kuras izvēlamies iedvesmojoties no studentu jautājumiem, interesēm un aktualitātēm.
Līdz šim apskatītas daudzas kursa dalībnieku augsti novērtētas tēmas, piemēram:
-
Kā izrakstīt rēķinus no Excel?
-
Excel īsceļi (shortcuts)
-
Efektīvs darbs Pivot tabulās
-
Dokumentu automatizācija ar Word & Excel (MailMerge)
- Par Datu validācijas sarakstiem
-
Meistarklase par INDEX MATCH
-
Datumi un laiks Excel
-
un citas
Everything you need to know to work better with data!
Module 1
ABOUT EXCEL'S MOST POPULAR FORMULAS, CREATING RELATIVE AND ABSOLUTE REFERENCES, COPYING FORMULAS
In this module, you will learn the most important things so that your future work with Excel will be much better.
-
"Basic set of functions" for working with numbers, texts and dates
-
copying formulas - how to effectively prepare formulas so that they can be copied correctly and reused, or cell relative and absolute references
-
Start using the power of Excel - evaluate both simple and compound conditions with the IF function
Dažas no mūsu kursantu atsauksmēm
Ar Excel Online kursu 'trāpīju desmitniekā’! Tas spēja aizraut no sākuma līdz beigām! Par visu bija padomāts!
Aiga Tarasova
Iegūtās zināšanas man ļoti atvieglo ikdienas darbu. Būtu gribējies to visu zināt jau agrāk.
Sigita Dagile
Pēc šo kursu apgūšanas mana darba ikdiena ir kļuvusi daudz vieglāka, ietaupot laiku un palielinot produktivitāti.
Laima Štolniece
Ļoti noder darba pienākumu pildīšanai :) Ļoti patīk, ka tiek parādīti dažādi risinājumi uzdevumiem!
Tatjana Kovaļenko
Katras minūtes vērts. Kurss, cik nu viegls, bet ļoti izsmeļošs un noderīgs. Ļoti patīk, ka ir darba lapas, kurās veikt sev svarīgos pierakstus.
Kristiāna Kapulinska
Lielisks online kurss. Bija iespēja mācīties manis izvēlētā laikā. Lejupielādējamie faili ar uzdevumiem ir lielisks uzskates materiāls.
Liene Tiļļa
Sadarbības partneri
Excel Kurss un darbnīcas vienā komplektā!
Paredzēts gan iesācējiem, gan ikdienas lietotājiem un ikvienam, kurš vēlas justies pārliecināti un prasmīgi darbā ar Excel.
EUR 195*
The offer includes:
-
Excel Online course (value 195,- EUR)
-
Free participation in the following live master classes, each worth EUR 25
-
12 months accessfor online training materials, work files
-
Bonus: 20 Productivity Tips Download
-
Bonus: Shortcuts pdf download
-
Support in the learning process - answers to questions, advice!
-
Excel Know How certificate, which will prove the newly acquired skills!
*cena privātpersonām; uzņēmumiem + PVN
** The course starts immediately after payment by card or Paypal. If you have chosen to pay for the course by bank transfer, you will access the lessons on the day the payment is received.
Pērkot katru kursu atsevišķi komplekta cena 390 EUR.
FREQUENTLY ASKED QUESTIONS
When does the course start and how long will I have access to this training?
The course starts immediately after payment by card or Paypal. If you have chosen to pay for the course by bank transfer, you will access the lessons on the day the payment is received. You will have access to training for 12 months. You can learn at your own pace or return to the materials at any time to brush up or review information on any course topic.
I am a complete beginner and with Excel I am on you. Will this training be right for me?
If you have to use Excel on a daily basis, or if you plan to do so in the future, then these trainings will definitely lay the foundations for using Excel. If you have not used excel at all, then it will probably take longer than other students, but if you need it, then the only way to learn is by doing.
What version of Excel do I need to take this course?
All examples are done using the Office 365 version of Excel. Using Office 2016 and 2019 you will not feel the difference, using the Office 2013 version you will notice some visual differences in the layout of the toolbar, but this does not change the essence of the function. On the other hand, using Excel 2010 and older versions, you will already notice functional differences.
How much time per week should I devote to the course?
As with any other skill, Excel can be learned if you take the time and it all depends on how quickly you want to learn it. The more time you invest, the faster you will learn. On average, our students spend about 1.5 to 2 hours a week on the course materials. However, if it will not be possible to learn the course material for a longer period of time, access to the materials and video lectures is 12 months. It will be possible to learn at your own pace, at a time convenient for you.
What is the training format?
The training consists of video lectures, which you can watch at any time convenient for you. The lectures are on average 3-5 minutes long (depending on the topic) and they are all available online. You will access them with your username and password.
If you have any questions while watching, you can ask them immediately in the discussion window or by sending a private message to ask@excelknowhow.com, and I or one of my teammates will be happy to help!
How can I receive an invoice on company details?
If payment is made with a company card, indicate the company name, registration number, address and account number in the notes. You will receive an invoice with the specified details by e-mail within one day.
If you want to pay for the course by transfer to our bank account, click on the "I want to pay by transfer" button, fill in the information we have asked you to provide about yourself and in the additional notes enter company name, registration no., address and Account No. and number of employees. You will receive e-mail within one day to pay the invoice with the specified details.
Ivars Krampis-Vanags
Excel Know How vadītājs, kursu autors un pasniedzējs
Esmu datu analīzes eksperts un praktiķis ar padziļinātām zināšanām Microsoft Excel, Microsoft Power BI un Mākslīgā intelekta (MI) jomā. Man ir ilggadēja pieredze finanšu vadībā, analīzē un plānošanā. Veiksmīgi optimizēju un uzlaboju procesus Excel un Power BI, kā arī integrēju MI risinājumus datu analīzē un vizualizācijā.
Esmu vairāku kursu un lekciju autors, sniedzot praktiskas apmācības un individuālas konsultācijas. Manus kursus ir apguvuši vairāk nekā 3000 studenti, un vebināros ir piedalījušies jau vairāk nekā 10 000 interesentu. Manas apmācības augsti novērtē dažādu nozaru komandas un speciālisti Latvijā, Baltijā un citur.
Augam par ekspertiem kopā!
SOFIUS SIA
LV40103714293
Nometņu 3-11, Riga, LV-1048, Latvia
Swedbank AS, HABALV22
LV30HABA0551048637023