3 ms·
you can do this with pivot tables. if your database has more than 1m entries you can do some preprocessing with powerquery. you don't even have to learn a sing
by princeb 6y ago
you can do this with pivot tables. if your database has more than 1m entries you can do some preprocessing with powerquery.
you don't even have to learn a single line of new code, if you've never coded before. you only need to know how to point and click with a mouse.
and the best thing is, you can take whatever you've done and send it down to whoever happens to have installed Excel on their machine, which, in a corporate environment, is everybody. Don't need to set up a new programming environment + dependencies.
- socialdemocrat 6y agoJulia is just as easy to install as Excel. There is literally no difference. If you cannot do a one click install, then how are you supposed to figure out how to make a Pivot table? Of course learning to code is a higher barrier. I don't think anybody challenges that. But as you begin using Excel much beyond the trivial I will argue it is actually easier to learn how to code. Code has the advantage, that it is very easy to document and explain with text. Explaining how to do things in a Excel through text is not easy. You will need images, videos etc which are not searchable. You cannot copy-paste and image to repeat an operation from Excel. With code in contrast you can copy and paste in code you find in blogs, help documentation or anywhere else. Basically is much easier to reuse and modify. Once you learn how to code you can advance your capabilities much quicker.
- princeb 6y ago> If you cannot do a one click install corporate IT security policies very often block installs of any kind.