Skip to content

ilyar126

Excel Function – ACOT()

  • ilyar126 

Description To calculate the inverse of a Cotangent or Arctangent. The result is in radians number from 0 to pi (3.14) Syntax ACOT(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arctangent in Degrees References Similar function ACOS calculates Arccosine or inverse cosine.

Excel Function – ACOSH

  • ilyar126 

Description To calculate the hyperbolic arccosine of a hyperbolic cosine (number). The Hyperbolic Arccosine is an inverse of a hyperbolic cosine is a number greater or equal to 1. Syntax ACOSH(number) Examples The results are as follows: References How to calculate Arccosine.

Excel Function – ACOS()

  • ilyar126 

Description To calculate the arccosine of a cosine (number). The Arccosine is an inverse of a cosine ranging from 0 to pi (3.14). Syntax ACOS(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arccosine in Degrees References Want to see ACOS() in action? Check out how to measure Earth’s distances between any 2 points here.

Excel Function – ACCRINTM()

  • ilyar126 

Description To calculate the accrued interest for a stock/bond or other security that pays interest at maturity Syntax ACCRINTM(issue, settlement, rate, par, [basis]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 Settlement: maturity date rate: annual coupon rate par: par value of security; if blank then defaults at $1000 [basis]: 5 types of day counts; this… Read More »Excel Function – ACCRINTM()

Excel Function – ACCRINT()

  • ilyar126 

Description To calculate the accrued interest for a stock/bond or other security with periodic interest Syntax ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 First_interest: when first interest is due Settlement: when the stock was sold rate: annual coupon rate frequency: how often coupon pays per year [basis]:… Read More »Excel Function – ACCRINT()

Excel Function – AGGREGATE()

  • ilyar126 

Excel Aggregate Function – This is a very useful function that actually combines 19 subfunctions that can be activated by choice.

Excel Function – ABS()

  • ilyar126 

Description Provides absolute number of any positive or negative number. The results is always a positive number. An absolute number means simple a number without a negative sign, so its always positive. Syntax ABS(number) Examples

Excel CUBEVALUE vs SUMIFS & GETPIVOTDATA

Once CUBEVALUE formula came out about 10 years ago along with PowerPivot, I was delighted because it had filled the gap that was missing in SUMIFS and GETPIVOTDATA formulas for certain usage scenario.

Formatting Calculated Items of Calculated Groups in Tabular Editor

In the previous post I explained how to create Calculated Groups (Calculated Groups – comparisons and calculated columns in a pivot directed by slicers » Data Empower), here I will talk about how to create different formatting for the calculated items. For those of you created Calculated Groups in PowerBI using Tabular Editor (Tabular Editor), there are situations where some of the items need to have different formatting. For example… Read More »Formatting Calculated Items of Calculated Groups in Tabular Editor

Calculation Groups – variances in a pivot directed by Slicers

I want to show a situation how using Calculation Groups we can create a pivot or matrix in which using 2 different drop downs (slicers), a user would compare different versions of data in the pivot and their variances. For example, if in the slicer 1, you select Brand A and in slicer 2, you select Brand B, then in the pivot you will see Brands A and B side-by-side… Read More »Calculation Groups – variances in a pivot directed by Slicers