Poslovni Excel

Conditional formatting tables

Conditional table formatting Conditional formatting highlights cells or a range of cells that meet certain conditions using data bars, color

The IF function in excel allows checking the fulfillment of a logical condition, and if it is true, it returns

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

VLOOKUP function – a function that searches for a given table (vertically in columns) compares the values in a given

When you print Excel, either in PDF format or on paper, we often happens that the table is cut, that