{"id":10558,"date":"2022-03-28T13:14:58","date_gmt":"2022-03-28T10:14:58","guid":{"rendered":"https:\/\/past.hrportal.md\/?post_type=event_listing&#038;p=10558"},"modified":"2024-01-22T18:19:18","modified_gmt":"2024-01-22T15:19:18","slug":"curs-excel-pentru-hr-online","status":"publish","type":"event_listing","link":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/","title":{"rendered":"Curs Excel Online p\/u HR"},"content":{"rendered":"<div class=\"kvgmc6g5 cxmmr5t8 oygrvhab hcukyx3x c1et5uql\">\n<p>Nu ai access sau \u00ee\u021bi este dificil s\u0103 contractezi un soft HR?<\/p>\n<p>Excel poate fi primul t\u0103u instrument de automatizare \u00een activitatea ta de resurse umane.<\/p>\n<p>\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile lui vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date cu angaja\u021bii din compania ta, vei putea extrage u\u0219or informa\u021bia pe diferite criterii de care ai nevoie, (persoane angajate \u00een luna ianuarie de exemplu sau persoane demisionate pe parcursul anului 2023)<\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t8d\/1\/16\/2611.png\" alt=\"\u2611\" width=\"16\" height=\"16\" \/><\/span>Vei putea calcula u\u0219or cite zile de concediu i-a r\u0103mas fiec\u0103rui angajat la o data anumit\u0103<\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t8d\/1\/16\/2611.png\" alt=\"\u2611\" width=\"16\" height=\"16\" \/><\/span>Vei putea introduce abil diverse formule \u00een tabelul de pontaj care s\u0103 \u00ee\u021bi economiseasc\u0103 timpul pe calcularea orelor \u0219i zilelor lucrate;<\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t8d\/1\/16\/2611.png\" alt=\"\u2611\" width=\"16\" height=\"16\" \/><\/span>Doar c\u00eeteva dintre beneficiile pe care le vei ob\u021bine venind la primul Curs de excel specializat \/ adaptat nevoilor unui profesionist din resurse umane.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>De ce s\u0103 fii prezent?<\/strong><\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t8d\/1\/16\/2611.png\" alt=\"\u2611\" width=\"16\" height=\"16\" \/><\/span>Datorita numarului redus de participanti, vei primi aten\u021bie individualizat\u0103 cu raspunsuri si explicatii exact la dificultatile la care te-ai blocat<\/p>\n<p><strong><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t8d\/1\/16\/2611.png\" alt=\"\u2611\" width=\"16\" height=\"16\" \/><mark class=\"lqd-highlight\"><span class=\"lqd-highlight-txt\">PRIME\u0218TI Bonus \u00eenregistrarea video \u0219i suportul de curs cu toate formulele utilizate!\u00a0\u00a0<\/span><span class=\"lqd-highlight-inner\"><\/span><\/mark><\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Program:<\/strong><\/p>\n<ol>\n<li><strong>\u00a0<\/strong><strong>Interfa\u021ba Excel: instrumente intuitive pentru domeniul resurselor umane <\/strong><\/li>\n<\/ol>\n<ul>\n<li>Bara de acces rapid, bara de titlu, bara de formule, panglica si gestiunea lor<\/li>\n<li>Conceptele de lucru in stocarea informa\u021bie<\/li>\n<li>Op\u021biuni de gestiune a foilor si a registrelor<\/li>\n<\/ul>\n<ol start=\"2\">\n<li><strong>Tipuri si formate de date, folosite in registrele de resurse umane <\/strong><\/li>\n<\/ol>\n<ul>\n<li>Numere<\/li>\n<li>Date calendaristice<\/li>\n<li>Texte<\/li>\n<li>Formate specifice tipurilor de date \u0219i aplicarea lor<\/li>\n<li>Serii specifice de date<\/li>\n<\/ul>\n<ol start=\"3\">\n<li><strong>Colectarea \u0219i<\/strong> <strong>Introducerea corecta a informa\u021biei angaja\u021bilor<\/strong><\/li>\n<\/ol>\n<ul>\n<li>Validarea datelor dup\u0103 lista<\/li>\n<li>Validarea informa\u021biei pentru date calendaristice<\/li>\n<li>Validarea datelor numerice<\/li>\n<li>Validarea condi\u021bionat\u0103 a informa\u021biei<\/li>\n<\/ul>\n<ol start=\"4\">\n<li><strong>Prelucrarea informa\u021biei specifice resurselor umane cu ajutorul formulelor si func\u021biilor <\/strong><\/li>\n<\/ol>\n<ul>\n<li>Opera\u021bii in formule (&amp;, +, -, *, \/, %, ^, &lt;, &lt;=, = &lt;&gt;, &gt;, &gt;=, And, Or, Not)<\/li>\n<li>Func\u021bii simple pentru calculul mediilor, totalurilor si transferurilor persoanelor.<\/li>\n<li>Calcule in dependenta de diferite criterii de selectare a persoanelor angajate, grupate pe departamente, domenii de activitate, filiale s.a<\/li>\n<li>Gestiunea informa\u021biilor conforma datelor: angaj\u0103rii, transferurilor, eliber\u0103rii, stagiului de munca, tuturor tipurilor de concedii.<\/li>\n<li>Prelucrarea informa\u021biilor de tip text cu ajutorul instrumentelor specifice resurselor umane<\/li>\n<li>Afi\u0219area si vizualizarea informa\u021biei, conform unor condi\u021bii complexe: dependen\u021ba de departament, v\u00e2rst\u0103, salariu, starea sociala s.a.m.d<\/li>\n<\/ul>\n<ol start=\"5\">\n<li><strong>Analiza informa\u021biilor, utiliz\u00e2nd instrumente simple <\/strong><\/li>\n<\/ol>\n<ul>\n<li>Tabele dinamice<\/li>\n<li>Format\u0103ri condi\u021bionate<\/li>\n<li>Sort\u0103ri<\/li>\n<li>Sort\u0103ri personalizate<\/li>\n<li>Filtr\u0103ri<\/li>\n<li>Agregarea rezultatelor filtr\u0103rii prin intermediul func\u021biilor corespunz\u0103toare<\/li>\n<li>Filtre avansate<\/li>\n<\/ul>\n<ol start=\"6\">\n<li><strong>Crearea rapoartelor: anuale, lunare, semestriale despre angaj\u0103ri, transferuri, eliber\u0103ri, concedii<\/strong><\/li>\n<\/ol>\n<ul>\n<li>Crearea rapoartelor in baza unei surse<\/li>\n<li>Crearea corecta a rapoartelor<\/li>\n<li>Formatarea personalizat\u0103 a rapoartelor<\/li>\n<li>Nivele de sortare in raport pivot<\/li>\n<li>Tipuri de filtrare a informa\u021biilor in tabele pivot<\/li>\n<li>Filtrarea interactiva a unuia si a mai multor tabele pivot<\/li>\n<li>Calcule simple in tabele pivot<\/li>\n<li>Calcule avansate in tabele pivot<\/li>\n<li>Calcule virtuale in tabele pivot<\/li>\n<li>Crearea unui tabel pivot in baza a mai multor surse<\/li>\n<\/ul>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/tf3\/1\/16\/1f539.png\" alt=\"\ud83d\udd39\" width=\"16\" height=\"16\" \/><\/span> Data: 12 Februarie 2024<\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/tf3\/1\/16\/1f539.png\" alt=\"\ud83d\udd39\" width=\"16\" height=\"16\" \/><\/span>Format: ONLINE<\/p>\n<p><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/tf3\/1\/16\/1f539.png\" alt=\"\ud83d\udd39\" width=\"16\" height=\"16\" \/><\/span>Investi\u021bia: 2799 Lei<\/p>\n<\/div>\n<div class=\"cxmmr5t8 oygrvhab hcukyx3x c1et5uql o9v6fnle\"><span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/tf3\/1\/16\/1f539.png\" alt=\"\ud83d\udd39\" width=\"16\" height=\"16\" \/><\/span>Detalii la num\u0103rul de telefon: <span class=\"pq6dq46d tbxw36s4 knj5qynh kvgmc6g5 ditlmg2l oygrvhab nvdbi5me sf5mxxl7 gl3lb2sf hhz5lgdu\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.xx.fbcdn.net\/images\/emoji.php\/v9\/t4d\/1\/16\/1f4de.png\" alt=\"\ud83d\udcde\" width=\"16\" height=\"16\" \/><\/span> +373 60 84 00 41<\/div>\n","protected":false},"featured_media":10790,"template":"","meta":[],"class_list":["post-10558","event_listing","type-event_listing","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Curs Excel Online p\/u HR | HRPortal Formule pentru tabelul de pontaj<\/title>\n<meta name=\"description\" content=\"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date &amp; vei putea extrage u\u0219or orice inf.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Curs Excel Online p\/u HR | HRPortal Formule pentru tabelul de pontaj\" \/>\n<meta property=\"og:description\" content=\"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date &amp; vei putea extrage u\u0219or orice inf.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/\" \/>\n<meta property=\"og:site_name\" content=\"HRPortal\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-22T15:19:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/past.hrportal.md\/wp-content\/uploads\/2022\/03\/excel-05.02.24.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"788\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Timp estimat pentru citire\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/\",\"url\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/\",\"name\":\"Curs Excel Online p\\\/u HR | HRPortal Formule pentru tabelul de pontaj\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/past.hrportal.md\\\/ro\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/past.hrportal.md\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/excel-05.02.24.png\",\"datePublished\":\"2022-03-28T10:14:58+00:00\",\"dateModified\":\"2024-01-22T15:19:18+00:00\",\"description\":\"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date & vei putea extrage u\u0219or orice inf.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/#primaryimage\",\"url\":\"https:\\\/\\\/past.hrportal.md\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/excel-05.02.24.png\",\"contentUrl\":\"https:\\\/\\\/past.hrportal.md\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/excel-05.02.24.png\",\"width\":940,\"height\":788,\"caption\":\"Excel Online\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/event\\\/curs-excel-pentru-hr-online\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Prima pagin\u0103\",\"item\":\"https:\\\/\\\/past.hrportal.md\\\/ro\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Curs Excel Online p\\\/u HR\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/past.hrportal.md\\\/ro\\\/#website\",\"url\":\"http:\\\/\\\/past.hrportal.md\\\/ro\\\/\",\"name\":\"HRPortal\",\"description\":\"Cursuri de instruire \u0219i consultan\u021b\u0103 \u00een managementul resurselor umane\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/past.hrportal.md\\\/ro\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ro-RO\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Curs Excel Online p\/u HR | HRPortal Formule pentru tabelul de pontaj","description":"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date & vei putea extrage u\u0219or orice inf.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/","og_locale":"ro_RO","og_type":"article","og_title":"Curs Excel Online p\/u HR | HRPortal Formule pentru tabelul de pontaj","og_description":"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date & vei putea extrage u\u0219or orice inf.","og_url":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/","og_site_name":"HRPortal","article_modified_time":"2024-01-22T15:19:18+00:00","og_image":[{"width":940,"height":788,"url":"https:\/\/past.hrportal.md\/wp-content\/uploads\/2022\/03\/excel-05.02.24.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Timp estimat pentru citire":"5 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/","url":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/","name":"Curs Excel Online p\/u HR | HRPortal Formule pentru tabelul de pontaj","isPartOf":{"@id":"http:\/\/past.hrportal.md\/ro\/#website"},"primaryImageOfPage":{"@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/#primaryimage"},"image":{"@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/#primaryimage"},"thumbnailUrl":"https:\/\/past.hrportal.md\/wp-content\/uploads\/2022\/03\/excel-05.02.24.png","datePublished":"2022-03-28T10:14:58+00:00","dateModified":"2024-01-22T15:19:18+00:00","description":"\u00censu\u0219ind aplica\u021biile \u0219i func\u021bionalit\u0103\u021bile Excelului vei putea u\u0219or s\u0103 \u00ee\u021bi organizezi prima baz\u0103 de date & vei putea extrage u\u0219or orice inf.","breadcrumb":{"@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/"]}]},{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/#primaryimage","url":"https:\/\/past.hrportal.md\/wp-content\/uploads\/2022\/03\/excel-05.02.24.png","contentUrl":"https:\/\/past.hrportal.md\/wp-content\/uploads\/2022\/03\/excel-05.02.24.png","width":940,"height":788,"caption":"Excel Online"},{"@type":"BreadcrumbList","@id":"https:\/\/past.hrportal.md\/ro\/event\/curs-excel-pentru-hr-online\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Prima pagin\u0103","item":"https:\/\/past.hrportal.md\/ro\/"},{"@type":"ListItem","position":2,"name":"Curs Excel Online p\/u HR"}]},{"@type":"WebSite","@id":"http:\/\/past.hrportal.md\/ro\/#website","url":"http:\/\/past.hrportal.md\/ro\/","name":"HRPortal","description":"Cursuri de instruire \u0219i consultan\u021b\u0103 \u00een managementul resurselor umane","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/past.hrportal.md\/ro\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ro-RO"}]}},"_links":{"self":[{"href":"https:\/\/past.hrportal.md\/ro\/wp-json\/wp\/v2\/event_listing\/10558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/past.hrportal.md\/ro\/wp-json\/wp\/v2\/event_listing"}],"about":[{"href":"https:\/\/past.hrportal.md\/ro\/wp-json\/wp\/v2\/types\/event_listing"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/past.hrportal.md\/ro\/wp-json\/wp\/v2\/media\/10790"}],"wp:attachment":[{"href":"https:\/\/past.hrportal.md\/ro\/wp-json\/wp\/v2\/media?parent=10558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}