Use Power Pivot, Power Query, and VBA (Macros) which are limited or unavailable online.
Go to office.com and sign in with the Microsoft account associated with your purchase or subscription. download excel desktop app
If you are building a data model that relates five different tables to one another to drive a Pivot Table, you need the desktop app. The ability to define relationships, create measures using DAX (Data Analysis Expressions), and manage the data model is a desktop-exclusive stronghold. Use Power Pivot, Power Query, and VBA (Macros)