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, […]
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, […]
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 […]
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 […]
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 […]
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. […]
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. […]
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 […]
Confused on whether You should take CAPM or the PRINCE2 Foundation? See comparison between CAPM and PRINCE2 Foundation
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 […]
Recent Comments