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 Excel

Power BITutorials

Learn 3 different ways to Merge Columns in Power Query

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

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…
Power BITutorials

Advanced Editor With Power Query

By Yoda Learning
December 4, 2019
1 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

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

By Yoda Learning
March 2, 2019
1 Mins read
How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it…
  • 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