(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Average last 5 values in columns in Excel.   Excel formula for Beginners – How to Average last 5 values in columns in Excel Generic formula =AVERAGE(OFFSET(firstcell,0,COUNT(rng)-N,1,N)) Explanation To average the last 5 data values … Continue reading Excel formula for Beginners – How to Average last 5 values in columns in Excel