I've only heard bad things about data entry positions tbh, but money is money doesnt hurt to take it. Regardless of any job tho, life is worth living. The worlds in a tough spot rn, a lot of positions are more competitive than they usually are bc everyones out of work. Better times ahead, stick around to see them
I understand pivot tables but need hand on experience to solidify it.
Not familiar with VBA.
it's basically a programming language within excel used to automate things. you can do things like simple work with cells (e.g. returning a random cell from a set range) or more complex stuff like combing your outlook emails and reading back metadata from within them.
that said i haven't used it in over 5 years now and honestly python is probably better than it at everything now, even within excel.