IF Function | Presentation Process

Autoplay
Autocomplete

Previous Section Complete and continue

Complete Excel Foundation Course

Excel Basics

Welcome and Important Information
All about getting Started with Excel (12:12)
All About Working With Worksheets (8:43)
All About Copy and Paste Functions (11:12)
All About Free Excel Templates (5:16)
[Excel Trick] Set Up Quick Access Toolbar (7:23)
[Excel Trick] Create Your Own Tab (7:19)
Quiz to Review Excel Basics
Important Update for Customers Only

Formatting Cells

Text Formatting Options In Excel (14:19)
How to Wrap Text in Cell (6:03)
Number Formatting Tools (13:57)
[Excel Trick] Convert Numbers To Percentages (3:56)
Quiz on Formatting Cells

Control Worksheet View

How to Freeze Split Or Hide Rows & Columns (9:28)
View 2 Excel Worksheets From the Same File (4:47)
Arrange or View 2 Files Side by Side (5:18)
[Excel Trick] Custom View in Excel (4:29)
How to Hyperlink To Another Sheet (7:48)
[Excel Trick] Create Table of Contents Fast (5:00)
Quiz on Control Worksheet View

Working with Cells and Ranges

Understanding Cell Reference In Excel (12:55)
How to Use Autofill in Excel (14:29)
4 Things To Know About Flash Fill (12:42)
Creating and Working with Named Ranges (12:51)
How to Insert Cell Comments And Notes (7:01)
Adding Excel Tooltip for Cells (3:57)
Excel Speak Cells Feature (5:28)
[Excel Trick] How to Remove Numbers from Text Strings (4:39)
Quiz on Cells and Ranges

Working with Data Tools

Basics of Data Sorting (12:18)
Data Sorting with Custom Lists (4:58)
Filters in Excel 2016 (Basic & Advanced) (9:30)
How to Filter Blank Cells in Excel (6:03)
How to do Advanced Filter (10:58)
How To Delete Duplicates (6:04)
How to Extract Unique Values From A Column (2:30)
[Excel Trick] Converting Text To Columns (7:59)
[Excel Trick] Add Subtotals to Cells (5:22)
[Excel Trick] Insert Blank Rows After Each Customer Automatically (4:08)
How to Convert Text to Numbers (7:02)
3 Quick Tips to Save Time ( Filter | Find & Replace | Paste) (4:58)
Quiz on Data Tools

Mastering Tables

All About Using Tables (12:01)
6 Hidden Capabilities of Tables (13:25)
Quiz on Tables

[FORMULAS] Formulas for Logical Tests

What is a Logical Test in Excel (6:23)
IF Function (8:48)
[Advanced] Nested IF Function (8:31)
AND Function (5:43)
OR Function (4:31)
[Advanced] Using IF, AND, OR Functions Together (5:10)
Using NOT Function (3:37)

[FORMULAS] Formulas for Text and Dates

[Text Function] 14 Different Text Functions (17:56)
[Text Function] EXACT Function (3:58)
[Date Function] Different Date Functions in Excel (18:12)
[Date Function] Calculate Exact Age in Excel (7:16)
[Date Function] Calculate Workdays (9:10)

[FORMULAS] Count and Sum Functions

5 Different COUNT Related Functions (8:52)
COUNTIFS Functions (11:51)
How to ADD with Conditions using SUMIFS (10:53)
Useful SUMPRODUCT Function (2:22)

[FORMULAS] Functions to Lookup Values

VLOOKUP with Exact Match (13:41)
Vlookup with Approximate Match (4:52)
VLOOKUP function Best Practices and Issues (11:51)
HLOOKUP for Horizontal Lookup (3:14)
LOOKUP Function (Backward Compatible function) (9:07)
MATCH Function (8:27)
Combining Vlookup And Match Functions (8:56)
INDEX Function (7:56)
Combining Index And Match Functions (10:35)
INDIRECT Function (6:13)
INDIRECT And VLOOKUP Functions (6:12)
[Microsoft 365] Super Useful Xlookup Function (16:02)
[Microsoft 365] New Xmatch Function (8:30)

[FORMULAS] *Special* CHOOSE Function for Lookup

How to use CHOOSE Function (8:06)
[Advanced] How to Dynamic Chart With Choose Function (4:35)
CHOOSE function as Better Alternative to Nested IF function (11:09)
[Microsoft 365] IFS instead of Nested IFs OR Choose Function (7:19)

[FORMULAS] Functions to Audit Errors

Trap errors with IFERROR Function (3:57)
How to Show Formulas & Troubleshoot Errors (10:40)

[FORMULAS] Ranking & Randomization

All About Generating Random Numbers (RAND & RANDBETWEEN) (7:08)
Generate Random Dates (3:31)
How to Randomize a List (2:03)
How to Reverse a List (1:42)
How to Rank Values from Lowest to Highest (7:24)

Data Validation Tools

How to Restrict Data Entered with Data Validation Tool (12:22)
2 Create Drop Down List with Color (6:21)
How To Set Up Custom Data Validation (14:06)
Avoid Duplicate Entries using Data Validation (4:31)
Create Dynamic List with Tables in Data Validation (9:57)
[Advanced] Create Dependent Dropdown list (10:26)
[Advanced] How to Circle Invalid Data (4:24)
Quiz on Data Validation Tools

[PIVOT TABLES] Basics to Advanced

Pivot Table Design Tricks (5:32)
Basics of Pivot Tables (15:09)
How to Group by Dates (for Reports) (6:59)
How to Group by Numbers (for Reports) (5:45)
Create a Calculated Field in Pivot Table (3:48)
Auto-generate Report Filter Pages (7:07)
[Tips] 9 Useful Excel Pivot Table Tips (15:18)
[Advanced] Generate Smarter Serial Numbers (4:23)
[Advanced] Slicers to Filter Tables Conveniently (13:04)
[Advanced] PivotTable Timeline to Filter Dates (4:02)
How to create Interactive Pivot Charts in Excel (9:33)
Quiz on Pivot Tables

Conditional Formatting

Basics of Conditional Formatting (9:53)
Conditional Formatting : With Formulas (8:20)
[Advanced] How to Highlight Rows or Columns (6:59)
Conditional Formatting : Data Bars (10:21)
Conditional Formatting with Icon Sets (10:43)
[Advanced] Create Interactive Highlight (7:13)
How to Highlight Alternate Rows (6:13)
Quiz on Conditional Formatting

[CHARTS] Data Charts & InCell Charts in Excel

All About Excel Chart Basics (12:41)
How to copy Chart Formatting in Excel (2:15)
Working with Line Charts in Excel (10:25)
Working with Column Charts (8:55)
7 Tips for Pie Charts (9:16)
[Incell Charts] Create Sparklines (8:43)
[InCell Charts] Bar Charts with Formula (4:44)
[InCell Charts] Surplus Deficit Charts (2:56)
Quiz on Charts

Data Consolidation Tools

How to Consolidate Data from Multiple Sheets (5:45)
Consolidate Data from Multiple Worksheets with Pivot Table (8:03)

How to Protect Your Content

Protect Sheet and Workbook from Viewing (3:55)
Protect Some Cells in Excel (7:05)
Add or Remove Passwords in Excel (5:36)

How to Print Excel Files like a PRO

Repeat Row Column Titles On Every Printed Page (4:24)
How To Set Print Area In Excel Like A Pro (3:47)
How To Print Gridlines In Excel (1:59)
How To Insert Header And Footer In Excel (11:42)
How To Center Print Area (5:57)
How To Insert Page Breaks in Worksheet (5:43)
How To Fit An Excel Sheet On One Page (7:29)

BONUS: Excel Tricks & Shortcuts

Excel keyboard shortcuts for Mac
Excel keyboard shortcuts for Windows

Teach online with

IF Function

Section content locked

If you're already signed up, you'll need to login.

Sign Up for Product to Unlock