Thanks for all the helpful replies!
MS Office is a lot more than Word and Excel. Our Admin also has to know Outlook well for email and calendars. If I were you, I would take classes and practice at home. If you don’t want to buy MS Office for Mac, you can try an Office 365 subscription. Good luck!
After 13 years of working together, our clinical director still needles me occasionally for having said I knew Excel on my resume. I knew what Excel was… 
She even sent me to 2 courses, and I still don’t like it/ avoid it whenever possible/get stressed by it/ never really got it. I simply do not have a brain that works well with spreadsheets. I’d recommend learning it and not faking it like I did… there are great workbooks out there for learning Microsoft Office.
Oh goodness, I just love love love Excel!! It works perfectly with my brain!!
You can’t become proficient with Office (especially Excel) from a course or courses. Knowing the keystrokes is a far cry from being able to apply the knowledge.
I hire people that have to be proficient in Office. I can spot a paper Office expert a mile away. If a job wants proficiency it requires experience.
This thread made me think of this story.
“His students need to pass a national exam that includes questions on information and communication technology (ICT) – but the school hasn’t had a computer since 2011.
So Akoto had an ingeniously simple idea: he drew computer features and software on his blackboard, using multicolored chalk.
“I wanted them to know or see how the window will appear if they were to be behind a computer,” Akoto told CNN. “Always wanted them to have interest in the subject so I always do my possible best for them.”
https://www.cnn.com/2018/03/01/africa/ghana-teacher-blackboard-intl/index.html
Where there’s a will, there’s a way!
I agree that classes in Excel don’t really teach you how to use it effectively. That can only be learned on the job in the real world. I never had a job that required Excel so I never learned it. In my current job I have to use Excel spreadsheets that someone developed long ago for things like payroll. I’m fine using them. It’s when I have to change them that I get in trouble. And there’s no one else there who knows it any better than I do. Excel classes haven’t worked so far because they never address the specific problem I’m having. What I really need is an Excel guru who can come by and show me how to do things as they come up.
I love Excel too, but I actually use hardly any of it. Pivot tables? Macros? Don’t need them. When my kids were young we figured out how to do various charts and graphs together. For a summer job, my younger son somehow turned an excel spread sheet into a map of the dorms they were renting out for the summer so they could keep track of reservations. AFAIK they are still using the system he designed. (They told him if he was going to redesign the system he needed to train his successor and provide a manual.)
I use Publisher, Word, and Excel almost every day, Powerpoint rarely, Access never. But I’d hardly call myself an expert. So glad I’m not job hunting! Computer classes unfortunately are generally geared to the lowest common denominator, you probably know more than you think, but not as much as your employer would like.
if you have friends that work for large (or perhaps medium) sized companies, ask if they have access to the Microsoft Home Use program and can buy a copy. I think it is around $10 or $15 for the entire Office Suite. You want to get Office 2019, not the new Office 365 which is just a subscription instead of the complete software. See https://www.microsoft.com/en-us/home-use-program?rtc=1 and also the answer to the FAQ “What has changed with the Home Use Program? Why am I not seeing an option to purchase Office Professional Plus 2019”
If you take that class at the CC then they may have free or discounted Office software.
Then you can do some of the online training to practice. I’d think you’ll want basic proficiency in using Word, Excel, Powerpoint.
Definitely learn to use Outlook. Big-company log-in access and passwords may come as a email link. If you are doing administrative work, your might need to set up or look at group calendars and set up appointments, using Outlook to determine when everyone is available. You could get stuck and embarrassed on the first day if you didn’t know use Outlook.
In my office, everyone sends their own emails, with the executives having assistance with official company-wide messages. I use Excel and Word all day every day in my position and any admin in our area would need to know about the control function short-cuts, etc. that would come from a class or online guided lessons.