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…
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…
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…
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…
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…
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…
https://youtube.com/watch?v=2482wD1FmEsIn this video, I will show you how to quickly unpivot data in Excel using Power Query. Since the Pivot table needs a specific data format, in case you get…
https://youtube.com/watch?v=6jLeD1YfWfYIn this video, I will show you a really easy way to show numbers in thousands in Excel (or in millions or billions). You can do this using the custom…
https://youtube.com/watch?v=nGdkfbvqd5QIn this video, I will show you how to open specific Excel files when you start Excel. You can specify a folder so that whenever you start Excel, it will…
https://youtube.com/watch?v=zqkINF31_nwIn this video, learn how to highlight cells with dates that are past the due date. This can easily be done using the TODAY function in conditional formatting. In this…