Separate First Name and Last Names – Excel Tips and Tricks
https://youtube.com/watch?v=FUKXR4aXY_4Learn how to separate first name and last names. METHOD 1: Using Ctrl + E Here are the steps. 1) Enter first name. 2) Go to any cell below that…
How to compare two lists to find missing values in excel – Excel Tips and Tricks
https://youtube.com/watch?v=dl75Lz_jaPsDiscover how to compare two lists to find missing values in Excel. You can use this same technique to compare two lists in Excel and pull not matching data. Likewise,…
Excel Tips: Replacing Asterisks and Question Marks in Excel | Find & Replace Tricks! #exceltutorial
https://youtube.com/watch?v=BuaGgQdFI-oWelcome to our Excel tutorial video! In this episode, we're diving into some handy tips and tricks for Microsoft Excel that will save you time and make your spreadsheet tasks…
VLOOKUP with a Dynamic Dropdown List in Excel #exceltips
https://youtube.com/watch?v=JZUlIb1H4y8Discover how to combine VLOOKUP with a dropdown list in Excel to create a dynamic and interactive data retrieval system. This method ensures accurate lookups based on user selection, improving…
Find the difference between two lists in Excel – Excel Tips and Tricks
https://youtube.com/watch?v=oR--v-k9TdMLearn how to find the difference between two lists in Excel. Here are the steps outlined in my video. 1) Select dataset 2) Ctrl + G 3) Special 4) Row…
Delete Empty Rows with these Excel Shortcuts #shorts
https://youtube.com/watch?v=_9QFKGfCZ5Q🔥 400,000+ professionals trust our courses—start your journey here! 👉 https://link.xelplus.com/yt-g-shorts-all-courses Quickly remove or delete blank rows in Excel. Don't highlight the row and delete from the menu. That can…
How do I monitor inventory in Excel? #exceltips #exceltutorial
https://youtube.com/watch?v=sa7d3-RLpJY👉 Join members: https://www.youtube.com/channel/UCeX5SphLC0ky7rpbsffFwqg/join Are you struggling to keep track of your inventory? Managing inventory is crucial for any business, big or small, and using Excel can be a powerful…
Built-In Crosshair Highlight In Excel – Excel Tips and Tricks
https://youtube.com/watch?v=utNDRUSvxDMLearn how to enable bui8ld-in crosshair highlight in Excel without VBA and conditional formatting. View ~ Show ~ Focus Cell #microsoft #excel #exceltips #tips #exceltricks #tricksandtips
Visualize year over year data in Excel – Excel Tips and Tricks
https://youtube.com/watch?v=Laz0R5YfZ8kLearn how to visualize year over year data in Excel. Here is the formula to calculate year-over-year YOY Calculation =(D5-C5)/C5 YOY Chart 1) Select Month and YOY column Press Ctrl…
Use VLOOKUP function to create dynamic charts – Excel Tips and Tricks
https://youtube.com/watch?v=RZH0zORV9doUse VLOOKUP function to create dynamic charts. Here are the steps featured in my video. Dynamic Chart Using VLOOKUP 1) Highlight the row like this 2) =VLOOKUP($B$5,$B$18:$F$33,COLUMN(B17),0) 3) Ctrl +…