@@pallavimishra8120 mein data analyst ka toh nahi laga but as a auditor data analyst job lag gaya But in reality data analyst jobs are very tough in day to day life, that's why companies paying us more money
@@dhavalpatel8155 5 lpa ka package laga hai in start up, Advance Excel, word , medium level power bi , basic all types of SQL knowledge that's it, In the end make a great project with all of those skills Good luck buddy 👍 Go for start up not big company as starting
But data analytics work not easy at all remember in reality When u actually come to office and u feel last night I slept not well or anything happened then u cannot do that day count, u need a fresh brain to think so much
Thank you 🙏 Bhai aapne meri help kar di mere pass paise nahi hai bilkul but I am interested mujhe Excel ache se aata hai aur aapki course mujhe bahut help Mila thank you so much 🙏
00:01 Introduction to Free Data Analysis Course 02:03 Data Analytics Full Course overview 04:54 Indexing and summation in Excel Basics 06:59 Understanding the minimum formula for data analytics 09:31 Explaining the concept of maximum value 11:47 Extracting specific numbers using Excel formula. 13:53 Understanding Excel formula referencing 15:59 Using Excel functions for data manipulation 17:50 Learning how to use the split function in Excel 19:39 Extracting values with split formula and fixing range using dollar sign 21:31 Learning GPT functions and essential Excel formulas Crafted by Merlin AI.
hello i have this one doubt which is 1 . i want to know the excel u r using is it advance excel or the normal excel application in the laptop, how can i get the advance excel application kindly help. 2. As i am unable to apply some of the formulas at my laptop applications idk what is the issue kindly help with these 2 issue 3. i am unable to fine the conditional format the excel which i am using
hi sir.... mere excel mai split ka formula kam nhi kar raha hai mai kya aru zara bta dijiye sir. its showing that the function is invalid. plz tell me that what should I do?????
Hello Sir , Sir ye jo pin message hai data sheet download karne keliye, Jab whatsapp channel pe jate hen ye to Amazon ka sale data sheet link hai aour aap jo video me dikhate ho different hai. could you please help here to clarify my doubt. what should we prefer like that Amazon data sheet link we will use for practice or any new data sheet you will provide?
@explorersusz You can use textafter or textbefore or substitute function same as split function they all has different uses E.g:- you have "City,pincode" in a column you need to separate them you can use textbefore(,) in city cell and textafter(,) in pincode cell and if you want both in a cell you can use substitute(,) function
Sir aap ki ye 20 lectures dekh ne k baad linked in p account creat ker na hai then tab ja k job lagegi please sir reply me i am medical background please sir help me
Pls sir pura krvayiega..... Totally dependent on u 🙏🙏🙏... And projects bhi krvayiega... Sir... Plsss sir coduct zoom meeting also with utube student also
Only this video is short, remaining video's range is from 35 mins to 90 mins. Depends upon the topic's necessity. Excel 3-4 hours PowerBi 2-3 Hours SQL 5-6 Hours Python 3-4 Hours Although this is only a concept building and fully practical course. After that I will build 4 - 5 Project few will be live sessions few will be recorded. After that there will be a course orientated sessions like building resumes and all. Also we will try to include a few cloud lectures so that we can prepare for data science. If we get a good response from you on this data analyst free course then we will definitely try to create a free data science course on this channel.
Sir apki screen clear nhi aa rhi ji ap excel me desktop par formula type krte ho baki sab sahi hai resolve this otherwise its better to go for paid course
Sir as Excel export please clear my doubt,Can copilot 365 and other ai tools do all type of works in ms Excel Or is it still important to learn ms Excel deeply all functions
sir iss shark tank vaaley database ka koi link ya kuch aur koi provide kardiye toh hamm exact practice bhi karlenge and hamko practical work bhi karne ko milega..... Or community channel pe is EXCEL SHEET ko attach kardo hun download karlenge😊