{"id":55465,"date":"2025-03-20T16:38:01","date_gmt":"2025-03-20T12:38:01","guid":{"rendered":"https:\/\/ibsu.edu.ge\/?page_id=55465"},"modified":"2025-07-14T15:16:14","modified_gmt":"2025-07-14T11:16:14","slug":"ms-excel","status":"publish","type":"page","link":"https:\/\/ibsu.edu.ge\/en\/ibsu-academy\/trainings-2025\/ms-excel\/","title":{"rendered":"MS Excel Course"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row type=&#8221;full-width&#8221;][vc_column]<div class=\"templatera_shortcode\"><style type=\"text\/css\" data-type=\"vc_shortcodes-custom-css\">.vc_custom_1742468064702{background-image: url(https:\/\/ibsu.edu.ge\/wp-content\/uploads\/2025\/03\/untitled-20-01-0x0-1.webp?id=55427) !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}.vc_custom_1733985081419{padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}.vc_custom_1733985138261{padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}<\/style><div class=\"vc_row wpb_row vc_row-fluid page-title vc_custom_1742468064702 vc_row-has-fill full-width\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"wpb_wrapper\"><div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner vc_custom_1733985081419\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column wpb_content_element  vc_custom_1733985138261 page-titles\" >\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2 class=\"heading\">MS Excel Course<\/h2>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column wpb_content_element \" >\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t\t\t\t<!-- Flexy Breadcrumb -->\r\n\t\t\t<div class=\"fbc fbc-page\">\r\n\r\n\t\t\t\t<!-- Breadcrumb wrapper -->\r\n\t\t\t\t<div class=\"fbc-wrap\">\r\n\r\n\t\t\t\t\t<!-- Ordered list-->\r\n\t\t\t\t\t<ol class=\"fbc-items\" itemscope itemtype=\"https:\/\/schema.org\/BreadcrumbList\">\r\n\t\t\t\t\t\t            <li itemprop=\"itemListElement\" itemscope itemtype=\"https:\/\/schema.org\/ListItem\">\r\n                <span itemprop=\"name\">\r\n                    <!-- Home Link -->\r\n                    <a itemprop=\"item\" href=\"https:\/\/ibsu.edu.ge\">\r\n                    \r\n                                                    <i class=\"fa fa-home\" aria-hidden=\"true\"><\/i>Home                    <\/a>\r\n                <\/span>\r\n                <meta itemprop=\"position\" content=\"1\" \/><!-- Meta Position-->\r\n             <\/li><li><span class=\"fbc-separator\">\/<\/span><\/li><li class=\"active\" itemprop=\"itemListElement\" itemscope itemtype=\"https:\/\/schema.org\/ListItem\"><span itemprop=\"name\" title=\"MS Excel Course\">MS Excel Course<\/span><meta itemprop=\"position\" content=\"2\" \/><\/li>\t\t\t\t\t<\/ol>\r\n\t\t\t\t\t<div class=\"clearfix\"><\/div>\r\n\t\t\t\t<\/div>\r\n\t\t\t<\/div>\r\n\t\t\t\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"wpb_wrapper\"><div  class=\"vc_wp_custommenu wpb_content_element school-menu\"><div class=\"widget widget_nav_menu\"><div class=\"menu-trainings-container\"><ul id=\"menu-trainings-1\" class=\"menu\"><li class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-55430\"><a href=\"https:\/\/ibsu.edu.ge\/en\/ibsu-academy\/\">About Us<\/a><\/li>\n<li class=\"menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-55437\"><a>Trainings<\/a>\n<ul class=\"sub-menu\">\n\t<li class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-61776\"><a href=\"https:\/\/ibsu.edu.ge\/en\/ibsu-academy\/trainings-2026\/\">Trainings 2026<\/a><\/li>\n\t<li class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-55438\"><a href=\"https:\/\/ibsu.edu.ge\/en\/ibsu-academy\/trainings-2025\/\">Trainings 2025<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-55495\"><a href=\"https:\/\/ibsu.edu.ge\/en\/ibsu-academy\/contact\/\">Contact<\/a><\/li>\n<\/ul><\/div><\/div><\/div><\/div><\/div><\/div><\/div>[\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Proficiency in Microsoft Excel is beneficial for individuals in any line of work. You will study both the fundamental and more complex features of Microsoft Excel as part of the training course.<\/p>\n<p>After completing the course, you will be able to process data in MS Excel, generate detailed reports, build work files, analyze, visualize and use AI (artificial intelligence).<\/p>\n<ul>\n<li>A 20% discount is available for students and graduates of the International Black Sea University.<\/li>\n<li>After completing the course, you will be awarded a bilingual certificate of the International Black Sea University.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Mentor Tsotne Shermadini<\/strong> \u2013 Financial Director of IVH Holding, Head of the Financial Analysis Department of Award Holding.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Course Schedule:<\/strong><\/p>\n<p>Starts April 24, 2025<br \/>\nTuesday \/ Thursday<br \/>\n19:30 \u2013 21:00<br \/>\n10 meetings, 5 weeks<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Topics<\/strong>:<\/p>\n<ul>\n<li>MS EXCEL interface \u2013 overview (RIBBON, TOOLBAR, WORKSHEET TABS)<\/li>\n<li>Overview of column and row functionality<\/li>\n<li>Entering data into a cell. Formatting. Entering data on several sheets at the same time<\/li>\n<li>MS EXCEL sheet adding, copying, hiding and removing a separate sheet functionality.<\/li>\n<li>Setting and removing a password on an MS EXCEL sheet and file<\/li>\n<li>Overview of basic navigation SHORTCUTs<\/li>\n<li>Entering and formatting numeric and date data<\/li>\n<li>Sorting and filtering.<\/li>\n<li>Working with tables and charts<\/li>\n<li>Absolute and relative addresses<\/li>\n<li>PASTE SPECIAL<\/li>\n<li>SUM, COUNT, AVERAGE, SUBTOTAL.<\/li>\n<li>LEN, LEFT, RIGHT, MID, COCATENATE, UPPER, LOWER, PROPER, TRIM.<\/li>\n<li>REMOVE DUPLICATES, TEXT TO COLUMN, FIND AND REPLACE<\/li>\n<li>ROUND, ROUNDDOWN, ROUNDUP, RAND, RANDBETWEEN, SUMPRODUCT<\/li>\n<li>TODAY, YEAR, MONTH, DAY, DATE, NETWORKDAYS.INTL, EOMONTH,<\/li>\n<li>AND, OR, IF, IFS.<\/li>\n<li>SUMIFS, COUNTIFS, AVERAGEIFS.<\/li>\n<li>IFERROR, ERROR Overview<\/li>\n<li>VLOOKUP, HLOOKUP, XLOOKUP<\/li>\n<li>DATA VALITADION<\/li>\n<li>CONDITIONAL FORMATTIG<\/li>\n<li>Principle of Dynamic Tables<\/li>\n<li>Choosing the Right Fields for a Dynamic Table<\/li>\n<li>Using the SUMMARIZE VALUES BY Function<\/li>\n<li>Using the SHOW VALUES AS Function<\/li>\n<li>Slicers (SLICER)<\/li>\n<li>Overview of Basic Charts<\/li>\n<li>Choosing a Chart Shape by Data Type<\/li>\n<li>Inserting a Chart and Managing its Design<\/li>\n<li>MACROs and Understanding Their Use<\/li>\n<li>Recording Basic MACROs to Automate Repetitive Tasks<\/li>\n<li>Assigning MACROs to Buttons for Easy Access<\/li>\n<li>Using AI in Excel<\/li>\n<li>Solving Examples of Combined Tasks Based on the Past Material.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Training Venue: International Black Sea University<\/p>\n<p>Address: St. Tbilisi, David Agmashenebeli Alley, 13th km, N2<\/p>\n<p>&nbsp;<\/p>\n<h4>Contact information:<\/h4>\n<p><strong>E-mail:<\/strong> <a href=\"mailto:training@ibsu.edu.ge\">training@ibsu.edu.ge<\/a><br \/>\n<strong>Tel:<\/strong> +995 322 800 064<\/p>\n<p>Registration: <a href=\"https:\/\/forms.gle\/U7FcAw7rx7JUwxGW6\" rel=\"noopener\">https:\/\/forms.gle\/U7FcAw7rx7JUwxGW6<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Course fee <strong>490 GEL<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h4><strong>Bank details<\/strong><\/h4>\n<p><strong>Receiving bank:<\/strong> JSC \u201cTBC Bank\u201d<br \/>\n<strong>Bank code:<\/strong> TBCBGE22.<br \/>\n<strong>Recipient name:<\/strong> International Black Sea University LLC<br \/>\n<strong>Recipient account number:<\/strong> GE52TB7505036080100001<br \/>\nIndicate the word \u201cTraining MS Excel\u201d in the subject field.[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"MS Excel Course Home \/MS Excel Course About Us Trainings Trainings 2026 Trainings 2025 Contact Proficiency in Microsoft Excel is beneficial for individuals in any line of work. You will study both the fundamental and more complex features of Microsoft Excel as part of the training course. After completing the course, you will be able","protected":false},"author":1,"featured_media":0,"parent":55435,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-55465","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/pages\/55465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/comments?post=55465"}],"version-history":[{"count":1,"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/pages\/55465\/revisions"}],"predecessor-version":[{"id":58853,"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/pages\/55465\/revisions\/58853"}],"up":[{"embeddable":true,"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/pages\/55435"}],"wp:attachment":[{"href":"https:\/\/ibsu.edu.ge\/en\/wp-json\/wp\/v2\/media?parent=55465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}