How to Write Power Query if Statements incl. Nested ifs, if or, if and with the IF function
nnnn Microsoft Excel Tips and Tricks nPower Query if statements using the Power Query if function are easier to write[…]
Read moreCategory: Uncategorized
How to Create a Four Quadrant Chart in Excel | Quadrant Scatter Plot | Quadrant Matrix Chart
nnn Microsoft Excel Tips and Tricks nIn this Microsoft Excel video tutorial I demonstrate how to create a quadrant chart.[…]
Read moreCount Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
nnnn Microsoft Excel Tips and Tricks nIn this Microsoft Excel video tutorial I demonstrate two ways of counting or summing[…]
Read moreWhy use Agile ways of working for project management?
nnnn Project Management nIn this discussion we’re looking at why you would use Agile, and we’ll be going through a[…]
Read moreAgile is the Future of Project Management
nnnn Project Management nAgile is the future of Project Managementnnnn Credit Project Management Craft n
Read moreThe Critical Path Method: A Game-Changer for Project Managers
nnnn Project Management nIn this video, we’ll discuss the Critical Path Method (CPM), a project management technique that helps you[…]
Read moreChatGPT Builds WBS in 10 Seconds! PMPs & Project Managers Observe!!
nnnn Project Management nAI and automation may replace some of the routine tasks that project managers currently perform. For example,[…]
Read more5 AI-Powered Tips and Ideas to Enhance Your Project Management
nnnn Project Management nWith the release of ChatGPT last year, it is clear that AI has made massive advancements and[…]
Read moreXlookup Sum of All Matches Using Excel | Xlookup or Sumif? | Xlookup or Sumproduct?
nnnn Microsoft Excel Tips and Tricks nnIn this Microsoft Excel video tutorial I demonstrate how to calculate a sum of[…]
Read moreAutofill Dates in Excel Based on Another Cell | Increment Dates Using Formula – Days, Weeks, Years
nnnn Microsoft Excel Tips and Tricks nIn this Microsoft Excel video tutorial I demonstrate how to autofill dates based on[…]
Read more