{"id":23328,"date":"2021-05-06T10:44:04","date_gmt":"2021-05-06T08:44:04","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23328"},"modified":"2024-05-27T10:36:28","modified_gmt":"2024-05-27T08:36:28","slug":"free-microsoft-excel-online-course","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/","title":{"rendered":"Free Microsoft Excel Online Course &#8211; 20+ Hours Beginner to Advanced Course"},"content":{"rendered":"<div class=\"elementor-element elementor-element-cab42e6 elementor-widget elementor-widget-text-editor\" data-id=\"cab42e6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-23495 size-full\" title=\"Free Microsoft Excel Online Course - 20+ Hours Beginner to Advanced Course\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Learn-Excel-Now2.png\" alt=\"Free Microsoft Excel Online Course - 20+ Hours Beginner to Advanced Course\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Learn-Excel-Now2.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Learn-Excel-Now2-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Learn-Excel-Now2-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/h2>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/#77_Lessons_20_hours_of_Free_Microsoft_Excel_Online_Training_Videos\" title=\"77 Lessons, 20+ hours of Free Microsoft Excel\u00a0 Online Training Videos\">77 Lessons, 20+ hours of Free Microsoft Excel\u00a0 Online Training Videos<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/#Absolutely_FREE_No_Sign-up_Needed_Scroll_Down_Start_Learning\" title=\"Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!\">Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"77_Lessons_20_hours_of_Free_Microsoft_Excel_Online_Training_Videos\"><\/span>77 Lessons, 20+ hours of Free Microsoft Excel\u00a0 Online Training Videos<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-6725bab elementor-widget elementor-widget-text-editor\" data-id=\"6725bab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<h2><span class=\"ez-toc-section\" id=\"Absolutely_FREE_No_Sign-up_Needed_Scroll_Down_Start_Learning\"><\/span><b>Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Whether you are <strong>new to the world of <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong> or just trying to <strong>improve your Excel skills<\/strong>, look no further.<\/p>\n<p><strong>Rank up your skill from novice to pro<\/strong> by following our guides and methodology in this Free Excel Training. Keep reading to explore the different lessons covered here!<\/p>\n<p>As you finish these lessons catered for you, you are <strong>guaranteed to get accustomed to the ways of Excel<\/strong>. Be it swiftly <strong>finding the solution to your problem<\/strong>, or an overall <strong>increase in speed while working<\/strong> on Excel.<\/p>\n<h4><strong>Complete every task with ease<\/strong> with this Free Excel Training. Just scroll down and<strong> start watching and learning<\/strong>!<\/h4>\n<p>&nbsp;<\/p>\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><br \/>\n<div class='content-column one_half'><p><span style=\"color: #0000ff;\"><i class=\"fa fa-arrow-circle-up \" ><\/i><strong><a href=\"#section01\">1. Excel Basics<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-lightbulb-o \" ><\/i><strong><a href=\"#section02\">2. Excel Formulas &amp; Functions<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-pencil \" ><\/i><strong><a href=\"#section03\">3. Formatting in Excel<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-table \" ><\/i><strong><a href=\"#section04\">4. Excel Tables<\/a><br \/>\n<\/strong><\/span><span style=\"color: #0000ff;\"><i class=\"fa fa-chart-pie \" ><\/i><strong><a href=\"#section05\">5. Excel Charts<\/a><\/strong><\/span><\/p><\/div><div class='content-column one_half last_column'><p><span style=\"color: #0000ff;\"><i class=\"fa fa-random \" ><\/i><strong><a href=\"#section06\">6. Excel Pivot Tables<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-code \" ><\/i><strong><a href=\"#section07\">7. Excel Macros &amp; VBA<\/a><\/strong><\/span><br \/>\n<span style=\"color: #0000ff;\"><i class=\"fa fa-bolt \" ><\/i><strong><a href=\"#section08\">8. Power Query<\/a><\/strong><br \/>\n<i class=\"fa fa-superpowers \" ><\/i><strong><a href=\"#section09\">9. Power Pivot<\/a><br \/>\n<\/strong><i class=\"fa fa-cogs \" ><\/i><strong><a href=\"#section10\">10. Power BI<\/a><\/strong><\/span><span style=\"color: #0000ff;\"><br \/>\n<\/span><\/p><\/div><div class='clear_column'><\/div><br \/>\n<\/div>\n<p>&nbsp;<\/p>\n<p>In this article, we will be covering 75+ lessons in these 10 Modules for you to become more efficient at Excel!<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section01\"><\/a>1. Excel Basics<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson01\">Lesson 1: Getting started with Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson02\">Lesson 2: 333 Excel Keyboard Shortcuts<\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section02\"><\/a>2. Excel Formulas &amp; Functions<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson03\">Lesson 3: MOST POPULAR Excel Formulas and Functions<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson04\">Lesson 4: Learn the VLOOKUP formula in 4 easy steps<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson05\">Lesson 5: 6 brand new functions in Office 365<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson06\">Lesson 6: Len Function<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson07\">Lesson 7: Filter Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson08\">Lesson 8: Substitute Function<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson09\">Lesson 9: Concatenate Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson06\">Lesson 10: Match Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson11\">Lesson 11: Absolute and Relative Function<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson12\">Lesson 12: Left, Mid and Right Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson13\">Lesson 13: XLOOKUP &#8211; Outstanding Replacement of VLOOKUP<\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section03\"><\/a>3. Formatting in Excel<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson14\">Lesson 14: Excel Fill Handle Tips<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson15\">Lesson 15: 6 ways to merge cells in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson16\">Lesson 16: Convert Text to Numbers<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson17\">Lesson 17: Evaluate Function &amp; Formulas<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson18\">Lesson 18: Text to Column<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson19\">Lesson 19: Clean &amp; Extract data using Excel <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson20\">Lesson 20: Remove duplicates<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson21\">Lesson 21: Flash Fill<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson22\">Lesson 22: Custom Numbers &#8211; Thousands &amp; Millions <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson23\">Lesson 23: Clean #REF error<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson24\">Lesson 24: Custom Date Format<\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section04\"><\/a>4. Excel Tables<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson25\">Lesson 25: How to Insert an Excel Table <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson26\">Lesson 26: Excel Table Headers Show in Columns <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson27\">Lesson 27: Filter &amp; Search in Excel Tables<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson28\">Lesson 28: Add Drop Down Menu In Your Excel Table <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson29\">Lesson 29: Autofill Formulas in an Excel Table <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson30\">Lesson 30: Remove Duplicates in an Excel Table <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson31\">Lesson 31: Excel Table: Styles <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson32\">Lesson 32: Excel Table Slicers <\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section05\"><\/a>5. Excel Charts<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson33\">Lesson 33: How to Make a Graph in Excel &#8211; The Definitive Guide! <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson34\">Lesson 34: Sparklines in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson35\">Lesson 35: How to Add Trendlines<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson36\">Lesson 36: 100% Stacked Column Chart <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson37\">Lesson 37: Waterfall Chart <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson38\">Lesson 38: Benchmark Chart <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson39\">Lesson 39: Bubble Chart <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson40\">Lesson 40: Milestone Chart <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson41\">Lesson 41: Logarithmic Scale Chart<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson42\">Lesson 42: Clustered Bar Chart<\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section06\"><\/a>6. Excel Pivot Tables<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson43\">Lesson 43: The Ultimate Excel Pivot Table Guide<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson44\">Lesson 44: Insert Pivot Table in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson45\">Lesson 45: Group by Quarters &amp; Years <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson46\">Lesson 46: Slicers &amp; PivotCharts<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson47\">Lesson 47: Frequency Distribution <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson48\">Lesson 48: Sort Option in Pivot Table<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson49\">Lesson 49: Pivot Table Conditional Formatting<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson50\">Lesson 50: GETPIVOTDATA Function<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson51\">Lesson 51: Calculated Fields in Pivot Table<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson52\">Lesson 52: Subtotals<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson53\">Lesson 53: Create Interactive Dashboards <\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section07\"><\/a>7. Excel Macros &amp; VBA<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson54\">Lesson 54: Create Macro Buttons<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson55\">Lesson 55: Insert Multiple Rows using Macros<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson56\">Lesson 56: Convert Excel to PDF<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson57\">Lesson 57: How to Autofit Columns<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson58\">Lesson 58: Convert Formulas into Values Using Macros<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson59\">Lesson 59: Convert Chart into Image Using Macros<\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section08\"><\/a>8. Power Query<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson60\">Lesson 60: How to Install Power Query in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson61\">Lesson 61: Introduction to Power Query<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson62\">Lesson 62: Consolidate Multiple Excel Sheets Using Power Query Append<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson63\">Lesson 63: Split the Date Using Power Query<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson64\">Lesson 64: Introduction, Parsing Text &amp; Inner Join<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson65\">Lesson 65: Unstack &amp; Merge Data Using Power Query <\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson66\">Lesson 66: Unpivot Data <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson67\">Lesson 67: Remove Top, Bottom, and Alternate Rows<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson66\">Lesson 68: Copy and Paste Queries Across Workbooks Using Power Query <\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section09\"><\/a>9. Power Pivot<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson69\">Lesson 69: Power Query vs Power Pivot Overview <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson70\">Lesson 70: Enabling Power Pivot in 2013<br \/>\n<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson71\">Lesson 71: Link Tables in Power Pivot <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson72\">Lesson 72: Importing Excel Workbooks in Power Pivot<br \/>\n<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson73\">Lesson 73: Using the Diagram View in Power Pivot <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson74\">Lesson 74: COUNTROWS in Power Pivot<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson75\">Lesson 75: Measures Vs Calculated Column in Power Pivot <\/a><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section10\"><\/a>10. Power BI<\/h3>\n<div style=\"background: #e8e8e8;\"><a href=\"#lesson76\">Lesson 76: Introduction to Power BI <\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"#lesson77\">Lesson 77: High Level Flow<\/a><\/div>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s look at each of these modules one by one!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"section01\"><\/a>Excel Basics<\/strong><\/h3>\n<p><strong><a id=\"lesson01\"><\/a>Lesson 1: Getting started with Excel<\/strong><\/p>\n<p>In this Excel tutorial, I will cover the <strong>Basics of Excel that you need to know to get started<\/strong> with how to use Excel. The outline of the topics that will be covered are as follows:<\/p>\n<ul>\n<li>Opening an Excel Spreadsheet<\/li>\n<li>Understanding the Different Elements of an Excel Spreadsheet<\/li>\n<li>Entering Data in an Excel Spreadsheet<\/li>\n<li>Basic Calculations in an Excel Spreadsheet<\/li>\n<li>Saving an Excel Spreadsheet<\/li>\n<\/ul>\n<p><em>For demonstration purposes, we have used Office 365 here!<\/em><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/djzmmeQM-ew?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-excel-spreadsheet\/\" target=\"_blank\">How to Use Excel for Dummies<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\">141 Free Excel Templates and Spreadsheets<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson02\"><\/a>Lesson 2: 333 Excel Keyboard Shortcuts<\/strong><\/p>\n<p>Excel keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcuts\" data-wpil-keyword-link=\"linked\">shortcuts<\/a> are extremely useful as they can <strong>make you faster and more efficient<\/strong> while working on Excel.<\/p>\n<p>In this video, we have <strong>compiled an exhaustive list<\/strong> for you so you can apply it to your Excel worksheet straight away:<\/p>\n<p>Frequent <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/outlook-shortcuts\/\" target=\"_blank\" rel=\"noopener\">Keyboard Shortcuts<\/a><br \/>\n<i class=\"fa fa-wrench \"><\/i>\u00a0Inside the Ribbon Shortcuts<br \/>\n<i class=\"fa fa-recycle \"><\/i>\u00a0Cell Navigation Shortcuts<br \/>\n<i class=\"fa fa-edit \"><\/i>\u00a0Formatting Cell Shortcuts<br \/>\n<i class=\"fa fa-retweet \"><\/i>\u00a0Making Selection Shortcuts<br \/>\n<i class=\"fa fa-flask \"><\/i>\u00a0Working with Formula Shortcuts<br \/>\n<i class=\"fa fa-bookmark \"><\/i>\u00a0Ribbon Tab Shortcuts<br \/>\n<i class=\"fa fa-list \"><\/i>\u00a0Power Pivot Shortcuts<br \/>\n<i class=\"fa fa-check-circle \"><\/i>\u00a0Function Key Shortcuts<br \/>\n<i class=\"fa fa-wrench \"><\/i>\u00a0Drag and Drop Shortcuts<br \/>\n<i class=\"fa fa-flask \"><\/i>\u00a0<a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macros\" data-wpil-keyword-link=\"linked\">Macros<\/a> and VBA Shortcuts<br \/>\n<i class=\"fa fa-list \"><\/i>\u00a0Pivot Table Shortcuts<br \/>\n<i class=\"fa fa-lightbulb-o \"><\/i>\u00a0Power BI Shortcuts<br \/>\n<i class=\"fa fa-bolt \"><\/i>\u00a0Other Shortcuts<\/p>\n<p>Below we have created a FREE downloadable PDF cheat sheet and a fully searchable list of the <strong>333 Excel Shortcuts for both Windows and <a class=\"wpil_keyword_link\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/mac\/microsoft-365-for-mac\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Mac\" data-wpil-keyword-link=\"linked\">Mac<\/a><\/strong>\u00a0for you!<\/p>\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" data-leadbox=\"https:\/\/app.monstercampaigns.com\/c\/shryndlrcpwibe3hqyir\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><strong>DOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET<i class=\"fa fa-download\"><\/i><\/strong><\/a><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/AqgQMiZeSqs?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"section02\"><\/a>Excel Formulas &amp; Functions<\/strong><\/h3>\n<p><strong><a id=\"lesson03\"><\/a>Lesson 3: MOST POPULAR Excel Formulas and Functions<\/strong><\/p>\n<p>Excel Formulas &amp; Functions will allow you to quickly analyze your data in many forms and will increase your Excel skill exponentially.<\/p>\n<p>After completing this tutorial, you will Master the Most POPULAR Excel Formulas and Functions: <strong>VLOOKUP, INDEX, MATCH, SUMIF, &amp; IF<\/strong> in only<strong> 1 HOUR<\/strong>! You will also learn:<\/p>\n<ul>\n<li>A proven step-by-step guide to creating Excel Formulas in SECONDS!<\/li>\n<li>The limitations of using a VLOOKUP and why INDEX &amp; MATCH is better!<\/li>\n<li>3 TIPS that the Excel experts &amp; MVPS use that will enhance your Formula knowledge!<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/eBkMQxIIkx4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\">101 Advanced Excel Formulas &amp; Functions Examples<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson04\"><\/a>Lesson 4: Learn VLOOKUP formula in 4 easy steps<\/strong><\/p>\n<p>Excel`s\u00a0<strong>VLOOKUP<\/strong>\u00a0function is arguably the <strong>most used function<\/strong> and the <strong>most talked-about function <\/strong>in Excel. It can be used to <strong>extract values from a table<\/strong> and use them in your custom reports and analysis.<\/p>\n<p>In this tutorial, we will cover how to use VLOOKUP in Excel using<strong> 4 easy steps<\/strong>!<\/p>\n<ul>\n<li>Enter VLOOKUP formula<\/li>\n<li>Enter the value you are looking for<\/li>\n<li>Enter the table where you going<\/li>\n<li>Enter the column number containing the result<\/li>\n<\/ul>\n<p>Watch this Tutorial to Master the VLOOKUP function and use it with confidence!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wlyr10UTgEQ?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-approximate-match-in-excel\/\" target=\"_blank\">VLOOKUP Approximate Match in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-multiple-excel-sheets\/\" target=\"_blank\">VLOOKUP in Multiple Sheets<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-columns\/\" target=\"_blank\">VLOOKUP in Multiple Columns at once<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-criteria-excel\/\" target=\"_blank\">VLOOKUP using Multiple Criteria<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson05\"><\/a>Lesson 5: 6 brand new functions in Office 365 <\/strong><\/p>\n<p>This is your o<strong>ne-stop-shop for learning<\/strong> all the <strong>new Excel formulas in Office 365:<\/strong><\/p>\n<ul>\n<li><strong>Filter Formula<\/strong> &#8211; \u00a0Filter your table data with an Excel Formula<\/li>\n<li><strong>Randarray Formula<\/strong> &#8211; Generate random numbers in an array<\/li>\n<li><strong>Sequence Formula<\/strong> &#8211; Generate a series of numbers with an Excel Formula<\/li>\n<li><strong>Sort Formula<\/strong> &#8211; Sorts a table based on a column and order specified<\/li>\n<li><strong>Sortby Formula<\/strong> &#8211; Sorts a table based on the column(s) specified<\/li>\n<li><strong>Unique Formula<\/strong> &#8211; Gets the unique values of a list<\/li>\n<\/ul>\n<p>Watch this video lesson to learn the following formulas in detail!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/D69Sy_fpGc8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-2019-vs-office-365\/\" target=\"_blank\">Excel 2019 VS Office 365<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson06\"><\/a>Lesson 6: LEN Function<\/strong><\/p>\n<p>There are times when you need to<strong> get the number of characters within a cell<\/strong> in Excel. Thankfully this is very easy to do with Excel\u2019s LEN (Length) formula!<\/p>\n<p>You can use the LEN formula in Excel:<\/p>\n<ul>\n<li>To <strong>count all characters in a cell<\/strong>, including letters, numbers, special characters, and all spaces.<\/li>\n<li>As a <strong>data cleansing technique<\/strong> to find leading or trailing spaces or can be nested with other TEXT functions.<\/li>\n<li>To<strong> find out errors<\/strong> like additional spaces in data entry.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/8_AFpelhieA?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><br \/>\n<strong><a id=\"lesson07\"><\/a>Lesson 7: FILTER Function<\/strong><\/p>\n<p>Did you know that you can now<strong> filter your table data with an Excel Formula<\/strong>? Watch this free Excel training to learn how.<\/p>\n<ul>\n<li>Filter is a <strong>new formula<\/strong> introduced in <strong>Office 365<\/strong> released in 2018!<\/li>\n<li>It can be used to filter a table array based on conditions you specify and extract matching records.<\/li>\n<li>It is a<strong> dynamic function<\/strong>\u00a0i.e. when the values in the data sources change the result from this formula will update automatically.<\/li>\n<li>It&#8217;s an ideal function for <strong>sorting and picking out data<\/strong> and can even be used to <strong>improve the presentation<\/strong> of your reports.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/TKI1Q4Wm0Mk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson08\"><\/a>Lesson 8: SUBSTITUTE Function<\/strong><\/p>\n<p>When you needed to <strong>replace a specific text\u00a0in each word<\/strong>, and there is a pattern, Excel has just the formula for you.<\/p>\n<p>Substitute Function can be used to :<\/p>\n<ul>\n<li>Clean Data by <strong>substituting any leading, trailing, or unwanted text.<\/strong><\/li>\n<li><strong>Replace every instance of old text<\/strong> with new text.<\/li>\n<li><strong>Replace multiple texts<\/strong> at one time using the nested Substitute function.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/nWOJzkRbvXg?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-second-hyphen-with-excels-substitute-formula\/\" target=\"_blank\">Remove Second Hyphen with Excel\u2019s SUBSTITUTE Formula<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-comma-after-the-surname-with-excels-substitute-formula\/\" target=\"_blank\">Add Comma in Excel between Names<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-text-occurrences-excels-substitute-formula\/\" target=\"_blank\">Count Text Occurrences with Excel\u2019s SUBSTITUTE Formula<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson09\"><\/a>Lesson 9: CONCATENATE Function<\/strong><\/p>\n<p>Excel\u2019s CONCATENATE functions <strong>join two or more text strings<\/strong> into one string. The<strong> item can be a text value, number, or cell reference<\/strong>.<\/p>\n<ul>\n<li>A helpful formula for extracting text from data<span style=\"color: #ff0000;\">.<\/span><\/li>\n<li><strong>Join several cells to give a consolidated result<\/strong>, especially useful for combining names and other details.<\/li>\n<li>You can even <strong>combine concatenate with other functions for advanced results.<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0ec59hlQkvw?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson10\"><\/a>Lesson 10: MATCH Function<\/strong><\/p>\n<p>The\u00a0<strong>MATCH<\/strong> function in Excel returns the position of an item within a list or a range of cells.<\/p>\n<ul>\n<li>It can <strong>find irregularities<\/strong> just as easily as it can extract data.<\/li>\n<li>The match function is a dynamic tool to <strong>help make your Excel work at optimum levels.<\/strong><\/li>\n<li>Primarily<strong> combined with INDEX function<\/strong> to help user result value from a table based on horizontal and vertical criteria.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/8ldK8L2ioEU?list=PLWSweFpA2PEiHZ03UzIsGZ2VQsY-Gy4YL\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson11\"><\/a>Lesson 11: ABSOLUTE and RELATIVE Function<\/strong><\/p>\n<p>Learn the differences between these two and how you can properly use them in Excel Formulas! You can easily <strong>compare the differences between Relative and Absolute References<\/strong> in Excel with this Online Excel Training.<\/p>\n<ul>\n<li>Use <strong>Absolute Reference<\/strong> &#8211; When you <strong>do not want cell reference<\/strong> to change when filling cells.<\/li>\n<li>Use <strong>Relative Reference<\/strong> &#8211; When you <strong>want cell reference<\/strong> to automatically adjust when filling cells.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wAGr82yKgz0?list=PLWSweFpA2PEiHZ03UzIsGZ2VQsY-Gy4YL\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson12\"><\/a>Lesson 12: Left, Right &amp; Mid Function<\/strong><\/p>\n<p>Ever wanted to <strong>get something on the left, middle, or right side of your text<\/strong>? You can with the LEFT, MID, and RIGHT text formulas in Excel.<\/p>\n<ul>\n<li>Three most <strong>useful and powerful text-based functions.<\/strong><\/li>\n<li><strong>Extracts a specific number<\/strong> of characters from the left, middle, or right of a text.<\/li>\n<li>Also, helpful in cases where <strong>different parts of text contain different information<\/strong> (like social security numbers).<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/WUz3A0GCAsk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-first-name-from-full-name-in-excel\/\" target=\"_blank\">Excel Extract First Name From Full Name<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson13\"><\/a>Lesson 13: XLOOKUP &#8211; Outstanding Replacement of VLOOKUP<\/strong><\/p>\n<p>XLOOKUP is a<strong>\u00a0versatile and outstanding replacement<\/strong>\u00a0for the above-mentioned Excel functions. It allows you to <strong>quickly lookup values in a data set<\/strong> (just like VLOOKUP Excel) with additional flexibility and advantages.<\/p>\n<ul>\n<li>It can search the value both\u00a0<strong>horizontally and vertically<\/strong>,<\/li>\n<li>Perform an\u00a0<strong>exact or approximate match<\/strong>,<\/li>\n<li>Use\u00a0<strong>wildcards<\/strong>,<\/li>\n<li>Return a\u00a0<strong>custom text when no result<\/strong>\u00a0is found,<\/li>\n<li><strong>Doesn\u2019t even have the restriction of the return array to be on the right<\/strong>\u00a0of the lookup array.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/aRo-bzKzTqM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h3><a id=\"formatting-in-excel\"><\/a>Formatting in Excel<\/h3>\n<p><strong><span style=\"color: #339966;\"><a id=\"&quot;lesson14\"><\/a>Lesson 14: Excel Fill Handle Tips <\/span><\/strong><\/p>\n<p>Excel knows to <strong>fill down\/right when you are working with dates, days, months, years, and even quarters<\/strong>. That is very helpful and quick.<\/p>\n<ul>\n<li>Filling cells help automate the data entry process<\/li>\n<li>It optimizes data entry to save time<\/li>\n<li>Watch this learn excel online video to get tips on new ways to fill in your data.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QUbyIFSCvuY?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/copy-the-cell-above-in-excel\/\" target=\"_blank\">Copy The Cell Above In Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson15\"><\/a>Lesson 15: 6 Ways to Merge Cells in Excel<\/strong><\/p>\n<p>While working in Excel, you will <strong>come across scenarios when you will have to merge cells or combine cells<\/strong> in Excel.<\/p>\n<ul>\n<li>Merging cells is a common tool for making <strong>data more presentable.<\/strong><\/li>\n<li>It <strong>improves the aesthetics<\/strong> of any report<\/li>\n<li><strong>Create titles for your reports <\/strong>or<strong> combine various cells<\/strong> into one.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/sIejxpsbI3A?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson16\"><\/a>Lesson 16: Convert Text to Numbers<\/strong><\/p>\n<p>In Microsoft Excel, when <strong>we do text transformations<\/strong> and extract numbers from text, they <strong>stay in the annoying text format<\/strong>! What if we want them to be <strong>treated as numbers right away<\/strong> so that we can perform mathematical operations? I have just the thing for you with <strong>4 creative ways to convert text into numbers<\/strong> in Excel!<\/p>\n<ul>\n<li>Many <strong>data manipulating functions work on numeric data only.<\/strong><\/li>\n<li>Converting text into numbers makes it <strong>easier to extract and analyze data<\/strong><\/li>\n<li><strong>Copying data from a PDF<\/strong> or similar sources need to necessarily be converted into the proper format, to be used correctly.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/HnSnA-OEfHs?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson17\"><\/a>Lesson 17: Evaluate Function &amp; Formulas<\/strong><\/p>\n<p>Excel provides the way to <strong>evaluate your formula<\/strong>, and <strong>break it down step by step<\/strong> so that you can understand it!<\/p>\n<ul>\n<li><strong>Breaks down a formula<\/strong> for better understanding<\/li>\n<li>Makes<strong> deciphering formulas in Excel easier<\/strong><\/li>\n<li><strong>Shows the working of each step<\/strong>, making it helpful in following the process of complex formulas.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/CJVRIkLrK-o?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson17\"><\/a>Lesson 18: Convert Text to Column<\/strong><\/p>\n<p>If you have a<strong> data set with text consisting of names and email addresses<\/strong> that are wrapped inside a parenthesis, then you can use the <strong>Text to Columns feature in Excel to take out the email addresses and put them in a separate column<\/strong><\/p>\n<ul>\n<li><strong>Separates a column<\/strong> having multiple data<\/li>\n<li><strong>Makes sorting and arranging data easier<\/strong><\/li>\n<li>Makes the <strong>data more manageable and presentable<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/6yo1vqHJIb8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson19\"><\/a>Lesson 19: Clean &amp; Extract Data using Excel<\/strong><\/p>\n<p>You will learn the <strong>different ways to clean and extract data using Excel formulas and Excel&#8217;s built-in analytical tools<\/strong>.<\/p>\n<ul>\n<li>Excel provides <strong>many functions to clean up your data and extract precisely<\/strong> what you are looking for<\/li>\n<li>A <strong>clean data sheet is better for presentation<\/strong> and analysis<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/lk0ltG65bRE?list=RDCMUCMaVSMuAqV5j9WRdUz9UQfw\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><br \/>\n<strong>Related Articles:<br \/>\n<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-data-cleansing-techniques\/\" target=\"_blank\">Top Excel Data Cleansing Techniques<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson20\"><\/a>Lesson 20: Remove Duplicates<\/strong><\/p>\n<p>When you have duplicates values within your data table there is a quick and easy way to remove those values.<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">An Excel Worksheet can have<strong> multiple duplicates that can be hard to find<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Having Excel remove your duplicates <strong>saves valuable time<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Removing duplicates <strong>makes the data more reliable and accurate<\/strong><\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/1HKAodeBcS8?list=PLWSweFpA2PEiHZ03UzIsGZ2VQsY-Gy4YL\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<br \/>\n<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-find-duplicates-in-excel\/\" target=\"_blank\">How to Find Duplicates in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-highlight-unique-values-in-excel\/\" target=\"_blank\">How to Highlight Unique Values in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson21\"><\/a>Lesson 21: Flash Fill<\/strong><\/p>\n<p>The Microsoft Excel Flash Fill feature was<strong> introduced in Excel 2013 and it is AWESOME<\/strong>!<\/p>\n<ul>\n<li>It allows you to <strong>transform a column of messy data into clean and workable data<\/strong> so you can do your Excel analysis with ease.<\/li>\n<li>It is an extremely <strong>fast way to fill sequential data<\/strong><\/li>\n<li>It takes <strong>pattern detected in previous data and auto-fill the row\/column<\/strong> up to the point desired<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/S4QcqLMeA0E?list=PLWSweFpA2PEgRk7rFkufFoMi0GCVJ6yCO\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-numbers-using-flash-fill-excel\/\" target=\"_blank\">Extract Numbers Using Flash Fill In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-values-dates-using-flash-fill-excel\/\" target=\"_blank\">Convert Values to Dates Using Flash Fill In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-hyphens-serial-numbers-using-excel-flash-fill\/\" target=\"_blank\">Add Hyphens To Serial Numbers Using Excel Flash Fill<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/fix-incorrect-formatting-using-flash-fill-in-excel\/\" target=\"_blank\">Fix Incorrect Formatting Using Flash Fill In Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson21\"><\/a>Lesson 22: Custom Numbers &#8211; Thousands &amp; Millions<\/strong><\/p>\n<p>Large numbers in Excel can be<strong> formatted so they can be shown in \u201cThousands\u201d or \u201cMillions\u201d<\/strong>. You can even <strong>add some text in your cells<\/strong> by entering any word within the quotation marks &#8220;your word&#8221;.<\/p>\n<ul>\n<li>Helps <strong>present data in different numeric formats<\/strong>, as according to the location where the data is to be presented<\/li>\n<li>Makes<strong> data more familiar<\/strong> and <strong>easy to understand<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/nde2MrqurAE?list=PLWSweFpA2PEgRk7rFkufFoMi0GCVJ6yCO\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-custom-symbols-with-your-numbers-in-excel\/\" target=\"_blank\">Create Custom Symbols in Excel based on Numbers<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-number-formats-in-excel\/\" target=\"_blank\">Custom Number Formats in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson23\"><\/a>Lesson 23: Clean #REF error<\/strong><\/p>\n<p>When your <strong>Excel workbook has formulas that are linked to other workbooks\/cells that have been deleted<\/strong>, you will <strong>get a <\/strong><strong>#REF! error<\/strong>.<\/p>\n<p>Watch this Free Excel Training to learn how to clear the #REF! error!<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">This helps <strong>clear out unwanted data<\/strong><\/span><\/li>\n<li>It makes the data look <strong>more accurate and free from error<\/strong>.<\/li>\n<li>It <strong>removes invalid or unavailable information<\/strong> from the datasheet<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/04RXP2WypF0?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/iferror-introduction\/\" target=\"_blank\">IFERROR Function<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-combine-vlookup-and-iferror-to-replace-the-n-a-error-in-excel\/\" target=\"_blank\">Replace the #N\/A Error in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson24\"><\/a>Lesson 24: Custom Date Format<\/strong><\/p>\n<p>Custom date formats in Excel allow you to display only certain parts of the date.<\/p>\n<ul>\n<li>Understand how to <strong>create a custom date format<\/strong> using the Format Cells option in Excel<\/li>\n<li>Helps in <strong>making data familiar to the region it is being presented in<\/strong><\/li>\n<li>Can <strong>make the data easier to read and understand<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/SkQMPAc6brQ?list=PLWSweFpA2PEgRk7rFkufFoMi0GCVJ6yCO\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/date-formula-in-excel\/\" target=\"_blank\">DATE Formula in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-uk-dates-to-us\/\" target=\"_blank\">How to Change &amp; Convert UK Dates to US in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><a id=\"section04\"><\/a>4. Excel Tables<\/h3>\n<p><strong><a id=\"lesson25\"><\/a>Lesson 25: How to Insert an Excel Table<\/strong><\/p>\n<p>You should start using Excel Tables asap regardless of the size of your data set, as their benefits are HUUUGE.<\/p>\n<ul>\n<li>Tables in Excel are one of the<strong> most versatile tools<\/strong> at our disposal.<\/li>\n<li>Tables have numerous advantages like <strong>autofill, duplicate removing, sorting, filtering<\/strong>, etc.<\/li>\n<li>They are even<strong> dynamic<\/strong>, as, in a reference in any chart, report or formula gets updated automatically when the table is modified.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/-6523LrnP0w?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson26\"><\/a>Lesson 26: Excel Table Headers Show in Columns<\/strong><\/p>\n<p>Watch this Free Excel Tutorial to learn how to show Excel Table headers in Columns.<\/p>\n<ul>\n<li>Excel tables have many functions that<strong> provide ease<\/strong> while working on Excel.<\/li>\n<li>One such feature is how the <strong>headers of each column are still available at the top<\/strong>, even when we scroll down and out of focus from the header&#8217;s original position.<\/li>\n<li>It <strong>removes the limited functionality of Excel Lists<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/uq-HvTPEb3Q?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson27\"><\/a>Lesson 27: Filter &amp; Search in Excel Tables<\/strong><\/p>\n<p>The<strong> Search box within the Filter button is powerful<\/strong> if you know how to use it to your advantage. Make sure to view this video to learn how.<\/p>\n<ul>\n<li>\u00a0Allows you to <strong>find specific text by typing in a few letters<\/strong> only.<\/li>\n<li><strong>Data presentation and interpretation<\/strong> can be easily done with this Excel tables feature.<\/li>\n<li><strong>Unique values or a group of common values can be conveniently found<\/strong> in the table via these features.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/yy7D54xDBCQ?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson28\"><\/a>Lesson 28: Add Drop Down Menu In Your Excel Table <\/strong><\/p>\n<p>You can learn how to add a dropdown menu in your Excel Table after watching this Excel Video!<\/p>\n<ul>\n<li>Allows users to <strong>select a value from a list instead of typing<\/strong> it.<\/li>\n<li>It can make the <strong>entry of repetitive data easier<\/strong> and error-free.<\/li>\n<li>You can<strong> implement data validation features<\/strong> in tables.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/HARZWsHTjXY?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dynamic-data-list-using-excel-tables\/\" target=\"_blank\">Dynamic Data List using Excel Tables<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/drop-down-list-with-data-validation\/\" target=\"_blank\">Drop Down List with Data Validation<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson29\"><\/a>Lesson 29: Autofill Feature in an Excel Table <\/strong><\/p>\n<p>Learn the benefits of Autofill Feature in Excel Table by viewing this tutorial.<\/p>\n<ul>\n<li>It can <strong>copy your formulas all the way down<\/strong>.<\/li>\n<li>This <strong>cuts down the tediousness of copy-pasting<\/strong> formulas.<\/li>\n<li>As you <strong>add extra rows<\/strong> to your Excel Table, the<strong> formula fills in the extra rows<\/strong> added.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/C6vM09X7Q9M?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson30\"><\/a>Lesson 30: Remove Duplicates in an Excel Table<\/strong><\/p>\n<p>There is a quick and easy way to Excel Remove Duplicates from Table!<\/p>\n<ul>\n<li>Use Excel Tables to <strong>eliminate the major hurdle to find and remove duplicates<\/strong> in Excel.<\/li>\n<li>You can <strong>remove duplicates from the existing table or highlight duplicates or copy a list of unique values<\/strong> to a new location.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/76M58IQTaq0?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson31\"><\/a>Lesson 31: Excel Table &#8211; Styles\u00a0<\/strong><\/p>\n<p>Excel Tables can be formatted using any of the pre-built styles available in Excel.<\/p>\n<ul>\n<li>Data can be <strong>better interpreted<\/strong> when presented in an attractive way.<\/li>\n<li>Data tables are in general <strong>more organized and clean, making it easier to read data<\/strong>.<\/li>\n<li>Tables in Excel have many different styles and themes to <strong>make data presentation more attractive<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/kVzeO0IeKTM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extra-excel-table-styles\/\" target=\"_blank\">Extra Excel Table Styles<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson32\"><\/a>Lesson 32: Excel Table Slicers\u00a0<\/strong><\/p>\n<p>Discover the power of Table Slicers by following this Free Excel Training!<\/p>\n<ul>\n<li>A<strong> new feature was added in Excel 2010<\/strong> called Slicers.<\/li>\n<li>Slicers allow us to<strong> filter data in an interactive manner<\/strong>.<\/li>\n<li>Slicers implemented in tables a<strong>dd to the versatility of tables.<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/YzuH7yihvAI?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/\" target=\"_blank\">All About Excel Table Slicers<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><a id=\"section05\"><\/a>5. Excel Charts<\/h3>\n<p><strong><a id=\"lesson33\"><\/a>Lesson 33: How to Make a Graph in Excel &#8211; The Definitive Guide!<\/strong><\/p>\n<p>Most organizations find it<strong> challenging to create reports or make decisions by analyzing huge amounts of data<\/strong> spread across various Excel spreadsheets. This is where<strong> Excel Charts and Graphs come into action!<\/strong><\/p>\n<ul>\n<li>Graphs can be used to <strong>convert a plethora of rows and columns in Excel into simple charts<\/strong> that are easy to evaluate.<\/li>\n<li>Any raw data can be<strong> better understood<\/strong> in a graphical form.<\/li>\n<li><strong>Data is precise and cleaner<\/strong> in a graphical representation.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/rzR2Z97d16M?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson34\"><\/a>Lesson 34: Sparklines in Excel<\/strong><\/p>\n<p>Sparklines in Excel is a <strong>tiny chart in a worksheet cell that provides a visual representation of data.<\/strong> Learn all about the different ways of utilizing Excel Sparklines in this Free Excel Training!<\/p>\n<ul>\n<li>A<strong> new feature<\/strong> introduced in Excel 2010.<\/li>\n<li>It can add a small dynamic spark to your database by<strong> showing trends, forecasts<\/strong>, <strong>adding low and high point<\/strong>, etc<\/li>\n<li>It can easily be placed beside your data cell for <strong>convenient understanding<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QK6qe6kgViM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/winloss-sparklines-in-excel\/\" target=\"_blank\">Win\/Loss Sparklines<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-high-low-points-in-an-excel-sparkline\/\" target=\"_blank\">Add High &amp; Low Points in an Excel Sparkline<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/in-cell-bar-charts-with-the-excel-rept-function\/\" target=\"_blank\">In-Cell Bar Charts with the REPT Function<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson35\"><\/a>Lesson 35: How to Add Trendlines<\/strong><\/p>\n<p>In this Excel Graphs and Charts Tutorial, we will show you how to Add Trendlines to your Excel Charts! With Excel Charts, it is very easy to create Trendlines for your data.<\/p>\n<ul>\n<li>Trendlines show which <strong>direction the trend of your data is going<\/strong>, and gives you the <strong>trajectory<\/strong> as well.<\/li>\n<li>It represents data in a line <strong>showing peaks and drops<\/strong>.<\/li>\n<li>It makes <strong>decision-making and analysis easier<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QjDvcZZ5QJY?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-chart-marker-options\/\" target=\"_blank\">Add Chart Marker Options in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/adding-data-labels-to-an-excel-chart\/\" target=\"_blank\">Adding Data Labels To An Excel Chart<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson36\"><\/a>Lesson 36: 100% Stacked Column Chart<\/strong><\/p>\n<p>You can easily create a 100% Stacked Column Chart in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-footnotes-in-powerpoint\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> with this tutorial.<\/p>\n<ul>\n<li>It is an <strong>extension of the Stacked Column<\/strong> chart.<\/li>\n<li>It can <strong>compare the percentage that each value contributes to a Total<\/strong>.<\/li>\n<li><span style=\"font-weight: 400;\">It is<strong> convenient for showing positive and negative variables<\/strong> in a single graph too.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/XCoOwXnRvx8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/100-stacked-bar-chart\/\" target=\"_blank\">100% Stacked Bar Chart<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson37\"><\/a>Lesson 37: Waterfall Chart<\/strong><\/p>\n<p>In this Excel Graphs and Charts Tutorial, we will show you how to create a Waterfall Chart!<\/p>\n<ul>\n<li>Waterfall Charts are one of the many new Charts <strong>available only in Excel 2016<\/strong>.<\/li>\n<li>They are very popular in the current corporate environment as they graphically<strong> show the positive and negative movements within your Monthly Net Profit or Cash Flow<\/strong>.<\/li>\n<li><span style=\"font-weight: 400;\">It shows the<strong> movement of data from an initial value to the current value<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/FUeqA9MAPZo?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-sunburst-chart-excel-2016\/\" target=\"_blank\">Excel Sunburst Charts<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-radar-chart-for-performance-reviews\/\" target=\"_blank\">Excel Radar Chart For Performance Reviews<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson38\"><\/a>Lesson 38: Benchmark Chart<\/strong><\/p>\n<p>In Excel 2013 and onwards, it has been made much easier to create benchmark charts with the new Combo charts!<\/p>\n<ul>\n<li>Show your<strong> actual sales versus your benchmark in a graphical way<\/strong>, highlighting the strong v weak months.<\/li>\n<li>They are extremely helpful to<strong> visualize forecasted data and actual data variations<\/strong><\/li>\n<li>It is very helpful in<strong> presenting budgeted sales over actual sales<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/r7mBcpchLXA?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/benchmark-chart-in-excel-2010\/\" target=\"_blank\">Benchmark Chart in Excel 2010<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson39\"><\/a>Lesson 39: Bubble Chart<\/strong><\/p>\n<p>Bubble Chart is extremely useful to<strong> graphically represent three dimensions of data and show the relationship<\/strong> between them. Watch this video tutorial to learn how to create them.<\/p>\n<ul>\n<li>It is an <strong>extension of the xy scatter chart<\/strong> and represents three variables at once.<\/li>\n<li>The first <strong>2 variables are visualized as coordinates,<\/strong> the <strong>third as the size<\/strong> of the bubble.<\/li>\n<li>It can be used to <strong>convey a lot of information at once<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/92_CrQRY8Ls?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-box-whisker-chart-excel-2016\/\" target=\"_blank\">Create a Box and Whisker Excel 2016<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/draw-a-logo-with-a-scatter-chart\/\" target=\"_blank\">Draw a Logo with a Scatter Chart in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson40\"><\/a>Lesson 40: Milestone Chart<\/strong><\/p>\n<p>In this Excel Graphs and Charts Tutorial, we will show you how to create a Project Milestone Chart in Excel.<\/p>\n<ul>\n<li>It is helpful in showing a <strong>timeline with different stops displaying key milestones or major achievements.<\/strong><\/li>\n<li>It helps<strong> make project management easier<\/strong>.<\/li>\n<li>It is useful in <strong>conveying information about goals and timelines<\/strong> to everybody.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/a-ICH6cnbcw?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/stock-line-chart-using-excel\/\" target=\"_blank\">Stock Line Chart Using Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/candlestick-chart-using-excel\/\" target=\"_blank\">Candlestick Chart Using Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson41\"><\/a>Lesson 41: Logarithmic Chart<\/strong><\/p>\n<p>You can easily create a Logarithmic Scale in Excel with this Excel Graphs and Charts Tutorial.<\/p>\n<ul>\n<li>It <strong>evens out a very skewed column<\/strong> chart.<\/li>\n<li>It is helpful in <strong>showing data that has some absurdly different isolated quantities.<\/strong><\/li>\n<li>It gives a <strong>more presentable chart, clearly showing differences in smaller\/larger values<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/V9ZHM2RtQ9E?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson42\"><\/a>Lesson 42: Clustered Bar Chart<\/strong><\/p>\n<p>Clustered Bar Chart in Excel is used to<strong>\u00a0display more than one series of data<\/strong> in clustered horizontal columns or bars.<\/p>\n<ul>\n<li>It can be used for<strong> year-on-year comparison.<\/strong><\/li>\n<li>It is used to <strong>compare values across different categories<\/strong> or time periods.<\/li>\n<li>If <strong>category names (eg. products, business names, etc.) are way too long<\/strong>, then the Clustered Bar chart is the one for you.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/VJJbjSD6agQ?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-12-month-trend\/\" target=\"_blank\">Clustered Column Chart<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/overlap-graphs-in-excel\/\" target=\"_blank\">How to Create Overlay Charts in Excel<\/a><\/p>\n<div><\/div>\n<h3><a id=\"section06\"><\/a>6. Excel Pivot Tables<\/h3>\n<p><strong><a id=\"lesson43\"><\/a>Lesson 43: The Ultimate Excel Pivot Table Guide<\/strong><\/p>\n<p>Use PivotTable in your daily job to create management reports and dashboards. Watch this Video to venture into the unknown of Pivot Tables.<\/p>\n<ul>\n<li>This is a<strong> complete pivot table guide<\/strong> for beginners and advanced users.<\/li>\n<li>Pivot tables and dashboards make your <strong>data more presentable and easier to interpret.<\/strong><\/li>\n<li><strong>Analyze more than 1 million rows<\/strong> of data with just a few mouse clicks.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/vA2NiYiGkgs?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-pivot-tables\/\" target=\"_blank\">50 Things You Can Do With Excel Pivot Table<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/learn-the-power-of-excel-pivot-tables\/\" target=\"_blank\">Learn the Power of Excel Pivot Tables!<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\">101 Excel Pivot Tables Examples<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/5-speedy-steps-excel-pivot-table\/\" target=\"_blank\">5 Speedy Steps To An Excel Pivot Table!<\/a><br \/>\n<a href=\"https:\/\/youtu.be\/dJtwYziFxLs\" target=\"_blank\" rel=\"nofollow noopener\">10 Excel Pivot Table Tips<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson44\"><\/a>Lesson 44: Insert Pivot Table<\/strong><\/p>\n<p>In this Excel Pivot Table tutorial, you will learn how to insert a Pivot Table in Excel.<\/p>\n<ul>\n<li>Pivot tables are a very<strong> powerful tool in data arrangement<\/strong>.<\/li>\n<li>Being an expert pivot table, you can<strong> simplify and optimize many work<\/strong> processes.<\/li>\n<li>A well-presented pivot table can be instrumental in properly <strong>conveying information<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/FCKd536F-14?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-blank-rows-in-a-pivot-table-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Insert Blank Rows In a Pivot Table<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/refresh-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Refresh a Pivot Table<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson45\"><\/a>Lesson 45: Group by Quarters &amp; Years<\/strong><\/p>\n<p>Pivot table is a dynamic tool that can be helpful in grouping dates on a quarterly and yearly basis.<\/p>\n<ul>\n<li>It helps in <strong>trend analysis and comparisons of current data with historical<\/strong> data.<\/li>\n<li>This is a<strong> quick and easy way<\/strong> to group dates and it reduces the risks of making any errors.<\/li>\n<li>It makes <strong>updating the report easily<\/strong> with any new additional data<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Yx1BW_gTeTk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-sales-weeks-starting-monday-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Group Sales by Weeks Starting on a Monday<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-custom-dates-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Group By Custom Dates With Excel Pivot Tables<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-by-time-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Group By Time With Excel Pivot Tables<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/errors-when-grouping-by-dates-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Errors When Grouping By Dates With Excel Pivot Tables<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson46\"><\/a>Lesson 46: Slicers &amp; PivotCharts<\/strong><\/p>\n<p>Watch this Free Excel Training to start <strong>creating some awesome interactive analytical reports<\/strong> in just a couple of steps.<\/p>\n<ul>\n<li>Adding Charts and Slicers can make the <strong>Pivot Table more dynamic<\/strong>.<\/li>\n<li>\u00a0It can make data <strong>easier to comprehend and assimilate.<\/strong><\/li>\n<li>It is a convenient way to<strong> create interactive and useful dashboards<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/V0MEcYs_LfM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/\" target=\"_blank\" rel=\"noopener noreferrer\">The Ultimate Guide to Excel Pivot Table Slicers<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Charts<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/copy-a-pivot-chart\/\" target=\"_blank\" rel=\"noopener noreferrer\">Copy a Pivot Chart<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/expand-and-collapse-fields-in-pivot-chart-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Expand and Collapse Fields in Pivot Chart in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-columns-to-slicer-buttons-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Columns to Pivot Table Slicer Buttons<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson47\"><\/a>Lesson 47: Frequency Distribution in Pivot Table<\/strong><\/p>\n<p>With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can even create a\u00a0<strong>Frequency Distribution Table<\/strong>?<\/p>\n<p>I\u2019ll show you how easy it is to create your own Frequency Distribution Chart in this Excel Training Online!<\/p>\n<ul>\n<li>Frequency distribution is an <strong>age-old tool in data analysis<\/strong> and you can <strong>use pivot tables to execute them<\/strong>.<\/li>\n<li>It is great to <strong>group data into convenient intervals<\/strong> and get information accordingly.<\/li>\n<li>Implementing frequency distribution in pivot tables can <strong>make your data more meaningful<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/htKvsOr4blc?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson48\"><\/a>Lesson 48: Sort Option in Pivot Table<\/strong><\/p>\n<p>The Sorting Option is the <strong>most powerful feature<\/strong> within Excel Pivot Table. We will learn how to sort your data quickly.<\/p>\n<ul>\n<li>It allows you to <strong>analyze your data in many different ways, all with a press of a button<\/strong>.<\/li>\n<li>Sorting is one of the <strong>most common tools<\/strong> to read data easily.<\/li>\n<li>Sorting helps users <strong>see only the relevant data<\/strong> for analysis.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Q0877uoX4Xg?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-an-item-row-left-to-right-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sort an Item Row (Left to Right) With Excel Pivot Tables<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-largest-to-smallest-grand-totals-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sort Largest to Smallest Grand Totals With Excel Pivot Tables<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-an-excel-pivot-table-manually\/\" target=\"_blank\">Sort an Excel Pivot Table Manually<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-filter-top-5-customers\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Table Filter: Top 5 Customers<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/filter-a-pivot-table-by-dates\/\" target=\"_blank\">Filter a Pivot Table by Dates<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson49\"><\/a>Lesson 49: Pivot Table Conditional Formatting<\/strong><\/p>\n<p>Want to know How to <strong>Conditionally Format Cells based on their Value<\/strong> in Excel Pivot Tables? Click on this video to view Free Excel Training!<\/p>\n<ul>\n<li>It is the foremost thing that one undertakes to <strong>clean up data and make it more presentable<\/strong>.<\/li>\n<li>Formatting in a Pivot Table can allow a user to<strong> highlight key data<\/strong> in a split second.<\/li>\n<li>Allows you to <strong>add some color<\/strong> to your analysis.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/H250MtFll10?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/color-scales-in-a-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Color Scales in a Pivot Table<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditionally-format-a-pivot-table-with-data-bars\/\" target=\"_blank\" rel=\"noopener noreferrer\">Conditionally Format a Pivot Table With Data Bars<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/icon-sets-in-a-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Icon Sets In A Pivot Table<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-conditional-formatting\/\" target=\"_blank\">Conditionally Format Blank Cells in Pivot Table<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lessson50\"><\/a>Lesson 50: GETPIVOTDATA Function<\/strong><\/p>\n<p>View this video on how to create a formula that extracts data stored in a Pivot Table &#8211; GETPIVOTDATA!<\/p>\n<ul>\n<li>This formula can help you create ad-hoc reports outside the Pivot Table.<\/li>\n<li>These reports will be <strong>dynamic<\/strong>, ie, as the pivot table is updated, the report will also be refreshed.<\/li>\n<li><strong>Additional columns\/rows can be added<\/strong> to such reports for more data presentation in specialized fields\/cases.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/RNfxAii3lc4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson51\"><\/a>Lesson 51: Calculated Fields in Pivot Table<\/strong><\/p>\n<p>Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List. Watch this video to learn how!<\/p>\n<ul>\n<li>You can <strong>create your own formula<\/strong> using Calculated Field.<\/li>\n<li>You can<strong> use any of the Excel mathematical equations<\/strong>, like \/*+-%.<\/li>\n<li>It lets you <strong>add more power<\/strong> to Pivot Table.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/AYNsO3QjU2I?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-calculated-item\/\" target=\"_blank\">Pivot Table Calculated Item<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson52\"><\/a>Lesson 52: Subtotals in Pivot Table<\/strong><\/p>\n<p>Read all about the different ways you can use the Subtotal Function in Excel!<\/p>\n<ul>\n<li>It has the ability to <strong>return a SUM, AVERAGE, COUNT, COUNTA, MAX, or MIN<\/strong> from your data.<\/li>\n<li>It can be used to <strong>break a long data list and get information about different groups<\/strong> of data.<\/li>\n<li>It can be helpful in <strong>analyzing different groups of data<\/strong> like regions, centers, products, and more.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/DoFvA7WOrE4?list=PLWSweFpA2PEgMcjQK_v2irmLaNS9BfLc2\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson53\"><\/a>Lesson 53: Create Interactive Dashboards<\/strong><\/p>\n<p>In this Interactive Excel Dashboard tutorial, you will learn how to <strong>use &amp; create an Interactive Excel Dashboard<\/strong> in Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Office 365 &#8211; for Beginners or Advanced users.<\/p>\n<ul>\n<li>Dashboards are a <strong>great way of aesthetically presenting data<\/strong>.<\/li>\n<li>It can also <strong>aid in the assimilation of information<\/strong> that the data is trying to provide<\/li>\n<li>It can be used to <strong>display the required data through ways of sorting, slicers, formatting<\/strong>, etc.<\/li>\n<li>Dashboards are also <strong>dynamic<\/strong>, meaning they will update as the source data is being edited<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/3oJxdvDerus?list=PLWSweFpA2PEgMcjQK_v2irmLaNS9BfLc2\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe>\\<\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-dashboard-tools-for-excel\/\" target=\"_blank\">Ultimate Dashboard Tools for Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><a id=\"section07\"><\/a>7. Excel Macros &amp; VBA<\/h3>\n<p><strong><a id=\"lesson54\"><\/a>Lesson 54: How to Use Macro Recorder in Excel<\/strong><\/p>\n<p>You can automate some steps in Excel using <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macro\" data-wpil-keyword-link=\"linked\">Macro<\/a> Recorder. Let&#8217;s learn how to use it!<\/p>\n<ul>\n<li>It may be <strong>cumbersome to code the exact macro<\/strong> &#8211; especially as a VBA beginner.<\/li>\n<li>Using a Macro Recorder can be <strong>easy and can save time<\/strong> as well.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/zkmEP1M-YgU?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<br \/>\n<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-macro-activate-the-developer-tab\/\" target=\"_blank\">Excel Macro: Activate the Developer Tab<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/macro-recorder-recording-your-first-excel-macro\/\" target=\"_blank\">Macro Recorder: Recording Your First Excel Macro<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-a-macro-to-the-quick-access-toolbar-ribbon-in-excel\/\" target=\"_blank\">How to Add a Macro to the Quick Access Toolbar Ribbon in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-numbers-using-macros-in-excel\/\" target=\"_blank\">How to Insert Numbers Using Macros in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson55\"><\/a>Lesson 55: Create Macro Buttons<\/strong><\/p>\n<p>Do you know that you can <strong>automate your tasks in Excel with a couple of mouse clicks<\/strong>? Watch this Free Excel Training to learn about it!<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Macros are a great way to<strong> automate basic data formatting and entry<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can be <strong>designed to handle complex tasks\u00a0<\/strong>as well.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Having a macro <strong>button<\/strong> makes it much <strong>easier to access the function of macros<\/strong>.<\/span><\/li>\n<li aria-level=\"1\"><span style=\"font-weight: 400;\">A Macro Button also helps make the <strong>data set more interactive and user-friendly<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/ycu5tXSsnOQ?list=RDCMUCMaVSMuAqV5j9WRdUz9UQfw\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-all-worksheets-by-name-using-macros-in-excel\/\" target=\"_blank\">Sort All Worksheets By Name Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unhide-all-worksheets-using-macros-in-excel\/\" target=\"_blank\">Unhide All Worksheets Using Macros In Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson56\"><\/a>Lesson 56: Insert Multiple Rows using Macros<\/strong><\/p>\n<p>Want to insert multiple rows in Excel with a click of a button?<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>Inserting additional rows in a table<\/strong> is a regular occurrence, which can be tackled using macros.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">This <strong>Macro will ask for the number of rows<\/strong> to be inserted in a dialog box.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">It will <strong>insert the mentioned rows all at the same time<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/FQiFvqY2XwM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-multiple-columns-using-macros-in-excel\/\" target=\"_blank\">How to Insert Multiple Columns Using Macros in Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/7-quick-ways-to-convert-excel-to-pdf-pdf-to-excel\/\" target=\"_blank\">7 Quick Ways to Convert Excel to PDF &amp; PDF to Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson57\"><\/a><strong>Lesson 57: How to Autofit Columns<\/strong><\/p>\n<p>Did you know you can\u00a0<strong>autofit columns\u00a0<\/strong><strong>using Macros in Excel<\/strong>? This Excel Tutorial shows you just that:<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">A worksheet having <strong>uneven column widths may look unattractive<\/strong> and<strong> resizing each column individually can be a huge task<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Macros can help autofit column width to fit their contents with a single click<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">When column widths are adjusted, it makes the sheet<strong> more presentable as well as easier to read<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/xSa_0bncs28?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-autofit-rows-using-macros-in-excel\/\" target=\"_blank\">How to Autofit Rows Using Macros in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson58\"><\/a><strong>Lesson 58: Convert Formulas into Values Using Macros<\/strong><\/p>\n<p>In this Free Excel Training, I will cover the tutorial on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/word-files-to-pdf\/\" target=\"_blank\" rel=\"noopener\">how to convert<\/a> formulas to values using a macro:<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It is done to provide the cell with a <strong>constant value<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The <strong>cell will not change its value<\/strong> when the <strong>arguments in the formula change<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Using macros, this function<strong> can be easily performed in a single click instead of repeatedly using the paste special functionality<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/ogUNUd_MElo?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/reverse-text-function-using-macros-in-excel\/\" target=\"_blank\">Reverse Text Function Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-a-degree-symbol-to-selection-using-macros-in-excel\/\" target=\"_blank\">Add a Degree Symbol to Selection Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-characters-at-the-start-using-macros-in-excel\/\" target=\"_blank\">Remove Characters at the Start Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-extra-spaces-from-selection-using-macros-in-excel\/\" target=\"_blank\">Remove Extra Spaces from Selection Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/protect-all-cells-with-formulas-using-macros-in-excel\/\" target=\"_blank\">Protect All Cells With Formulas Using Macros In Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson59\"><\/a><strong>Lesson 59: Convert Chart into Image Using Macros<\/strong><\/p>\n<p>You can use Excel Macros to\u00a0<strong>convert your selected chart into an image! <\/strong>Watch the step-by-step tutorial in this Learn Excel Free Tutorial.<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An image is a <strong>versatile format to share information<\/strong> as it is more compatible.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An image l<strong>ocks the details of a chart from further change<\/strong>, hence curbing manipulation and promoting alteration.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Using Excel macros, you can <strong>easily convert charts to images<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/ReVefSrSW7o?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-chart-title-using-macros-in-excel\/\" target=\"_blank\">Add Chart Title Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-chart-type-using-macros-in-excel\/\" target=\"_blank\">Change Chart Type Using Macros In Excel<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/resize-all-charts-using-macros-in-excel\/\" target=\"_blank\">Resize All Charts Using Macros In Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section08\"><\/a>8. Power Query<\/h3>\n<p><a id=\"lesson60\"><\/a><strong>Lesson 60: How to Install Power Query in Excel<\/strong><\/p>\n<p>You can easily install Power Query in Excel 2010 with this tutorial.<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query is a <strong>new feature added in Excel 2013<\/strong> and has gained fame due to its usefulness, <strong>making it back compatible with Excel 2010 as well<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It lets you <strong>interact with data as you want<\/strong>, providing flexibility in data management.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It allows you to <strong>set up a query once<\/strong> and then <strong>reuse it with a simple refresh<\/strong>. It\u2019s also pretty powerful<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/qVQSKkbElZA?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/\" target=\"_blank\">Install Power Query With Excel 2013<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson61\"><\/a><strong>Lesson 61: Introduction to Power Query<\/strong><\/p>\n<p>Want to understand what Power Query is all about? You can easily<strong> use Power Query (Get &amp; Transform Data)<\/strong> in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-excel-labels-with-word\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel with<\/a> this tutorial.<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query is a <strong>powerful tool introduced in Excel 2013<\/strong> that can easily transform data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tables and data sheets <strong>imported from various locations<\/strong> often have undesirable additions to then that needs to be <strong>cleaned for proper data management<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query helps<strong> clean data and transform it<\/strong> into a more workable position. These<strong> steps can be applied to any data set in a single click<\/strong>, which can save your precious time.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/GntiR_djKM4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\">50 Things You Can Do With Excel Power Query<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson62\"><\/a>Lesson 62: Consolidate Multiple Excel Sheets Using Power Query Append<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Workbooks have<strong> similar data sets in different sheets<\/strong> that would be <strong>more efficient if they were consolidated<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Such operations can be done using a variety of functions but the <strong>optimum way is to perform it via a power query<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It ensures <strong>correct input of data is entered without tampering<\/strong> with the original data, hence giving you more flexibility<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/D_fH8_lwHk4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson63\"><\/a><strong>Lesson 63: Split the Date Using Power Query<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query is one of the <strong>most powerful transformational tools<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can <strong>easily split your date column into a day, month, or year<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Doing this operation via Power Query <strong>saves you a lot of time and can be applied to other sets of data<\/strong> with a single click.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/oOjIKPfC29I?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-the-time-using-power-query-or-get-transform\/\" target=\"_blank\">Split the Time Using Power Query or Get &amp; Transform<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/rename-a-column-using-power-query-or-get-transform\/\" target=\"_blank\">Rename a Column Using Power Query or Get &amp; Transform<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson64\"><\/a><strong>Lesson 64: Introduction, Parsing Text &amp; Inner Join<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query is a dynamic tool that can <strong>help you in parsing text and analyzing it<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The <strong>text to column function can be easily and efficiently performed<\/strong> using Power Query. You can easily<strong> use custom delimiters to separate columns.<\/strong><\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It is <strong>useful in extracting data<\/strong> that may be common between different data sets using <strong>advanced functions like inner join<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0YmD4zTHEWo?list=PLWSweFpA2PEishb8aYcovkqtpO4G1R2to\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<br \/>\n<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-text-using-power-query-or-get-transform\/\" target=\"_blank\">Format Text Using Power Query or Get &amp; Transform<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson65\"><\/a><strong>Lesson 65: Unstack &amp; Merge Data Using Power Query<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Copying data from other sources can give unattractive and incomprehensible data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query can help<strong> install this data and present it in a clean format<\/strong>, making it easier to read, interpret and manipulate<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You can even <strong>merge tables easily<\/strong>, choosing the specific columns that you want to merge without interfering with the original data.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/RpTa80BWSEo?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-duplicates-using-power-query\/\" target=\"_blank\">Remove Duplicates Using Power Query or Get &amp; Transform<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson66\"><\/a><strong>Lesson 66: Unpivot Data<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pivot tables are amazing tools to present and analyze data. But sometimes, you just need to <strong>unpivot the data<\/strong>.<\/span><\/li>\n<li aria-level=\"1\">Unpivot will <strong>rotate the table by transforming columns into rows<\/strong>.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">You can easily <strong>convert the crosstab format of a table into a tabular format <\/strong><\/span><\/span><span style=\"font-weight: 400;\">using Power Query.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/G6kj-1T2YXM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson67\"><\/a><strong>Lesson 67: Remove Top, Bottom, and Alternate Rows<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Query is a great tool to <strong>update and cleanse data<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can be used to <strong>remove rows &#8211;<\/strong> <strong>top n rows, bottom n rows, or alternate rows<\/strong> in the data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can be better to <strong>present data by removing rows that are unwanted<\/strong> and make data messy.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/TMcxNiZSMpk?list=PLWSweFpA2PEishb8aYcovkqtpO4G1R2to\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-columns-using-power-query\/\" target=\"_blank\">Merge Columns Using Power Query<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-index-columns-using-power-query\/\" target=\"_blank\">Create Index Columns Using Power Query<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson66\"><\/a><strong>Lesson 68: Copy and Paste Queries Across Workbooks Using Power Query<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Applying multiple copy and paste functions across your workbook can be tiresome and time-wasting<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You easily copy-paste queries across your multiple workbooks and save tons of time.<\/span><\/li>\n<li aria-level=\"1\">Learn how to reuse\u00a0queries in Power Query\u00a0or Get &amp; Transform\u00a0with just a few easy steps.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/7DosSaQRAX8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-a-query-into-two-parts-in-power-query\/\" target=\"_blank\">Split a Query into Two Parts in Power Query<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/comment-in-query-steps-in-power-query\/\" target=\"_blank\">Comment In Query Steps In Power Query<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-steps-until-end-in-power-query\/\" target=\"_blank\">Delete Steps Until End In Power Query<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section09\"><\/a>9. Power Pivot<\/h3>\n<p><a id=\"lesson69\"><\/a><strong>Lesson 69: Enabling Power Pivot in 2013<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot is a strong tool to <strong>accumulate data from different sources<\/strong>\u00a0for analysis.<\/span><\/li>\n<li aria-level=\"1\">Power Pivot gives you the power to work with large sets of data that are\u00a0<strong>over 1 million rows<\/strong>!!!<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It is a great way to handle a large volume of data and <strong>analyze them all in a beautiful pivot table<\/strong>.<\/span><\/li>\n<\/ul>\n<p>Watch this Free Excel Training to learn how to enable this powerful feature in Excel 2013.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/hXSWlPoMyng?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<br \/>\n<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/enabling-power-pivot-excel-2016\/\" target=\"_blank\">Enabling Power Pivot in 2016<\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-pivot-excel-2010\/\" target=\"_blank\">Installing Power Pivot in Excel 2010<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson70\"><\/a><strong>Lesson 70: Link Tables in Power Pivot<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In data management, <strong>relationships between different tables are the key to getting consolidated<\/strong> data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot helps create a <strong>common relationship between two tables to extract common<\/strong> from both tables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It is a great tool for <strong>analyzing data when you are working in a workbook<\/strong> that contains multiple tables.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wUw5WPicwo0?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-excel-tables-power-pivot\/\" target=\"_blank\">Using Excel Tables in Power Pivot<\/a><\/p>\n<p><a id=\"lesson71\"><\/a><strong>Lesson 71: Importing Excel Workbooks in Power Pivot<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot is a dynamic tool that helps <strong>handle a large volume of data with ease<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can <strong>import data from various different sources<\/strong> like Access, Oracle, text files, Excel files, SQL server, etc.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It has <strong>high flexibility in data importing<\/strong> and an easy interface for managing data.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/_kK1Y5BOzb4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a id=\"lesson72\"><\/a><strong>Lesson 72: Using the Diagram View in Power Pivot<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot is helpful in <strong>managing a large volume of data<\/strong> and it&#8217;s a powerful tool in handling even a million rows\/<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Due to the large database that it attracts, it <strong>can be overwhelming to keep track of all the data<\/strong> and the different relationships between your data tables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot provides a <strong>diagram view option so that the entire data can be viewed at a bird&#8217;s eye level for easy understanding<\/strong>.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/LnstFqMXxd4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson73\"><\/a><strong>Lesson 73: COUNTROWS in Power Pivot<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power Pivot acts as a<strong> strong measure in collecting, controlling, and analyzing large chunks of data<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">One of its powerful functions is known as measures, which are basically <strong>calculated fields(as known in Excel 2013)<\/strong>.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Watch this Free Excel Training to learn how easy it is to use the <strong>COUNTROWS<\/strong>\u00a0function in your\u00a0<strong>Measure.<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/twL_9gzILXk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><a id=\"lesson74\"><\/a><strong>Lesson 74: Measures Vs Calculated Column in Power Pivot<\/strong><\/p>\n<ul>\n<li>In Excel Power Pivot, two of the <strong>more powerful feature <\/strong>are <strong>Measures <\/strong>and <strong>Calculated Columns<\/strong>.<\/li>\n<li><strong>Measures <\/strong>are DAX formulas that can be <strong>added to Pivot Table<\/strong> and <strong>Calculated Columns <\/strong>are DAX formulas that you can <strong>add to each row<\/strong>.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In this Free Excel Training, we will elaborate on the differences between measures and calculated columns.<\/span><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/uj0HaAeboCQ?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Related Articles:<\/strong><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-measures-power-pivot\/\" target=\"_blank\">Using Measures in Power Pivot<\/a><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: left;\"><a id=\"section10\"><\/a><span style=\"color: #339966;\">10. Power BI<\/span><\/h3>\n<p><a id=\"lesson75\"><\/a><strong>Lesson 75: Introduction to Power BI<\/strong><\/p>\n<p>How to understand the Power BI &#8211; Overview! You can easily learn the overview of Excel Power BI with this Free Excel Training.<\/p>\n<ul>\n<li>Power BI allows you to <strong>get data from almost any source<\/strong>.<\/li>\n<li>It can be used to <strong>create data relationships and display attractive Dashboards.<\/strong><\/li>\n<li>You can easily<strong> share these Power BI reports with your colleagues<\/strong>.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0QE2GKvNWcI?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson76\"><\/a>Lesson 76: High-Level Flow of Power BI<\/strong><\/p>\n<p>To get a better understanding of Power BI, please go through this ultimate guide on Power BI flow.<\/p>\n<ul>\n<li>\u00a0Start with <strong>Power Query<\/strong>, i.e. load data from various sources and clean it.<\/li>\n<li>Then <strong>Power Pivot<\/strong> &#8211; Create Data Models by establishing relationships between tables.<\/li>\n<li>Next <strong>Power View<\/strong> &#8211; Create visualization to show trends in your data model<\/li>\n<li>Lastly, <strong>Publish<\/strong> it on the Power BI website so that it can be viewed and shared by colleagues.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/4xrkc50dZL8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>77 Lessons, 20+ hours of Free Microsoft Excel\u00a0 Online Training Videos Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning! &nbsp; Whether you are new to the world of Excel or just trying to improve your Excel skills, look no further. Rank up your skill from novice to pro by following our [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":23495,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Free Microsoft Excel Online Course - 20+ Hours Beginner to Advanced Course","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,5,3,56,4,7,120],"tags":[94,178,724,667,153,723,371,679,145,117],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23328"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23328"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23328\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/23495"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}