I have name changed for this as I am actively recruiting for 2 admin office based roles at the moment and have done a lot of CV sifting, working with recruiters and interviewing recently.
You have asked about office skills and the O365 suite is a bare minimum I would look for on a CV. Also Zoom or Teams experience is a must so you can coordinate meetings.
There are other skills that I need which are considered soft skills but are key in the sifting process. I would want to see experience of working in a team, stress tolerance and stability. Short term gigs on a CV or lots of changes are big red flags to me.
For me and my team, recruiting is about risk management. I need to know:
are you a risk to my existing team?
do you have sufficient skills to be able to do the job?
are you resilient enough for the workplace?
can you cope with change/are flexible?
can you 'hit the ground running'?
If I get the risk profile wrong it can be very costly in terms of time, money and conflict in the workplace.
In the spirit of being constructive I hope this helps.
At the moment, I would not hire you and you probably wouldn't get past the sift, even if you skilled up. Skills are the basic entry ticket, the soft skills are equally important and at the moment you pose too much of risk to me as a hiring manager.
You're a risk because you have a huge gap in your work history. Realistically I don't really know why that gap was there, you could give me your reasons but I would need to take them at face value which I wouldn't do. You could have been absent from the workplace for a multitude of reasons that could be detrimental to us as an employer.
You are late fifties, so in terms of flexibility I have no reference for how quickly you can adapt to new technologies or your willingness to embrace constant change.
Your previous qualifications and employment is irrelevant as its out of date.
I can tell you that at the present time, not only are you competing against younger candidates with a lot more relevant experience but you are also competing against higher qualified individuals who are looking for employment at a lower rung of the ladder to weather the current storm in the job market. I've had people with MBAs and PhDs applying for basic admin roles as they have been made redundant.
On the positive side, in your shoes I would get skilled up but I would do it through a volunteer position. Get upto speed on O365, Zoom/Teams, a finance app would also be useful from a CV perspective.
Do some admin based volunteering so you close that gap on your CV for at least a year. As long as it has a job title and you can get a reference. Then start applying next year once you have got back into the swing of it.
Professional references are key, relying on friends is a bit Mickley mouse. Its got to be someone you've worked with otherwise their assessment of you in the workplace is meaningless.
Its great people are encouraging you but you need to know the view from the otherside. Good wishes won't get you a job but some active realistic planning will.
Good luck.