There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
Why this course?
| Introduction | |||
| Self-Paced Learning with Exercises (2:00) | |||
| Download Exercises | |||
| Submit Assignments | |||
| Module 1.1 : Conditional Statements | |||
| 10 Advanced IF formulas every analyst should know (22:00) | |||
| Properly Use Excel IFS Function (11:00) | |||
| Module 1.2 : Name Manager | |||
| Excel Relative Named Ranges - A Secret of Excel Pro Users (12:00) | |||
| Top Tips for Using Named Ranges in Excel (14:00) | |||
| Create SMART Drop Down Lists in Excel (with Data Validation) (16:00) | |||
| Module 1.3 : Fixing Ranges | |||
| How to Freeze Multiple Rows and or Columns in Excel using Freeze Panes (2:00) | |||
| 3 Nifty example of Fixing Formulas in Excel (9:00) | |||
| How to stop excel from changing a range | Fixing a Range basics (3:00) | |||
| Module 1.4 : Lookup and Reference (level 1) | |||
| #1 : Basics of VLOOKUP | |||
| #2 : Vlookup for multiple rows (3:00) | |||
| #3 : Using VLOOKUP to get multiple values (ordered) (4:00) | |||
| #4 : Using VLOOKUP to get multiple values(unordered) (3:00) | |||
| #5 : VLOOKUP with dynamic table using Name Manager (3:00) | |||
| #6 : VLOOKUP when range_lookup is True (2:00) | |||
| Exercise 1: VLOOKUP Marathon | |||
| Exercise 2: Choosing Type of Celebrity | |||
| Exercise 3: Bi-Monthly Summary | |||
| Exercise 4: Wise Owl Training Course | |||
| Module 1.5 : New XLOOKUP | |||
| XLOOKUP for Excel: Explained in 3 Minutes (4:00) | |||
| How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples) (14:00) | |||
| Module 2.1: Summary Functions | |||
| Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria) (14:00) | |||
| How to SUMIFS With Multiple Criteria In the SAME Column in Excel (4:00) | |||
| 15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included (17:00) | |||
| Module 2.2: Sum Product | |||
| Master Excel's SUMPRODUCT Formula (15:00) | |||
| Module 4.1: Handling Dates | |||
| #1: Introduction to how Excel stores dates | serial_number (4:00) | |||
| #2 Today Function, Getting the number of days between 2 dates (2:00) | |||
| #3: Day, Month, Year Function | |||
| #4: How to use Date Function ? (3:00) | |||
| #5: How to use EOMONTH and EDATE (2:00) | |||
| #6: How to use NETWORKDAYS and WORKDAY function (3:00) | |||
| #7: How to use WEEKDAY and WEEKNUM functions ? (2:00) | |||
| #8 : Correcting the dates when the month and day are swapped (5:00) | |||
| #9: How to use NETWORKDAYS with date picker ? (2:00) | |||
| Module 5.1: Handling Text | |||
| 18 Text Functions in Excel You Need to Know (25:00) | |||
| Breaking News! We FINALLY get the Excel functions we've been Wanting! (11:00) | |||
| New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips) (7:00) | |||
| Module 6.1: Data Handling - Remove Duplicates | |||
| #1 - How to remove duplicates in excel (3:00) | |||
| #2 - Removing duplicates using two column (5:00) | |||
| #3 - Removing duplicates using three column (4:00) | |||
| #4.1 - Extracting Min and Max values (4:00) | |||
| #4.2 - Extracting Min and Max values using 2 columns (3:00) | |||
| #5 - Finding whole row duplicates (5:00) | |||
| #6 - Finding whole row duplicate (without one column) (2:00) | |||
| #7 - How to the expand option while using Removing duplicates (3:00) | |||
| #8 - Working with dates using 2 columns (5:00) | |||
| #9 - Finding Max and Min of sales in Month/Year (3:00) | |||
| Module 6.2: Extract Number from Text | |||
| Separate Text and Numbers in Excel (4 Easy Ways) (16:00) | |||
| Extract Numbers from a String in Excel | Using Formula and VBA (14:00) | |||
After successful purchase, this item would be added to your courses.You can access your courses in the following ways :
