🔢Indirect Function🔢| Advanced Excel | Excel Carols
Tired with data littered throughout the workbook ?
Excel Carols is here with a very useful formula which you might need if you're dealing with a sheet full of numbers or trying to analyze finances and many such instances. The INDIRECT returns the reference specified by a text string. References are immediately evaluated to display their contents. We can use INDIRECT when we want to change the reference to a cell within a formula without changing the formula itself.
Timestamp -
Working of INDIRECT function - 00:41
Entering INDIRECT Function - 0:53
Direct response from INDIRECT function - 1:25
Application for INDIRECT formula - 1:50
Keyboard shortcut for creating a Table - 2:29
Apply Data Validation - 2:51
SUMIFS function - 3:26
The problem that we are going to resolve - 4:07
Strategy for resolution - 4:37
The combo - 4:45
The big fat formula - 5:38
Disclaimer - 09:12
Link for video on VLOOKUP function : • 📈Lookup functions | Index & Match | Automa...
Background Music by : https://www.bensound.com
Please like and share the video if you find it useful. Excel Carols is always looking for scope of improvements, so please mention your feedback in the comments section below. In case, you want to learn about any other feature of Ms Excel, please mention that too in the comments section. Don't forget to subscribe to the channel and press the bell icon in order to get all the notifications.
Please follow the instagram handle in order to get all the updates : https://instagram.com/excelcarols?utm...
#ExcelCarols #MsExcel #ExcelShortcuts #Advanced Excel #KeyboardShortcuts #ExcelOptions #MsExcelOptions