Sorry, this entry is only available in Srpski.
Category: Advanced Excel
Advanced Excel is intended for users who have mastered basic and intermediate levels of knowledge. Making calculations in a pivot table column is one of them.
(Srpski) Kako sprovesti procenu rizika u Excelu
Sorry, this entry is only available in Srpski.
What is the difference between SORT and SORTBY function in Excel
As of version 2021, new SORT and SORTBY functions have been added in Excel that sort the data in the
How to create new function in Excel with LAMBDA
Creating a function in Excel using the LAMBDA function, allows the user to create their own function without knowledge of
Price leveling in Excel
Price leveling is a procedure by which the price of a stock of goods in a wholesale (warehouse) or retail
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
How to Create an Inventory List in Excel
An inventory is a bookkeeping document that provides a complete, detailed list of every product your company has in stock. This
FILTER function filters a range of data based on supplied criteria
Excel: 2021, 365, for Mac and web Excel appeared in 1987, and only after 34 years create the formula FILTER ?????
SORT sorts the contents of a range or array
Excel: 2021, 365, for Mac and web Excel appeared in 1987, and only after 34 years create the formula SORT ?????
UNIQUE – Returns a list of unique values
Excel Version: 2021, 365 I am increasingly wondering how some formulas did not exist in Excel before. This is also