How to Import Data from the Web in Excel
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to import and dynamically connect web data to your[…]
Read more
Tag: Excel
If Time is Within Range | If Time is Greater Than or Less Than, Return Value
Microsoft Excel Tips and Tricks In this video I demonstrate how to do the following: 1) Perform an IF statement[…]
Read more
IF and VLOOKUP Nested Function | VLOOKUP with a Drop-down
Microsoft Excel Tips and Tricks In this video I explore combining IF with VLOOKUP. 1) In the first scenario I[…]
Read more
Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text
Microsoft Excel Tips and Tricks In this video, I demonstrate how to combine concatenation with an IF condition. In the[…]
Read more
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