borth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 year agoYou have 1 wish...sh.itjust.worksimagemessage-square102fedilinkarrow-up11.53Karrow-down117
arrow-up11.51Karrow-down1imageYou have 1 wish...sh.itjust.worksborth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 year agomessage-square102fedilink
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.