Have you looked into powerpivot in Excel? I learned how to use it, then eventually moved into using Power BI, and now that's what I do for a living. Powerpivot

Have you looked into powerpivot in Excel? I learned how to use it, then eventually moved into using Power BI, and now that's what I do for a living. Powerpivot unlocks so much potential in Excel, and it allows you to have millions of rows of data and work with it seamlessly. It also allows you to create relationships between tables instead of using vlookups. If you haven't tried it, look at some introductory videos on youtube. It will blow your mind.