Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. Oz provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge.
Released 3/2023
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
1.1 KB
.pad/1
126.1 KB
.pad/10
167.3 KB
.pad/11
456.8 KB
.pad/12
240.5 KB
.pad/13
82 KB
.pad/14
123.7 KB
.pad/15
261.3 KB
.pad/16
97.7 KB
.pad/17
168.3 KB
.pad/18
191.9 KB
.pad/2
371.5 KB
.pad/3
414.6 KB
.pad/4
149 KB
.pad/5
317 KB
.pad/6
261 KB
.pad/7
415.3 KB
.pad/8
92.3 KB
.pad/9
36.8 KB
TutsNode.net.txt
63 B
[TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/01 - Learning advanced formulas and functions using Excel.srt
1.1 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.mp4
46.1 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.srt
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.mp4
28.7 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.srt
10.2 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/02 - Tables and absolute cell references.srt
6.6 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/03 - Dynamic arrays introduction.srt
7.1 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.srt
5.6 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.mp4
34.1 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.srt
16.4 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.mp4
20.4 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.srt
7.1 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.mp4
25.1 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.srt
10.3 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.mp4
31.4 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.srt
11.3 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/03 - VLOOKUP and XLOOKUP comparison.srt
3 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.srt
5.9 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/05 - The INDEXMATCH vs. VLOOKUP controversy.mp4
24.4 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/05 - The INDEXMATCH vs. VLOOKUP controversy.srt
1.5 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/06 - Two-way lookups.srt
8.7 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/07 - Approximate and tiered matches.mp4
22.3 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/07 - Approximate and tiered matches.srt
10.2 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.srt
9.6 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.srt
5.7 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.srt
5.8 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.mp4
23.3 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.srt
8.6 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.srt
8.3 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.mp4
36.1 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.srt
2.2 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.mp4
20.2 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.srt
9.9 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/07 - Writing 3D formulas.srt
4.7 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.srt
6.6 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.mp4
30.7 MB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.srt
14.1 KB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/10 - Error handling IFNA and IFERROR.srt