Lookup the Last Value in a Column or Row in Excel
Microsoft Excel Tips and Tricks In this video I demonstrate how to lookup the value in the last non-empty cell[…]
Read more
Author: Noel
Excel Wildcard IF – NOT WORKING! | If Cell Contains Text Then…
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform a wildcard “contains” test in an IF[…]
Read more
SUMIFS & COUNTIFS Partial Match | Part of Cell Contains Text
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform partial match SUMIFS and COUNTIFS calculations using[…]
Read more
Easily Compare Multiple Tables in Power Query
Microsoft Excel Tips and Tricks Learn how to easily compare 3 or more tables in Power Query and avoid having[…]
Read more
Auto Refresh PivotTables & Queries – without VBA!
Microsoft Excel Tips and Tricks Auto Refresh PivotTables isn’t on by default, and the process differs depending on whether your[…]
Read more