YodalearningYodalearning
Menu
  • Home
  • All Courses
  • Login

Browsing tag

Excel

ExcelTutorials

Quartile Function in Excel

By excelsuperstar20
March 8, 2020
2 Mins read
ExcelTutorials

How to Create Calendar in Excel

By excelsuperstar20
January 22, 2020
3 Mins read
This example describes how to create a calendar in Excel. The calendar is an important part of keeping all your activities, appointments,…
ExcelTutorials

How to Calculate Ratio in Excel | Excel Formula

By excelsuperstar20
January 7, 2020
2 Mins read
This article is been written to find calculate the ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more…
ExcelTutorials

INDIRECT Function with SUM, MAX, MIN & Independent Cell Value

By excelsuperstar20
December 25, 2019
3 Mins read
Indirect Function in Excel returns a reference to a range. Excel Indirect functions are useful to create a reference that won’t change…
ExcelTutorials

Insert a Picture into a Cell in Excel

By excelsuperstar20
December 25, 2019
4 Mins read
Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this?…
ExcelTutorials

How to use the Histogram in Excel (Step By Step Guide)

By excelsuperstar20
December 24, 2019
3 Mins read
In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure…
ExcelTutorials

What is Flash Fill ? How to use flash fill in Excel ?

By excelsuperstar20
December 23, 2019
2 Mins read
Before we learn how to use flash fill in Excel, there are some questions we need to address first. These questions are:…
ExcelTutorials

Create a report in excel for sales data analysis using Pivot Table Techniques

By excelsuperstar20
December 21, 2019
3 Mins read
Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure…
Excel VBA CodeTutorials

Create a Dependent Combobox in Excel and VBA

By excelsuperstar20
December 21, 2019
3 Mins read
In this blog, we will discuss how to create a Combobox in Excel and as well as through VBA. List box &…
ExcelTutorials

5 Powerful Tricks to Format cells in Excel

By excelsuperstar20
December 20, 2019
4 Mins read
In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these in excel will make…
Excel VBA CodeTutorials

Perform Google Search on Internet Explorer using Excel VBA

By excelsuperstar20
December 19, 2019
3 Mins read
First time in my life I have come across to create this type of automation and finally, I got success. How to…
ExcelTutorials

How to Create Sparklines in Excel

By excelsuperstar20
December 19, 2019
2 Mins read
Imagine you have a result sheet for your students over the last 5 years and want to create a chart in Excel,…
ExcelTutorials

How to unlock or lock cells in excel- Single or multiple

By excelsuperstar20
December 18, 2019
1 Mins read
In Microsoft Excel 2007 or later versions like Excel 2019, we want to protect few cells only in a worksheet, then how…
ExcelTutorials

How to Remove Duplicates in Excel | Find & Delete Duplicates

By excelsuperstar20
December 17, 2019
2 Mins read
In Microsoft Office Excel you have several ways to filter for unique values or find and remove duplicates in Excel.Now, you will…
Excel VBA CodeTutorials

How to Automate Mail Merge through VBA in Microsoft Excel | VBA

By excelsuperstar20
December 16, 2019
5 Mins read
In this blog, I will try to cover how to get rid of Mail Merge by using the sample Excel VBA code….
ExcelTutorials

How to convert invalid date formats into valid data formats?

By excelsuperstar20
December 15, 2019
3 Mins read
Unclean or Invalid Dates (DMY Format) should be converted to valid data formats. By default, Excel accepts date input in MM/DD/YY format…
ExcelTutorials

Special Character Symbol List with Shortcodes in Excel

By excelsuperstar20
December 15, 2019
3 Mins read
To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric…
Excel VBA CodeTutorials

Loop Multiple Sheets and Merge Data using Excel VBA Worksheets

By excelsuperstar20
December 14, 2019
2 Mins read
In this blog article, we will be covering how to loop through multiple sheets and merge data in Excel VBA Worksheets as…
ExcelTutorials

Drag and Drop: 5 Simple MS Excel Shortcuts that really Work

By excelsuperstar20
December 12, 2019
3 Mins read
Working on your Excel spreadsheets can be much faster than you think if you use this 5 Simple drag and drop MS…
ExcelTutorials

Create Report in Excel Using Pivot Table Techniques

By excelsuperstar20
December 12, 2019
3 Mins read
Create a report in excel using a pivot table for sales data analysis is an important aspect of any business. Unless you…
Older posts
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