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

Browsing category

Tutorials

(function (w,i,d,g,e,t,s) {w[d] = w[d]||[];t= i.createElement(g); t.async=1;t.src=e;s=i.getElementsByTagName(g)[0];s.parentNode.insertBefore(t, s); })(window, document, '_gscq','script','//widgets.getsitecontrol.com/52939/script.js');

Power BITutorials

Opportunity Analysis Power BI Dashboard

By Vijay Galiya
January 4, 2021
1 Mins read
Power BITutorials

Procurement Analysis Power BI Dashboard

By Vijay Galiya
December 31, 2020
1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

By Vijay Galiya
December 28, 2020
1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…
Power BITutorials

Human Resources Power BI Dashboard

By Vijay Galiya
December 24, 2020
1 Mins read
Information: This dashboard looks at new hires, active employees, and employees who have left. The main objectives are to understand: Who we…
Power BITutorials

Customer Profitability Power BI Dashboard

By Vijay Galiya
December 24, 2020
1 Mins read
Information: A company that manufactures, marketing materials. This dashboard was created to see key metrics about their five business unit managers (executives),…
Power BITutorials

IT Spend Analysis sample for Power BI

By Vijay Galiya
December 24, 2020
1 Mins read
Information: Analyzes the planned vs. actual costs of an IT department. This comparison helps us understand how well the company planned for…
ExcelTutorials

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

By Vijay Galiya
December 17, 2020
11 Mins read
MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and…
ExcelTutorials

How to Find Duplicate Values in Excel

By Yoda Learning
September 19, 2020
2 Mins read
You can Find duplicate values in Excel by reading this blog. An Excel sheet is a great way of packing lots of…
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…
TableauTutorials

Tableau Aggregate Functions

By dishank
June 10, 2020
2 Mins read
Tableau is a top-rated Data Visualization tool. Tableau is a self-service BI and analytics tool, capable of building compelling visualizations. Being a…
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…
TableauTutorials

Tableau Data Sources

By dishank
June 4, 2020
2 Mins read
A Data Source is a connection to a database or a place where the data is generally stored. Users are able to…
KNIMETutorials

KNIME Interview Questions & Answers for Beginners

By dishank
June 1, 2020
3 Mins read
While facing the KNIME interview, the following interview questions and answers will help you to revise the basics but important facts about…
TableauTutorials

Tableau Data Types | Different Data Types In Tableau

By Vijay Galiya
May 27, 2020
3 Mins read
Tableau Data Types gives us information about the kind of data stored in the data source. There can be a text value,…
Older posts
  • Latest posts

    • 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
    • ExcelExcel VBA Code

      Save Each Worksheet as a Separate PDF

      January 8, 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

    • 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
    • Procurement 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