YodalearningYodalearning
Menu
  • Home
  • All Courses
  • Login
51 posts

Browsing category

Excel

ExcelTutorials

Learn How to Create or Make Excel Scatter Plots

By excelsuperstar20
December 7, 2019
2 Mins read
ExcelTutorials

Excel Advanced filter technique using the Subtotal excel function

By excelsuperstar20
December 7, 2019
3 Mins read
Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature…
ExcelTutorials

Tricks to create Hyperlink in Excel | 'How to'

By excelsuperstar20
December 6, 2019
4 Mins read
Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and where we can use it. What are Hyperlinks? A…
ExcelTutorials

How to Wrap Text in Excel Automatically and Manually

By excelsuperstar20
December 6, 2019
5 Mins read
Wrap Text is the most known function of excel. There are times when it is difficult to adjust long texts within an…
ExcelTutorials

Text To Column in Excel | Split Cells

By excelsuperstar20
December 4, 2019
3 Mins read
TEXT TO COLUMNS To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example,…
ExcelTutorials

How to Group Numbers, Dates & Text in Pivot table in Excel

By excelsuperstar20
December 1, 2019
3 Mins read
Now will talk about the Grouping Data features of the pivot table. This technique of grouping numbers, dates and text are not…
ExcelTutorials

Create Drop Down List in Excel using Conditional Formatting in Excel

By excelsuperstar20
July 25, 2019
2 Mins read
Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends…
ExcelTutorials

Learn how to remove blank cells in Excel

By excelsuperstar20
June 3, 2018
2 Mins read
How to remove blank cells in Excel? confused? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes,…
ExcelTutorials

How to Create Formulas in Excel?

By excelsuperstar20
February 12, 2018
3 Mins read
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel…
ExcelTutorials

How to sort in Pivot Table | Custom Sorting

By excelsuperstar20
January 29, 2018
2 Mins read
Sorting data in alphabetical order is helpful when you have large amounts of data in a Pivot Table. Sorting lets you organize…
ExcelTutorials

How to add Error Bars in Excel: Standard Deviation

By excelsuperstar20
November 30, 2017
2 Mins read
How to add Error Bars in Excel: Standard Deviation? Imagine that if all data was perfect, absolute and complete. Although actually, it…
Newer posts
  • Most Popular Tutorials

    • ExcelTutorials

      Excel Formulas & Functions in PDF List

      By excelsuperstar20
      June 14, 2020
      11 Mins read
    • ExcelTutorials

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

      By excelsuperstar20
      May 6, 2020
      2 Mins read
    • Excel

      220+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

      By excelsuperstar20
      December 17, 2020
      7 Mins read
    • Power BITutorials

      Learn 3 different ways to Merge Columns in Power Query

      By excelsuperstar20
      May 2, 2020
      3 Mins read
    • ExcelTutorials

      Combine Text with Date or Time in Excel - Reporting Tips

      By excelsuperstar20
      May 17, 2020
      1 Mins read
    • ExcelTutorials

      Unprotect Excel | Excel Password Remover Online

      By excelsuperstar20
      May 20, 2020
      2 Mins read
    • ExcelTutorials

      How to delete rows in excel based on a condition?

      By excelsuperstar20
      June 7, 2020
      6 Mins read
    • ExcelTutorials

      Turn ON or Turn OFF Scroll Lock in Excel

      By excelsuperstar20
      September 7, 2020
      3 Mins read
    • ExcelTutorials

      How to Calculate Ratio in Excel | Excel Formula

      By excelsuperstar20
      January 7, 2020
      2 Mins read
    • Excel VBA CodeTutorials

      Remove Password from Excel Using VBA [Macros] Tutorial

      By excelsuperstar20
      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
    • All 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-2022