{"id":493,"date":"2021-08-16T23:59:00","date_gmt":"2021-08-16T23:59:00","guid":{"rendered":"http:\/\/study.sudancareer.com\/?p=493"},"modified":"2021-08-17T03:43:32","modified_gmt":"2021-08-17T03:43:32","slug":"advancedexcel","status":"publish","type":"post","link":"https:\/\/study.sudancareer.com\/?p=493","title":{"rendered":"Advanced Skills in Excel 2021 Free Course"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><strong><span class=\"has-inline-color has-vivid-green-cyan-color\">Advanced Skills in Excel 2021 Free Course<\/span><\/strong><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Learn advanced skills in Excel and learn the most important and most commonly used equations in Excel<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Advanced Excel Outputs:<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Explanation of the most important and most commonly used functions in Excel<\/li><li>Explanation of the working methods of pivot tables<\/li><li>Explain how to find and replace in Excel<\/li><li>Explain how to divide and quotation cells in Excel<\/li><li>Explain how to arrange and filter data Sort, Filter S<\/li><li>Explain how to protect cells that contain equations with a password<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Advanced Excel Requirements:<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Seriousness and desire to learn<\/li><li>The practical application of the course step by step while watching the explanation<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Course coach:<\/h2>\n\n\n\n<p>Coach Hesham Abdul-hamid Eisa<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Course Contents:<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>the first lecturer<\/li><li>The easiest explanation of the if, if compound function<\/li><li>How to search for a specific need in the excel file &#8211; replace words with other words<\/li><li>How to make Sort, Filter in Excel<\/li><li>The second lecture<\/li><li>Explanation of the SUMIF function, Sumifs<\/li><li>COUNT Function COUNT,COUNTA,COUNTBLANK,COUNTIF,COUNTIFS<\/li><li>How to split a cell in excel<\/li><li>Third lecture<\/li><li>Explanation of the AND function, OR-0<\/li><li>Explanation of how to link the iF function with And and Or (Ifand, If or)<\/li><li>How to protect specific cells in the excel sheet<\/li><li>Fourth lecture<\/li><li>Pivot table Pivot tables<\/li><li>Explanation of Data Validation drop-down list in Excel<\/li><\/ul>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-white-color has-vivid-cyan-blue-background-color has-text-color has-background\" href=\"https:\/\/www.courseset.com\/course\/advanced-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Register Now<\/strong><\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Advanced Skills in Excel 2021 Free Course Learn advanced skills in Excel and learn the most important and most commonly used equations in Excel Advanced Excel Outputs: Explanation of the most important and most commonly used functions in Excel Explanation of the working methods of pivot tables Explain how to find and replace in Excel [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[155],"class_list":["post-493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-courses","tag-free-course-advanced-skills-in-excel-2021"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/study.sudancareer.com\/wp-content\/uploads\/2021\/06\/1545.png?fit=448%2C241&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/posts\/493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=493"}],"version-history":[{"count":2,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/posts\/493\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/posts\/493\/revisions\/503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=\/wp\/v2\/media\/494"}],"wp:attachment":[{"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/study.sudancareer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}