{"id":4141,"date":"2026-08-10T09:10:41","date_gmt":"2026-08-10T09:10:41","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-microsoft-excel-pivot-tables-with-formulas-functions-2024-5\/"},"modified":"2026-08-10T09:10:41","modified_gmt":"2026-08-10T09:10:41","slug":"udemy-microsoft-excel-pivot-tables-with-formulas-functions-2024-5","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-microsoft-excel-pivot-tables-with-formulas-functions-2024-5\/","title":{"rendered":"Udemy \u2013 Microsoft Excel Pivot Tables With Formulas &#038; Functions 2024-5"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"5:1-5:319\"><span style=\"vertical-align: inherit\">Microsoft Excel Pivot Tables With Formulas &amp; Functions course. This course comprehensively teaches you how to use Pivot Tables in Microsoft Excel along with formulas and functions to analyze and manipulate data effectively. This course is suitable for users who have a basic understanding of Excel and want to improve their data analysis skills. Course topics:<\/span><\/p>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li data-sourcepos=\"9:3-9:41\"><span style=\"vertical-align: inherit\">The first session: Getting to know Microsoft Excel<\/span><\/li>\n<li data-sourcepos=\"15:3-15:36\"><span style=\"vertical-align: inherit\">Second session: Intermediate Excel skills<\/span><\/li>\n<li data-sourcepos=\"21:3-21:31\"><span style=\"vertical-align: inherit\">The third session: Understanding pivot tables<\/span><\/li>\n<li data-sourcepos=\"27:3-27:47\"><span style=\"vertical-align: inherit\">The fourth session: advanced pivot table techniques<\/span><\/li>\n<li data-sourcepos=\"33:3-33:38\"><span style=\"vertical-align: inherit\">Session 5: Real world applications<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"7:1-7:24\"><span style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"9:1-20:0\">\n<li data-sourcepos=\"9:1-9:92\"><span style=\"vertical-align: inherit\">Introducing the Excel interface and features<\/span><\/li>\n<li data-sourcepos=\"10:1-10:96\"><span style=\"vertical-align: inherit\">Introducing formulas and functions<\/span><\/li>\n<li data-sourcepos=\"11:1-11:107\"><span style=\"vertical-align: inherit\">Data entry and formatting techniques<\/span><\/li>\n<li data-sourcepos=\"12:1-12:154\"><span style=\"vertical-align: inherit\">Data validation and conditional formatting<\/span><\/li>\n<li data-sourcepos=\"13:1-13:105\"><span style=\"vertical-align: inherit\">Work with multiple worksheets and folders<\/span><\/li>\n<li data-sourcepos=\"14:1-14:103\"><span style=\"vertical-align: inherit\">Create PivotTables from a dataset<\/span><\/li>\n<li data-sourcepos=\"15:1-15:131\"><span style=\"vertical-align: inherit\">Customizing PivotTables<\/span><\/li>\n<li data-sourcepos=\"16:1-16:123\"><span style=\"vertical-align: inherit\">Grouping and summarizing data in PivotTables<\/span><\/li>\n<li data-sourcepos=\"17:1-17:128\"><span style=\"vertical-align: inherit\">Use Slicers for interactive filtering<\/span><\/li>\n<li data-sourcepos=\"18:1-18:105\"><span style=\"vertical-align: inherit\">Create Pivot Charts from PivotTables<\/span><\/li>\n<li data-sourcepos=\"19:1-20:0\"><span style=\"vertical-align: inherit\">Tips and tricks to optimize PivotTable performance<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"21:1-21:32\"><span style=\"vertical-align: inherit\">Who is this course suitable for?<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"23:1-29:0\">\n<li data-sourcepos=\"23:1-23:90\"><span style=\"vertical-align: inherit\">Anyone interested in becoming an Excel pro with PivotTables and Charts.<\/span><\/li>\n<li data-sourcepos=\"24:1-24:16\"><span style=\"vertical-align: inherit\">Administrative staff<\/span><\/li>\n<li data-sourcepos=\"25:1-25:16\"><span style=\"vertical-align: inherit\">Data analysts<\/span><\/li>\n<li data-sourcepos=\"26:1-26:11\"><span style=\"vertical-align: inherit\">accountants<\/span><\/li>\n<li data-sourcepos=\"27:1-27:11\"><span style=\"vertical-align: inherit\">Students<\/span><\/li>\n<li data-sourcepos=\"28:1-29:0\"><span style=\"vertical-align: inherit\">Anyone who uses data in their work<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course specifications Microsoft Excel Pivot Tables With Formulas &amp; Functions<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/microsoft-excel-pivot-tables-with-formulas-functions\/?couponCode=LETSLEARNNOWPP\" target=\"_blank\"><span style=\"vertical-align: inherit\">Udemy<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor:&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\/click-learning\/\" data-position=\"1\"><span style=\"vertical-align: inherit\">Click Learning<\/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: 2 hours and 5 minutes<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Number of courses: 19<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910579 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Microsoft-Excel-Pivot-Tables-With-Formulas-Functions-1.jpg\" alt=\"Microsoft Excel Pivot Tables With Formulas &amp; Functions\" width=\"883\" height=\"379\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course prerequisites<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">No experience needed.<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">This course is compatible with any version of Excel<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910580 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Microsoft-Excel-Pivot-Tables-With-Formulas-Functions.jpg\" alt=\"Microsoft Excel Pivot Tables With Formulas &amp; Functions\" width=\"897\" height=\"344\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><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-130637-1\"><video class=\"wp-video-shortcode\" id=\"video-130637-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_Downloadly.ir.mp4?nocache=1786100464038\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_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 dir=\"ltr\" style=\"text-align: left\">\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: 720p<\/span><\/p>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Udemy_Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_2024-5.part1_Downloadly.ir.rar?nocache=1786100463\"><span style=\"vertical-align: inherit\">Download part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Udemy_Microsoft_Excel_Pivot_Tables_With_Formulas_And_Functions_2024-5.part2_Downloadly.ir.rar?nocache=1786100463\"><span style=\"vertical-align: inherit\">Download part 2 \u2013 213 MB<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">1.2 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Microsoft Excel Pivot Tables With Formulas &amp; Functions course. This course comprehensively teaches you how to use Pivot Tables in Microsoft Exce<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[45019,45020,45021,45022,45023,45024],"class_list":["post-4141","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-click-learning","dgi_tag-course-microsoft-excel-pivot-tables-with-formulas-functions","dgi_tag-download-course-microsoft-excel-pivot-tables-with-formulas-functions","dgi_tag-download-microsoft-excel-pivot-tables-with-formulas-functions","dgi_tag-free-download-microsoft-excel-pivot-tables-with-formulas-functions","dgi_tag-free-microsoft-excel-pivot-tables-with-formulas-functions"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4141","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\/4141\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=4141"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=4141"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=4141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}