instead of copying the formula in every row, you could just double click at the bottom-right corner of the first cell containing the formula. It works as Auto-fill.
Mr Vadim. Love the work sir. Precise and accurate. Concise and clear. Would like to recommend 1 small change. Please stop pushing with the subscribe videos on the right. It take half the screen and not only do you sabotage anyone following your train of though, but also make it quiet "hard to follow". It was quiet annoying. Your work is amazing sir and speaks for itself. Hope I did not come off as arrogant, a troll or entitled. Only here to learn from an excellent teacher!
Thank you very much for taking time to leave you honest r feedback Jazy! It's greatly appreciated and would be taken into considerations when creating my new tutorials. Please come back though and check out my new video tutorials - there's lots of helpful information in every single one. Thanks again for taking time to leave your feedback and good luck in your learning journey!
Thank you Vera, You are absolutely correct. There are multiple different ways to answer this question and I am pretty sure employer would accept your version as well. Thank you for sharing it here.
Hi Romeka, Here is the formula I have used to concatenate custom ID for row 675: =LEFT(G675,3) & " - " & LEFT(H675) & " - " & LEFT(J675,3) & " - " & RANDBETWEEN(100,999). You can also download XLSX file - link is in the description of the video to see how it is implemented right in the file. All the best on the interview!
Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/
instead of copying the formula in every row, you could just double click at the bottom-right corner of the first cell containing the formula. It works as Auto-fill.
great tip !
This is definitely advanced for me, plus, you speed through it making it difficult to grasp the first time - whew! I'm sweating.
You got this Sharon! Don't give up - give it another try - it should be much easier. Keep learning and please stay healthy!
Mr Vadim. Love the work sir. Precise and accurate. Concise and clear. Would like to recommend 1 small change.
Please stop pushing with the subscribe videos on the right. It take half the screen and not only do you sabotage anyone following your train of though, but also make it quiet "hard to follow". It was quiet annoying. Your work is amazing sir and speaks for itself. Hope I did not come off as arrogant, a troll or entitled. Only here to learn from an excellent teacher!
Thank you very much for taking time to leave you honest r feedback Jazy! It's greatly appreciated and would be taken into considerations when creating my new tutorials. Please come back though and check out my new video tutorials - there's lots of helpful information in every single one. Thanks again for taking time to leave your feedback and good luck in your learning journey!
When using the RAND or RANDBETWEEN functions, how do you know all numbers are unique?
The numbers won't be unique. To make them unique, you can just add UNIQUE function in front and of course, don't forget the brackets.
I would say this is a little in advance side but I welcome it. Practice what you could be prepared in the interview/test.
Thanks so much for the honest feedback! Please check my other tutorials and don't forget to sign up to my channel so you don't miss the new tutorials.
The Sales tab shows Sales income after discounts
Thank you Vera, You are absolutely correct. There are multiple different ways to answer this question and I am pretty sure employer would accept your version as well. Thank you for sharing it here.
I am unable to concatenate the 3 series ID number HELP??
Hi Romeka, Here is the formula I have used to concatenate custom ID for row 675: =LEFT(G675,3) & " - " & LEFT(H675) & " - " & LEFT(J675,3) & " - " & RANDBETWEEN(100,999). You can also download XLSX file - link is in the description of the video to see how it is implemented right in the file. All the best on the interview!
can't find the downloadable file. (?)
Yes, its not there.
For creating a GUID, I don't understand why you used a specific number 4294967295 and 42949 in the RANDBETWEEN function. Can you please explain that?
why did you use financials for Text in syntax fourmula for concatnation
Hi Romeka, I have responded to your other comment and shared the formula. Hope this helps. Thanks
Many Thanks Mr. Vadim
So nice of you