Hi guys, Welcome to the Advanced Video Search Engine, and you are watching INDIRECT Excel Function: How it works and when to use it [Advanced Excel]. That video is uploaded by 365 Data Science at 2017-10-27T00:18:13-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [kDkS8rNCoBM]
| Name | INDIRECT Excel Function: How it works and when to use it [Advanced Excel] |
| Video Uploader | Video From 365 Data Science |
| Upload Date | This Video Uploaded At 27-10-2017 07:18:13 |
| Video Discription | 👉🏻 Download Our Free Data Science Career Guide: https://bit.ly/342E0x4 👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/2Y0i7e8 In this video we'll learn how to use another interesting Excel function indirect in addition. We'll see how it can be applied in combination with vlookup. Previously we've said it is common practice to use cell references in formulas and indirect. If implemented properly it can be helpful when working with cell references. Download the Exercise and Solution files and practice along with the video: https://www.dropbox.com/sh/691s50xadcmwtxq/AAAgVTScm1RVSOaBmnEsXqF4a?dl=0 Please follow this lecture carefully to understand how indirect functions. It can be tricky but don't worry, we are here for you! Indirect returns the reference indicated by a text string so the input we should have in the brackets must be a text string. What do I mean by that I suppose was interested in the precise number of staff employees working in a company and I wanted to obtain that number by using indirect in other words. I am interested in the number written in cell c6. Right, let's see what happens if I select cell c6 as the input of the function Excel displays an error message. Why? Because c6 is not a text string and hence the function can't provide a result look at how the result changes if I place C 6 within inverted commas ► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1 ► VISIT our website: https://bit.ly/365ds 🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/ 365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists. We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online. Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb #INDIRECT #Excel #Function kDkS8rNCoBM |
| Category | Education |
| Tags | 365 data science | indirect excel | indirect excel function | indirect excel formula | indirect and vlookup | when to use indirect excel | Learning Python Programming | data science certificate | data science python | data science | vlookup in excel | vlookup | excel vlookup | excel vlookup tutorial | how to use vlookup in excel | vlookup multiple sheets | microsoft excel vlookup tutorial | 365datascience | 365 datascience | excel vlookup tutorial 2016 |
