2022 updates MS Excel - Data Cleaning Course Enroll now  
YodalearningYodalearning
Menu
  • Home
  • Courses
  • Tutorials
    • ESSENTIALS 1
      • Shortcuts
      • Lookup Formulas
      • Pivot Table
      • Data Cleaning
    • ESSENTIALS 2
      • Charts
      • Dashboard
      • Consolidation
    • VBA MACROs
      • Basics
      • Readymade Codes
      • Essential Theory
    • CASE STUDIES
      • HR & L&D
      • Sales & Marketing
      • IT & Project Management
      • Finance & Audit
      • Office 365
  • Blogs
    • Excel
    • Power BI
    • Excel VBA Code
    • Alteryx
  • Login

Browsing tag

Power BI

Power BITutorials

Learn 3 different ways to Merge Columns in Power Query

By Yoda Learning
May 2, 2020
3 Mins read
Power BITutorials

Power Query Helps In Transposing Data

By Yoda Learning
May 1, 2020
1 Mins read
Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an…
Power BITutorials

Power BI Visualization with Bars & Column Charts

By Yoda Learning
January 13, 2020
2 Mins read
In this article let us understand the Bar & Column Charts in Power BI visualization. One of the most common ways of…
Power BITutorials

Microsoft Business Intelligence(MSBI)

By Yoda Learning
January 11, 2020
3 Mins read
MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here…
Power BITutorials

Read How to Remove Rows With Errors Using Power Query

By Yoda Learning
December 28, 2019
1 Mins read
Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware…
Power BITutorials

Learn How to Split Queries In Power Query

By Yoda Learning
December 28, 2019
1 Mins read
As explained in the above example, we have generated a conditional column for the given query. If we want to split this…
Power BITutorials

How to Use First Row As Headers in Power Query

By Yoda Learning
December 27, 2019
1 Mins read
One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s…
Power BITutorials

Split Column in Power Query

By Yoda Learning
December 27, 2019
1 Mins read
Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a…
Power BITutorials

Keep Duplicate Records in Power Query

By Yoda Learning
December 20, 2019
1 Mins read
Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst…
Power BITutorials

Power Bi Dax Deduplication Based On Column

By Yoda Learning
December 17, 2019
3 Mins read
To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has…
Power BITutorials

Learn How to Create Index Column Using Power Query

By Yoda Learning
December 12, 2019
1 Mins read
There is one more interesting feature of Power Query where it lets you add an index column that serves as a row…
Power BITutorials

How to do Duplicate Columns in Power Query

By Yoda Learning
December 12, 2019
1 Mins read
You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have…
Power BITutorials

How to Add Comments In M Using Power Query

By Yoda Learning
December 4, 2019
1 Mins read
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’…
Power BITutorials

Steps to Create A List Query From A Table Column

By Yoda Learning
December 4, 2019
1 Mins read
Power Query also allows you to create a list query from a data table available. The column from the given data table…
Power BITutorials

How to Manage Parameters in Power Query

By Yoda Learning
December 4, 2019
1 Mins read
Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List…
Power BITutorials

4 Easy Steps to Concatenate Columns in Power Query

By Yoda Learning
December 4, 2019
1 Mins read
Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily…
Power BITutorials

Top 3 Steps to Append Queries Using Power Query

By Yoda Learning
December 4, 2019
1 Mins read
You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together….
Power BITutorials

Top 5 Steps to Extract Age Using Date in Power Query

By Yoda Learning
December 4, 2019
1 Mins read
Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the…
Power BITutorials

How to Create A Sequential List Using Power Query

By Yoda Learning
December 4, 2019
1 Mins read
The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is…
Power BITutorials

Disable Relationship Detection for Beginners in Power Query

By Yoda Learning
December 4, 2019
1 Mins read
Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When…
Older posts
  • Most Popular Tutorials

    • ExcelTutorials

      Excel Formulas & Functions in PDF List

      By Yoda Learning
      June 14, 2020
      11 Mins read
    • Excel

      220+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

      By Yoda Learning
      December 17, 2020
      7 Mins read
    • ExcelTutorials

      [How to] Calculate Profit Margin in Excel | Profit Margin Formula

      By Yoda Learning
      May 6, 2020
      2 Mins read
    • ExcelTutorials

      Unprotect Excel | Excel Password Remover Online

      By Yoda Learning
      May 20, 2020
      2 Mins read
    • Power BITutorials

      Learn 3 different ways to Merge Columns in Power Query

      By Yoda Learning
      May 2, 2020
      3 Mins read
    • ExcelTutorials

      Turn ON or Turn OFF Scroll Lock in Excel

      By Yoda Learning
      September 7, 2020
      3 Mins read
    • ExcelTutorials

      How to delete rows in excel based on a condition?

      By Yoda Learning
      June 7, 2020
      6 Mins read
    • ExcelTutorials

      How to Calculate Ratio in Excel | Excel Formula

      By Yoda Learning
      January 7, 2020
      2 Mins read
    • ExcelTutorials

      Combine Text with Date or Time in Excel - Reporting Tips

      By Yoda Learning
      May 17, 2020
      1 Mins read
    • Excel VBA CodeTutorials

      Remove Password from Excel Using VBA [Macros] Tutorial

      By Yoda Learning
      April 20, 2019
      3 Mins read
  • Yoda Learning Academy

    Learn to [Analyse], [Visualise] and [Automate] using the most commonly used tools in organisations globally i.e. Excel & Power BI.

  • Recent Posts

    • Alteryx Hotkeys – Alteryx Keyboard Shortcuts
    • Step By Step Guide to Learn Alteryx
    • VBA Code to Clean the Date Format
    • VBA Code to Split table by Columns
    • Create A Table Of Contents By VBA Code
  • Navigation

    • Home
    • Courses
    • Tutorials
      • ESSENTIALS 1
        • Shortcuts
        • Lookup Formulas
        • Pivot Table
        • Data Cleaning
      • ESSENTIALS 2
        • Charts
        • Dashboard
        • Consolidation
      • VBA MACROs
        • Basics
        • Readymade Codes
        • Essential Theory
      • CASE STUDIES
        • HR & L&D
        • Sales & Marketing
        • IT & Project Management
        • Finance & Audit
        • Office 365
    • Blogs
      • Excel
      • Power BI
      • Excel VBA Code
      • Alteryx
    • Login
  • Popular Videos

    • Dashboard Videos
    • Excel Chart Videos
    • Data Cleaning Videos
    • Pivot Table Videos
    • Lookup Formulas Videos
    • Excel Shortcut Videos

Copyright - Yoda Learning Solutions 2015-2022