A query re computer software knowledge and workplaces?

Greetings All,
Hoping someone can point me in the right direction!
Long story short, I have minimal computer knowledge, at school we had "Amstrad" and "BBC" computers, I was apprenticed into a trade and never needed to use a PC for work purposes, I currently have a job where I do have a PC yet it is predominantly used for an inhouse programme called PRISM, I am reasonably confident in the use of the WORD programme, yet it falls away pretty rapidly after that as I have had no formal training in anything else.
I am in a position where I am giving serious thought to a career change, yet realise that in order to do so I will no doubt have to update my skills in this area and I am unsure of which programmes are likely to be the base requirement for a new job? I have seen Excel and Powerpoint before but have never used either of them before, but assume they probably would be ones to look at.
Can anyone give me any advice on what are likely to be the most popular programmes in workplaces and what they are used for?
I am planning to look into some formal training but want to have done some research first so any suggestions you can offer would be more than appreciated!
Hoping someone can point me in the right direction!
Long story short, I have minimal computer knowledge, at school we had "Amstrad" and "BBC" computers, I was apprenticed into a trade and never needed to use a PC for work purposes, I currently have a job where I do have a PC yet it is predominantly used for an inhouse programme called PRISM, I am reasonably confident in the use of the WORD programme, yet it falls away pretty rapidly after that as I have had no formal training in anything else.
I am in a position where I am giving serious thought to a career change, yet realise that in order to do so I will no doubt have to update my skills in this area and I am unsure of which programmes are likely to be the base requirement for a new job? I have seen Excel and Powerpoint before but have never used either of them before, but assume they probably would be ones to look at.
Can anyone give me any advice on what are likely to be the most popular programmes in workplaces and what they are used for?
I am planning to look into some formal training but want to have done some research first so any suggestions you can offer would be more than appreciated!