Summary Table Documentation Requirements for Self Mass Gov Mass Form

Instructions and help about Summary Table Documentation Requirements For Self Mass Gov Mass

hey guys in this video we are going to discuss that in microsoft excel how we can quickly create or how we can quickly prepare a summary report from a detailed report for example here we have detailed sales report in which we have customer name units sold and invoice amount if we go down in this detailed sales report we can see that there are almost 7000 rows or 7000 lines so from such a detailed sales report how we can quickly prepare a summary report before we create a summary report we need to identify that on which base we want to create some report as this is sales report sales to different customers that how many units are sold and what is invoice amount for different customers so obviously we want to create summary report based on customers so after we identify base on which we want to create our summary report we can go to data tab in data tab we can go to advanced filters and in advanced filter window in list range we can select the column based on which we want to create our