17 views
Leave a like???? to help the channel! ???? LEARN EXCEL IN A PRACTICAL WAY???? ???? There are more than 60 100% practical video classes where you will go from basic to advanced!!! ???????????? ENJOY ???????????? I just released for you *FREE*: FREE EBOOK https://drive.google.com/file/d/1APeh... SPREADSHEETS USED IN THE COURSE: https://drive.google.com/drive/folder... ------------------------------------------------------------------ FULL COURSE SCHEDULE ------------------------------------------------------------------ MODULE 1: BASIC EXCEL REVIEW PlayList • BASIC EXCEL REVIEW ✅ BONUS - Excel Shortcut Keys Ebook ✅ 1 - SUM ✅ 2 - AVERAGE ✅ 3 - SUBTOTAL ✅ 4 - COUNT.VALUES ✅ 5 - DOLLAR SIGN ✅ 6 - HIGHEST / SMALLEST / MAXIMUM / MINIMUM ✅ 7 - IF ✅ 8 - IF AND OR MODULE 2: ADVANCED EXCEL PlayList: • Advanced Excel ✅ 9 - VLOOKUP ✅ 10 - IFERROR ✅ 11 - ISORRS ✅ 12 - VLOOKUP TWO BASES ✅ 13 - VLOOKUP THREE BASES ✅ 14 - HLOOKUP ✅ 15 - LEFT ✅ 16 - RIGHT ✅ 17 - SEARCH ✅ 18 - NUMBER OF CHARS ✅ 19 - EXTRACT TEXT ✅ 20 - TEXT ✅ 21 - VALUE ✅ 22 - CONCATENATE ✅ 23 - INDEX ✅ 24 - MATCH ✅ 25 - INDEX WITH MATCH ✅ 26 - SUMIFS ✅ 27 - AVERAGEIFS ✅ 28 - COUNTS ✅ 29 - ABS ✅ 30 - ROUND ✅ 31 - ROUND UP - ROUND DOWN ✅ 32 - PIVOT TABLE ✅ 33 - PIVOT TABLE - DATA GROUPING ✅ 34 - PIVOT TABLE - GRAND TOTAL PERCENTAGE ✅ 35 - PIVOT TABLE - CALCULATED FIELD ✅ 36 - PIVOT TABLE - DATA SEGMENTATION ✅ 37 - PIVOT TABLE - DATA UPDATE ✅ 38 - GRAPH DYNAMIC 1 ✅ 39 - DYNAMIC GRAPH ✅ 40 - DATA VALIDATION ✅ 41 - ACCESS DATA IMPORT ✅ 42 - TEXT DATA IMPORT ✅ 43 - WEB DATA IMPORT ✅ 44 - XML DATA IMPORT ✅ 45 - EXCEL DATA IMPORT ✅ 46 - MICROSOFT QUERY DATA IMPORT ✅ 47 - CONDITIONAL FORMATTING 1 ✅ 48 - CONDITIONAL FORMATTING 2 ✅ 49 - CONDITIONAL FORMATTING 3 ✅ 50 - CONDITIONAL FORMATTING 4 ✅ 51 - PANEL FREEZING ✅ 52 - SPREADSHEET PROTECTION ✅ 53 - NAME MANAGER ✅ 54 - DAY FUNCTION ✅ 55 - MONTH FUNCTION ✅ 56 - YEAR FUNCTION ✅ 57 - DAY OF THE WEEK FUNCTION ✅ 58 - WORKDAY FUNCTION ✅ 59 - ITNL WORKDAY FUNCTION ✅ 60 - NETWORKDAY FUNCTION ✅ 61 - INTL WORKDAY FUNCTION ✅ 62 - TODAY FUNCTION ✅ 63 - NOW FUNCTION ✅ 64 - MACROS 1 ✅ 65 - MACROS 2 ✅ 66 - MACROS 3 ✅ 67 - CREATING A HOUSEHOLD BUDGET HLOOKUP, Excel, How to use HLOOKUP, HLOOKUP function, HLOOKUP tutorial, Excel formulas, HLOOKUP step by step, Excel for beginners, Excel tips, Excel course, Learn HLOOKUP, Excel spreadsheets, Basic Excel, Data management in Excel, Advanced HLOOKUP, Automation in Excel, Formulas with HLOOKUP, Excel tricks, Efficient HLOOKUP, HLOOKUP for work, Solving problems with HLOOKUP, Intermediate Excel, Data connection in Excel, Simplified HLOOKUP, Professional spreadsheets, Advanced Excel.