Author Archives

jayant kodwani

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

VBA Basics – Part 1

Dear Readers, VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft. The Birth story of VBA VBA was derived from Visual Basic. The story of the birth of VBA began in 1991 when Microsoft partnered with Alan Cooper from Tripod under the project code named as “Ruby“. Microsoft decided […]

CAPM vs PRINCE2 Foundation: Which is better?

Confused on whether You should take CAPM or the PRINCE2 Foundation? See comparison between CAPM and PRINCE2 Foundation

PMP vs PRINCE2 Practitioner: Which is better?

Dear Readers, A lot of professionals looking out for a project management certification has been asking me these questions very frequently: Should I do PMP or PRINCE2? What is the difference between PMP and PRINCE2? Which one has more market value between PMP and PRINCE2? What is the eligibility criteria […]

We improve our products and advertising by using Microsoft Clarity to see how you use our website. By using our site, you agree that we and Microsoft can collect and use this data. Our privacy statement https://jayantkodwani.com/get-certified/privacy-policy/ has more details.
%d bloggers like this: