How to Use the TAKE Function in Microsoft Excel Mary 2 months 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