Відео

Advanced Excel - WRAPROWS Formula to re-arrange the data in a sheet

How to select a value that is restricted between a given lower and upper values.

FILTER Formula is a Dynamic Array Formula that is available in Office 365. It helps to filter the records from a table array based on the filter conditions provided in the formula.

How to create a custom Tab to the Ribbon and add your macro to the Tab? Link to Part 1: ua-cam.com/video/MxXD32cXa6A/v-deo.html

It becomes difficult to navigate and select the desired sheet when there are large number of worksheets in a single excel file. Worksheet Navigator created using a simple VBA code is a good option to deal with such situation. Link to Part 2: ua-cam.com/video/EeeyauumJpk/v-deo.html

Create a dynamic employee summary report from the employee master using the Excel COUNTIFS formula. Calculate employee turnover rate for any time frame with ease.

Sometimes the data is received in multiple columns and the same needs to be arranged in a single column. In this video, we are trying to achieve the same using VLOOKUP.

Use VLOOKUP instead of the IF formula to shorten the lengthy nested IF formula into a single short VLOOKUP formula.