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
279 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

How to Find Duplicate Values in Excel

By Yoda Learning
September 19, 2020
2 Mins read
ExcelTutorials

How to Lock Formulas in Excel?

By Yoda Learning
September 12, 2020
2 Mins read
How to Lock Formulas in Excel? Protect formula in Excel? Confused? Here is the blog to know how to lock excel formulas….
ExcelTutorials

Remove Password from Excel or Unprotected Excel

By Yoda Learning
September 7, 2020
2 Mins read
How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes? This…
ExcelTutorials

Turn ON or Turn OFF Scroll Lock in Excel

By Yoda Learning
September 7, 2020
3 Mins read
Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice…
ExcelTutorials

How to Split Cells In Excel

By Yoda Learning
September 6, 2020
2 Mins read
Merging and splitting cells in Microsoft Excel is very similar. Below are the steps required for merging and splitting cells in each…
ExcelTutorials

Strikethrough in Excel & Word | Strikethrough Shortcut

By Yoda Learning
July 31, 2020
2 Mins read
Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). An example sometimes, while creating a document we don’t…
ExcelTutorials

How to Display/Show Formulas in Excel

By Yoda Learning
July 12, 2020
2 Mins read
If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and…
Tutorials

Excel Formulas & Functions in PDF List

By Yoda Learning
June 14, 2020
24 Mins read
Excel Formulas PDF and Functions: What do you Understand by the Advanced Excel Formulas and Basic Excel Functions? This Blog will give you the Excel…
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 from…
Tutorials

Copy Text from PDF without Line Breaks & More Word Tricks

By Yoda Learning
May 20, 2020
1 Mins read
How to copy text from pdf without broken lines? We have been working on Excel, VBA & Powerpoint tutorial, and felt the…
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 been…
ExcelTutorials

Unprotect Excel | Excel Password Remover Online

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

How to protect cells and hide formula in excel ?

By Yoda Learning
May 18, 2020
1 Mins read
Investment banker protects the excel file by password and hide formula also hide formula in google spreadsheet, but anyone having access to…
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,…
ExcelTutorials

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….
Tutorials

[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

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

By Yoda Learning
May 2, 2020
2 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…
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