[Pluralsight] Excel Statistics and Finance Function Playbook [2019, ENG]

Содержание

Course Overview 1m 27s Course Overview 1m 27sUsing the SUMIFS Function 18m 37s Using the SUMIFS Function 2m 43s SUM, SUMIF, SUMIFS Comparison Examples 2m 57s SUMIFS Multiple Criteria Examples 3m 12s SUMFIS Cell Reference Examples 4m 14s SUMIFS Empty and Non-empty Cell Examples 1m 19s SUMIFS Wildcard Examples 4m 10sUsing the AVERAGEIFS Function 18m 1s Using the AVERAGEIFS Function 3m 25s AVERAGE, AVERAGEIF, AVERAGEIFS Comparison Examples 2m 6s AVERAGEIFS Multiple Criteria Examples 3m 52s AVERAGEFIS Cell Reference Examples 3m 0s AVERAGEIFS Empty and Non-empty Cell Examples 1m 14s AVERAGEIFS Wildcard Examples 4m 22sUsing the COUNTIFS Function 18m 34s Using the COUNTIFS Function 3m 34s COUNT, COUNTIF, COUNTIFS Comparison Examples 1m 28s COUNTIFS Multiple Criteria Examples 3m 16s COUNTIFS Cell Reference Examples 2m 57s COUNTIFS Empty and Non-empty Cell Examples 1m 11s COUNTIFS Wildcard Examples 6m 6sUsing the NPV Function 12m 10s Using the NPV Function 3m 42s NPV Investment Examples 3m 4s NPV Different Time Period Examples 2m 53s NPV Capital Budgeting Examples 2m 29sUsing the FV Function 8m 45s Using the FV Function 4m 9s FV Lump Sum and Payment Examples 2m 9s FV Time Period, Rate, and Type Examples 2m 25sUsing the PV Function 8m 46s Using the PV Function 3m 12s PV Annuity Examples 1m 56s PV Savings Goal Examples 1m 53s PV Loan Amount Examples 1m 42s

Скриншоты