Sorry, this entry is only available in Srpski.
Category: Microsoft® Excel
Microsoft® Excel is a spreadsheet computer program (so-called spreadsheet program) from Microsoft. It is one of the most common programs of its kind for personal needs as well as business use.
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
Vertical Lookup Function (VLOOKUP)
VLOOKUP function – a function that searches for a given table (vertically in columns) compares the values in a given
Appropriate priting
When you print Excel, either in PDF format or on paper, we often happens that the table is cut, that
Frozen formula
Sometimes we want to freeze the values in the formula or function. This is used when you want to copy