Welcome! Enter below articles or choose one from the menu above

How to Use DAX (Data Analysis Expressions) Functions

DAX expressions (Data Analysis Expressions) is the formal language for writing formulas in Power Bi, Power Pivot and in Excel data models. This language is made up of functions, constants, and operators. You can use DAX to define custom calculations for Calculated Columns and for Measures (also known as calculated fields). It also allows you to calculate values, create relationships between tables, and more.

Read more ...

How to Find Duplicates in Excel

In this lesson, you will learn how to find duplicates in Excel. It's a quick way to find a large amount of data in just a second.

Read more ...

How to Calculate Beta of a Stock in Excel

Stock beta is a measurement of the risk of a particular stock relative to the risk of the entire stock market. Before choosing a particular stock for your portfolio, you can check the beta of that particular stock to decide how risky it is.

Though beta is not the only factor to consider before investing in a stock, you can make a wise decision by considering beta as well.

Read more ...

How to use Xmatch function in Excel

The XMATCH function in Microsoft Excel is used to search for a specified value in a range of cells and return its relative position. The XMATCH function is similar to the MATCH function, but it provides more flexibility in terms of the match type and handling of errors. To use the XMATCH function in Excel, follow these steps:

Read more ...

How to Make a Bar Chart

Every Excel tutorial needs to contain how to make a bar chart lesson. Bar charts are one of the simplest ways to represent a collection of data. Also, creating a bar chart is just a matter of a few clicks in Excel. This is an ultimate guide to cover up creating and formatting bar charts, types of bar charts and its limitations.

Read more ...