gigastasio@sh.itjust.works to Ask Lemmy@lemmy.world · 5 days agoWhat's that video game boss you've never been able to beat, or took you the longest to beat?message-squaremessage-square235linkfedilinkarrow-up1145arrow-down12
arrow-up1143arrow-down1message-squareWhat's that video game boss you've never been able to beat, or took you the longest to beat?gigastasio@sh.itjust.works to Ask Lemmy@lemmy.world · 5 days agomessage-square235linkfedilink
minus-squarebstix@feddit.dklinkfedilinkarrow-up3arrow-down1·4 days agoPivot tables are great because they force people to put their data into tables. Formulas suck. You only need sum. Everything is a sum, if you enter your data correctly in a table. Want to substract? yes, that is a sum in which one of the numbers are negative. Multiply? Yes that is more sums. What about IF statements then? No, no, no. Conditions are simply factors in a sumproduct. Learn the keyboard shortcut for sum. It’s the straight edge and compass of excel math.
Pivot tables are great because they force people to put their data into tables.
Formulas suck. You only need sum. Everything is a sum, if you enter your data correctly in a table.
Want to substract? yes, that is a sum in which one of the numbers are negative. Multiply? Yes that is more sums.
What about IF statements then? No, no, no. Conditions are simply factors in a sumproduct.
Learn the keyboard shortcut for sum. It’s the straight edge and compass of excel math.