NEW! FREE 15 Hours Microsoft Excel Course! View now 

YodalearningYodalearning
Menu
  • Home
  • Excel
    • 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
  • Power BI
  • Webinar
  • Courses
  • Login

Browsing tag

Power Excel

Power BITutorials

5 Easy Steps to Concatenate Data using 'M' in Power Query

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

Learn How to Display A Monospaced Font in Power Query

By Yoda Learning
December 4, 2019
1 Mins read
Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this…
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 ‘/*’ and end with ‘*/’. Comment…
Power BITutorials

Top 5 Steps to do Comments In Query Steps - Power Query Tutorial

By Yoda Learning
December 4, 2019
2 Mins read
Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions…
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. [toc] Power Query can create a query parameter and link it to the…
Power BITutorials

Learn How to Rename A Column Using Power Query

By Yoda Learning
December 4, 2019
1 Mins read
One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename…
Power BITutorials

Learn How to Merge 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 Grouped Serial Numbers In Power Query

By Yoda Learning
December 4, 2019
2 Mins read
Steps to Create Grouped Serial Numbers in Power Query. If we have data for products and we want a unique identifier for…
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…
Power BITutorials

Advanced Editor With Power Query

By Yoda Learning
December 4, 2019
2 Mins read
Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be…
Power BITutorials

Use Excel's Right Function With 'M' To Extract Left Side Data

By Yoda Learning
December 2, 2019
1 Mins read
If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because…
Power BITutorials

Get The Length Of Strings Using 'M' in Power Query

By Yoda Learning
December 2, 2019
1 Mins read
Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of…
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

Split First & Last Name Using Power Query

By Yoda Learning
December 1, 2019
1 Mins read
Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the…
Power BITutorials

Steps to Format Columns Using Power Query

By Yoda Learning
March 4, 2019
1 Mins read
Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim,…
Power BITutorials

How to Navigate Query Editor Using Power Query

By Yoda Learning
March 4, 2019
1 Mins read
While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created…
Power BITutorials

How to Edit A Query Using Power Query

By Yoda Learning
March 4, 2019
1 Mins read
Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a…
Older posts
  • Latest posts

    • ExcelExcel VBA Code

      Create A Table Of Contents By VBA Code

      January 14, 2021
      1 Mins read
    • ExcelExcel VBA Code

      Save Each Worksheet as a Separate PDF

      January 8, 2021
      1 Mins read
    • Power BITutorials

      Opportunity Analysis Power BI Dashboard

      January 4, 2021
      1 Mins read
  • Popular

    • Excel Formulas & Functions in PDF List

      June 14, 2020
    • 220+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

      December 17, 2020
    • Unprotect Excel | Excel Password Remover Online

      May 20, 2020
    • [How to] Calculate Profit Margin in Excel | Profit Margin Formula

      May 6, 2020
  • Subscribe and Follow

  • About

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

  • Recent Posts

    • Create A Table Of Contents By VBA Code
    • Save Each Worksheet as a Separate PDF
    • Opportunity Analysis Power BI Dashboard
    • Procurement Analysis Power BI Dashboard
    • Retail Analysis Power BI Dashboard
  • Navigation

    • Home
    • Excel
      • 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
    • Power BI
    • Webinar
    • Courses
    • 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-2020