Basic IF Function 02 | AmazingExcel

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Intermediate Level Course

Week 1

Cell Reference Part 1 (4:26)
Cell Reference Part 2 (2:50)
Grouping several rows together using Group or Outline (5:32)
Using IF Function to Check Business Requirement (6:04)
Using IF Function - Checking a List of Value (8:34)
Using IF Function Part 3 - Calculate a different bonus based on business requirement (6:11)
Using Cell Reference - another example (2:14)
Basic IF Function 1 (5:10)
Basic IF Function 02 (3:03)
Basic IF Function 03 (4:52)
Basic Function IF 04 (1:55)
How to calculate School Exam Grade using Absolute Cell Reference and IF function (6:51)
Using AND Function - Basic Understanding (5:57)
The Smarter way to Error Checking using Equal Operator (4:10)
using IFError to avoid showing potential Excel error #DIV/0 (3:21)
Aging - Conditional Formatting (4:32)

Time Saving Shortcut

AX Excel Shortcut_List 2021

Week 2

VLookup TRUE Type (4:37)
VLOOKUP Function (5:26)
VLookup Function - Example 2 (4:57)
VLookup - Lookup from Other Workbook and Learn MATCH (4:57)
VLookup + Match - another example (4:57)
Creating a Drop Down List using Data Validation (4:31)
Drop down List - Referring Source from another sheet (7:36)
Dropdown List - Another Example (2:36)
How to Remove Data Validation and Named Range (3:37)
XLookup - available in Office 365 (7:10)
XLookup - Part 2 (6:17)
Understand OFFSET - Part 1 (6:24)
Understand OFFSET - part 2 more dynamic with Match (5:27)
Understand OFFSET - part 3 - Solution to my student SUM a range based on condiitions (5:57)
Dynamic Picking the right column using MATCH and INDEX (5:25)

Week 3

Searching Words using Wildcard Pattern (6:37)
Protecting Your Data - Protect Worksheet (6:42)
Protecting Your Data - Hiding Formula (6:03)
Basic of Hyperlink (4:21)
Hyperlink - A more practical example to track personal finance (8:58)
Create a Table of Content using HYPERLINK and INDEX (4:10)
How to check Invoice overdue using IF (1:55)
Excel Function - Subtotal (4:16)
Excel Function Subtotal 9 vs 109 (3:57)
Text Function - UPPER, LOWER (9:46)
Using Excel Table (4:05)
Excel Table - Using Reference Operator (6:44)
Date related Function - YearFrac, Weekday, Today and more (10:57)

Charting

Creating Mini Chart - Sparkline (2:03)
Create Icon Set (2:32)
Creating Treemap Chart (3:39)
Create Conditional Formatting Chart (4:22)

Teach online with

Basic IF Function 02

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock