✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
Excel has a wide range of tools to group and summarize information, such as Dynamic and Subtotal tables, however in this tutorial we will see a very interesting way to summarize information, and that is, with the fabulous Power Query tool.
In our example file we have a table of data which we wish to group information. The group we want is based on BRANCH and SELLER, that is, we want to know the quantity of PRODUCTS sold by each SELLER in each BRANCH and know the SUM OF products sold.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
8 сен 2024