NEW! FREE 1 Hour Excel Data Cleaning Course! Watch 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

Browsing tag

Excel Formula

ExcelTutorials

Working with Excel Sumif Formula

By Yoda Learning
April 26, 2020
1 Mins read
ExcelTutorials

9 Excel Error in Formula and How to correct it

By Yoda Learning
December 7, 2019
5 Mins read
Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel…
ExcelTutorials

Advanced Excel Formula Auditing

By Yoda Learning
April 7, 2019
5 Mins read
Microsoft Excel has a lot of features one of it is excel formula auditing. It has a variety of powerful tools that…
ExcelTutorials

How to use the Excel Choose Function

By Yoda Learning
February 11, 2019
2 Mins read
The CHOOSE Function in Excel returns a value from a list using a given position or index. The values provided to CHOOSE…
ExcelTutorials

How to use the Excel Code Function

By Yoda Learning
February 11, 2019
1 Mins read
The CODE Function in Excel returns a numeric code for a given character. The CODE Function can be used to understand numeric…
ExcelTutorials

How to use the Excel Column Function

By Yoda Learning
February 11, 2019
2 Mins read
The COLUMN function in Excel returns the column number for a reference. In other words, Column Function too will return the column…
ExcelTutorials

How to use Char Function in Excel

By Yoda Learning
January 28, 2019
2 Mins read
The CHAR Function in Excel returns a character when given a valid Character Code. CHAR Function is used to specify the characters…
Tutorials

How to Use SUBSTITUTE Function

By Yoda Learning
May 21, 2018
2 Mins read
Let’s first grasp what a Substitute Function is and when to use it. Before we figure out how to use the SUBSTITUTE…
  • Latest posts

    • Excel VBA Code

      VBA Code to Clean the Date Format

      February 13, 2021
      1 Mins read
    • ExcelExcel VBA Code

      VBA Code to Split table by Columns

      January 20, 2021
      3 Mins read
    • ExcelExcel VBA Code

      Create A Table Of Contents By VBA Code

      January 14, 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
    • [How to] Calculate Profit Margin in Excel | Profit Margin Formula

      May 6, 2020
    • Unprotect Excel | Excel Password Remover Online

      May 20, 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

    • VBA Code to Clean the Date Format
    • VBA Code to Split table by Columns
    • Create A Table Of Contents By VBA Code
    • Save Each Worksheet as a Separate PDF
    • Opportunity 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