Excel
-
How to use index and match together
The formula: =Index(C:C; Match(D2:D55&E2:E55;A:A&B:B;0) C:C is the range of cells you want to return D2:D55&E2:E55: are the matching fields from…
Read More » -
Data validation in Excel
What is data validation When filling an excel file you need to define some rules that you need to respect…
Read More » -
Different ways to calculate sum in Excel
I use different ways to calculate and this makes work with excel much easier. when it comes to calculating sum…
Read More » -
How to track values in Excel and in which formulas they are used
We can use trace dependent to track in which formulas a value is used. in this video will explain how…
Read More » -
How to remove duplicates in Excel file
Removing duplicates in an excel file is an easy process, you need to follow few steps. In your excel file…
Read More » -
How to compare two columns in Excel
Comparing two columns in Excel allows to see if there are some missing or different values between the two columns.…
Read More » -
How to convert a csv file in excel table using data tab
In this tutorial, I will explain how to convert in a few clicks a CSV file into an Excel table.…
Read More » -
How to lock a cell in excel formula
You may need some time to lock a cell in an excel formula, to do so select the part of…
Read More » -
Excel Pivot Table set up
Excel Pivot Table is one of the best tools in Excel. It allows to quickly summarise a table from a…
Read More » -
What does the exclamation mark in the excel cell refers to
Excel is a very smart application and is trying to help you. Excel does not distinguish between dates and numbers.…
Read More »