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

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

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

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

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

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

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

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

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

Excel Text to Columns or Split Cells in Excel is used in data cleaning and data re-arrangement. Excel text to columns formula technique is used for following: How to Apply Text to Column to Split Cells Split the text as last name and first name in two different columns. If a cell has got more than just a word...Read More

INTRODUCTION TO PIVOT TABLES When you have a large amount of data in your worksheet and you can’t analyze or sort the data then Pivot Table 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 is Pivot Table and...Read More

To do deduplication based on column or to eliminate the duplicate data from a data set, Power BI has a weapon called DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be united to create formulas and expressions in Power BI Desktop. We can deduplicate any data based on a column...Read More

To activate the special character, you need to use an Alt keyboard sequence: Num Lock key must be pressed, to activate the numeric key section of the keyboard (you can find on right top corner side). Press Alt key, and hold. While the Alt key is pressed, type the sequence of numbers (on the numeric keypad) from the Alt...Read More

The AVERAGEIFS Function of Excel computes the average of the figures in a range that meet one or more delivered conditions. The criteria of the AVERAGEIFS Function also supports the logical operators and wildcard operators in Excel. What Is The Averageifs Function In Excel? AVERAGEIFS Function averages cells in a range that is equivalent to...Read More

The AVERAGEIF Function of Excel calculates the average of the numbers in a range that meet the supplied conditions. The measures for AVERAGEIF Function supports logical operators and wildcards for partial matching. What is an AVERAGEIF Function in Excel? What is the formula for AVERAGEIF Function? What is the example of AVERAGEIF Function? How is...Read More

An Excel Function is a predefined formula that executes the actions like calculating values in a precise order. The common functions of Excel are AGGREGATE, AVERAGE, COUNT, INDEX, ROUND, SUM etc. In this blog, we are going to see all the Excel Functions one by one in depth. Also, you will learn the different parts of a function and how to...Read More

An Excel Function is a predefined formula that executes the actions like calculating values in a precise order. The common functions of Excel are AGGREGATE, AVERAGE, COUNT, INDEX, ROUND, SUM etc. In this blog, we are going to see all the Excel Functions one by one in depth. Also, you will learn the different parts of a function and how to...Read More

How to Delete Duplicate in Excel or find and remove duplicate? Find duplicates for one or more fields, such as a Name or City field, with the same data and want to limit the records to unique data for some fields. When you remove duplicate values, only the values in the range of cells or...Read More

Most of the times when you’ve worked on a Data set and you share your Spreadsheet with anyone you don’t want the Cells to change or shift. To avoid Modifications, MS Excel 2016 and its earlier versions lets you lock cells in MS Excel. You can lock Cells in Excel or Lock Specified Cells in...Read More