Derived (Pivot) tables allow summarizing, counting, or aggregating data 1 from the initial/analytical table. We often hear or say “pivoting” or
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.
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
THE REAL POWER OF POWER PIVOT TABLES
Power pivot (advanced derived) table includes the process of creating a report table very similar to the Pivot table , whose main
How to create Excel spreadsheets
We create Excel tables in two ways, by creating a visual table by enclosing a part of the workspace (sheet)
DAX formulas in Power Pivot and Power BI
DAX (Data Analysis Expressions) is a language used to create expressions (formulas) to create reporting dimensions used in PowerPivot tables. The same terms can
Shortcuts from the keyboard
Excel keyboard shortcuts are often used to speed up spreadsheets. Shortcuts allow us to perform an action in Excel instead of
The difference between formula and function in Excel
How to use the COUNTIF function in Excel Kada je koju dobro koristiti može te pročitati na sajtu kalkulacija.com i
Excel XMATCH formula
Excel: 2021, 365, for Mac and web Excel appeared in 1987, and only after 34 years create the formula XMATCH. Function/Formula
XLOOKUP – replacement for VLOOKUP
Excel Version: 2021, 365 The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP,
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 ?????