borth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 year agoYou have 1 wish...sh.itjust.worksimagemessage-square88fedilinkarrow-up11.52Karrow-down117cross-posted to: techsupportmemes@lemmy.ca
arrow-up11.5Karrow-down1imageYou have 1 wish...sh.itjust.worksborth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 year agomessage-square88fedilinkcross-posted to: techsupportmemes@lemmy.ca
minus-squareCoupleOfConcerns@lemmy.nzlinkfedilinkarrow-up10arrow-down1·edit-21 year agoHonestly, since the introduction of ‘tables’, pivot tables, Power Pivot and Power Query, Excel is way more viable to be used as a database. Tables in particular mean that formulas fill down and the range automically resizes when records are added.
minus-squaredroans@lemmy.worldlinkfedilinkarrow-up4·1 year agoIirc tables are actually treated similar to databases on the backend.
Honestly, since the introduction of ‘tables’, pivot tables, Power Pivot and Power Query, Excel is way more viable to be used as a database. Tables in particular mean that formulas fill down and the range automically resizes when records are added.
Iirc tables are actually treated similar to databases on the backend.