To pass an Excel skills test in a job interview, practice the basics until they are automatic: clean data entry, SUM and AVERAGE formulas, sorting, filtering, formatting and simple charts. Ask what version of Excel the test uses, read every question twice, and check your answers. Our Microsoft Excel & Office Essentials class gives you hands-on practice with these exact skills.
What Excel tests usually cover
Tests vary by employer, but entry-level office tests tend to focus on everyday tasks:
- Entering and editing data accurately
- Writing basic formulas like SUM, AVERAGE, MIN, MAX and COUNT
- Copying formulas and using absolute references with dollar signs
- Sorting and filtering a list
- Formatting cells as currency, percentages or dates
- Creating a chart from a small table
- Sometimes IF formulas, lookups or a basic pivot table
Some tests are timed and run in a testing website. Others hand you a file and ask you to complete tasks while someone watches. Either way, speed comes from practice, not memorizing.
How to prepare in the week before
- Ask the recruiter what to expect. It is fine to ask what skills are tested and what version of Excel they use.
- Practice with real data. Make a list of 50 items with names, dates, amounts and categories. Sort it, filter it, total it and chart it.
- Learn a few shortcuts. Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+Arrow keys to jump, and Ctrl+Shift+Arrow to select save time.
- Time yourself. Repeat the same tasks until they feel easy.
- Review mistakes. Note what slowed you down and practice that part again.
On test day
- Read each question twice. Many errors come from answering a slightly different question.
- Do the easy questions first if the test lets you skip around.
- Do not panic over one hard task. Move on and come back.
- Check that formulas reference the right cells before you submit.
- If someone is watching, talk through your steps. Showing clear thinking helps.
Turn the test into a talking point
After the test, interviewers often ask how you use Excel. This is where a portfolio project helps. In our class you build a portfolio spreadsheet project you can describe with confidence: what the data was, which formulas you used and what the chart showed. That turns a test score into a story.
For more interview help, read our interview tips. Our Career Readiness program also includes mock interviews; see the programs page.
Class details
- Class: Microsoft Excel & Office Essentials, 12 hours total.
- Evening cohort: Tuesdays and Thursdays, 6:00 to 9:00 PM Pacific, December 1 to 10, 2026.
- Saturday cohort: January 9 and 16, 2027, 9:00 AM to 3:00 PM Pacific.
- Format: in person at 255 N. D Street, Suite #200-XXVII, San Bernardino, CA 92401, or live online from anywhere in the U.S.
- Price: $297.
- What you get: hands-on practice with Excel formulas, sorting, filtering, charts and a simple budget, plus Word documents, resumes and letters, Outlook email and calendar, and a portfolio spreadsheet project you can show employers.
How to enroll
- Apply online. It takes about 2 minutes.
- Pay with the Excel & Office Essentials pay link or see every option on the tuition page.
- We confirm your seat within 2 business days.
Not sure yet? Join our free Info Session & Orientation, online every Monday from 5:00 to 5:45 PM Pacific. Register on the enroll page to get the link.
FAQ
What if the test uses a different version of Excel than I practiced on?
The basics work the same way across recent versions. Menus may look a little different, so take a moment to look around before you start.
Will this class guarantee I pass an employer's test?
No class can guarantee that, since every employer's test is different. The class gives you structured, hands-on practice with the skills these tests commonly check.
Can I take the class online from outside California?
Yes. The class is offered live online from anywhere in the U.S. and in person in downtown San Bernardino.
Questions? Call or text (909) 454-7076.