Since I’m used to twiddle with pivot tables, I’ve tried to use one of them in the spreadsheet I use to register all my expenses with Libreoffice. Pivot table are one of them, at work for me they are vital. It’s very useful, it has a lot of potential, even though excel files can become outrageously heavy and you need a Xeon CPU just to add one column in a reasonable time.Īnyway, Excel is commercial and proprietary software, you have to pay for it and you can appreciate its plus only when you heavily use it, in all its advanced feature.
Excel’s Power Pivot lets you manage data like a SQL database without having the SQL infrastructure installed on your PC. If you’re familiar with relational databases, you have already guessed where I’m going to. If you don’t know, Power Pivot is a tool introduced starting from Office 2010 allowing to manage data in Excel and create Pivot tables taking data coming from several sources. They also had me do a course on Power Pivot. I work in a big company and one of my daily work companion is MS Office, in particular Excel.
0 kommentar(er)
