4 ms·
Have you used the data model features in newer versions of Excel? I haven't really used them myself (I generally keep all my code in SQL and just use Excel as a
by tfehring 6y ago
Have you used the data model features in newer versions of Excel? I haven't really used them myself (I generally keep all my code in SQL and just use Excel as a frontend) but my impression is that Microsoft is trying to do exactly that. https://support.office.com/en-us/article/Create-a-Data-Model-in-Excel-87E7A54C-87DC-488E-9410-5C75DBCB0F7B https://support.office.com/en-us/article/Create-a-Data-Model...
- qubex 6y agoI’ve never really get very at home with Excel. I’ve used Lotus Improv, Quantrix Modeler, Apple Numbers and XCubes. Then again I’ve got to the point where I build my balance sheets and profit & loss accounts as Python objects...