Главная
Study mode:
on
1
) Introduction
2
) Excel’s Golden Rule
3
) Look at list of Formula Types and Formula Elements
4
) Number Formula Examples
5
) Text and Number Formulas for counting numbers above a hurdle
6
) When to combine Comparative Operator and Number in a cell or when to combine Comparative Operator and Number in the formula.
7
) DOLLAR function.
8
) How to combine Comparative Operator and Number in the formula.
9
) VLOOKUP function and Array Constant
10
) IF Function
11
) Logical Formula
12
) Aggregate Calculation / Aggregate Formula
13
) Array Calculation / Array Formula
14
) Excel Formula Order of Precedence (Excel’s Order of Operations)
15
) Tracking Down Errors in Excel: 4 Step Method.
16
) Types of Errors
17
) When to use ROUND function
18
) 3 ways to enter cell references into formulas
19
) Summary
20
) Homework
Description:
Dive into a comprehensive 55-minute video tutorial on Excel 2016 fundamentals, focusing on formulas with 15 practical examples. Learn Excel's Golden Rule, explore various formula types and elements, and master essential functions like VLOOKUP, IF, and DOLLAR. Understand the intricacies of number, text, logical, aggregate, and array formulas. Discover Excel's order of precedence, troubleshoot errors using a 4-step method, and explore when to use the ROUND function. Gain insights on different ways to enter cell references and conclude with a summary and homework assignment to reinforce your learning.

Excel Fundamentals - Comprehensive Formula Lesson

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel
0:00 / 0:00
1 of 20

) Introduction