By introducing a variable name that replaces one to n cells of the table, Microsoft has made it possible, when
Category: Tips for excel
(Srpski) Excel funkcija EXACT
EXACT function The Excel EXACT function returns TRUE or FALSE as a result after comparing two strings. It has been
Advanced Filter
Advanced filter allows you to extract (display) only those data that meet some criteria. Filter and Advanced filter are basic
Excel function DATEDIF
Excel function DATEDIF Calculates the number of days, months or years between two dates. Warning: The DATEDIF function may calculate
Numbers in thousand (k) or in million (M)
The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is
Copy Visible Cells Only
By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this
Protected View in Excel
Excel precaution to protect your computer from potential viruses, all files are protected through the opening show. By using Protected
Figure as Number
Not a few times in the table we have a numbers with which we can not do any mathematical operation
AutoFit Column Width
In cases where the content is not displayed in a cell, simply select the column, row or entire table and
Shifting text to columns
When we have the contents of a set of data in a single table cell as the following figure: i We need
