fbpx
[email protected] +1 203-349-9909 / +91-8080042523

By

Yoda Learning

How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on the condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set. You need to delete a certain section of data that is not relevant or there are innumerable blank cells,...
Read More

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

How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover...
Read More

How to split spreadsheet into separate workbooks using Excel VBA?

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbook with same data. Hope you have enjoyed our earlier blogs, revisit “How to split excel data into separate spreadsheets using VBA“. Split spreadsheet...
Read More

Excel Advanced filter technique using the Subtotal excel function

Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature in action before. If you work with large data set and often arrange your data for analysis, It’s practically impossible for someone to make a conclusion by sampling looking at this massive data....
Read More

Advanced Excel Formula Auditing

Microsoft Excel has a lot of features one of it is excel formula auditing. It has a variety of powerful tools that allow checking what is happening in your spreadsheet. Today we will discuss on Advanced Excel formula. It helps you to get the relations between formula and your cells. Which cells are using the...
Read More

Merge excel files into a single excel spreadsheet

In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a single excel spreadsheet. The source of the data may be from the same worksheet or from the closed workbook. We will merge excel files into a single sheet. For example, individual states data...
Read More

How to Calculate Ratio in Excel | Excel Formula

This article is been written to find calculate ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such advanced excel tutorial in our advanced excel dashboard course. If...
Read More

Working with Excel Date Functions

What is Excel Date Functions? How is a date stored in Excel (Hint: Every valid date is a number) A data in Excel is not stored in Excel the way we see it. If you know how it is stored and read by Excel, it will help you write complex logical Excel date functions. It...
Read More

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one. This can be...
Read More

How to compare two columns in Excel?

How to Compare two Columns in Excel Step-By-Step. Find difficulty in finding the same text in Excel, you can have a look for comparing two columns for matches or differences in the same row Like a two-dimensional database. Excel is capable of storing many different types of data from small business contacts to personal income...
Read More

Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S....
Read More
1 11 12 13
Power BI Interview Questions
101 Power BI Interview Questions and Answers[Q&A]
November 11, 2019
Alteryx Shortcuts and Alteryx Hotkeys
Alteryx Hotkeys – Alteryx Keyboard Shortcuts
November 1, 2019
Alteryx vs Tableau
Alteryx vs Tableau – Choose the right Data Analytics Tools
October 25, 2019
Alteryx Gallery Questions and Answers
Alteryx Analytics Gallery Questions and Answers | Alteryx Gallery – Public Gallery
October 24, 2019
Difference between Business Analyst and Financial Analyst - Business Analyst vs Financial Analyst
Difference between Business Analyst and Financial Analyst | Business Analyst vs Financial Analyst
October 24, 2019
What is Alteryx - Introduction to Alteryx Designer
What is Alteryx? | Introduction to Alteryx Designer
October 22, 2019
Comparison between Alteryx vs KNIME
Alteryx vs KNIME Comparison | Data Analytics tools
October 18, 2019
Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions & Answers [Q&A]
October 16, 2019
Alteryx Data Types
Alteryx Data Types | Alteryx Data Analytics
October 15, 2019
Alteryx Download and Installation Guide for Windows and Mac
Alteryx Download and Install for Windows and Mac | Alteryx Designer
October 14, 2019
Data Science Interview Questions with Answers
Data Science Interview Questions and Answers [Q&A]
September 26, 2019
Power bi vs SSRS
Power BI vs. SSRS | Difference between Power BI and SSRS
September 20, 2019
Tableau Interview Questions
Tableau Interview Questions and Answers [Q&A]
September 18, 2019
Power BI Data Sources
Power BI Data Sources and Power BI Services
September 16, 2019
What is Power BI_ _ Introduction to Microsoft Power BI
What is Power BI? | Introduction to Microsoft Power BI
September 13, 2019
POWER BI COMPONENTS
Power BI Components and Building Blocks of Power BI
September 13, 2019
Basics of Power BI DAX Function
Basics of Power BI DAX | List of Power BI DAX Function with Example
September 9, 2019
Power BI vs. Tableau
Power BI vs Tableau – Comparing Functionality, Pricing and Support
September 3, 2019
Business Analyst Interview Questions
Business Analyst Interview Questions & Answer (Q&A)
July 25, 2019
Data Analyst Interview Questions and Answers
Data Analyst Interview Questions and Answers [Q&A]
July 25, 2019