YodalearningYodalearning
Menu
  • Home
  • Courses
  • Blogs
    • Excel
    • Power BI
    • Excel VBA Code
    • Alteryx
    • 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
  • Corporate TrainingNEW
  • Quiz
    • Excel VBA Quiz
    • Excel VLookup Quiz
    • Excel Pivot Table Quiz
  • Login

Browsing tag

Power Query

Power BITutorials

Power Query Helps In Transposing Data

By Yoda Learning
May 1, 2020
1 Mins read
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

51 Amazing Power Query Tips & Tricks | Power Query Tutorial

By Yoda Learning
December 8, 2019
11 Mins read
Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to…
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

Best Ways to Add Column From Examples in Power Query

By Yoda Learning
December 2, 2019
1 Mins read
Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you…
Power BITutorials

Best Ways to Import Data From XML in Power Query

By Yoda Learning
December 2, 2019
1 Mins read
You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an…
Power BITutorials

Learn How to Replace Values in Power Query

By Yoda Learning
December 1, 2019
1 Mins read
There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace…
Power BITutorials

Learn How to Filter Records Using Power Query

By Yoda Learning
March 2, 2019
1 Mins read
Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how…
Power BITutorials

Learn How to Create Pivot Columns Using Power Query

By Yoda Learning
March 1, 2019
1 Mins read
To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI….
  • 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
    • Power BITutorials

      Learn 3 different ways to Merge Columns in Power Query

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

      Unprotect Excel | Excel Password Remover Online

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

      How to delete rows in excel based on a condition?

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

      Turn ON or Turn OFF Scroll Lock in Excel

      By Yoda Learning
      September 7, 2020
      3 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
    • Blogs
      • Excel
      • Power BI
      • Excel VBA Code
      • Alteryx
      • 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
    • Corporate Training
    • Quiz
      • Excel VBA Quiz
      • Excel VLookup Quiz
      • Excel Pivot Table Quiz
    • 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