{"id":3928,"date":"2026-08-10T09:08:49","date_gmt":"2026-08-10T09:08:49","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-mastering-microsoft-excel-formulas-2024-1\/"},"modified":"2026-08-10T09:08:49","modified_gmt":"2026-08-10T09:08:49","slug":"udemy-mastering-microsoft-excel-formulas-2024-1","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-mastering-microsoft-excel-formulas-2024-1\/","title":{"rendered":"Udemy \u2013 Mastering Microsoft Excel Formulas 2024-1"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p data-sourcepos=\"3:1-3:66\"><span style=\"vertical-align: inherit\">Mastering Microsoft Excel Formulas course. This comprehensive Excel course is offered by Ahmed Oyelowo, who has a brilliant track record in the field of Excel. He has won the Microsoft MVP title 4 times, has been an official Microsoft trainer since 2018, and is also a Microsoft Office expert (Excel expert).<\/span><\/p>\n<p data-sourcepos=\"5:1-5:31\"><span style=\"vertical-align: inherit\">In this course, you will learn how to use more than 50 everyday Excel functions using practical examples. You will also learn how to easily combine multiple Excel functions into one Excel formula. One of them is used by the instructor, which you should use to follow the lessons, and the other is for your own practice. The exercise file automatically determines your score after completing the exercises in it. You\u2019ll also learn cell referencing logic, which is the backbone of writing precise formulas when you need to repeat formulas across multiple cells in Excel.<\/span><\/p>\n<h3 data-sourcepos=\"17:1-17:65\"><strong><span style=\"vertical-align: inherit\">What you will learn in the Mastering Microsoft Excel Formulas course:<\/span><\/strong><\/h3>\n<ul data-sourcepos=\"19:1-27:0\">\n<li data-sourcepos=\"19:1-19:47\"><span style=\"vertical-align: inherit\">Using more than 50 everyday Excel functions<\/span><\/li>\n<li data-sourcepos=\"20:1-20:31\"><span style=\"vertical-align: inherit\">Easy combination of multiple functions in Excel<\/span><\/li>\n<li data-sourcepos=\"21:1-21:32\"><span style=\"vertical-align: inherit\">Using cumulative functions in Excel<\/span><\/li>\n<li data-sourcepos=\"22:1-22:64\"><span style=\"vertical-align: inherit\">Using text functions like LEFT, CONCATENATE, TEXTJOIN, etc<\/span><\/li>\n<li data-sourcepos=\"23:1-23:61\"><span style=\"vertical-align: inherit\">Use date functions like EOMONTH, EDATE, DATEDIF, etc<\/span><\/li>\n<li data-sourcepos=\"24:1-24:64\"><span style=\"vertical-align: inherit\">Use search functions such as VLOOKUP, XLOOKUP, INDEX&amp;MATCH<\/span><\/li>\n<li data-sourcepos=\"25:1-25:71\"><span style=\"vertical-align: inherit\">Using mathematical and statistical functions such as SUMIF, COUNTIF, AVERAGEIF, etc<\/span><\/li>\n<li data-sourcepos=\"26:1-27:0\"><span style=\"vertical-align: inherit\">Use logical functions like IF, AND, OR, etc<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"28:1-28:37\"><strong><span style=\"vertical-align: inherit\">Who is this course suitable for?<\/span><\/strong><\/h3>\n<ul data-sourcepos=\"30:1-32:10\">\n<li data-sourcepos=\"30:1-30:62\"><span style=\"vertical-align: inherit\">This course is suitable for all categories of Excel learners.<\/span><\/li>\n<li data-sourcepos=\"31:1-31:57\"><span style=\"vertical-align: inherit\">Looking to advance your Excel knowledge beyond the basics?<\/span><\/li>\n<li data-sourcepos=\"32:1-32:10\"><span style=\"vertical-align: inherit\">Looking to start or improve your data analysis skills?<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Mastering Microsoft Excel Formulas course specifications<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/mastering-microsoft-excel-formulas\/?couponCode=OF52424\" target=\"_blank\"><span style=\"vertical-align: inherit\">Udemy<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Lecturer:&nbsp; <\/span><a class=\"ud-btn ud-btn-large ud-btn-link ud-heading-md ud-text-sm ud-instructor-links\" href=\"https:\/\/downloadlynet.ir\/tag\/foresight-bi-analytics\/\" data-position=\"1\"><span style=\"vertical-align: inherit\">Foresight BI &amp; Analytics<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: beginner to advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 4 hours and 21 minutes<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Number of courses: 59<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h2>&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-908838 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Mastering-Microsoft-Excel-Formulas2.jpg\" alt=\"Mastering Microsoft Excel Formulas\" width=\"808\" height=\"551\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Prerequisites for Mastering Microsoft Excel Formulas course<\/span><\/h3>\n<div class=\"ud-block-list-item ud-block-list-item-small ud-block-list-item-tight ud-block-list-item-neutral ud-text-sm\">\n<ul>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\">Familiarity with basic excel<\/li>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\">Microsoft Excel for Windows<\/li>\n<\/ul>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-908836 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Mastering-Microsoft-Excel-Formulas.jpg\" alt=\"Mastering Microsoft Excel Formulas\" width=\"653\" height=\"247\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Sample video of the course<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-129494-1\"><video class=\"wp-video-shortcode\" id=\"video-129494-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Mastering_Microsoft_Excel_Formulas_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Mastering_Microsoft_Excel_Formulas_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Mastering_Microsoft_Excel_Formulas_Downloadly.ir.mp4?nocache=1786099852440\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Mastering_Microsoft_Excel_Formulas_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<h3><span style=\"vertical-align: inherit\">Installation guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite Player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Subtitle: None<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 1080p<\/span><\/p>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Udemy_Mastering_Microsoft_Excel_Formulas_2024-1.part1_Downloadly.ir.rar?nocache=1786099851\"><span style=\"vertical-align: inherit\">Download part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Udemy_Mastering_Microsoft_Excel_Formulas_2024-1.part2_Downloadly.ir.rar?nocache=1786099851\"><span style=\"vertical-align: inherit\">Download part 2 \u2013 769 MB<\/span><\/a><\/p>\n<p><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">1.7 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Mastering Microsoft Excel Formulas course. This comprehensive Excel course is offered by Ahmed Oyelowo, who has a brilliant track record in the fiel<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[43506,43507,43508,43509,43510,43511],"class_list":["post-3928","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-mastering-microsoft-excel-formulas","dgi_tag-download-course-mastering-microsoft-excel-formulas","dgi_tag-download-mastering-microsoft-excel-formulas","dgi_tag-foresight-bi-analytics","dgi_tag-free-download-mastering-microsoft-excel-formulas","dgi_tag-free-mastering-microsoft-excel-formulas"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/3928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/3928\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=3928"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=3928"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=3928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}