Poslovni Excel

SUCCESS Diagrams in Excel or ZEBRA BI

SUCCESS Diagrams are the fourth generation of graphical data display in the excel. Although simplicity and minimalism in the presentation

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

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