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,…
How To Highlight Active Row in Excel – Excel Tips and Tricks
https://youtube.com/watch?v=GfUehj5zZR0Learn how to highlight active row in Excel. Here are the steps outlined in the video. 1) Ctrl + A 2) Home -- Style -- Conditional Formatting 3) New Rule…
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…
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…
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 +…
How to use DGET function in Excel with example – Excel Tips and Tricks
https://youtube.com/watch?v=KI8rk74pjWILearn how to use DGET function in Excel with example. Excel is a powerful spreadsheet software that offers a wide range of functions to help users manipulate and analyze data.…