Saveti za napredni excel

How to create Pivot Table

Derived (Pivot) tables allow summarizing, counting, or aggregating data 1 from the initial/analytical table. We often hear or say “pivoting” or

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

The Excel HYPERLINK function returns a hyperlink from a given destination and “friendly name”. You can use HYPERLINK to construct

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

Sorry, this entry is only available in Srpski.

Sorry, this entry is only available in Srpski.

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