Author Archives

jayant kodwani

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 […]

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 […]

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 […]

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, […]

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, […]

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 […]

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 […]

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 […]

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. […]

PMP EVM (Earned Value Management) terms and formula calculator with Mock Exam in MS Excel Spreadsheet

As per PMBOK, Earned Value Management is a methodology that combines scope, schedule, and resource measurements to assess project performance and progress. Earned Value has been one of the most important topics for PMP exam and you cannot risk your exam without understanding EVM terms, formulas and calculations. […]