| 1 -Building Basic Formulas.mp4 | 23.4 MB | ||
| 1 -Creating Advance Formulas - Complete.xlsx | 460.6 KB | ||
| 1 -Creating Advance Formulas - Teaching file.xlsx | 437 KB | ||
| 1 -Creating Advanced Formulas.mp4 | 16.2 MB | ||
| 1 -Creating Advanced Formulas.pptx | 508.7 MB | ||
| 1 -Creating Basic Formulas - Complete.xlsx | 395.4 KB | ||
| 1 -Creating Basic Formulas Teaching File.xlsx | 394.1 KB | ||
| 1 -Creating Basic Formulas.pptx | 377.9 MB | ||
| 1 -Troubleshooting Formulas - Complete.xlsx | 447.8 KB | ||
| 1 -Troubleshooting Formulas - Teaching file.xlsx | 447.3 KB | ||
| 1 -Troubleshooting Formulas.mp4 | 18.1 MB | ||
| 1 -Troubleshooting Formulas.pptx | 224.1 MB | ||
| 1 -Understanding Formulas.mp4 | 12.2 MB | ||
| 1 -Understanding Functions - Complete.xlsx | 369 KB | ||
| 1 -Understanding Functions - teaching file.xlsx | 368.8 KB | ||
| 1 -Understanding functions.pptx | 55.4 MB | ||
| 10 -Controlling Worksheet Calculation.mp4 | 26.8 MB | ||
| 10 -Using Dialog Box Controls on a Worksheet.mp4 | 17.9 MB | ||
| 10 -Watching Cell Values.mp4 | 9 MB | ||
| 11 -Reference Types in Formulas.mp4 | 31.6 MB | ||
| 11 -Using the Form Controls.mp4 | 18.3 MB | ||
| 12 -Copying and Moving Formulas.mp4 | 12.1 MB | ||
| 12 -Group Boxes & Option Buttons.mp4 | 25.4 MB | ||
| 13 -Check Boxes.mp4 | 16.6 MB | ||
| 13 -Displaying Worksheet Formulas.mp4 | 19.6 MB | ||
| 14 -Converting Formula to a Value.mp4 | 20.6 MB | ||
| 14 -List Boxes & Combo Boxes.mp4 | 13.9 MB | ||
| 15 -Scroll Bars & Spin Boxes.mp4 | 16.7 MB | ||
| 15 -Working with Range Names in Formulas.mp4 | 13.8 MB | ||
| 16 -Using a Range Name Into a Formula.mp4 | 18.8 MB | ||
| 17 -Applying Range Names to Existing Formulas.mp4 | 68.3 MB | ||
| 18 -Working with Links in Formulas.mp4 | 38.8 MB | ||
| 2 -About Excel's Functions.mp4 | 64.3 MB | ||
| 2 -Understanding Excel's Error Values.mp4 | 80.6 MB | ||
| 2 -Understanding Formula Basics.mp4 | 16.2 MB | ||
| 2 -Working with Arrays.mp4 | 42.8 MB | ||
| 3 -Array Formulas that Operate on Multiple Ranges.mp4 | 20.9 MB | ||
| 3 -Fixing Other Formula Errors.mp4 | 35.9 MB | ||
| 3 -Input Modes.mp4 | 22.1 MB | ||
| 3 -The Structure of A Function.mp4 | 26.8 MB | ||
| 4 -Arithmetic Functions.mp4 | 20.6 MB | ||
| 4 -Handling Formula Errors with IFERROR.mp4 | 13.3 MB | ||
| 4 -Typing a Function into a Formula.mp4 | 38.5 MB | ||
| 4 -Using Array Constants.mp4 | 35.2 MB | ||
| 5 -Functions that Use Arrays.mp4 | 34.8 MB | ||
| 5 -Using Comparison Formulas.mp4 | 23 MB | ||
| 5 -Using The Formula Error Checker.mp4 | 22.1 MB | ||
| 5 -Using the Insert Function Feature.mp4 | 14.1 MB | ||
| 6 -Auditing Worksheet.mp4 | 20.8 MB | ||
| 6 -Text Formulas Introduction.mp4 | 11.4 MB | ||
| 6 -Using Iteration and Circular References.mp4 | 23.6 MB | ||
| 7 -Array References in Formulas.mp4 | 24.1 MB | ||
| 7 -Consolidating Data by Position.mp4 | 53.4 MB | ||
| 7 -Tracing Cell Errors.mp4 | 8.1 MB | ||
| 8 -Consolidating Multi-Sheet Data by Category.mp4 | 23.9 MB | ||
| 8 -Removing Tracer Errors.mp4 | 8.2 MB | ||
| 8 -Understanding Operator Precedence.mp4 | 24.4 MB | ||
| 9 -All Important ().mp4 | 21.8 MB | ||
| 9 -Applying Data Validation Rules to Cells.mp4 | 24.1 MB | ||
| 9 -Evaluating Formulas.mp4 | 10.7 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 62 total files | |||
Introduction to Formulas and Functions in Excel by CreateMyExcel with Ben Scholl
https://WebToolTip.com
Published 8/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 2h 13m | Size: 2.31 GB
Learn Formula & Function Basics!
What you'll learn
Learn to build basic formulas using arithmetic, comparison, and text operators.
Understand Excel’s order of operations and how to control it with parentheses.
Practice using relative, absolute, and mixed references in cell formulas.
Discover how to name ranges and apply them in formulas for clarity and reuse.
Use advanced formulas with arrays, constants, and dynamic functions.
Apply data validation and worksheet controls for more interactive sheets.
Identify and fix common formula errors like #DIV/0! or #NAME?.
Use IFERROR and auditing tools to manage and trace formula issues.
Explore how Excel functions are structured and how to insert them properly.
Activate the Analysis ToolPak to unlock additional statistical functions.
Requirements
Microsoft Excel (Office 2021 or Microsoft 365) installed.
Basic knowledge of Excel (e.g., entering data, simple calculations).
Access to a computer with a stable internet connection.
No prior advanced Excel skills required; suitable for beginners.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.1 GB | freecoursewb | 2 days | 25 | 24 | |
| 1.2 GB | freecoursewb | 4 days | 15 | 12 | |
| 3.8 GB | freecoursewb | 2 weeks | 4 | 5 | |
| 1.6 GB | freecoursewb | 2 weeks | 5 | 3 | |
| 1.6 GB | freecoursewb | 2 weeks | 9 | 4 |
All Comments