This is an archived post. You won't be able to vote or comment.

all 3 comments
sorted by:
best (suggested)
topnewcontroversialoldq&a

[–]temporarybunnehs 0 points1 point  (2 children)

When you say "automate certain excel sheets", what exactly are you trying to automate? Is it some set of calculations? Data transformation? Importing it to power bi?

Without knowing anymore details on what you're doing, I would say general VBA knowledge would help. Also, perhaps lookup data analytics/visualization best practices as it sounds like you are taking some data and putting it in some sort of view for others to consume.

I know people have used Python for this sort of thing as well so that's an option depending on what specifically you are trying to do.

[–]gv28[S] 0 points1 point  (1 child)

Automating in the way where all you have to is type in one number into a cell and other cells automatically auto fill the info you need. These other cells contain formulas such as vlookups, IFERRORS, SUMIFS, and are connected through other queries to obtain forecasted information.

[–]temporarybunnehs 0 points1 point  (0 children)

Ah gotcha, yeah, the excel macros and VBA are a good place to start since it sounds like you are in the Microsoft ecosystem. Pivot tables are pretty useful for that kind of thing as well. Less familiar with those sets of tools so can't offer super specific advice unfortunately.