YodalearningYodalearning
Menu
  • Home
  • Courses
  • Blogs
    • Excel
    • Power BI
    • Excel VBA Code
    • Alteryx
    • Tutorials
      • 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
  • Corporate TrainingNEW
  • Quiz
    • Excel VBA Quiz
    • Excel VLookup Quiz
    • Excel Pivot Table Quiz
  • Login
16 posts

Browsing category

Excel VBA Code

Excel VBA CodeTutorials

VBA Code to Clean the Date Format

By Yoda Learning
February 13, 2021
1 Mins read
Excel VBA CodeTutorials

VBA Code to Split table by Columns

By Yoda Learning
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…
Excel VBA CodeTutorials

Create A Table Of Contents By VBA Code

By Yoda Learning
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…
Excel VBA CodeTutorials

Save Each Worksheet as a Separate PDF

By Yoda Learning
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…
Excel VBA CodeTutorials

How to split spreadsheet into separate workbooks using Excel VBA?

By Yoda Learning
May 7, 2020
3 Mins read
Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook….
Excel VBA CodeTutorials

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

By Yoda Learning
April 20, 2020
6 Mins read
Learn How to Update and Delete Using Excel VBA Userform? It’s useful for making a task easy in business areas like Banking…
Excel VBA CodeTutorials

Create a Dependent Combobox in Excel and VBA

By Yoda Learning
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 &…
Excel VBA CodeTutorials

Perform Google Search on Internet Explorer using Excel VBA

By Yoda Learning
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…
Excel VBA CodeTutorials

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

By Yoda Learning
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….
Excel VBA CodeTutorials

Loop Multiple Sheets and Merge Data using Excel VBA Worksheets

By Yoda Learning
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…
Excel VBA CodeTutorials

How to Merge Excel Files in to one Or into a Spreadsheet using Excel Macro

By Yoda Learning
December 7, 2019
2 Mins read
How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the…
Excel VBA CodeTutorials

Merge excel files into a single excel spreadsheet

By Yoda Learning
December 7, 2019
2 Mins read
In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a…
Excel VBA CodeTutorials

Excel Advanced Filters to split data into separate sheets using VBA

By Yoda Learning
December 7, 2019
3 Mins read
Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one…
Excel VBA CodeTutorials

Remove Password from Excel Using VBA [Macros] Tutorial

By Yoda Learning
April 20, 2019
3 Mins read
How to remove password from Excel using VBA as part of our continued effort to give the valuable resource of learning for…
Excel VBA CodeTutorials

Export data from SQL to Excel spreadsheet using VBA

By Yoda Learning
December 7, 2017
3 Mins read
In this blog, we will Import data from SQL to Excel spreadsheets using VBA. Assuming that you have a little bit of…
Excel VBA CodeTutorials

Create sales dashboard in excel using VBA Codes

By Yoda Learning
December 7, 2017
4 Mins read
You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used…
  • Most Popular Tutorials

    • ExcelTutorials

      Excel Formulas & Functions in PDF List

      By Yoda Learning
      June 14, 2020
      11 Mins read
    • Excel

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

      By Yoda Learning
      December 17, 2020
      7 Mins read
    • ExcelTutorials

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

      By Yoda Learning
      May 6, 2020
      2 Mins read
    • Power BITutorials

      Learn 3 different ways to Merge Columns in Power Query

      By Yoda Learning
      May 2, 2020
      3 Mins read
    • ExcelTutorials

      Unprotect Excel | Excel Password Remover Online

      By Yoda Learning
      May 20, 2020
      2 Mins read
    • ExcelTutorials

      How to delete rows in excel based on a condition?

      By Yoda Learning
      June 7, 2020
      6 Mins read
    • ExcelTutorials

      Turn ON or Turn OFF Scroll Lock in Excel

      By Yoda Learning
      September 7, 2020
      3 Mins read
    • ExcelTutorials

      How to Calculate Ratio in Excel | Excel Formula

      By Yoda Learning
      January 7, 2020
      2 Mins read
    • ExcelTutorials

      Combine Text with Date or Time in Excel - Reporting Tips

      By Yoda Learning
      May 17, 2020
      1 Mins read
    • Excel VBA CodeTutorials

      Remove Password from Excel Using VBA [Macros] Tutorial

      By Yoda Learning
      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
    • Courses
    • Blogs
      • Excel
      • Power BI
      • Excel VBA Code
      • Alteryx
      • Tutorials
        • 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
    • Corporate Training
    • Quiz
      • Excel VBA Quiz
      • Excel VLookup Quiz
      • Excel Pivot Table Quiz
    • 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