[Pluralsight] Calculating Cell Values with Formulas [2019, ENG]

Содержание

Course Overview 1m 47s Course Overview 1m 47s Implementing Operations and Performing Calculations with Functions and Formulas 29m 20s Module and Course Introduction 2m 22s Aggregate Functions - SUM and COUNT 5m 14s Aggregate Functions - MIN, MAX, and AGGREGATE 6m 17s Logical Operators and Functions 4m 38s Demo: Implementing Logical Operators and Functions in Excel 4m 28s Statistical Functions - AVERAGE, MEDIAN, MODE, and STDDEV 2m 12s Statistical Functions: SUMIF, COUNTIF, and AVERAGEIF 2m 41s Summary 1m 25sReferencing and Serializing Date and Time in Excel 13m 40s Module Introduction 1m 19s NOW and TODAY Functions 1m 38s Demo: Implementing the NOW and TODAY Functions in Excel 2m 33s Date and Time Storage in Excel 4m 20s DATE and TIME Functions 3m 48sCell References and Data Lookup in Excel 19m 52s Module Introduction 47s Cell References in Excel 6m 32s VLOOKUP Function 3m 16s Demo: Looking up Data with the VLOOKUP Function 2m 24s INDEX and MATCH Functions 3m 25s Demo: Combining the INDEX and MATCH Functions 3m 25sMonitoring, Validating, and Debugging Cells and Formulas in Excel 19m 36s Module Introduction 1m 8s Trace Precedents and Dependents 3m 55s Monitor Cells Using Watch Window 3m 5s Validating Formulas with Error Checking Rules 4m 53s Debugging Formulas Using Evaluate Formula 5m 5s Summary and Feedback 1m 26s

Скриншоты