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

Yoda Learning

About author
If you desire to become faster and better at office applications, (Excel, PowerPoint, Word, Excel VBA, Access, Visio, Outlook ) but don’t know where to start, this page is for you. For me and Yoda Learning community (We all call ourselves Yoda), we focus on helping each other with one goal – How can I get things done in the least possible time a.k.a. smarter-faster-better.
Articles
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

By Yoda Learning
September 17, 2021
2 Mins read
AlteryxTutorials

Step By Step Guide to Learn Alteryx

By Yoda Learning
September 14, 2021
6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

By Yoda Learning
February 13, 2021
1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…
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…
Power BITutorials

Opportunity Analysis Power BI Dashboard

By Yoda Learning
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 Yoda Learning
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 Yoda Learning
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 Yoda Learning
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 BI

Customer Profitability Power BI Dashboard

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

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

By Yoda Learning
December 17, 2020
7 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
3 Mins read
How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes?…
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…
Older posts
  • 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