FREE VIRTUAL INTERNSHIP | DATA ANALYTICS AND VISUALIZATION | ACCENTURE
ฝัง
- เผยแพร่เมื่อ 26 ธ.ค. 2023
- This Video contains Guidance for Free Virtual Internship for DATA ANALYTICS AND VISUALIZATION from Forage for Accenture Company
--------------------------------------------------------------------------------------------------
For Materials, Supporting Files, Bonus Gifts Join the Telegram
telegram.me/itechanalyticsolu...
--------------------------------------------------------------------------------------------------
Follow the Trainer on LinkedIN
/ aadiputtaswamyt
/ itechanalyticsolutions
--------------------------------------------------------------------------------------------------
Follow us on Social Media
TH-cam : / @itechanalyticsolutions
Telegram : telegram.me/itechanalyticsolu...
WhatsApp : wa.me/919066078793
Facebook : / itechanalyticsolutions
Telegram : / itechanalyticsolutions
Super thankful for this explanation video helped me a lot 👍🏻
sir 15:16 i am unable to understand can u explain me why u use vlookup i have a doubt
Sir, I am using vlookup formula in mac libre office it is not working here. Please guide I am a beginner
i have joined the telegram but i dont find presnetation video can u please mention it
presentation video please
how its autofilling the photo mine was not filling it?
Thank you sir 😊
Sir., pleae guide me to compete the presentation in ppt
Sir ye timei 18:27 sumif tha total score of each category tha formula chaiye sir.
How to enter type sentiment and score in excel sheet
please someone explain this 14:39 which shortcut key is to be used after selecting column of content id as selecting shift +space is just deleting first cell content and nothing else
bro just simply select them :-
select one row then click cltrl+shift+down arrow .all records will get selected and delete them by pressing delete button on keyboard.
www.google.com/search?q=how+to+remove+empty+rows+in+excel&rlz=1C1YTUH_enIN1039IN1039&oq=how+to+remove+emp&gs_lcrp=EgZjaHJvbWUqBwgBEAAYgAQyBggAEEUYOTIHCAEQABiABDIHCAIQABiABDIHCAMQABiABDIHCAQQABiABDIHCAUQABiABDIHCAYQABiABDIHCAcQABiABDIHCAgQABiABDIHCAkQABiABNIBCDY1OTFqMGo3qAIAsAIA&sourceid=chrome&ie=UTF-8#fpstate=ive&vld=cid:7803fe92,vid:_9QFKGfCZ5Q,st:0
use this link to delete emply row
Tq bro @@ratikvarshney
can anybody tell me how to download the data to perform these tasks?? please
I have seen the blanks removal part for more than 6 times but still cant understand what sir is doing
actually sir is deleting those rows where the customer id is blank,because this is part of data cleaning where we remove unnecessary record.
He first searched for row having blank in content id column by using filter and he deleted all of them
You have not Completely guide for the 3rd table LookUp
You are just Giving the link to the Telegram And making up to Find those links and that link also contain The same video that also didn't explain the same
Harshit please check from 16.37 minute it's there. Pls let me know where you are not able to solve will help u.
How you added sentiment column and their count you didn't specified @@itechanalyticsolutions
Will they assign project in this internship
Sir, is this an internship or Project based
How to upload data clean
Please share the VLOOKUP formula for type, sentiment,Score
When I am removing duplicates in category column I am getting only "studying" as 16 unique values.
Can you explain why this is happening?
Join our telegram channel let's have this session again
telegram.me/itechanalyticsolutions
Can you please tell here as well what can be the mistake
@@muskansinghal4771 Im also getting the same problem
can you explain me what should I
need to do
Facing the same issue can u guide me? If u done it?
how to download your presentation and we have to upload the presentation video then we have to give the presentation
Please join the telegram group you will get
Have u completed all the tasks?
after we completing first vlookup command how to execute it to all other rows can u tell me that command please
Double click on the plus symbol rather than dragging it
After copying category column and to remove duplicates then only 'studying' remaining what should I do?
Facing the same issue, did u got it done!? Figured it out!?
You are facing this issue because you copying the column that you've created using the lookup function. Copy the column from the native table.
How can I add this internship in resume, do I mention free internship and so on?
Mention the details of what you have done in this internship and also add the link of your certificate in your profile
the file is not uploading in task 2 can you please help me out it only loading
Did ur file uploaded?
Sir on what basis did you do Vlookup?
Hi all soon let's have a live session on this project again
When removing duplicates it's showing only studying in all rows.
Did u got it done!?
After removing duplicates from the Category, everything comes same in my data? why is it so? can someone help me?
This is because of the formula in the data you pasted. Try paste only text and then remove duplicates.
How to do that pls explain@@manansaluja
SIR YOUR SUM IS NOT MATCHING WITH MINE
The formula of sumif is of new version (in the video) and we are using old excel (Version) hence getting **error/no_value" and now I rectified it by selecting "range" from "catagory" colomn first and then selecting "studiyng" on that colomn and then selecting the sum range from "score" then I got the result
How can i join the internship, where to apply ??
Join this telegram channel telegram.me/itechanalyticsolutions
You get video for the internships
will there be any time limit for completion course after login
No
In task 4, uploading a video presentation without face is okay/not sir ?
No need of having a video with personal appearance. you can save the presentation as video and upload. All the best
I don't understand about how you write Vlookup in Type, sentiment,score thing?
Please check the video, and also there are materials in our Telegram Page. Please join our telegram channel and get the files and work on it.
telegram.me/itechanalyticsolutions
Me too
Hello sir
sir am not getting how did u does that sumifs formula please tell
Shortly let's have this session again. Please join our community will surely let's have this session repeated. telegram.me/itechanalyticsolutions
sir i could not find material in telegram kindly share that ppt
did you find the material
Sir can u plz tell what is the vlookup formula use for the type , score and sentiment because I tried but that not execute first category and content execute but reaction type. Csv how to transfer this columns
Divya, please join the telegram channel you get the complete notes and the files for all the tasks completed.
telegram.me/itechanalyticsolutions
Sir can you tell us in detail.how to did you used vlookup after content and category
Did u complted
If u have done please help me to do this im also facing same issue
@@Nishefashionneed to do same way we did before for content using vlookup
how did u do that sentiment and score columns
Helloo did you complete this internship
@@jakkulapavan78 YES DONE
What and how we present the task 4 presentation
You can either create a presentation convert that into MP4 or make a video of your own and submit
I'm stuck at 17:21 please help me after this step....
SAME, DID U FIGURE OUT BRO?
How to download those datasets ?
Please join the channel telegram.me/itechanalyticsolutions
Can we write this internship in resume
Yes you can add this in your resume
How to fill the content type and category values(photo,...)for those entire columns
Sir your content is totally confusing
Ok let's have a session from beginning soon
Yes sir.
Sir start the session on it...
@@itechanalyticsolutionsplease provide ppt presentation to submitt I need