How to Use the TAKE Function in Microsoft Excel Mary 4 hours ago How to Use the TAKE Function in Microsoft ExcelLearn how to use the TAKE function in Microsoft Excel to efficiently calculate totals and averages for the first or last rows of your data. Credit to: Chris Menard