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
The Learning Zone
Dedicated to everything Learning, learning is fun
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
Excel Sum Across Worksheets When Rows Are Lined Up Or Not – 2572
Microsoft Excel Tips and Tricks Some call it a 3D reference or a spearing formula. If your Excel worksheets are[…]
Read more
Interactive Dashboards in Excel: Microsoft Excel Crash Course
Microsoft Excel Tips and Tricks In this Microsoft Excel tutorial, we’ll walk you through creating an interactive dashboard in Excel[…]
Read more
5 MIN ARM WORKOUT – With Weights (Upper Body Toning)
Fitness Tips Short on time? Try this 5 min total upper body session with dumbbells! Targets biceps, triceps, shoulders, and[…]
Read more