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
130 posts

Yoda Learning

About author
If you desire to become faster and better at office applications, (Excel, PowerPoint, Word, Excel VBA, Access, Visio, Outlook ) but don’t know where to start, this page is for you. For me and Yoda Learning community (We all call ourselves Yoda), we focus on helping each other with one goal – How can I get things done in the least possible time a.k.a. smarter-faster-better.
Articles
ExcelTutorials

Excel Formulas & Functions in PDF List

By Yoda Learning
June 14, 2020
11 Mins read
ExcelTutorials

How to delete rows in excel based on a condition?

By Yoda Learning
June 7, 2020
6 Mins read
In this blog, I will discuss how to delete rows in excel based on the condition. Sometimes we get the data set…
TableauTutorials

Tableau Data Types | Different Data Types In Tableau

By Yoda Learning
May 27, 2020
2 Mins read
Tableau Data Types gives us information about the kind of data stored in the data source. There can be a text value,…
Tutorials

Copy Text from PDF without Line Breaks & More Word Tricks

By Yoda Learning
May 20, 2020
1 Mins read
We have been working on Excel, VBA & PowerPoint tutorials, and felt the need for exploring Word Tricks to enhance productivity and…
ExcelTutorials

Undo - Redo Shortcuts Keys in Excel

By Yoda Learning
May 20, 2020
6 Mins read
Undo, Redo shortcut keys for MAC & Windows and other foremost needed Functions: Easy and Essential keyboard shortcut functions of Excel you’ve…
ExcelTutorials

Unprotect Excel | Excel Password Remover Online

By Yoda Learning
May 20, 2020
2 Mins read
Open password-protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let…
ExcelTutorials

Error in excel when you Insert Column or Row in Excel (Solved)

By Yoda Learning
May 17, 2020
1 Mins read
Are you fed up with the Errors in Excel while entering a row or column? Then you have come to the right…
ExcelTutorials

Combine Text with Date or Time in Excel - Reporting Tips

By Yoda Learning
May 17, 2020
1 Mins read
Many times you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the…
ExcelTutorials

How to Find Circular Reference in Excel

By Yoda Learning
May 15, 2020
3 Mins read
In Excel, a Circular reference warning is received with raised eyebrows and terrified looks most of the time. But from our experience,…
Excel VBA CodeTutorials

How to split spreadsheet into separate workbooks using Excel VBA?

By Yoda Learning
May 7, 2020
3 Mins read
Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook….
ExcelTutorials

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

By Yoda Learning
May 6, 2020
2 Mins read
Struggling with profit and loss? Or still, figuring out how to calculate the profit margin in excel? Here is your answer, the…
Power BITutorials

Learn 3 different ways to Merge Columns in Power Query

By Yoda Learning
May 2, 2020
3 Mins read
How to use power query concatenate function? There are times when we want to perform such tasks that are not built in…
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…
ExcelTutorials

How to Attach File in Excel or Object in Excel Spreadsheet

By Yoda Learning
April 25, 2020
2 Mins read
Want to attach an existing or new file in excel? then you land on the perfect page. You can check our ultimate…
Power BITutorials

Download Power BI Templates | Power BI Tutorials

By Yoda Learning
April 24, 2020
4 Mins read
When you are using Power BI for your report analysis, you also need to create a few dashboards that can be really…
Excel VBA CodeTutorials

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

By Yoda Learning
April 20, 2020
6 Mins read
Learn How to Update and Delete Using Excel VBA Userform? It’s useful for making a task easy in business areas like Banking…
PowerPointTutorials

Create Magnifier Glass Effect in Powerpoint Picture

By Yoda Learning
April 12, 2020
1 Mins read
I frequently visit the “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of…
Power BITutorials

Top 5 Essential Power BI Data Types

By Yoda Learning
April 11, 2020
3 Mins read
Power BI is a self-service data analytics and visualization tool. Power BI is now pre-integrated in the office 365 product suite. Power…
ExcelTutorials

Quartile Function in Excel

By Yoda Learning
March 8, 2020
2 Mins read
The Quartile Function in Excel helps to return the quartile of a data set in Excel. Going further in this tutorial, you’ll…
TableauTutorials

Tableau Date Functions

By Yoda Learning
March 5, 2020
2 Mins read
Tableau is a self-service, highly recommended Business Intelligence, Data Analytics, and Visualization tool. It stands as a leader nine times consecutively in…
Older posts
Newer 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
    • 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