Related Posts
Who’s working this Sunday?
Hi All,
I am in a process of receiving offer from citi, its almost 43% hike on cctc.
What is the appraisal cycle in citi? and if I dont complete a year before appraisal ,is there any default hike that they provide?
Cctc: 18.14
Citi:26
YOE : 6.1
This is my first offer and I dont want to go for any service based companies. Citi is a good firm according to me and I dont want loose the offer because of over negotiating
Citi
Additional Posts in Excel Genius
Time to convert to xlookup
why is index match superior to vlookup?
I truly appreciate this group.
New to Fishbowl?
unlock all discussions on Fishbowl.
Probably try a course on Udemy? I’ve taken 2-3 courses on there and they’ve helped me get a good understanding of the environment to know where to go next.
There’s a lot of excel functionality in VBA (I am NOT an expert in any means) which you can take advantage of. The most intense macro I made was able to do order entry in SAP from an Excel form.
Alteryx is generally going to be your best option for excel formatting a batch of tabs/files provided all of the tabs are in the same format
Don't get me wrong, I love Excel because of it's familiarity - but isn't that more along the lines of what the Alteryx is for? I haven't yet used/experienced Alteryx but I that's what I ascertained from it's "hype" & "presentation"
So you don’t need to use a macro to pull in the data. You can utilize the query editor and power query to do aggregate the data from other sources and translate if necessary.It’s very easy to do and you can connect both to excel data files as well as other sources - SAP SQL server, Azure Synapse, SAP, SFDC.
As for alteryx, I have used it and yes you can achieve the same result. In terms or aggregating and summarizing. It very powerful. We have been testing it out at work the last few months