{"id":32066,"date":"2020-02-08T17:36:12","date_gmt":"2020-02-08T15:36:12","guid":{"rendered":"https:\/\/www.it-training.pro\/courses\/779-analyzing-data-with-excel\/"},"modified":"2022-08-09T13:30:49","modified_gmt":"2022-08-09T10:30:49","slug":"779-analyzing-data-with-excel","status":"publish","type":"lp_course","link":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/","title":{"rendered":"779 &#8211; Analyzing Data with Excel"},"content":{"rendered":"<div class=\"pdfprnt-buttons pdfprnt-buttons-lp_course pdfprnt-top-right\"><a href=\"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/lp_course\/32066?print=pdf\" class=\"pdfprnt-button pdfprnt-button-pdf\" target=\"_blank\" ><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/plugins\/pdf-print\/images\/pdf.png\" alt=\"image_pdf\" title=\"Download PDF\" \/><\/a><a href=\"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/lp_course\/32066?print=print\" class=\"pdfprnt-button pdfprnt-button-print\" target=\"_blank\" ><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/plugins\/pdf-print\/images\/print.png\" alt=\"image_print\" title=\"Print Content\" \/><\/a><\/div><h1 style=\"text-align: center;\">Microsoft Official Courses (MOC)<\/h1>\n<div class=\"grid-container mscom-grid-container row-fluid\" data-cols=\"1\" data-view1=\"1\" data-view2=\"1\" data-view3=\"1\" data-view4=\"1\">\n<div class=\"span bp0-col-1-1 bp1-col-1-1 bp2-col-1-1 bp3-col-1-1\">\n<div class=\"grid-container mscom-grid-container row-fluid\" data-cols=\"1\" data-view1=\"1\" data-view2=\"1\" data-view3=\"1\" data-view4=\"1\">\n<div class=\"span bp0-col-1-1 bp1-col-1-1 bp2-col-1-1 bp3-col-1-1\">\n<div class=\"grid-container mscom-grid-container row-fluid\" data-cols=\"1\" data-view1=\"1\" data-view2=\"1\" data-view3=\"1\" data-view4=\"1\">\n<div class=\"span bp0-col-1-1 bp1-col-1-1 bp2-col-1-1 bp3-col-1-1\">\n<div class=\"grid-container mscom-grid-container row-fluid\" data-cols=\"1\" data-view1=\"1\" data-view2=\"1\" data-view3=\"1\" data-view4=\"1\">\n<div class=\"span bp0-col-1-1 bp1-col-1-1 bp2-col-1-1 bp3-col-1-1\">\n<h1 id=\"courseLangCode\" class=\"\" lang=\"en\" style=\"text-align: center;\">Course 20779B: Analyzing Data with Excel<\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner.png\"><img decoding=\"async\" class=\" wp-image-11355 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner.png\" alt=\"\" width=\"282\" height=\"185\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner.png 660w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner-600x394.png 600w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner-300x197.png 300w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner-230x151.png 230w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner-350x230.png 350w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2018\/10\/microsoft-partner-480x315.png 480w\" sizes=\"(max-width: 282px) 100vw, 282px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/ms365-ent-expert.png\"><img decoding=\"async\" class=\"size-full wp-image-14814 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/ms365-ent-expert.png\" alt=\"\" width=\"112\" height=\"112\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/ms365-ent-expert.png 112w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/ms365-ent-expert-100x100.png 100w\" sizes=\"(max-width: 112px) 100vw, 112px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<h2 style=\"text-align: center;\">About this Course:<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>\n<h5 style=\"font-weight: inherit;\">The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.<\/h5>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2 style=\"text-align: center;\">Course Goals\/Skills:<\/h2>\n<ul>\n<li class=\"\">Explore and extend a classic Excel dashboard.<\/li>\n<li>Explore and extend an Excel data model.<\/li>\n<li>Pre-format and import a .CSV file.<\/li>\n<li>Import data from a SQL Server database<\/li>\n<li>Import data from a report.<\/li>\n<li>Create measures using advanced DAX functions.<\/li>\n<li>Create data visualizations in Excel.<\/li>\n<li>Create a Power BI dashboard with Excel.<\/li>\n<\/ul>\n<h2 style=\"text-align: center;\">Audience:<\/h2>\n<div class=\"lb-rtxt\">\n<ul>\n<li>\n<p style=\"font-weight: 400;\">This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.<br \/>\nThe course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.<\/p>\n<\/li>\n<\/ul>\n<\/div>\n<hr \/>\n<h2 style=\"text-align: center;\"><b>Course Format:<\/b><\/h2>\n<div class=\"mceTemp\"><\/div>\n\n<table id=\"tablepress-1\" class=\"tablepress tablepress-id-1\">\n<thead>\n<tr class=\"row-1\">\n\t<th class=\"column-1\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www-cdn.it-training.pro\/wp-content\/uploads\/2019\/11\/teach.png\" alt=\"\" width=\"230\" height=\"230\" class=\"alignnone size-full wp-image-23575\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/teach.png 230w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/teach-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/teach-150x150.png 150w\" sizes=\"(max-width: 230px) 100vw, 230px\" \/><\/a><\/th><th class=\"column-2\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www-cdn.it-training.pro\/wp-content\/uploads\/2019\/11\/learn.png\" alt=\"\" width=\"230\" height=\"230\" class=\"alignnone size-full wp-image-23577\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/learn.png 230w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/learn-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/learn-150x150.png 150w\" sizes=\"(max-width: 230px) 100vw, 230px\" \/><\/a><\/th>\n<\/tr>\n<\/thead>\n<tbody class=\"row-hover\">\n<tr class=\"row-2\">\n\t<td class=\"column-1\"><strong><h4>\u041f\u0440\u0438\u0441\u044a\u0441\u0442\u0432\u0435\u043d (Classroom) \u041a\u0443\u0440\u0441 \u0432 \u0423\u0447\u0435\u0431\u043d\u0430\u0442\u0430 \u043d\u0438 \u0437\u0430\u043b\u0430 \u0438\u043b\u0438 \u0412 \u041e\u0444\u0438\u0441 \u043d\u0430 \u041a\u043b\u0438\u0435\u043d\u0442<\/h4><\/strong><\/td><td class=\"column-2\"><strong><h4>\u041e\u043d\u043b\u0430\u0439\u043d (Online\/Virtual) \u041a\u0443\u0440\u0441 \u0432\u044a\u0432 \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u043d\u0430 \u0437\u0430\u043b\u0430 \u0441 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440<\/h4><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-1 from cache -->\n<hr \/>\n<h2 style=\"text-align: center;\"><b>Course Language Option<\/b><\/h2>\n\n<table id=\"tablepress-2\" class=\"tablepress tablepress-id-2\">\n<thead>\n<tr class=\"row-1\">\n\t<th class=\"column-1\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/flag-400.png\" alt=\"\" width=\"400\" height=\"240\" class=\"alignnone size-full wp-image-30057\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/flag-400.png 400w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/flag-400-300x180.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/a><\/th><th class=\"column-2\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/flag-400-1.png\" alt=\"\" width=\"400\" height=\"240\" class=\"alignnone size-full wp-image-30061\" \/><\/a><\/th>\n<\/tr>\n<\/thead>\n<tbody class=\"row-striping row-hover\">\n<tr class=\"row-2\">\n\t<td class=\"column-1\"><strong><h4>\u0411\u044a\u043b\u0433\u0430\u0440\u0441\u043a\u0438 (Bulgarian)<\/h4><\/strong><\/td><td class=\"column-2\"><strong><h4>\u0410\u043d\u0433\u043b\u0438\u0439\u0441\u043a\u0438 (English)<\/h4><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-2 from cache -->\n<h4>You can choose the language in which the training will be conducted &#8211; Bulgarian or English. All our instructors are fluent in English.<\/h4>\n<hr \/>\n<h2 style=\"text-align: center;\"><b>Student Guides:<\/b><\/h2>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5.png\"><br \/>\n<img decoding=\"async\" class=\" wp-image-31777 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5.png\" alt=\"\" width=\"152\" height=\"151\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5.png 512w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5-300x300.png 300w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/digital-icon-png-5-150x150.png 150w\" sizes=\"(max-width: 152px) 100vw, 152px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4>The training materials are available in electronic format. They can be used online \/ offline on any device. Lifetime access.<\/h4>\n<hr \/>\n<h2 style=\"text-align: center;\"><b>Lab Environment<\/b>:<\/h2>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon.png\"><img decoding=\"async\" class=\" wp-image-31779 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon.png\" alt=\"\" width=\"141\" height=\"141\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon.png 512w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon-300x300.png 300w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/pc-icon-150x150.png 150w\" sizes=\"(max-width: 141px) 100vw, 141px\" \/><\/a><\/p>\n<h4>Each student has their own lab environment where the exercises are conducted, part of the course. You do not need to install software on a computer or special hardware requirements.<br \/>\nParticipants in a face-to-face format in our Training Center have an individual computer during the training.<\/h4>\n<hr \/>\n<h2>At Course Completion:<\/h2>\n<p style=\"text-align: center;\">\n<table id=\"tablepress-3\" class=\"tablepress tablepress-id-3\">\n<thead>\n<tr class=\"row-1\">\n\t<th class=\"column-1\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/video2.png\" alt=\"\" width=\"224\" height=\"224\" class=\"alignnone size-full wp-image-24443\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/video2.png 224w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/video2-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/video2-150x150.png 150w\" sizes=\"(max-width: 224px) 100vw, 224px\" \/><\/a><\/th><th class=\"column-2\"><a href=\"#\"><img decoding=\"async\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/prove.png\" alt=\"\" width=\"224\" height=\"224\" class=\"alignnone size-full wp-image-23579\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/prove.png 230w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/prove-100x100.png 100w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/11\/prove-150x150.png 150w\" sizes=\"(max-width: 224px) 100vw, 224px\" \/><\/a><\/th>\n<\/tr>\n<\/thead>\n<tbody class=\"row-striping row-hover\">\n<tr class=\"row-2\">\n\t<td class=\"column-1\"><strong><h4>Lifetime Access - Video Archive 24\/7<\/h4><\/strong><\/td><td class=\"column-2\"><strong><h4>Certificate of Course Completion<\/h4><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-3 from cache --><\/p>\n<h4>Lifetime access to a video archive with recording of each individual lecture.<br \/>\nOfficial internationally recognized certificate for completed training course.<\/h4>\n<hr \/>\n<h2 style=\"text-align: center;\">Course Duration:<\/h2>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time.png\"><img decoding=\"async\" class=\"wp-image-30437 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time.png\" alt=\"\" width=\"167\" height=\"176\" srcset=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time.png 932w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time-600x631.png 600w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time-285x300.png 285w, https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/09\/time-768x808.png 768w\" sizes=\"(max-width: 167px) 100vw, 167px\" \/><\/a><\/p>\n<ul>\n<li>3 working days (09:00 &#8211; 17:00)<br \/>\nor<\/li>\n<li>24 hours\u00a0 training (theory and practice) in non-working hours lasting 2weeks<br \/>\nSaturday and Sunday 10:00 &#8211; 14:00, 14:00 &#8211; 18:00, 18:00 &#8211; 22:00<br \/>\nMonday and Wednesday 19:00 &#8211; 23:00<br \/>\nTuesday and Thursday 19:00 &#8211; 23:00<\/li>\n<li><\/li>\n<\/ul>\n<hr \/>\n<h2 style=\"text-align: center;\"><b>Payments:<\/b><\/h2>\n<p><a href=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/10\/payments.png\"><img decoding=\"async\" class=\"size-full wp-image-21617 aligncenter\" src=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/10\/payments.png\" alt=\"\" width=\"247\" height=\"88\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>An application for an invoice is accepted at the time of enrollment in the respective course.<\/p>\n<p>An invoice is issued within 7 days of confirming the payment.<\/p>\n<hr \/>\n<h2 style=\"text-align: center;\">Next Class:<\/h2>\n<div  class=\"tribe-compatibility-container\" >\n\t<div\n\t\t class=\"tribe-common tribe-events tribe-events-view tribe-events-view--widget-events-list tribe-events-widget\" \t\tdata-js=\"tribe-events-view\"\n\t\tdata-view-rest-url=\"https:\/\/www.it-training.pro\/en\/wp-json\/tribe\/views\/v2\/html\"\n\t\tdata-view-manage-url=\"1\"\n\t\t\t\t\t\t\tdata-view-breakpoint-pointer=\"9a098c55-bacc-4da0-acee-a5ced9651b43\"\n\t\t\t>\n\t\t<div class=\"tribe-events-widget-events-list\">\n\n\t\t\t\n\t\t\t<script data-js=\"tribe-events-view-data\" type=\"application\/json\">\n\t{\"slug\":\"widget-events-list\",\"prev_url\":\"\",\"next_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/?post_type=tribe_events&eventDisplay=widget-events-list&paged=2\",\"view_class\":\"Tribe\\\\Events\\\\Views\\\\V2\\\\Views\\\\Widgets\\\\Widget_List_View\",\"view_slug\":\"widget-events-list\",\"view_label\":\"View\",\"view\":null,\"should_manage_url\":true,\"id\":null,\"alias-slugs\":null,\"title\":\"Events from 22 June 2026 \\u2013 6 July 2026 \\u2013 IT-Training.pro\",\"limit\":5,\"no_upcoming_events\":false,\"featured_events_only\":null,\"jsonld_enable\":false,\"tribe_is_list_widget\":true,\"admin_fields\":{\"title\":{\"label\":\"Title:\",\"type\":\"text\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-title\",\"name\":\"widget-tribe-widget-events-list[-1][title]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"limit\":{\"label\":\"Show:\",\"type\":\"number\",\"default\":5,\"min\":1,\"max\":10,\"step\":1,\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-limit\",\"name\":\"widget-tribe-widget-events-list[-1][limit]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"metadata_section\":{\"type\":\"fieldset\",\"classes\":\"tribe-common-form-control-checkbox-checkbox-group\",\"label\":\"Display:\",\"children\":{\"cost\":{\"type\":\"checkbox\",\"label\":\"Price\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-cost\",\"name\":\"widget-tribe-widget-events-list[-1][cost]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"venue\":{\"type\":\"checkbox\",\"label\":\"Venue\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-venue\",\"name\":\"widget-tribe-widget-events-list[-1][venue]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"street\":{\"type\":\"checkbox\",\"label\":\"Street\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-street\",\"name\":\"widget-tribe-widget-events-list[-1][street]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"city\":{\"type\":\"checkbox\",\"label\":\"City\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-city\",\"name\":\"widget-tribe-widget-events-list[-1][city]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"region\":{\"type\":\"checkbox\",\"label\":\"State (US) Or Province (Int)\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-region\",\"name\":\"widget-tribe-widget-events-list[-1][region]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"zip\":{\"type\":\"checkbox\",\"label\":\"Postal Code\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-zip\",\"name\":\"widget-tribe-widget-events-list[-1][zip]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"country\":{\"type\":\"checkbox\",\"label\":\"Country\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-country\",\"name\":\"widget-tribe-widget-events-list[-1][country]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"phone\":{\"type\":\"checkbox\",\"label\":\"Phone\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-phone\",\"name\":\"widget-tribe-widget-events-list[-1][phone]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"organizer\":{\"type\":\"checkbox\",\"label\":\"Organizer\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-organizer\",\"name\":\"widget-tribe-widget-events-list[-1][organizer]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"website\":{\"type\":\"checkbox\",\"label\":\"Website\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-website\",\"name\":\"widget-tribe-widget-events-list[-1][website]\",\"options\":[],\"placeholder\":\"\",\"value\":null}},\"parent_classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-metadata_section\",\"name\":\"widget-tribe-widget-events-list[-1][metadata_section]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"taxonomy_section\":{\"type\":\"section\",\"classes\":[\"calendar-widget-filters-container\"],\"label\":\"Filters:\",\"children\":{\"filters\":{\"type\":\"taxonomy-filters\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-filters\",\"label\":\"\",\"name\":\"widget-tribe-widget-events-list[-1][filters]\",\"options\":[],\"placeholder\":\"\",\"value\":null,\"list_items\":[]},\"operand\":{\"type\":\"fieldset\",\"classes\":\"tribe-common-form-control-checkbox-radio-group\",\"label\":\"Operand:\",\"selected\":\"OR\",\"children\":[{\"type\":\"radio\",\"label\":\"Match any\",\"button_value\":\"OR\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-operand\",\"name\":\"widget-tribe-widget-events-list[-1][operand]\",\"options\":[],\"placeholder\":\"\",\"value\":null},{\"type\":\"radio\",\"label\":\"Match all\",\"button_value\":\"AND\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-operand\",\"name\":\"widget-tribe-widget-events-list[-1][operand]\",\"options\":[],\"placeholder\":\"\",\"value\":null}],\"parent_classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-operand\",\"name\":\"widget-tribe-widget-events-list[-1][operand]\",\"options\":[],\"placeholder\":\"\",\"value\":null}},\"parent_classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-taxonomy_section\",\"name\":\"widget-tribe-widget-events-list[-1][taxonomy_section]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"taxonomy\":{\"type\":\"taxonomy\",\"classes\":\"calendar-widget-add-filter\",\"label\":\"Add a filter:\",\"placeholder\":\"Select a Taxonomy Term\",\"parent_classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-taxonomy\",\"name\":\"widget-tribe-widget-events-list[-1][taxonomy]\",\"options\":[],\"value\":null},\"no_upcoming_events\":{\"label\":\"Hide this widget if there are no upcoming events.\",\"type\":\"checkbox\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-no_upcoming_events\",\"name\":\"widget-tribe-widget-events-list[-1][no_upcoming_events]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"featured_events_only\":{\"label\":\"Limit to featured events only\",\"type\":\"checkbox\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-featured_events_only\",\"name\":\"widget-tribe-widget-events-list[-1][featured_events_only]\",\"options\":[],\"placeholder\":\"\",\"value\":null},\"jsonld_enable\":{\"label\":\"Generate JSON-LD data\",\"type\":\"checkbox\",\"parent_classes\":\"\",\"classes\":\"\",\"dependency\":\"\",\"id\":\"widget-tribe-widget-events-list--1-jsonld_enable\",\"name\":\"widget-tribe-widget-events-list[-1][jsonld_enable]\",\"options\":[],\"placeholder\":\"\",\"value\":null}},\"venue\":false,\"country\":false,\"street\":false,\"city\":false,\"region\":false,\"zip\":false,\"phone\":false,\"cost\":false,\"organizer\":false,\"website\":false,\"operand\":\"OR\",\"filters\":{\"post_tag\":[],\"tribe_events_cat\":[]},\"address\":false,\"events\":[10007869,10008126,10008127,10007870,10008128],\"url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/?post_type=tribe_events&eventDisplay=widget-events-list\",\"url_event_date\":false,\"bar\":{\"keyword\":\"\",\"date\":\"\"},\"today\":\"2026-06-22 00:00:00\",\"now\":\"2026-06-22 09:19:30\",\"home_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/\",\"rest_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/wp-json\\\/tribe\\\/views\\\/v2\\\/html\",\"rest_method\":\"GET\",\"rest_nonce\":\"\",\"today_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/?post_type=tribe_events&eventDisplay=widget-events-list&rest_route=%2Fwp%2Fv2%2Flp_course%2F32066\",\"today_title\":\"Click to select today's date\",\"today_label\":\"Today\",\"prev_label\":\"\",\"next_label\":\"\",\"date_formats\":{\"compact\":\"Y-m-d\",\"month_and_year_compact\":\"Y-m\",\"month_and_year\":\"F Y\",\"time_range_separator\":\" - \",\"date_time_separator\":\" @ \"},\"messages\":[],\"start_of_week\":\"1\",\"header_title\":\"\",\"header_title_element\":\"h1\",\"content_title\":\"\",\"show_content_title\":false,\"breadcrumbs\":[],\"backlink\":false,\"before_events\":\"\",\"after_events\":\"\\n<!--\\nThis calendar is powered by The Events Calendar.\\nhttp:\\\/\\\/evnt.is\\\/18wn\\n-->\\n\",\"display_events_bar\":false,\"disable_event_search\":false,\"live_refresh\":true,\"ical\":{\"display_link\":true,\"link\":{\"url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/?post_type=tribe_events&#038;eventDisplay=widget-events-list&#038;ical=1\",\"text\":\"Export Events\",\"title\":\"Use this to share calendar data with Google Calendar, Apple iCal and other compatible apps\"}},\"container_classes\":[\"tribe-common\",\"tribe-events\",\"tribe-events-view\",\"tribe-events-view--widget-events-list\",\"tribe-events-widget\"],\"container_data\":[],\"is_past\":false,\"breakpoints\":{\"xsmall\":500,\"medium\":768,\"full\":960},\"breakpoint_pointer\":\"9a098c55-bacc-4da0-acee-a5ced9651b43\",\"is_initial_load\":false,\"public_views\":{\"list\":{\"view_class\":\"Tribe\\\\Events\\\\Views\\\\V2\\\\Views\\\\List_View\",\"view_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/calendar\\\/list\\\/\",\"view_label\":\"List\",\"aria_label\":\"Display Events in List View\"},\"month\":{\"view_class\":\"Tribe\\\\Events\\\\Views\\\\V2\\\\Views\\\\Month_View\",\"view_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/calendar\\\/month\\\/\",\"view_label\":\"Month\",\"aria_label\":\"Display Events in Month View\"},\"day\":{\"view_class\":\"Tribe\\\\Events\\\\Views\\\\V2\\\\Views\\\\Day_View\",\"view_url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/calendar\\\/today\\\/\",\"view_label\":\"Day\",\"aria_label\":\"Display Events in Day View\"}},\"show_latest_past\":false,\"past\":false,\"compatibility_classes\":[\"tribe-compatibility-container\"],\"view_more_text\":\"View Calendar\",\"view_more_title\":\"View more events.\",\"view_more_link\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/calendar\\\/\",\"widget_title\":\"\",\"hide_if_no_upcoming_events\":false,\"display\":{\"cost\":false,\"venue\":false,\"street\":false,\"city\":false,\"region\":false,\"zip\":false,\"country\":false,\"phone\":false,\"organizer\":false,\"website\":false},\"subscribe_links\":{\"gcal\":{\"label\":\"Google Calendar\",\"single_label\":\"Add to Google Calendar\",\"visible\":true,\"block_slug\":\"hasGoogleCalendar\"},\"ical\":{\"label\":\"iCalendar\",\"single_label\":\"Add to iCalendar\",\"visible\":true,\"block_slug\":\"hasiCal\"},\"outlook-365\":{\"label\":\"Outlook 365\",\"single_label\":\"Outlook 365\",\"visible\":true,\"block_slug\":\"hasOutlook365\"},\"outlook-live\":{\"label\":\"Outlook Live\",\"single_label\":\"Outlook Live\",\"visible\":true,\"block_slug\":\"hasOutlookLive\"},\"ics\":{\"label\":\"Export .ics file\",\"single_label\":\"Export .ics file\",\"visible\":true,\"block_slug\":null},\"outlook-ics\":{\"label\":\"Export Outlook .ics file\",\"single_label\":\"Export Outlook .ics file\",\"visible\":true,\"block_slug\":null}},\"display_recurring_toggle\":true,\"_context\":{\"slug\":\"widget-events-list\"}}<\/script>\n\n\t\t\t\n\t\t\t\n\t\t\t\t<div class=\"tribe-events-widget-events-list__events\">\n\t\t\t\t\t\t\t\t\t\t\t<div  class=\"tribe-common-g-row tribe-events-widget-events-list__event-row\" >\n\n\t<div class=\"tribe-events-widget-events-list__event-date-tag tribe-common-g-col\">\n\t<time class=\"tribe-events-widget-events-list__event-date-tag-datetime\" datetime=\"2026-06-06\">\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-month\">\n\t\t\tJun\t\t<\/span>\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-daynum tribe-common-h2 tribe-common-h4--min-medium\">\n\t\t\t6\t\t<\/span>\n\t<\/time>\n<\/div>\n\n\t<div class=\"tribe-events-widget-events-list__event-wrapper tribe-common-g-col\">\n\t\t<article  class=\"tribe-events-widget-events-list__event post-10007869 tribe_events type-tribe_events status-publish has-post-thumbnail hentry tag-101-500 tag-102-500-2 tag-course-2 tag-ittraining tag-linux tag-linux-professional tag-lpi tag-lpic-1 tag-lpic-1-101-500 tag-lpic-1-102-500 tag-lpic-1-system-administrator tag-onlinecourse tag-system-administrator tribe_events_cat-lpi tribe_events_cat-lpic-1 pmpro-has-access tribe-recurring-event tribe-recurring-event-parent\" >\n\t\t\t<div class=\"tribe-events-widget-events-list__event-details\">\n\n\t\t\t\t<header class=\"tribe-events-widget-events-list__event-header\">\n\t\t\t\t\t<div class=\"tribe-events-widget-events-list__event-datetime-wrapper tribe-common-b2 tribe-common-b3--min-medium\">\n\t\t<time class=\"tribe-events-widget-events-list__event-datetime\" datetime=\"2026-06-06\">\n\t\t<span class=\"tribe-event-date-start\">6 June 2026 @ 10:00<\/span> - <span class=\"tribe-event-date-end\">28 June 2026 @ 14:00<\/span> <span class='timezone'> EEST <\/span>\t<\/time>\n\t\n<span class=\"tribe-events-calendar-series-archive__container\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/series\/linux-professional-institute-lpic-1-prep-for-101-500-and-102-500-4-weeks-13\/\"\n\t\taria-label=\"Event series: Linux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\"\n\t\tclass=\"tribe-events-calendar-series-archive__link\"\n\t>\n\t\t\n<svg  class=\"tribe-common-c-svgicon tribe-common-c-svgicon--series tribe-events-series-archive__icon\"  width=\"14\" height=\"12\" viewBox=\"0 0 14 12\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t<rect x=\"0.5\" y=\"4.5\" width=\"9\" height=\"7\" \/>\n\t<path d=\"M2 2.5H11.5V10\" \/>\n\t<path d=\"M4 0.5H13.5V8\" \/>\n<\/svg>\n\t<\/a>\n<\/span>\n<\/div>\n\t\t\t\t\t<h3 class=\"tribe-events-widget-events-list__event-title tribe-common-h7\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/event\/linux-professional-institute-lpic-1-prep-for-101-500-and-102-500-4-weeks-15\/2026-06-06\/\"\n\t\ttitle=\"Linux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\"\n\t\trel=\"bookmark\"\n\t\tclass=\"tribe-events-widget-events-list__event-title-link tribe-common-anchor-thin\"\n\t>\n\t\tLinux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\t<\/a>\n<\/h3>\n\t\t\t\t<\/header>\n\n\t\t\t\t\n\t\t\t<\/div>\n\t\t<\/article>\n\t<\/div>\n\n<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div  class=\"tribe-common-g-row tribe-events-widget-events-list__event-row\" >\n\n\t<div class=\"tribe-events-widget-events-list__event-date-tag tribe-common-g-col\">\n\t<time class=\"tribe-events-widget-events-list__event-date-tag-datetime\" datetime=\"2026-06-22\">\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-month\">\n\t\t\tJun\t\t<\/span>\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-daynum tribe-common-h2 tribe-common-h4--min-medium\">\n\t\t\t22\t\t<\/span>\n\t<\/time>\n<\/div>\n\n\t<div class=\"tribe-events-widget-events-list__event-wrapper tribe-common-g-col\">\n\t\t<article  class=\"tribe-events-widget-events-list__event post-10008126 tribe_events type-tribe_events status-publish has-post-thumbnail hentry tag-ceh tag-ceh-version-13 tag-cehv13 tag-cehv13ai tag-certified-ethical-hacker tag-course-2 tag-ec-council tag-ethical-hacker tag-hacker tag-it tribe_events_cat-ceh tribe_events_cat-ec-council tribe_events_cat-live-training pmpro-has-access tribe-recurring-event tribe-recurring-event-parent\" >\n\t\t\t<div class=\"tribe-events-widget-events-list__event-details\">\n\n\t\t\t\t<header class=\"tribe-events-widget-events-list__event-header\">\n\t\t\t\t\t<div class=\"tribe-events-widget-events-list__event-datetime-wrapper tribe-common-b2 tribe-common-b3--min-medium\">\n\t\t<time class=\"tribe-events-widget-events-list__event-datetime\" datetime=\"2026-06-22\">\n\t\t<span class=\"tribe-event-date-start\">22 June 2026 @ 09:00<\/span> - <span class=\"tribe-event-date-end\">26 June 2026 @ 17:00<\/span> <span class='timezone'> EEST <\/span>\t<\/time>\n\t\n<span class=\"tribe-events-calendar-series-archive__container\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/series\/ec-council-certified-ethical-hacker-cehv13-en\/\"\n\t\taria-label=\"Event series: EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\tclass=\"tribe-events-calendar-series-archive__link\"\n\t>\n\t\t\n<svg  class=\"tribe-common-c-svgicon tribe-common-c-svgicon--series tribe-events-series-archive__icon\"  width=\"14\" height=\"12\" viewBox=\"0 0 14 12\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t<rect x=\"0.5\" y=\"4.5\" width=\"9\" height=\"7\" \/>\n\t<path d=\"M2 2.5H11.5V10\" \/>\n\t<path d=\"M4 0.5H13.5V8\" \/>\n<\/svg>\n\t<\/a>\n<\/span>\n<\/div>\n\t\t\t\t\t<h3 class=\"tribe-events-widget-events-list__event-title tribe-common-h7\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/event\/ec-council-certified-ethical-hacker-cehv13-en\/2026-06-22\/\"\n\t\ttitle=\"EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\trel=\"bookmark\"\n\t\tclass=\"tribe-events-widget-events-list__event-title-link tribe-common-anchor-thin\"\n\t>\n\t\tEC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\t<\/a>\n<\/h3>\n\t\t\t\t<\/header>\n\n\t\t\t\t\n\t\t\t<\/div>\n\t\t<\/article>\n\t<\/div>\n\n<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div  class=\"tribe-common-g-row tribe-events-widget-events-list__event-row\" >\n\n\t<div class=\"tribe-events-widget-events-list__event-date-tag tribe-common-g-col\">\n\t<time class=\"tribe-events-widget-events-list__event-date-tag-datetime\" datetime=\"2026-06-29\">\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-month\">\n\t\t\tJun\t\t<\/span>\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-daynum tribe-common-h2 tribe-common-h4--min-medium\">\n\t\t\t29\t\t<\/span>\n\t<\/time>\n<\/div>\n\n\t<div class=\"tribe-events-widget-events-list__event-wrapper tribe-common-g-col\">\n\t\t<article  class=\"tribe-events-widget-events-list__event post-10008127 tribe_events type-tribe_events status-publish has-post-thumbnail hentry tag-ceh tag-ceh-version-13 tag-cehv13 tag-cehv13ai tag-certified-ethical-hacker tag-course-2 tag-ec-council tag-ethical-hacker tag-hacker tag-it tribe_events_cat-ceh tribe_events_cat-ec-council tribe_events_cat-live-training pmpro-has-access tribe-recurring-event tribe-recurring-event-parent\" >\n\t\t\t<div class=\"tribe-events-widget-events-list__event-details\">\n\n\t\t\t\t<header class=\"tribe-events-widget-events-list__event-header\">\n\t\t\t\t\t<div class=\"tribe-events-widget-events-list__event-datetime-wrapper tribe-common-b2 tribe-common-b3--min-medium\">\n\t\t<time class=\"tribe-events-widget-events-list__event-datetime\" datetime=\"2026-06-29\">\n\t\t<span class=\"tribe-event-date-start\">29 June 2026 @ 09:00<\/span> - <span class=\"tribe-event-date-end\">3 July 2026 @ 17:00<\/span> <span class='timezone'> EEST <\/span>\t<\/time>\n\t\n<span class=\"tribe-events-calendar-series-archive__container\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/series\/ec-council-certified-ethical-hacker-cehv13-en\/\"\n\t\taria-label=\"Event series: EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\tclass=\"tribe-events-calendar-series-archive__link\"\n\t>\n\t\t\n<svg  class=\"tribe-common-c-svgicon tribe-common-c-svgicon--series tribe-events-series-archive__icon\"  width=\"14\" height=\"12\" viewBox=\"0 0 14 12\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t<rect x=\"0.5\" y=\"4.5\" width=\"9\" height=\"7\" \/>\n\t<path d=\"M2 2.5H11.5V10\" \/>\n\t<path d=\"M4 0.5H13.5V8\" \/>\n<\/svg>\n\t<\/a>\n<\/span>\n<\/div>\n\t\t\t\t\t<h3 class=\"tribe-events-widget-events-list__event-title tribe-common-h7\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/event\/ec-council-certified-ethical-hacker-cehv13-en\/2026-06-29\/\"\n\t\ttitle=\"EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\trel=\"bookmark\"\n\t\tclass=\"tribe-events-widget-events-list__event-title-link tribe-common-anchor-thin\"\n\t>\n\t\tEC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\t<\/a>\n<\/h3>\n\t\t\t\t<\/header>\n\n\t\t\t\t\n\t\t\t<\/div>\n\t\t<\/article>\n\t<\/div>\n\n<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div  class=\"tribe-common-g-row tribe-events-widget-events-list__event-row\" >\n\n\t<div class=\"tribe-events-widget-events-list__event-date-tag tribe-common-g-col\">\n\t<time class=\"tribe-events-widget-events-list__event-date-tag-datetime\" datetime=\"2026-07-04\">\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-month\">\n\t\t\tJul\t\t<\/span>\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-daynum tribe-common-h2 tribe-common-h4--min-medium\">\n\t\t\t4\t\t<\/span>\n\t<\/time>\n<\/div>\n\n\t<div class=\"tribe-events-widget-events-list__event-wrapper tribe-common-g-col\">\n\t\t<article  class=\"tribe-events-widget-events-list__event post-10007870 tribe_events type-tribe_events status-publish has-post-thumbnail hentry tag-101-500 tag-102-500-2 tag-course-2 tag-ittraining tag-linux tag-linux-professional tag-lpi tag-lpic-1 tag-lpic-1-101-500 tag-lpic-1-102-500 tag-lpic-1-system-administrator tag-onlinecourse tag-system-administrator tribe_events_cat-lpi tribe_events_cat-lpic-1 pmpro-has-access tribe-recurring-event tribe-recurring-event-parent\" >\n\t\t\t<div class=\"tribe-events-widget-events-list__event-details\">\n\n\t\t\t\t<header class=\"tribe-events-widget-events-list__event-header\">\n\t\t\t\t\t<div class=\"tribe-events-widget-events-list__event-datetime-wrapper tribe-common-b2 tribe-common-b3--min-medium\">\n\t\t<time class=\"tribe-events-widget-events-list__event-datetime\" datetime=\"2026-07-04\">\n\t\t<span class=\"tribe-event-date-start\">4 July 2026 @ 10:00<\/span> - <span class=\"tribe-event-date-end\">26 July 2026 @ 14:00<\/span> <span class='timezone'> EEST <\/span>\t<\/time>\n\t\n<span class=\"tribe-events-calendar-series-archive__container\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/series\/linux-professional-institute-lpic-1-prep-for-101-500-and-102-500-4-weeks-13\/\"\n\t\taria-label=\"Event series: Linux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\"\n\t\tclass=\"tribe-events-calendar-series-archive__link\"\n\t>\n\t\t\n<svg  class=\"tribe-common-c-svgicon tribe-common-c-svgicon--series tribe-events-series-archive__icon\"  width=\"14\" height=\"12\" viewBox=\"0 0 14 12\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t<rect x=\"0.5\" y=\"4.5\" width=\"9\" height=\"7\" \/>\n\t<path d=\"M2 2.5H11.5V10\" \/>\n\t<path d=\"M4 0.5H13.5V8\" \/>\n<\/svg>\n\t<\/a>\n<\/span>\n<\/div>\n\t\t\t\t\t<h3 class=\"tribe-events-widget-events-list__event-title tribe-common-h7\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/event\/linux-professional-institute-lpic-1-prep-for-101-500-and-102-500-4-weeks-15\/2026-07-04\/\"\n\t\ttitle=\"Linux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\"\n\t\trel=\"bookmark\"\n\t\tclass=\"tribe-events-widget-events-list__event-title-link tribe-common-anchor-thin\"\n\t>\n\t\tLinux Professional Institute LPIC-1 prep for 101-500 and 102-500 (4 weeks)\t<\/a>\n<\/h3>\n\t\t\t\t<\/header>\n\n\t\t\t\t\n\t\t\t<\/div>\n\t\t<\/article>\n\t<\/div>\n\n<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div  class=\"tribe-common-g-row tribe-events-widget-events-list__event-row\" >\n\n\t<div class=\"tribe-events-widget-events-list__event-date-tag tribe-common-g-col\">\n\t<time class=\"tribe-events-widget-events-list__event-date-tag-datetime\" datetime=\"2026-07-06\">\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-month\">\n\t\t\tJul\t\t<\/span>\n\t\t<span class=\"tribe-events-widget-events-list__event-date-tag-daynum tribe-common-h2 tribe-common-h4--min-medium\">\n\t\t\t6\t\t<\/span>\n\t<\/time>\n<\/div>\n\n\t<div class=\"tribe-events-widget-events-list__event-wrapper tribe-common-g-col\">\n\t\t<article  class=\"tribe-events-widget-events-list__event post-10008128 tribe_events type-tribe_events status-publish has-post-thumbnail hentry tag-ceh tag-ceh-version-13 tag-cehv13 tag-cehv13ai tag-certified-ethical-hacker tag-course-2 tag-ec-council tag-ethical-hacker tag-hacker tag-it tribe_events_cat-ceh tribe_events_cat-ec-council tribe_events_cat-live-training pmpro-has-access tribe-recurring-event tribe-recurring-event-parent\" >\n\t\t\t<div class=\"tribe-events-widget-events-list__event-details\">\n\n\t\t\t\t<header class=\"tribe-events-widget-events-list__event-header\">\n\t\t\t\t\t<div class=\"tribe-events-widget-events-list__event-datetime-wrapper tribe-common-b2 tribe-common-b3--min-medium\">\n\t\t<time class=\"tribe-events-widget-events-list__event-datetime\" datetime=\"2026-07-06\">\n\t\t<span class=\"tribe-event-date-start\">6 July 2026 @ 09:00<\/span> - <span class=\"tribe-event-date-end\">10 July 2026 @ 17:00<\/span> <span class='timezone'> EEST <\/span>\t<\/time>\n\t\n<span class=\"tribe-events-calendar-series-archive__container\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/series\/ec-council-certified-ethical-hacker-cehv13-en\/\"\n\t\taria-label=\"Event series: EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\tclass=\"tribe-events-calendar-series-archive__link\"\n\t>\n\t\t\n<svg  class=\"tribe-common-c-svgicon tribe-common-c-svgicon--series tribe-events-series-archive__icon\"  width=\"14\" height=\"12\" viewBox=\"0 0 14 12\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t<rect x=\"0.5\" y=\"4.5\" width=\"9\" height=\"7\" \/>\n\t<path d=\"M2 2.5H11.5V10\" \/>\n\t<path d=\"M4 0.5H13.5V8\" \/>\n<\/svg>\n\t<\/a>\n<\/span>\n<\/div>\n\t\t\t\t\t<h3 class=\"tribe-events-widget-events-list__event-title tribe-common-h7\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/event\/ec-council-certified-ethical-hacker-cehv13-en\/2026-07-06\/\"\n\t\ttitle=\"EC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\"\n\t\trel=\"bookmark\"\n\t\tclass=\"tribe-events-widget-events-list__event-title-link tribe-common-anchor-thin\"\n\t>\n\t\tEC-Council &#8211; Certified Ethical Hacker (CEHv13 EN)\t<\/a>\n<\/h3>\n\t\t\t\t<\/header>\n\n\t\t\t\t\n\t\t\t<\/div>\n\t\t<\/article>\n\t<\/div>\n\n<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t<div class=\"tribe-events-widget-events-list__view-more tribe-common-b1 tribe-common-b2--min-medium\">\n\t<a\n\t\thref=\"https:\/\/www.it-training.pro\/en\/calendar\/\"\n\t\tclass=\"tribe-events-widget-events-list__view-more-link tribe-common-anchor-thin\"\n\t\ttitle=\"View more events.\"\n\t>\n\t\tView Calendar\t<\/a>\n<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n<script data-js='tribe-events-view-nonce-data' type='application\/json'>{\"tvn1\":\"8a571f1c3e\",\"tvn2\":\"\"}<\/script>\n<p>For more information, use the contact format. We will contact you to confirm the data.<\/p>\n<hr \/>\n<div class=\"course-section__heading\">\n<h2 class=\"course-section__title\" style=\"text-align: center;\">Prerequisites:<\/h2>\n<\/div>\n<div class=\"course-section__content\">\n<div class=\"course-section__rtf\">\n<ul>\n<li>\n<div class=\"editor\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul class=\"\">\n<li><span style=\"font-family: Calibri;\">Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/span><\/li>\n<li>Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/li>\n<li>Working knowledge of relational databases.<\/li>\n<li>Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.<\/li>\n<li>Basic knowledge of data analytics equivalent to having attended course 10994.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/li>\n<\/ul>\n<hr \/>\n<h3 style=\"text-align: center;\">This Class will teach you how to pass the following exams:<\/h3>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h2 class=\"has-margin-none\">Exam 70-779: Analyzing data with Excel<\/h2>\n<\/li>\n<li><a href=\"https:\/\/www.it-training.pro\/en\/catalog\/%d0%b2%d0%b0%d1%83%d1%87%d0%b5%d1%80-%d0%b7%d0%b0-%d1%81%d0%b5%d1%80%d1%82%d0%b8%d1%84%d0%b8%d0%ba%d0%b0%d1%86%d0%b8%d0%be%d0%bd%d0%b5%d0%bd-%d0%b8%d0%b7%d0%bf%d0%b8%d1%82-microsoft-certification-exam\/\">\u041c\u043e\u0436\u0435 \u0434\u0430 \u0441\u0435 \u0441\u0435\u0440\u0442\u0438\u0444\u0438\u0446\u0438\u0440\u0430\u0442\u0435 \u0432 \u043d\u0430\u0448\u0438\u044f \u0442\u0435\u0441\u0442 \u0446\u0435\u043d\u0442\u044a\u0440 \u0441 \u0432\u0430\u0443\u0447\u0435\u0440 \u0441 \u043e\u0442\u0441\u0442\u044a\u043f\u043a\u0430 \u043e\u0442 \u0446\u0435\u043d\u0430\u0442\u0430 \u043d\u0430 \u0438\u0437\u043f\u0438\u0442.<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.<\/p>\n","protected":false},"author":2,"featured_media":28093,"comment_status":"closed","ping_status":"closed","template":"","course_category":[3761,3786,4202,4237,4203,4366],"course_tag":[4520],"class_list":["post-32066","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-instructor-lead-training","course_category-microsoft-en","course_category-mos-en","course_category-office-365-en","course_category-office-365-2019-en","course_category-power-bi-en","course_tag-powerbi-en","pmpro-has-access","course"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>779 - Analyzing Data with Excel Course - IT-Training.pro<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"779 - Analyzing Data with Excel Course - IT-Training.pro\" \/>\n<meta property=\"og:description\" content=\"The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IT-Training.pro\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ittrainingpro\/\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-09T10:30:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/Power-BI-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1020\" \/>\n\t<meta property=\"og:image:height\" content=\"520\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ITTraining_pro\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/\",\"url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/\",\"name\":\"779 - Analyzing Data with Excel Course - IT-Training.pro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.it-training.pro\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Power-BI-1.png\",\"datePublished\":\"2020-02-08T15:36:12+00:00\",\"dateModified\":\"2022-08-09T10:30:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.it-training.pro\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Power-BI-1.png\",\"contentUrl\":\"https:\\\/\\\/www.it-training.pro\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Power-BI-1.png\",\"width\":1020,\"height\":520},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/779-analyzing-data-with-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u041d\u0430\u0447\u0430\u043b\u043e\",\"item\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/courses\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"779 &#8211; Analyzing Data with Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/\",\"name\":\"IT-Training.pro\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#organization\",\"name\":\"IT-Training.pro\",\"url\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.it-training.pro\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/it-training-logo-text-only-small.png\",\"contentUrl\":\"https:\\\/\\\/www.it-training.pro\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/it-training-logo-text-only-small.png\",\"width\":205,\"height\":33,\"caption\":\"IT-Training.pro\"},\"image\":{\"@id\":\"https:\\\/\\\/www.it-training.pro\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ittrainingpro\\\/\",\"https:\\\/\\\/x.com\\\/ITTraining_pro\",\"https:\\\/\\\/www.instagram.com\\\/ittrainingpro\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/it-training.pro\",\"https:\\\/\\\/www.pinterest.com\\\/ittrainingpro\",\"https:\\\/\\\/youtube.com\\\/channel\\\/UCdNdux5j3SShtWeanzs3GhQ\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"779 - Analyzing Data with Excel Course - IT-Training.pro","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:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/","og_locale":"en_US","og_type":"article","og_title":"779 - Analyzing Data with Excel Course - IT-Training.pro","og_description":"The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.","og_url":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/","og_site_name":"IT-Training.pro","article_publisher":"https:\/\/www.facebook.com\/ittrainingpro\/","article_modified_time":"2022-08-09T10:30:49+00:00","og_image":[{"width":1020,"height":520,"url":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/Power-BI-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@ITTraining_pro","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/","url":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/","name":"779 - Analyzing Data with Excel Course - IT-Training.pro","isPartOf":{"@id":"https:\/\/www.it-training.pro\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/Power-BI-1.png","datePublished":"2020-02-08T15:36:12+00:00","dateModified":"2022-08-09T10:30:49+00:00","breadcrumb":{"@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/#primaryimage","url":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/Power-BI-1.png","contentUrl":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2020\/01\/Power-BI-1.png","width":1020,"height":520},{"@type":"BreadcrumbList","@id":"https:\/\/www.it-training.pro\/en\/courses\/779-analyzing-data-with-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u041d\u0430\u0447\u0430\u043b\u043e","item":"https:\/\/www.it-training.pro\/en\/"},{"@type":"ListItem","position":2,"name":"Courses","item":"https:\/\/www.it-training.pro\/en\/courses\/"},{"@type":"ListItem","position":3,"name":"779 &#8211; Analyzing Data with Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.it-training.pro\/en\/#website","url":"https:\/\/www.it-training.pro\/en\/","name":"IT-Training.pro","description":"","publisher":{"@id":"https:\/\/www.it-training.pro\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.it-training.pro\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.it-training.pro\/en\/#organization","name":"IT-Training.pro","url":"https:\/\/www.it-training.pro\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.it-training.pro\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/it-training-logo-text-only-small.png","contentUrl":"https:\/\/www.it-training.pro\/wp-content\/uploads\/2019\/08\/it-training-logo-text-only-small.png","width":205,"height":33,"caption":"IT-Training.pro"},"image":{"@id":"https:\/\/www.it-training.pro\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ittrainingpro\/","https:\/\/x.com\/ITTraining_pro","https:\/\/www.instagram.com\/ittrainingpro\/","https:\/\/www.linkedin.com\/company\/it-training.pro","https:\/\/www.pinterest.com\/ittrainingpro","https:\/\/youtube.com\/channel\/UCdNdux5j3SShtWeanzs3GhQ"]}]}},"_links":{"self":[{"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/lp_course\/32066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/comments?post=32066"}],"version-history":[{"count":0,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/lp_course\/32066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/media\/28093"}],"wp:attachment":[{"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/media?parent=32066"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/course_category?post=32066"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/www.it-training.pro\/en\/wp-json\/wp\/v2\/course_tag?post=32066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}