Excel Complete Portfolio Project for Beginners| Analytics Project | Excel Tutorials
HTML-код
- Опубликовано: 23 мар 2022
- Are you looking for a project that is best fit for your resume for a data analyst role or do you want to know how do analyst use microsoft excel to analyse data and create dashboard. In this video i am discussing complete end to end project on microsoft excel we have analysed the data using excel formulaes and created stock market dashboard using excel graphs and charts. The dashboard is completely dynamic in nature so with
a button click the data for the stock changes for different companies. This can be included as a advanced level project into your resume and will give a visibility to the recruiter that you know the skills and how to apply them practically.
Link to the excel file - github.com/ashutoshkr103/Micr...
👉 Microsoft excel tutorial from beginner to advanced-
• Microsoft Excel Tutori...
Stock market data - finance.yahoo.com
----------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 Microsoft excel tutorial from beginner to advanced-
• Microsoft Excel Tutori...
👉 How to become a data analyst complete roadmap-
• Data Analyst Complete ...
👉Check out the roadmap to become a business analyst - • Business Analyst Compl...
👉 Best Business analytics certification courses -
• Top Business analytics...
👉All about analytics playlist-
• All about analytics
👉 Top 3 you tube channels to learn excel for free for beginners
• Top 3 you tube channel...
👉0 to 1 advanced sql playlist -
• 0 to 1 Sql Course
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into busi...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutosh.analytics
💻Linkedin- / ashutoszh
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
ashutosh kumar analytics
data analyst
data analyst job
data analyst career
data analytics
excel tutorial
excel for data analysts
excel for data science
excel project
excel project for data analyst
excel tutorials for beginners
stock market dashboard using excel
how to create graphs in excel
how to create dashboard in excel
dashboarding in excel
complete excel portfolio project
_____________________________________________________________________
🏷️ Hashtags
#analytics #careerinanalytics #portfolioproject
For all the people getting N/A error first must check the date should be available in your data set i am getting the same error today date is not involved in dataset
Thanks
@@AshutoshKumaryt keep up the good work mate and what do you do professionally?
@@manishnegi6927 time waste karta hu bhai
Use TODAY()-1 U CAN SOLVE THE ERROR
Now a days analyst youtubers upload excel tutorial for data analysis A-Z and Projects. Very happy
Thanks
@@AshutoshKumaryt waiting your upcoming video's
much needed video. Thankyou bro.. :)
bro is there any way to dynamically update excel sheet there by stocks graph change daily according to updated date. like this is static right, if i wanna check daily analysis of my stock then is there a way???
Thank you very much. Waiting for next end to end project with pivot tables
Thanks coming soon more projects,please explore more from your end too what more you can add to the sheet
As it is shown in the video, the option we select in the drop down menu is automatically coming to the other side of the date coloumn. But I am not able to get the option dynamically when I select anything from the drop down. Please help.
Can you please elaborate
I just started this video and I'm on intermediate level in learning excel. When I'll complete learning excel I'll come back to this video to create this project.
Bhai excel.for data analysis ka course Kiya kya aapne
Mai bhi kar Raha hu aap btaonge which job is best for this kaha krni chahiye iske base pr job
@@anshulraut3410 Bhai excel sikhne ke liye koi institute mein dene ki jarurat nhi hai, youtube se hi free mein sikh skte ho. Maine bhi free mein sikha tha, aur ab projects bna rha hu, agar advanced excel sikh lete ho to uske saath VBA aur macros bhi sikhna, fir agar graduate ho to MIS ki job ke apply karna chalu kar dena.
@@Mr.Potato23 number do na aapka iske bare me baat krni hai what's app wala Dena what's pr krta hu message aaapko
Dialogue -jo bhi vhyakthi😂😂 cool❤
wHERE we can add the excel project so that recruiter can see over project.
40:16 ,i didn't understand how you fill the lookup value here
Please make more projects
Sure
@@AshutoshKumaryt please make videos on tableau
Where is the next video of this project?
When I apply the right formula but still popup N/A WHY I DONT KNOW
Open , high , low...inka itna index vgera lgaje ki bjay hum vlookup bi to kr skte the ...
Do we need to have stock market knowledge for this project?
No not at all, no usage of stock market terms,the video has been made focussing on the analytics part ,stock market is just the domain/subject i had to use for making the project.
@@AshutoshKumaryt okay... Thanks
there is N|A show while i trying to calculate high can anyone explain?
me too
@@wordlife_97 Same
@@nikhilbhute07 Double Check Your Formula
Agr Cell Range ghalt select karo to N/A show hota he
I suggest use Absolute Reference when selecting table array You can do this by pressing F4 on your Keyboard Right after selecting table array.
Time waste kr diya bhai bdiya vala
It's very silly questions but I am doing some mistake will writing frst index formula the result is showing N/A everytime
Will u please help me for that
No question is silly, it might be because of the date used, instead ofl today hardcode the date for which you downloaded the data
@@AshutoshKumaryt hello, I'm also getting the same response. could there be a way to solve that?
Should I follow this video ? As I want to become a business analyst. One important doubt - Should I do data analyst certification by IBM to be a business analyst?
Hi sure this project is also relevant to people willing to become business analyst. IBM data science is a great course but if you can also consider pursuing top business analytics certification course provided by top IIM's with placement assistance. I have made a curated list of IIM's offering this course best part is they provide placement assistance. Check out the video here - ruclips.net/video/3_0wXVl3QYA/видео.html
Please help me out on your linkeidn
Hey you can connect with me over linkedin www.linkedin.com/in/ashutoszh
Hello sir...I did everything and saved it but next day all formulas and charts disappeared from my sheet...
Hardcode the date , instead of today just hardcode the date
@@AshutoshKumaryt ok thank you sir