Excel Conditionally Format Dates Within x Number of Days From Today’s Date
Microsoft Excel Tips and Tricks In this Excel video tutorial I explain how to conditionally format dates that are within[…]
Read more
Tag: Excel
How to Write Power Query if Statements incl. Nested ifs, if or, if and with the IF function
Microsoft Excel Tips and Tricks Power Query if statements using the Power Query if function are easier to write than[…]
Read more
How to Create a Four Quadrant Chart in Excel | Quadrant Scatter Plot | Quadrant Matrix Chart
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate how to create a quadrant chart. A[…]
Read more
Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate two ways of counting or summing checked[…]
Read more
Xlookup Sum of All Matches Using Excel | Xlookup or Sumif? | Xlookup or Sumproduct?
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I demonstrate how to calculate a sum of all[…]
Read more