Combine Date and Text Formula | Combine Date and Time in One Cell | Concatenate Current Date & Text
Microsoft Excel Tips and Tricks In this video I demonstrate how to combine date, time and text in a single[…]
Read more
Tag: Excel
Excel Add A Blank Row After Each Subtotal
Microsoft Excel Tips and Tricks Your manager asks if you can add a blank row after each subtotal. Episode 2433[…]
Read more
INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick
Microsoft Excel Tips and Tricks Learn how to create an advanced array formula to spill two-way lookup results using INDEX[…]
Read more
Perform a T-Test in Excel | Get P Value from T-Test in Excel
Microsoft Excel Tips and Tricks I demonstrate how to perform a T-Test in Excel. Credit Chester Tugwell
Read more
Calculate Variance and Standard Deviation in Excel
Microsoft Excel Tips and Tricks In the video I demonstrate how to calculate variance and standard deviation in Excel. The[…]
Read more