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

Category

Tutorials

Read How to Remove Rows With Errors Using Power Query

Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps. Remove Rows With Errors By Power Query Let’s take an example. As shown in below picture there is some revenue that has invalid values....
Read More

Learn How to Split Queries In Power Query

As explained in the above example, we have generated a conditional column for the given query. If we want to split this query into two, Power Query will help us in doing so. How to Split Queries In Power Query The user will be able to mark a set of consequent steps, starting at the...
Read More

Learn How to Create Index Column Using Power Query

There is one more interesting feature of Power Query where it lets you add an index column that serves as a row counter to your data. Power Query Helps To Create Index Column Let’s go through the steps in detail with an example. Our sample data consists of Months and revenue data as shown in the...
Read More

Read How to Remove Duplicates Using Power Query

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually. Remove Duplicates by Power Query Suppose you have this set of data. As you can see the marked ones are...
Read More

Acquire Knowledge to Fill Down Values Using Power Query

Power Query helps you to perform a series of steps to transform your data. Among which there is a step that allows you to fill data down easily. This feature is specially used to fill the missing data where predictions are available for the missing data. Power Query Helps To Fill Down Values Let’s suppose...
Read More

Steps to Remove Columns Using Power Query

Another feature of Power Query is Remove Columns. This feature allows you to remove the unwanted columns easily. Learn Steps to Remove Columns By Power Query This is helpful when you have columns that you want to eradicate and do not need in your final report – but do want to keep in your source...
Read More

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

How to do Duplicate Columns in Power Query

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. Duplicate Columns Using The Power Query Editor Suppose you...
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 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 eg....
Read More

Keep Duplicate Records in Power Query

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...
Read More

How to use Excel? Excel basics for beginners

In this blog, we will learn Excel basics guide for beginners, Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Office is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming...
Read More

Connect to Data in Power Query

Power Query is the Microsoft Data Connectivity and Data Preparation technology that allows the users to flawlessly access data stored in hundreds of data sources and reshape it to fit their needs. What is Power Query Editor in Power BI? Power Query can replace, merge, clean and transform all the messy data and display it in...
Read More

How to use Text to Column in Excel with 4 Difference Example

Do you know what Text to Columns is feeling right now? It is feeling sad and unappreciated. It is because it gets less credit than it actually deserves. Text to Columns in Excel is one of the most wonderful features in Excel. Here in this tutorial, you’ll learn about the various things you can do...
Read More

Things you should learn in Excel Course

The essential skills that a competent business Excel user should be aware of are Formatting & basic formulas, Excel shortcuts, VLOOKUPS & conditional statements, Data analysis like filtering, sorting, and analyzing data, Data visualization like tables, charts, and dual axis charts, What-if-analysis and Pivot tables. The complete Excel course is bifurcated into three major parts viz. Beginner Excel Course,...
Read More

How to use Clean Function in Excel

The CLEAN Function in Excel takes a text string and returns a text that has been “cleaned” of line breaks and other non-printable characters. What is a CLEAN Function? What is the syntax for CLEAN Function? How to use CLEAN Function? And finally, What are the applications of CLEAN Function? ➡ What is Clean Function in...
Read More

How to use the Excel Choose Function

The CHOOSE Function in Excel returns a value from a list using a given position or index. The values provided to CHOOSE can include references. Let’s have a look below to get more details about CHOOSE Function. ➡ What is Excel Choose Function? CHOOSE Function is a function in Excel that helps you to get...
Read More

How to use the Excel Code Function

The CODE Function in Excel returns a numeric code for a given character. The CODE Function can be used to understand numeric codes given to the CHAR Function as it is the reverse process of CHAR Function. ➡ What is Code Function in Excel? The Function that accepts one argument, for the text for which you...
Read More

How to use the Excel Column Function

The COLUMN function in Excel returns the column number for a reference. In other words, Column Function too will return the column number of the cell which contains formula when reference is not provided. ➡ What is Column Function in Excel? The function which will returns column number for a reference is called Excel COLUMN Function....
Read More

How to use Ceiling Function in Excel

The CEILING Function in Excel returns a given number rounded up to a specified multiple. CEILING Function is always used for rounding up. Its purpose is to Round a number up to nearest multiple. It returns a rounded number. What is a CEILING Function in Excel? What is the syntax for CEILING Function? Where can...
Read More

How to use Char Function in Excel

The CHAR Function in Excel returns a character when given a valid Character Code. CHAR Function is used to specify the characters that are difficult to enter in a formula in Excel. Now, let us study in detail the CHAR Function as given below. What is a CHAR Function in Excel? What is the formula...
Read More
1 2 3 4 5 12
Need Help? Chat with us