This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Understand OFFSET - part 2 more dynamic with Match
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock