- Видео 9
- Просмотров 6 133
Let Us Excel
Индия
Добавлен 2 мар 2023
Hi, Welcome to Let Us Excel. We are here to learn..
1. A different way to use most frequently used formulas to improve productivity.
2. How and what formulas to use while dealing with huge data?
3. VBA coding with interactive user forms and much more.
1. A different way to use most frequently used formulas to improve productivity.
2. How and what formulas to use while dealing with huge data?
3. VBA coding with interactive user forms and much more.
Consolidate data from multiple sheets using VSTACK formula 1 Edited
Advanced Excel - Dynamic array formula: "VSTACK" to consolidate data from multiple sheets into a single sheet using one simple formula.
Просмотров: 182
Видео
WRAPROWS Formula to re-arrange the data in a sheet
Просмотров 66Год назад
Advanced Excel - WRAPROWS Formula to re-arrange the data in a sheet
Creating BETWEEN formula using MIN and MAX together - Restrict a cell value between a given range
Просмотров 27Год назад
How to select a value that is restricted between a given lower and upper values.
Multiple Lookup results using FILTER Formula - Excel Dynamic Array Formulas
Просмотров 167Год назад
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.
Excel Worksheet Navigator with Search Feature using VBA Part 2 of 2
Просмотров 165Год назад
How to create a custom Tab to the Ribbon and add your macro to the Tab? Link to Part 1: ruclips.net/video/MxXD32cXa6A/видео.html
Excel Worksheet Navigator with Search Feature using VBA Part 1 of 2
Просмотров 182Год назад
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: ruclips.net/video/EeeyauumJpk/видео.html
Employee Summary and Turnover Report using COUNTIFS
Просмотров 4,1 тыс.Год назад
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.
How to Transpose a Table in Excel using VLOOKUP.
Просмотров 456Год назад
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.
Advanced VLOOKUP - Using VLOOKUP to replace IF Formula
Просмотров 804Год назад
Use VLOOKUP instead of the IF formula to shorten the lengthy nested IF formula into a single short VLOOKUP formula.
Thank you!!! It was very easy to understand.
Nitin bhai make a video to show how we can make separate workbook for each tab on the excel