Excel Intermediate Level Course
If time is valuable to you, then let us lead you from basic Excel User to next level, start to analyze data faster
Your Instructor
Course Curriculum
Week 1
Available in
days
days
after you enroll
-
StartCell Reference Part 1 (4:26)
-
StartCell Reference Part 2 (2:50)
-
StartGrouping several rows together using Group or Outline (5:32)
-
StartUsing IF Function to Check Business Requirement (6:04)
-
StartUsing IF Function - Checking a List of Value (8:34)
-
StartUsing IF Function Part 3 - Calculate a different bonus based on business requirement (6:11)
-
StartUsing Cell Reference - another example (2:14)
-
PreviewBasic IF Function 1 (5:10)
-
StartBasic IF Function 02 (3:03)
-
StartBasic IF Function 03 (4:52)
-
StartBasic Function IF 04 (1:55)
-
StartHow to calculate School Exam Grade using Absolute Cell Reference and IF function (6:51)
-
StartUsing AND Function - Basic Understanding (5:57)
-
StartThe Smarter way to Error Checking using Equal Operator (4:10)
-
Startusing IFError to avoid showing potential Excel error #DIV/0 (3:21)
-
PreviewAging - Conditional Formatting (4:32)
Time Saving Shortcut
Available in
days
days
after you enroll
Week 2
Available in
days
days
after you enroll
-
PreviewVLookup TRUE Type (4:37)
-
StartVLOOKUP Function (5:26)
-
StartVLookup Function - Example 2 (4:57)
-
StartVLookup - Lookup from Other Workbook and Learn MATCH (4:57)
-
StartVLookup + Match - another example (4:57)
-
StartCreating a Drop Down List using Data Validation (4:31)
-
StartDrop down List - Referring Source from another sheet (7:36)
-
StartDropdown List - Another Example (2:36)
-
StartHow to Remove Data Validation and Named Range (3:37)
-
PreviewXLookup - available in Office 365 (7:10)
-
StartXLookup - Part 2 (6:17)
-
PreviewUnderstand OFFSET - Part 1 (6:24)
-
StartUnderstand OFFSET - part 2 more dynamic with Match (5:27)
-
PreviewUnderstand OFFSET - part 3 - Solution to my student SUM a range based on condiitions (5:57)
-
StartDynamic Picking the right column using MATCH and INDEX (5:25)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
This is a monthly subscription program. You can unsubscribe anytime you want. After enrolling, you will immediately have access to this course for as long as you like - across any and all devices you own. Start learning today, success determine not by other, but in your own hand. Thank you for becoming our student today.