In fact, we often have to process data from a large excel file from sales software or data from HR software transferred for example.The work will be faster and more efficient if we combine the built-in tools of excel, Consolidate is a typical.Ĭonsolidate can generate a summary report of all selected data fields in a few simple steps.In this article, we will sum using the Consolidate tool in excel 2010 (excel 2007, 2013, 2016 is similar) 2. To understand more and better about the use of CONSOLIDATE, you refer to the article information below 1. Consolidate helps us calculate extremely effectively when integrated allowing quick performance of sum (sum), average (evergage), max, min. Along with the Pivot Table, the SUBTOTAL function, CONSOLIDATE is one of the very effective data statistics functions in Excel.
0 kommentar(er)
