Tips for excel Archives - Calculation in essence of everything!

Variables in Excel

By introducing a variable name that replaces one to n cells of the table, Microsoft has made it possible, when

EXACT function The Excel EXACT function returns TRUE or FALSE as a result after comparing two strings. It has been

Advanced filter allows you to extract (display) only those data that meet some criteria. Filter and Advanced filter are basic

Excel function DATEDIF Calculates the number of days, months or years between two dates. Warning: The DATEDIF function may calculate

The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this

Excel precaution to protect your computer from potential viruses, all files are protected through the opening show. By using Protected

Not a few times in the table we have a numbers with which we can not do any mathematical operation

In cases where the content is not displayed in a cell, simply select the column, row or entire table and

When we have the contents of a set of data in a single table cell as the following figure: i We need