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 ...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 ...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 ...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 ...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 ...- Backwards Vlookup
- Case Sensitive VLOOKUP
- How to automatically load the values into the drop-down list using VLOOKUP?
- How to do VLOOKUP with two criteria?
- How to find common part of two columns using vlookup?
- How to use a vlookup formula to check if a value exists?
- Vlookup across multiple files
- Vlookup for a range
- VLOOKUP Function: Knowing it & 10 Examples of its Usage
- Vlookup on multiple sheets
- VLOOKUP text inside a string
- Vlookup That Returns True or False

- How to calculate the variance in Excel?
- How to open .VCF files?
- How to remove green triangles?
- How to calculate logarithms and inverse logarithms in Excel?
- How to calculate CAGR?
- 3 axis Chart
- How to use the integral function?
- How to calculate ROI?
- COUNTIF
- Toggle button
- BCG Matrix
- How to apply formula to entire column?
- How to Calculate z-score?

- How To Use SQL in Excel
- How to run a SQL query in Excel VBA
- How to convert Excel to database
- Dynamic Chart
- Multiple Overlay Charts
- How To Use Slicers
- How To Use Lambda Function
- How to Use DAX Functions?
- How to create own add-in?
- How to create a folder and sub folder in Excel VBA?
- How to use trig functions?
- How to zoom in graph?
- Interactive Charts