{"id":10758,"date":"2025-10-16T18:35:19","date_gmt":"2025-10-16T15:35:19","guid":{"rendered":"https:\/\/sudacad.net\/?post_type=courses&#038;p=10758"},"modified":"2025-10-16T18:35:19","modified_gmt":"2025-10-16T15:35:19","slug":"basic-and-advanced-excel","status":"publish","type":"courses","link":"https:\/\/sudacad.net\/ar\/courses\/basic-and-advanced-excel\/","title":{"rendered":"Basic and advanced Excel"},"content":{"rendered":"<p class=\"ng-binding\">Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables. Excel is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualize data, and innumerable other tasks<\/p>\n<h4>What you\u2019ll learn<\/h4>\n<div class=\"uk-child-width-1-2@s uk-grid\">\n<div class=\"uk-first-column\">\n<ul class=\"list-2\">\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Calculating sums, averages, Counting cells and totals<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Learning formulas, such as IF, COUNTIF, SUMIF, and VLOOKUP<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Inserting, editing, and deleting comments<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Pasting, sorting, and converting columns to rows<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">How to remove duplicates in Excel<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Adding passwords<\/li>\n<li class=\"ng-binding ng-scope\" aria-hidden=\"false\">Using a pivot table as a powerful tool<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul class=\"list-2\">\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">Creating a good report<\/li>\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">working with big data<\/li>\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">Freeze cell<\/li>\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">V lookup function<\/li>\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">Visualizing Data Using Charts<\/li>\n<li class=\"ng-binding ng-scope\" style=\"margin: 10px 0px 10px 28px;line-height: 27px;position: relative\" aria-hidden=\"false\">Real world scenario using counts function<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<h4>Requirements<\/h4>\n<ul class=\"list-1\">\n<li class=\"ng-binding ng-scope\">Willingness to learn the course<\/li>\n<\/ul>\n<h4>Here is exactly what we cover:<\/h4>\n<p>MS Excel use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs. Excel is typically used to organize data and perform financial\u00a0analysis.<\/p>\n<p>The main uses of Excel include:<\/p>\n<ul>\n<li>Data entry<\/li>\n<li>Data management<\/li>\n<li>Accounting<\/li>\n<li>Financial analysis<\/li>\n<li>Charting and graphing<\/li>\n<li>Programming<\/li>\n<li>Time management<\/li>\n<li>Task management<\/li>\n<li>Financial modeling<\/li>\n<li>Customer relationship management (CRM)<\/li>\n<li>Almost anything that needs to be organized!<\/li>\n<\/ul>\n<h3>Data Functions, Formulas, And Shortcuts<\/h3>\n<p>The Excel software program includes many functions, formulas, and shortcuts that can be used to enhance its functionality.\u00a0We have defined the\u00a0key functions and formulas in the course<\/p>\n<h3>Financial and accounting uses<\/h3>\n<p>Excel is used extensively in finance and accounting functions.\u00a0In fact, many organizations run their entire\u00a0<strong>budgeting, forecasting, and accounting<\/strong>\u00a0functions entirely out of Excel spreadsheets.<\/p>\n<p>While Excel is defined as a \u201cdata\u201d management tool, the data that is most commonly managed is\u00a0financial. We would define Excel as the ultimate financial software.<\/p>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables. Excel is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":10759,"template":"","course-category":[240],"course-tag":[],"class_list":["post-10758","courses","type-courses","status-publish","has-post-thumbnail","hentry","course-category-information-technology-it","pmpro-has-access","entry","has-media","owp-thumbs-layout-horizontal","owp-btn-very-big","owp-tabs-layout-horizontal","has-no-thumbnails","has-product-nav"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Basic and advanced Excel<\/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:\/\/sudacad.net\/ar\/courses\/basic-and-advanced-excel\/\" \/>\n<meta property=\"og:locale\" content=\"ar_AR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basic and advanced Excel\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables. Excel is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sudacad.net\/ar\/courses\/basic-and-advanced-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"SUDACAD\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sudacad.net\/wp-content\/uploads\/2025\/01\/1709099553-s5ccsbI2hH.png\" \/>\n\t<meta property=\"og:image:width\" content=\"575\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\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=\"\u0648\u0642\u062a \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u064f\u0642\u062f\u0651\u0631\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u062f\u0642\u064a\u0642\u0629 \u0648\u0627\u062d\u062f\u0629\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/\",\"url\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/\",\"name\":\"Basic and advanced Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sudacad.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/1709099553-s5ccsbI2hH.png\",\"datePublished\":\"2025-10-16T15:35:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/#breadcrumb\"},\"inLanguage\":\"ar\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sudacad.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/1709099553-s5ccsbI2hH.png\",\"contentUrl\":\"https:\\\/\\\/sudacad.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/1709099553-s5ccsbI2hH.png\",\"width\":575,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/basic-and-advanced-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sudacad.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/sudacad.net\\\/courses\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Basic and advanced Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/#website\",\"url\":\"https:\\\/\\\/sudacad.net\\\/\",\"name\":\"SUDACAD\",\"description\":\"Sudatel Telecommunication Academy (SUDACAD)\",\"publisher\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sudacad.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ar\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/#organization\",\"name\":\"AcadeGenius\",\"url\":\"https:\\\/\\\/sudacad.net\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/sudacad.net\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sudacad.net\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/cropped-YourLogo-AcadeGenius.png\",\"contentUrl\":\"https:\\\/\\\/sudacad.net\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/cropped-YourLogo-AcadeGenius.png\",\"width\":500,\"height\":138,\"caption\":\"AcadeGenius\"},\"image\":{\"@id\":\"https:\\\/\\\/sudacad.net\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Basic and advanced Excel","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:\/\/sudacad.net\/ar\/courses\/basic-and-advanced-excel\/","og_locale":"ar_AR","og_type":"article","og_title":"Basic and advanced Excel","og_description":"Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables. Excel is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely [&hellip;]","og_url":"https:\/\/sudacad.net\/ar\/courses\/basic-and-advanced-excel\/","og_site_name":"SUDACAD","og_image":[{"width":575,"height":450,"url":"https:\/\/sudacad.net\/wp-content\/uploads\/2025\/01\/1709099553-s5ccsbI2hH.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"\u0648\u0642\u062a \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u064f\u0642\u062f\u0651\u0631":"\u062f\u0642\u064a\u0642\u0629 \u0648\u0627\u062d\u062f\u0629"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/","url":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/","name":"Basic and advanced Excel","isPartOf":{"@id":"https:\/\/sudacad.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/#primaryimage"},"image":{"@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/sudacad.net\/wp-content\/uploads\/2025\/01\/1709099553-s5ccsbI2hH.png","datePublished":"2025-10-16T15:35:19+00:00","breadcrumb":{"@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/#breadcrumb"},"inLanguage":"ar","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/"]}]},{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/#primaryimage","url":"https:\/\/sudacad.net\/wp-content\/uploads\/2025\/01\/1709099553-s5ccsbI2hH.png","contentUrl":"https:\/\/sudacad.net\/wp-content\/uploads\/2025\/01\/1709099553-s5ccsbI2hH.png","width":575,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/sudacad.net\/courses\/basic-and-advanced-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sudacad.net\/"},{"@type":"ListItem","position":2,"name":"Courses","item":"https:\/\/sudacad.net\/courses\/"},{"@type":"ListItem","position":3,"name":"Basic and advanced Excel"}]},{"@type":"WebSite","@id":"https:\/\/sudacad.net\/#website","url":"https:\/\/sudacad.net\/","name":"SUDACAD","description":"Sudatel Telecommunication Academy (SUDACAD)","publisher":{"@id":"https:\/\/sudacad.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sudacad.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ar"},{"@type":"Organization","@id":"https:\/\/sudacad.net\/#organization","name":"AcadeGenius","url":"https:\/\/sudacad.net\/","logo":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/sudacad.net\/#\/schema\/logo\/image\/","url":"https:\/\/sudacad.net\/wp-content\/uploads\/2021\/12\/cropped-YourLogo-AcadeGenius.png","contentUrl":"https:\/\/sudacad.net\/wp-content\/uploads\/2021\/12\/cropped-YourLogo-AcadeGenius.png","width":500,"height":138,"caption":"AcadeGenius"},"image":{"@id":"https:\/\/sudacad.net\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/courses\/10758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/users\/67"}],"version-history":[{"count":1,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/courses\/10758\/revisions"}],"predecessor-version":[{"id":12415,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/courses\/10758\/revisions\/12415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/media\/10759"}],"wp:attachment":[{"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/media?parent=10758"}],"wp:term":[{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/course-category?post=10758"},{"taxonomy":"course-tag","embeddable":true,"href":"https:\/\/sudacad.net\/ar\/wp-json\/wp\/v2\/course-tag?post=10758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}