The Clash of the Billions @ Galwan Valley

Today is one of the most saddening and unprecedented day in India-china relationships. Two countries which represent 1/3 of humanity have come to tussle where the soldiers have been martyred at both sides (china yet to accept it). Indian, Chinese troops clashed in Galwan area for a violent […]

Share with:


VBA Macro to Split Single Excel file into Multiple Excel Files basis any row count

Dear Readers,  A strong command in MS Excel is one of must have skill for every professional but an expertise in VBA is a lifesaver. Recently, I encountered a common situation where a platform had a limitation of accepting excel files with no more than 1000 rows. This […]

Share with:


Watching ISS International Space Station amid COVID-19 lockdown

The world has come to a halt due to Coronavirus pandemic and like millions of others, I have been working from home. This means that I am saving around 3-4 hours of office commute and now getting some extra precious time to spend on my interest areas. It […]

Share with:


Income Tax 2020 Regime Decision Maker

Still confused on which Income Tax 2020 regime you should opt for??  Relax, you are not the only one. In the annual budget for 2020 announced on 1 Feb 2020, finance minister Nirmala Sitharaman said that taxpayers, should they choose to forego all exemptions, will now pay across six tax […]

Share with:


Bye Bye VLOOKUP, Welcome XLOOKUP!

Yes, its true, It is time to forget Vlookup, Hlookup, Index-Match as Microsoft Excel is now fully loaded with XLOOKUP. This best in breed function is called XLOOKUP as it can do Cross lookup (*vertically as well as horizontally). Here is the quick syntax: =XLOOKUP (lookup_value, lookup_array, return_array, […]

Share with:


How to Count Distinct in a pivot table?

Hello Learners, Today, I am going to talk about a handy and simple Excel formula which can help you count distinct values in a pivot table. When we create a pivot table and look for field values options we can see that we can summarize values by Count, […]

Share with:


My Australian Visa Journey Part-2 (Step by Step Guide for applying Business visitor subclass 600 through Immiaccount)

Step by Step Guide for applying Online Step 1:- ImmiAccount Create your ImmiAccount via https://online.immi.gov.au/lusc/login You will be required to provide basic but the most important information such as your Family name (aka surname, Last name) and Given name (aka First name) and contacts details like email address […]

Share with:


My Australian Visa Journey Part-1

Dear Readers, Its been a long time since my last post and I am really eager to share what I have been doing so far. So, recently I got this lucky onsite opportunity for visiting Sydney, Australia for official purposes. It is indeed quite an exciting moment when […]

Share with:


Mastering PERT/BETA/3 Point Estimate and Six Sigma PMP Questions

As per guide to PMBOK Schedule Management Knowledge area, Estimate Activity Durations is the process of estimating the number of work periods needed to complete individual activities with estimated resources. The key benefit of this process is that it provides the amount of time each activity will take to complete. This […]

Share with:


How to Book a Tiger Safari at Ranthambore National Park

Dear Readers, Majority of tourists (domestic as well as Foreign) don’t know how to online book Tiger safari at Ranthambore through official means and end up booking safari at higher prices through Hotels and touts.  Hotels/agents charge 40-70% higher than the genuine amount  basis the season and availability. […]

Share with: