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
Category: Excel
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
Problems with PivotTable Running Totals and HOW TO FIX THEM
Microsoft Excel Tips and Tricks PivotTable running totals just don’t make sense sometimes. In this video I’ll show you why[…]
Read more