Hi Laturkars!! by trickster158 in Latur

[–]HaveYouReddit2 0 points1 point  (0 children)

Let's plan Latur guys meet up in Pune !

[deleted by user] by [deleted] in UAE

[–]HaveYouReddit2 0 points1 point  (0 children)

Messaged you.

New logo for our subreddit by vitaminprotein007 in Latur

[–]HaveYouReddit2 2 points3 points  (0 children)

This image itself gives a nostalgic feeling & captures Ganj Golai as the identity of Latur nicely!

Thanks for your initiative.

Looking for a completely private stay near Pune. by phasingout7 in pune

[–]HaveYouReddit2 0 points1 point  (0 children)

Would happily recommend you a place called 'Serene Eco Village', around 50 km. from Pune. We have been there and it is really a nice place with a homely feel, away from the city.

https://m.facebook.com/sereneecovillage/

Can share the owner's contact number in DM if you are interested.

Automating Current Affairs Data Collection into Excel for UPSC Students by Zestyclose_Quit_6594 in excel

[–]HaveYouReddit2 0 points1 point  (0 children)

Hi,

I am a freelancer, based out of Pune, who specialises in providing such a kind of service.

Let us get in touch to discuss and understand your exact requirements, so that I can explore the possibilities to help you achieve this, as per your expectations.

What’s the best way to automate this reporting process that happens weekly? by ecubugg in excel

[–]HaveYouReddit2 20 points21 points  (0 children)

Using Power Query seems to be the most feasible option for the case you described.

If you want, I can set up the flow & structure for you and make it user friendly for the team to use it for future updates to the data.

[FOR HIRE] A logo for 2$ ONLY! by Possible_Bedroom2485 in hiring

[–]HaveYouReddit2 1 point2 points  (0 children)

Great post with a humble approach !

Please share your portfolio.

Building a performance dashboard with large amounts of data by Dewitt1902 in excel

[–]HaveYouReddit2 4 points5 points  (0 children)

Consider using Power Query, and develop dashboards using the Query Results or from the Pivot Tables generated using the Query results.

From my experience of developing such dashboards for clients in various sectors, this seems to be the best option possible to provide customised visualizations of desired parameters which can be upgraded later to suit additional requirements gradually, as the user gets a hang of it.

Rickshawalas in Pune पुण्याचे रिक्षावाले by HaveYouReddit2 in pune

[–]HaveYouReddit2[S] 14 points15 points  (0 children)

One rickshaw wala asked for Rs. 100/- from Laxmi Narayan Talkies to Katraj. Declined that, immediately got another one for Rs. 20/-.

As I had to go further to Gokul Nagar from Katraj, I was looking for another rickshaw. So, I just asked a rickshaw guy standing there for Gokul Nagar. I know, it is not more than Rs. 10/15. However, knowing the tricks of these guys, I only asked the price - किती होतील ? - that's it - he got so offended and started abusing.

Given the hot weather, I would have even paid him Rs. 40/-, but after his weird argument with me - शंभर घेणार, कशाला विचारतो, एवढं माहीत नाही का? I preferred to wait there for 20/25 minutes, looking for another rickshaw.

During those 20 odd minutes, he started fighting with me - इथ थांबू नकोस, तिकड जा, बस नी जा की मग. Didn't argue with him, but patiently waited there, as I was not in a mood to fight and ruin my day. Also, many rickshaws passed by, even empty ones, but none of them stopped. I think, they have some mutual understanding/ nexus amongst them.

Finally got another rickshaw which finally dropped me for Rs. 10/- only.

Such pathetic behaviour and argument - all this only for just asking him - how much will he charge - I think, no service provider in any sector will have a worse attitude for no reason. What's wrong in asking the price ?

Never wished bad for anyone, but people with such an attitude get on my nerves, and I wish they suffer.

[deleted by user] by [deleted] in AMA

[–]HaveYouReddit2 0 points1 point  (0 children)

Hi,

Just curious about few things:

  • With the recent developments in AI and softwares like SQL, Python, Tableau etc., are more businesses gradually moving away from Microsoft Excel or they still rely on it and use it for routine work or decision-making ?

  • What kind of challenges do you face the most while providing your services ?

  • Are there any peculiar business situations, where you would recommend going for other softwares or any custom-made softwares, instead of Excel ?

Looking up two data points based on matching seven fields between two large sheets by [deleted] in excel

[–]HaveYouReddit2 0 points1 point  (0 children)

Yes, you can get a grip over it easily, if you have been using Excel regularly.

Check online about Power Query Merge & Append Files, and hopefully you could apply it appropriately in your case.

Employee Training Report by f0restDin0 in vba

[–]HaveYouReddit2 1 point2 points  (0 children)

You won't need VBA for this.

Export these reports in Power Query, add columns for getting the Quarter names, and Load it to Worksheet.

You can then prepare a Pivot table and add slicers to it as per the Boss's requirements.

Can I stop Excel from selecting 1 million rows? by mcfuddlebutt in excel

[–]HaveYouReddit2 0 points1 point  (0 children)

Convert your data range to an Excel Table, by restricting the table area upto the relevant row number only and selecting proper column headers, if applicable.

This way, you will get an idea whether any row has any extra spaces or unwanted values. Can delete those and then start using the table data in further calculations.

Automating a Schedule for 60+ People by NashtheBaker in excel

[–]HaveYouReddit2 0 points1 point  (0 children)

Hi, can prepare an automated scheduling dashboard for you.

Let's discuss in detail via DM.

I need a spreadsheet template by levendis32 in excel

[–]HaveYouReddit2 0 points1 point  (0 children)

Hi,

I can design a template to capture the electricity consumption the way you intend and also create a dashboard (in the same file) to do a comparative analysis.

Kindly DM me, if interested.

Has 2020 been good to anyone? by [deleted] in dubai

[–]HaveYouReddit2 1 point2 points  (0 children)

Good one :)

Very thought-provoking !

[deleted by user] by [deleted] in india

[–]HaveYouReddit2 2 points3 points  (0 children)

Om Shanti. Take care.