borth@sh.itjust.works to Memes@lemmy.mlEnglish · 2 years agoYou have 1 wish...sh.itjust.worksimagemessage-square90fedilinkarrow-up11.53Karrow-down117
arrow-up11.51Karrow-down1imageYou have 1 wish...sh.itjust.worksborth@sh.itjust.works to Memes@lemmy.mlEnglish · 2 years agomessage-square90fedilink
minus-squareCoupleOfConcerns@lemmy.nzlinkfedilinkarrow-up10arrow-down1·edit-22 years 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·2 years 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.