This channel is dedicated to providing insightful content focused on the field of data analytics. Our goal is to offer comprehensive coverage of topics related to data analysis, including techniques, tools, best practices, case studies, and industry trends. We aim to educate and inform our audience about the latest developments in data analytics, empowering individuals and organizations to harness the power of data for strategic decision-making, problem-solving, and business growth.
Пікірлер
From 10 weeks analytics! Thank you for sharing this
Amazing
Good Evening. Thank you for this video. Okay, so i have 2 questions. 1. is there an alternative formula for the text after fxn, I'm using an older Excel version. 2. how can i select just a single column in an excel sheet. anytime i try, i end up selecting the whole sheet. Thank you
Okay. I'm back. So I've gotten an alternative formula for the text after fxn
Once again. Quality Video. I couldn't get my assignment do in time to submit unfortunately. Thank you for this review. much appreciated. To the lady that kept getting an error message, my guess would be that she didn't put a comma when writing her formula for the Lookup fxn.
Great teaching
Thank you
Thank you so much for this class. So insightful, and broken down so simply.
Quality video. Very insightful for beginners such as myself. I have a question, during the course of video, you kept saying down the row and across the column. I had always thought that in Excel, columns were vertical while rows were horizontal, in line with your statements at the start of the video that (columns are represented alphabetically while rows, numerically). Correct me if I'm wrong. I always tend to mix them up. Once again, thank you for the Video.
Yes, you are very correct. However when you move vertically down you are moving from one row to the other and also if you are moving horizontally you are moving from one column to the other
This is impressive
Thank you
Thanks for this sir.
Please I have a question on mixed referencing. Mixed referencing is the combination of relative and absolute referencing. Then you gave an example of adding numbers using their roll and columns and then locking it with the $ sign like D$13+E$but then in another spreadsheets of you talking about drivers, we were trying to multiply it, you used only locked the first roll which was D$2*D5 that is using 7% in D2 to multiply the roll So my question is why didn’t you lock both like d$2*D$5 because if we locked both and multiply, won’t we get the same answers?
Mixed referencing in formulas refers to fixing either the row or column of a certain cell or all of the cells involved in the formula while allowing the other part to change as the formula is copied to different cells.
My question still hasn’t been answered Could you share more light on it
Powerful ✨ teaching
Sharp Explanation
Very clear teaching. Keep it up
Hello
Nice
Please can we get the file used for this tutorial?? it wasnt shared in the milestone folder