How to Sort by Last Name in Excel (3 Easy Ways)
https://youtube.com/watch?v=8vpKwR0Fd7wIn this video, I will show you three easy ways to sort the names data based on the last name. The following three methods are covered in this video: 1.…
Excel Advanced Filter – Complete Tutorial in Tamil | 16+ Excel Tips & Tricks of Advanced Filter
https://youtube.com/watch?v=owoB5mkIA-ELike the normal filter, Advanced Filter is also one of the major featured option in excel. Watching the entire video can give you a lot of ideas to work better…
Excel Formula And Functions – Most Useful Best And Powerful – Excel Formulas in Hindi
https://youtube.com/watch?v=oRoXy9pFKOkExcel Formula And Functions - Most Useful Best And Powerful - Excel Formulas in Hindi, Agar Aap Soch Rahe Hain ki MS Excel Main Smart Work karne ke liye kon…
How To Create Data Validation Lists From Pivot Tables || Excel Tips & Tricks || dptutorials
https://youtube.com/watch?v=fNfooOsIq2MIn this tutorial let us see how to Create Data Validation Lists from Pivot Tables in Excel Let us consider a situation where you need to get the data validated…
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dptutorials
https://youtube.com/watch?v=nHbW_eUZ-XwIn this tutorial let us see how to use INDEX and MATCH with multiple criteria To lookup values with INDEX and MATCH, using multiple criteria we need to use an…
How to create dependent drop down lists in Excel || Excel Tips & Tricks || dptutorials
https://youtube.com/watch?v=NNrYIcV8QrIIn this tutorial let us see How to create dependent drop down lists in Excel You might be knowing the data validation feature in excel using which one can create…
Filter the Smart Way – Use Advanced Filter in Excel
https://youtube.com/watch?v=ZUFEqjDLM2IExcel Advanced Filter is one of the most underrated and under-utilized features that I have come across. If you work with Excel, I am sure you have used (or at…
3 Amazing Time-Saving Tips Using Excel AUTO-CORRECT
https://youtube.com/watch?v=6NjeJ_WCYeIIn this video, I will show you how to use Excel Autocorrect to save time in Excel. Excel autocorrect is a feature that's built to correct misspelled words or convert…
Show Negative Numbers in Red Color (with a Bracket) in Excel
https://youtube.com/watch?v=9aokrf_tMRIIn this video, I will show you how to show negative numbers in red color and/or with brackets. This can be done using two methods: -- Conditional Formatting -- Custom…
Master Advanced Excel Techniques
https://youtube.com/watch?v=hXm_EXGQd94Looking to take your Excel skills to the next level and be more productive? Our free webinar on Advanced Excel with Simon Hurst, Excel guru and EwB course author, will…