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
Tag: Excel
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
Create a Multi-Category Chart in Excel | Multi-Level Category Labels in Excel Chart
Microsoft Excel Tips and Tricks In this video I demonstrate how to create a chart that features multi-level categories. The[…]
Read more
Ageing Analysis in Excel Using IF Formula & PivotTables | Accounts Receivable Report
Microsoft Excel Tips and Tricks In this video I demonstrate how to perform ageing analysis in Excel. We want to[…]
Read more