PrepNPlaced
26.6K subscribers
219 photos
6 videos
313 files
9.4K links
๐Ÿš€ Welcome to the Elite Data Engineering & Agentic AI Hub! ๐Ÿš€

๐Ÿ‘‘ Community Creator: Mandar Patil
๐Ÿ‘จโ€๐Ÿ’ป Admin & Mentor: Durgesh Yadav

The era of basic data tasks is over. With Agentic AI evolving the industry, up to 60% of traditional Data Analyst roles
Download Telegram
Hey hustlers, Very good morning, and I hope you're doing great.

Welcome Day 43 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge.

Today we will be creating another Excel Project into our Projects Portfolio part

Use below Tutorials for learning and understanding ๐Ÿ˜Š

https://youtu.be/Rthh_bK5xUs?si=zvTibZslujxn0KKT


I look forward to your responses.

Till then keep learning and keep exploring ๐Ÿ™Œ
๐Ÿ‘4๐Ÿ‘1
PrepNPlaced pinned ยซHey hustlers, Very good morning, and I hope you're doing great. Welcome Day 43 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge. Today we will be creating another Excel Project into our Projects Portfolio part Useโ€ฆยป
๐Ÿš€ Unlock your career journey with GeeksforGeeks !!

๐ŸŒŸ Job-A-Thon 36 is your gateway to ๐Œ๐ฎ๐ฅ๐ญ๐ข๐ฉ๐ฅ๐ž ๐…๐ฎ๐ฅ๐ฅ-๐“๐ข๐ฆ๐ž & ๐ˆ๐ง๐ญ๐ž๐ซ๐ง๐ฌ๐ก๐ข๐ฉ ๐Ž๐ฉ๐ฉ๐จ๐ซ๐ญ๐ฎ๐ง๐ข๐ญ๐ข๐ž๐ฌ.

-GeeksforGeeks expands opportunities! Formerly limited to 4-5 companies, now anyone can participate. Succeed, and your profile reaches Multiple Tech Giants.

-GeeksforGeeks it self hiring for SDE Position- Freshers (2024).

๐Ÿ“… Test Date: 21st August, 2024
๐Ÿ• Time: 8 PM.
โณ Duration: 2.5 hours.

๐Ÿ”— Apply now: https://practice.geeksforgeeks.org/contest/job-a-thon-36-hiring-challenge

๐Ÿค Fresher from batches 2024 and 2023, share with friends and college groups.
๐Ÿ‘1
Company โ€“ BharatPe
Role โ€“ Data Scientist - GenAI
Exp. โ€“ 1-2 yrs
Apply Here โ€“ https://www.linkedin.com/jobs/view/3999657393

๐Ÿ‘‰WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

๐Ÿ‘‰Telegram Link: https://t.me/dataanalyticsbuddy

All the best ๐Ÿ‘๐Ÿ‘
๐Ÿ‘1
Company โ€“ Truelancer.com
Role โ€“ Data Analyst
Exp. โ€“ 2+ yrs
Apply Here โ€“ https://www.truelancer.com/apply/data-analyst-remote-job

๐Ÿ‘‰WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

๐Ÿ‘‰Telegram Link: https://t.me/dataanalyticsbuddy

All the best ๐Ÿ‘๐Ÿ‘
๐Ÿ‘1
๐—”๐—œ ๐˜๐—ผ๐—ผ๐—น๐˜€ ๐˜„๐—ต๐—ถ๐—ฐ๐—ต ๐˜„๐—ถ๐—น๐—น ๐—ถ๐—บ๐—ฝ๐—ฟ๐—ผ๐˜ƒ๐—ฒ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—ฑ๐—ฎ๐—ถ๐—น๐˜† ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐˜ƒ๐—ถ๐˜๐˜†๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_productivity-ai-techtools-activity-7231125250665549824-My_L
๐Ÿ‘2โค1
Hey hustlers, Very good morning, and I hope you're doing well.

Welcome Day 44 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge.

Today we will be revising all concepts and formulas learn till now

Use below resources for learning and practice purpose

https://www.w3schools.com/EXCEL/


https://corporatefinanceinstitute.com/resources/excel/excel-test/


https://excel-practice-online.com/excel-practice-tests/


Use below online platform for practice purpose if don't have Excel application ๐Ÿ‘‡๐Ÿป

https://excel-practice-online.com/



I look forward to your responses.

Till then keep learning and keep exploring ๐Ÿ™Œ
๐Ÿ‘3โค2๐Ÿ‘2
PrepNPlaced pinned ยซHey hustlers, Very good morning, and I hope you're doing well. Welcome Day 44 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge. Today we will be revising all concepts and formulas learn till now Use below resourcesโ€ฆยป
American Express is hiring for the role of Consultant- Freshers (2024)
Experience: 0 -1 year's

Link: https://unstop.com/jobs/risk-consultant-american-express-1130934

๐Ÿ‘‰WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46


All the best ๐Ÿ‘๐Ÿ‘
๐Ÿ‘1
๐—–๐—ผ๐—บ๐—ฝ๐—น๐—ฒ๐˜๐—ฒ ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐˜๐—ผ๐—ฝ๐—ถ๐—ฐ๐˜€ ๐—ฎ๐—ป๐—ฑ ๐˜€๐˜‚๐—ฏ๐˜๐—ผ๐—ฝ๐—ถ๐—ฐ๐˜€ ๐—ด๐˜‚๐—ถ๐—ฑ๐—ฒ ๐—ณ๐—ผ๐—ฟ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—™๐—ฟ๐—ฒ๐—ฒ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_power-bi-roadmap-for-data-analyst-activity-7231487611574394880-UVMG
๐Ÿ”ฅ1
Hey hustlers, Very good morning, and I hope you're doing well.

Welcome Day 45 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge.

Today we will preparing ourselves for Excel Interview Questions. Here are questions that we should be knowing as Fresher Data Analyst and rest you can find in PDF.

1. What are the basic functionalities of Excel, and how are they used in data analysis?

2. Explain the difference between a worksheet and a workbook in Excel.

3. How do you perform basic arithmetic operations in Excel?

4. Discuss the significance of functions like SUM, AVERAGE, and COUNT in data analysis.

5. How do you filter and sort data in Excel?

6. Explain the importance of pivot tables in data summarization and analysis.

7. How do you create and format charts/graphs in Excel for data visualization?

8. Discuss the usage of VLOOKUP and HLOOKUP functions in Excel.

9. Explain the concept of conditional formatting and its application in Excel.

10. How do you handle missing or NaN values in Excel spreadsheets?


And many more...


Use below resources for learning and practice purpose

https://www.w3schools.com/EXCEL/


https://corporatefinanceinstitute.com/resources/excel/excel-test/


https://excel-practice-online.com/excel-practice-tests/


Use below online platform for practice purpose if don't have Excel application ๐Ÿ‘‡๐Ÿป

https://excel-practice-online.com/



I look forward to your responses.

Till then keep learning and keep exploring ๐Ÿ™Œ
๐Ÿ‘5
PrepNPlaced pinned ยซHey hustlers, Very good morning, and I hope you're doing well. Welcome Day 45 of the ๐—›๐˜‚๐˜€๐˜๐—น๐—ฒ๐—ฟ๐˜€๐—น๐—ฒ๐—ฟ๐˜€ ๐˜๐—ผ ๐—ฏ๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ ๐˜๐—ผ ๐˜„๐—ผ๐—ฟ๐—ธ๐—ถ๐—ป๐—ด ๐—ฎ๐˜€ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜ challenge. Today we will preparing ourselves for Excel Interview Questions. Here are questions thatโ€ฆยป
EXCEL Interview Questions.pdf
1.1 MB
Excel Interview Questions๐Ÿ”ฅ

Share with others to helpโœจ

โœ…Join our Community:
https://t.me/dataanalyticsbuddy

Do react โค๏ธ if you want more resources like this
โค4๐Ÿฅฐ1
PrepNPlaced
EXCEL Interview Questions.pdf
Guys !! You can use it for Data Analytics interview too.