In simple words, this feature helps you connect one set of data with another set of data so that you can create combined pivot reports. If you are one of those, then you are going to love Excel’s data model & relationships feature. They connect table 1 with table 2 so that all the data needed for making that pivot report is on one place. Every day, millions of analysts and managers enter VLOOKUP hell and suffer. Its what happens when you have to write a lot of vlookup formulas before you can start analyzing your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |