NEW! FREE 90 Minutes Excel Charts Course for Reporting 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
18 posts

Vijay Galiya

About author
Articles
Excel VBA Code

VBA Code to Clean the Date Format

By Vijay Galiya
February 13, 2021
1 Mins read
ExcelExcel VBA Code

VBA Code to Split table by Columns

By Vijay Galiya
January 20, 2021
3 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
ExcelExcel VBA Code

Create A Table Of Contents By VBA Code

By Vijay Galiya
January 14, 2021
1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
ExcelExcel VBA Code

Save Each Worksheet as a Separate PDF

By Vijay Galiya
January 8, 2021
1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
Power BITutorials

Opportunity Analysis Power BI Dashboard

By Vijay Galiya
January 4, 2021
1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
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
1 Mins read
MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and…
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,…
TableauTutorials

Tableau Features and Benefits | Key Features of Tableau 10

By Vijay Galiya
February 29, 2020
5 Mins read
The critical reason for Tableau’s popularity is its incredible features. The features of Tableau are so overwhelming that it outruns almost all…
Qlik SenseTutorials

Qlik Sense Data Model - Qlik Sense Tutorial

By Vijay Galiya
January 14, 2020
3 Mins read
Qlik Sense is a “Data Visualization Tool” which has gained a lot of popularity in “Business Intelligence” Industry because of the available…
TableauTutorials

Tableau File Types and their uses - Tableau Tutorial

By Vijay Galiya
December 30, 2019
4 Mins read
Each file is created to serve a definite purpose in software. The workflow of the software develops separate data at each stage….
TableauTutorials

Top 10 Reasons Why Tableau is a necessity for Business

By Vijay Galiya
December 27, 2019
4 Mins read
Why Tableau is a necessity for Business? Due to the proliferation of the internet, data is increasing day by day. Thanks to…
AlteryxTutorials

Alteryx for Beginners - Alteryx Online FREE Course

By Vijay Galiya
December 3, 2019
2 Mins read
Alteryx for Beginners Course is designed for the people who hardly know about Alteryx or how it can be used. We have…
ExcelTutorials

Online Excel Course - Online Excel Training Course

By Vijay Galiya
November 26, 2019
4 Mins read
In this technological sound world, where access to a computer and online services are handy enough and can be accessed by any…
  • 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