Need Help? Chat with us

By

Yoda Learning

How to Use First Row As Headers in Power Query

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...
Read More

Split Column in Power Query

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a column by the number of characters easily. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....
Read More

Pivot Table in Excel for Beginners to Advanced User’s

INTRODUCTION TO PIVOT TABLE IN EXCEL When you have a large amount of data in your worksheet and you can’t analyze or sort the data then Pivot Table in Excel helps you to carry out the task easily and more conveniently. Pivot Tables are powerful functions in excel. We are going to start with what...
Read More

How to create Icons in PowerPoint

Think sometimes you need an icon to be pasted or used somewhere that is not available in your system. In such cases, it is better to Create your own PowerPoint Icon using PowerPoint tools. It is much easier than it seems. Imagine the number of possibilities that you can unlock by using this tool to...
Read More

How to compare two lists in Excel

In the tutorial, we will learn: How to compare two columns in Excel. We use various ways to compare two cells using functions in Excel. Some of these ways are: Comparing two columns row-by-row. Comparing many columns for row matches or differences. Highlight matches or differences between two columns. Highlight row matches and differences. Compare...
Read More

INDIRECT Function with SUM, MAX, MIN & Independent Cell Value

Indirect Function in Excel returns a reference to a range. Excel Indirect functions are useful to create a reference that won’t change if columns or rows are inserted in a worksheet. There are a number of indirect functions in excel such as SUM, MAX, MIN & Independent Cell Value. In this tutorial, we explain one...
Read More

Find & Replace – using wildcard Character (*)

This time we’ll talk about “Find and Replace” and we’ll see its importance in the context of data cleaning. In fact, I have to start with the data which is going to illustrate how is this going to be used. For example, if I have a set of names with certain extra data with respect...
Read More

Insert a Picture into a Cell in Excel

Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this? You need to know, how to insert a Picture into a Cell in Excel. To show pictures in the adjacent cell or any other cell, instructed in a column you must know how...
Read More

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More

Power BI Dashboard vs. Power BI Report | BI Dashboard

Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect Power BI dashboard contains only the most important fundamentals of the story. So before creating the Power BI Dashboard or Report, let’s know What...
Read More

Create Power BI Layouts – Power BI Tips and Tricks

Power BI has this excessive functionality where you can go and download preset layouts which make your Power BI reports look more effective. There is a simple trick to create these Power BI layouts. You can create layouts in PowerPoint and then convert them into images. After that, you can insert them into your Power...
Read More

Complete Guide of Power BI Download and Power BI Installation Steps

Power BI Download and Installation Guide Microsoft Power BI Desktop is designed for the data analyst. It consists of the interactive visualizations, with industry-leading data query and modeling built-in. You can generate and publish your reports to Power BI. Power BI Desktop helps you authorize others with timely critical information, anytime, anywhere. and Checkout Power...
Read More

How to use the Histogram in Excel (Step By Step Guide)

In case, if you plan to use the Histogram tool, you need to keep in mind and you have to make sure that the Analysis Tool Pak Add-in is installed on your system. Using the Histogram in Excel: If you’re planning to use the Histogram tool, then there are certain things that you need to...
Read More

Alteryx Interview Questions and Answers | Alteryx Gallery – Public Gallery

Alteryx Interview Questions and Answers: Whether you are a fresher or an experienced professional, you need Alteryx Interview Questions and Answers to have a better understanding of Alteryx. Our real-time experts prepare these Top Alteryx Interview Questions and Answers, and this tutorial will help you to crack your next Alteryx job interview very quickly. With...
Read More

What is Flash Fill ? How to use flash fill in Excel ?

Before we learn how to use flash fill in Excel, there are some questions we need to address first. These questions are: What exactly is Flash fill? Why should we use it? And what can it do for you? What is Flash Fill? Let’s say there is a pattern evident in the cells. Flash fill...
Read More

5 Excel Charts Hack to Make Your Boss Smile | Excel Tips

Doesn’t it feel great to get that approval from your boss that everyone around you is striving for? Of course, it does. After reading this article, that dream is going to come true really soon. In today’s tutorial, we going to learn top5 Excel Chart Hacks to make your chart sexy.   Here are some...
Read More

Macro to convert Excel to PDF file

Looking to convert Excel to PDF File? Don’t worry we offer you the best practice to create PDF Files from Excel using VBA Macro. Which of these tasks is part of your daily work life? To Convert Excel to PDF Sending PDF attachments via email How to Convert Excel to PDF File Using VBA Micro...
Read More

Create a report in excel for sales data analysis using Pivot Table Techniques

Create a report in excel for sales data analysis is an important aspect of any business. Unless you are able to measure and analyze data, how can you improve your performance? It’s true that improving performance is a whole new story, but unless your data measurement isn’t accurate, you can never hope to reach the...
Read More

Add sizzle to your presentation with PowerPoint special effects

People ask me often – “Where did you learn all the PowerPoint special effects from?” I answer – “Investor Relations!” I frequently visit “Investor Relations” section of numerous companies. They contain Annual Reports, Quarterly Reports, and Investor Presentations, etc. I am always keen to go through their “Investor Presentations” reports. A few of them use...
Read More
1 2 3 4 5 13