| 1 -Chapter 6 - Working with logical and information Functions Complete.xlsx | 415.5 KB | ||
| 1 -Chapter 6 - Working with logical and information Functions Teaching File.xlsx | 410.7 KB | ||
| 1 -Chapter 6 - Working with logical and information functions.pptx | 474.4 MB | ||
| 1 -Working with Logical and Information Functions.mp4 | 16.9 MB | ||
| 10 -Full IFS Function.mp4 | 31.1 MB | ||
| 11 -The AND Function.mp4 | 21.3 MB | ||
| 12 -Slotting Values into Categories.mp4 | 40.9 MB | ||
| 13 -The OR Function.mp4 | 16.3 MB | ||
| 14 -Applying Conditional Formatting with Formulas.mp4 | 41.5 MB | ||
| 15 -Applying a Condition Across a Range.mp4 | 43.6 MB | ||
| 16 -Operating Only on Cells that Meet a Condition.mp4 | 45.6 MB | ||
| 17 -Determining Whether a Value Appears in a List.mp4 | 26.6 MB | ||
| 18 -Counting Occurrences in a Range.mp4 | 26.1 MB | ||
| 19 -Determining Where a Value Appears in a List.mp4 | 38.4 MB | ||
| 2 -Adding Intelligence with Logical Functions.mp4 | 16.5 MB | ||
| 20 -Calculating a Smarter Due Date Example.mp4 | 50.9 MB | ||
| 21 -Aging Overdue Invoices Example.mp4 | 35 MB | ||
| 22 -Getting Data with Information Functions.mp4 | 9.9 MB | ||
| 23 -The CELL Function.mp4 | 26.3 MB | ||
| 24 -The ERROR. TYPE Function.mp4 | 7.9 MB | ||
| 25 -The INFO Function.mp4 | 15.7 MB | ||
| 26 -The SHEET and SHEETS Function.mp4 | 10.9 MB | ||
| 27 -The IS Function.mp4 | 30.6 MB | ||
| 28 -Counting the Number of Blanks in a Range.mp4 | 20 MB | ||
| 29 -Ignoring Errors When Working with a Range.mp4 | 13.6 MB | ||
| 3 -Introducing the IF Function.mp4 | 14 MB | ||
| 4 -Practicing the IF Function.mp4 | 26.6 MB | ||
| 5 -Handling a False Result with IF.mp4 | 14 MB | ||
| 6 -Full IF.mp4 | 31.1 MB | ||
| 7 -Avoiding Division by Zero.mp4 | 21.4 MB | ||
| 8 -Performing Multiple Logical Tests & Nested IFS.mp4 | 47.7 MB | ||
| 9 -Calculating Tiered Bonuses Example.mp4 | 27 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 34 total files | |||
Deep Dive into Logical and Informational Functions in Excel
https://WebToolTip.com
Published 8/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 1h 23m | Size: 1.21 GB
Build Smarter, Error-Proof Excel Formulas Using Logical & Information Functions
What you'll learn
Students will use IF and nested IF functions to create formulas that make decisions based on conditions.
They’ll combine AND, OR, and NOT functions to handle multiple logical tests.
Learners will avoid errors like division by zero using logical checks.
They’ll apply conditional formatting formulas to highlight data dynamically.
Students will count and locate values in ranges using logical tests.
They’ll calculate tiered bonuses and smart due dates with logical functions.
Learners will use information functions like CELL, ERROR.TYPE, and INFO to get worksheet details.
They’ll check data types and cell states using IS functions like ISBLANK and ISNUMBER.
Students will handle errors gracefully and ignore them when needed in ranges.
They’ll automate data validation and analysis with logical and information functions combined.
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 |
|---|---|---|---|---|---|
| 2.5 GB | freecoursewb | 5 months | 0 | 0 | |
| 4 GB | freecoursewb | 5 months | 24 | 10 | |
| 582.4 MB | freecoursewb | 7 months | 0 | 0 | |
|
Udemy - AWS Networking Deep-Dive Crash Course - Master VPC Essentials Posted by
freecoursewb in Other
|
1.8 GB | freecoursewb | 7 months | 4 | 2 |
| 1.7 GB | freecoursewb | 7 months | 5 | 1 |
All Comments