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…
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
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…
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 +…
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.…
https://youtube.com/watch?v=JiTQRUWEMcMStop dragging formulas down in Excel. How to apply formula to entire column without dragging. Here are the hot keys featured in my video. Select All Rows Ctrl + Shift…
https://youtube.com/watch?v=0DjRtJp0Y9cWords Count in Excel - Excel Tips and Tricks Learn how to word count in Excel cell. This is the formula. =LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1 #microsoft #excel #exceltips #tips #exceltricks #tricksandtips
https://youtube.com/watch?v=cTEqWmzT8RMDiscover how to alternating row colors in Excel using conditional formatting and ISEVEN() function. This is a demonstration of how do I fill alternate rows with color in Excel? Excel…
https://youtube.com/watch?v=roOnmcbgbTINow you know how to crosshair highlight in excel, essentially, how to highlight row and column of active cell. And also create a crosshair highlight with intersecting cell as a…
https://youtube.com/watch?v=-l4FBL7CnXULearn how to add to select non-adjacent cells using Shift + F8. To pick cells that are not contiguous / non-adjacent, press Shift + F8. Make sure you can see…