Главная
Study mode:
on
1
) Introduction
2
) Topics in video
3
) Worksheet Formula Elements: what can go into a formula
4
) Excel Formula Order of Operations
5
) Guidelines for building Excel Worksheet Formula Models
6
) Number Formatting as a Façade and how it can lead to misleading models if it is not understood
7
) The power of General Number Formatting as an eraser, including keyboard shortcut
8
) When you must use the ROUND function rather than Number Formatting
9
) Excel’s Golden Rule
10
) Building an Excel Worksheet Formula Model
11
) ISNA and FORMULATEXT functions to document model.
12
) Summary of Formula Types
13
) Example of Number, Text and Logical Formulas
14
) Example of Aggregate Formula and Single Input-Output Formula. Using AVERAGE, COUNT, COUNTA and ROWS functions.
15
) Examples of Dynamic Spilled Array Formulas (only available in Microsoft 365 Excel). Compare and contrast this new school way of making formulas with the old school way.
16
) Example of Relative and Absolute Cell References. This is the Old School way to make formulas
17
) Dynamic Spilled Array Formula. This new school method is MUCH easier than the older methods
18
) Three reasons Dynamic Spilled Array Formula are more efficient than the old methods
19
) Second example of Dynamic Spilled Array Formula, including Spilled Range Operator #
20
) Example of Scalar Array Formula
21
) How Excel Table Column Formulas are different than Single Input-Output Formulas and Dynamic Spilled Array Formulas.
22
) % of Total and % Change Formulas. Dynamic Spilled Array Formula and Old School Methods.
23
) Video Summary
24
) Conclusion and Video Links
Description:
Dive into a comprehensive 43-minute video tutorial on Excel statistical analysis, focusing on worksheet formulas, functions, and model building. Master the fundamentals of Excel formula elements, order of operations, and guidelines for constructing effective worksheet models. Explore number formatting techniques, including the use of the ROUND function, and understand Excel's Golden Rule. Learn to build and document Excel worksheet formula models using functions like ISNA and FORMULATEXT. Discover various formula types, including number, text, logical, aggregate, and single input-output formulas. Compare old school methods of relative and absolute cell references with new Dynamic Spilled Array Formulas available in Microsoft 365 Excel. Gain insights into Excel Table Column Formulas and their unique properties. Practice creating percentage of total and percentage change formulas using both traditional and modern techniques. Download the accompanying Excel file to follow along and reinforce your learning. Read more

Excel Statistical Analysis - Comprehensive Worksheet Formula & Model Building

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Mathematics #Statistics & Probability #Statistical Analysis
0:00 / 0:00
1 of 24

) Introduction