Главная
Study mode:
on
1
) Introduction
2
) List of Formula Elements
3
) Discuss Different Formula Types
4
) Examples of Modes of Formula Editing
5
) Examples of the five Calculation Formula Types
6
) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
7
) When you must use ROUND function
8
) Use General Number Format as eraser to remove Number Formatting
9
) Type #2: Dynamic Spilled Array Formulas
10
) Spilled Range Operator for Dynamic Spilled Array Formulas
11
) Type #3: Excel Table Formulas
12
) Summary about SIOF, DSAF and TF formulas.
13
) Type #5: Aggregate Formulas
14
) Type #4: Scalar Array Formulas
15
) Style Formatting for Models
16
) Compare Number Formats: Accounting, Currency and Number
17
) Build Model #1: Sales & Expenses Budget
18
) Build Model #2: Markup On Cost Pricing Formulas
19
) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project
20
) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS
21
) Look at Finance Cashflow Model to help pick investment
22
) Look at Analytics Simulation Model to product risk of new project
23
) Homework or practice problems
24
) Conclusion
25
) Closing and Video Links
Description:
Dive into an extensive 71-minute video tutorial on Excel worksheet formulas and models. Explore various formula types, including relative and absolute cell references, dynamic spilled array formulas, and Excel table formulas. Learn essential functions like ROUND, UNIQUE, SORT, and MAXIFS. Practice building practical models for sales budgets, markup pricing, project time calculations, and profit analysis. Gain insights into style formatting, number formats, and advanced financial and analytical models. Download accompanying Excel and PDF files for hands-on practice and reinforce your learning with provided homework problems.

Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Finance #Financial Modeling
0:00 / 0:00
1 of 25

) Introduction