I would like to gain new skills that help me get job in Banking industry. Do you suggest me to learn Visual Basic, Microsoft Access or SQL?
Or any other program more practicle than the above?
I heard that Visual Basics is dieing
if you in the industry can you give me some advice?
agree. any books/pdf/epub you can suggest for someone with good excel (but only formulas) to start learning vba and advance macros?
Sorry, don't know.
I personally just googled what I needed to do if I couldn't do it. If I still couldn't I just asked the more experienced members of my team to teach me, if they didn't know, thats when we went to the propeller heads in the technology department!
Recording yourself doing stuff, then modifying the code was usually more than enough to at least semi automate some processes.
master excel and you will succeed
not just basic excel but visual basic / macros
Could you give some examples of when we might need macros in a banking/finance scenario? Are your examples purely based on IT-type roles?
Any task in Excel that can be automated or semi automated with macros.
Formatting a shitty report so it readable for example.
I suggest getting to English classes first.
Plenty of "propeller heads" are terrible at English…
Banking and finance need people with good communication skills (oral and written) e.g Preparation of documents and dealing with clients. can't see why OP can't do both at the same time. Study English and whatever is being suggested on this thread.
Agree. That applies to many white collar jobs, if not life in general though.
My point is a lot of technical people won't always have direct contact with external clients. They can sometimes just stay in the dark, windowless technology sections, heads down in code, being awkward with people…thats they way some of them like it.
Yes they may have internal clients (other team members/departments), but English is not necessarily high up there for that interaction.
program? no need!@!@!#!
important skills? YES!: sweet talks and office politics
python
What type of role are you after?
Front office, back office, IT development?
that is a very good question Xeno which applies if OP needed to do further English classes.
What do you want to do? You can be the office cleaner with no need to study
I am in the industry, I can give you more ideas if you provide more details. Like others have asked, you have to tell us what kind of role.
Strong Excel skills are needed (or just very useful) for all roles - as well as Outlook and PowerPoint.
"I would like to gain new skills that help me get job in Banking industry. "
Here you go. Will also work if you go into politics.
https://www.amazon.com/Complete-Idiots-Guide-Mafia-Second/dp…
communication, you don't need any skills if you can talk sh*t
Current BIT student myself.
VB completely phased out. A lot of resources getting put into SQL now.
I worked in Banking and Wealth Management for 10 years over 2 of the Big 4.
Out of all the above choices I would easily choose SQL.
Many large companies increasingly discourage people using MS Access because of the potential to have multiple sources of the same thing. Especially for banks, they want one source of truth so they it can be all data warehoused and then all that valuable data can be used for things like CRM.
In my current role having to deal with teams who keep their own data is a PITA, there are so many MDB and accdbs to interrogate.
SQL is also a portable skill as it is used in almost all industries in some form. Demonstrating your ability to interrogate systems for data and then presenting it is highly desirable for employers.
Arguably the greatest ozbargain thread of all time
fortran 77
SQL out of those three. down mySql for SqlExpress and create your own transaction db
id become a pro at excel too, excel will be around longer than cockroaches.
Depends on the role? But I would think in general SQL would be first then VBA and Access are about the same level.
When I got a got at a bank I had no formal experience with these, but learned on the job.
Funnily/scarily enough, excel (with a bit of VBA) was used the most in my day to day activities. I demonstrated enough knowledge of Excel in my interviews to get the job I suppose…which wasn't that much to begin with.