It’s 3:18 PM. You’re elbow-deep in the HR team’s latest compensation audit. Someone pasted 78 rows of ‘high school’-related job entries from LinkedIn Recruiter into Excel—but column B says 'Excel High School' next to salaries like $42,500 and $61,800. Your boss just walked by and asked, 'How much is Excel High School?' You stare at B5, where it reads Excel High School - Math Instructor (FT), and realize: nobody meant a school named Excel. They meant Excel as in Microsoft Excel skills—attached to high school teaching roles.
The Setup
This happens every quarter. HR pulls raw job-posting exports—often unstructured, inconsistently formatted, and full of ambiguous phrases. Below is a realistic slice (rows 1–9) from their Job_Posts_Q2_2024.xlsx file, copied into Sheet1 starting at A1:
| A: Job Title | B: Company | C: Salary | D: Location |
|---|---|---|---|
| Excel High School Teacher | Lincoln Prep Academy | $45,200 | Chicago, IL |
| High School Biology Teacher w/ Excel Skills | Summit Ridge HS | $51,900 | Austin, TX |
| Excel + High School Curriculum Designer | EdCore Solutions | $68,400 | Remote |
| High School Counselor (Excel reporting required) | Valley View HS | $56,100 | Portland, OR |
| Excel High School Admin Assistant | BrightPath Charter | $39,750 | Miami, FL |
| High School Math Teacher — Advanced Excel Modeling | Noble College Prep | $58,300 | Detroit, MI |
| Excel Training for High School Staff | State Ed Dept | $72,000 | Columbus, OH |
| High School Librarian (Excel data literacy focus) | Riverside High | $47,600 | Seattle, WA |
| Excel High School Internship Coordinator | TechBridge Youth | $36,200 | Atlanta, GA |
The Challenge
You need to answer: How much is Excel high school? But that phrase doesn’t refer to a school—it’s a conflation of two concepts: Microsoft Excel proficiency and high school education roles. The real question is: what’s the average salary for positions requiring both Excel skills and high school-level work? The problem? Excel appears in 7 of 9 job titles—but in wildly different contexts: sometimes as a modifier (w/ Excel Skills), sometimes as part of a compound noun (Excel Training), sometimes misleadingly front-loaded (Excel High School Teacher). Filtering by “Excel” alone would include irrelevant admin roles. Searching for “High School” alone would miss roles like Curriculum Designer or Internship Coordinator that serve high schools but don’t say ‘HS’ or ‘High School’. And yes—FIND() on “Excel” then “High School” separately fails when one term wraps the other (like “Excel + High School”).
Walking Through It
The beauty of this approach is that we don’t clean text—we reinterpret intent. We’ll use TEXTSPLIT() (available in Microsoft 365) to break each title into logical tokens, then flag rows where both “Excel” and a high-school-related term appear—not necessarily adjacent. Here’s how:
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | In E1, enter: =LOWER(A1). Drag down to E9. | All titles in lowercase for case-insensitive matching | — |
| 2 | In F1, enter: =TEXTSPLIT(E1," "). Press Ctrl+Shift+Enter if not in M365; otherwise just Enter. | Creates dynamic array: {"excel","high","school","teacher"} in F1:I1 | Alt+M, Alt+U, Alt+S (to insert TEXTSPLIT) |
| 3 | In G1, enter: =OR(ISNUMBER(SEARCH("excel",E1)),ISNUMBER(SEARCH("xls",E1))) | TRUE for any row containing 'excel' or 'xls' (catches 'Excel', 'excel', 'XLS') | — |
| 4 | In H1, enter: =OR(ISNUMBER(SEARCH("high school",E1)),ISNUMBER(SEARCH("hs",E1)),ISNUMBER(SEARCH("charter",E1)),ISNUMBER(SEARCH("prep",E1))) | TRUE if title references high school context—even without saying 'high school' | — |
| 5 | In I1, enter: =AND(G1,H1). Drag all formulas down. | Only rows 2, 3, 4, 6, 7, and 8 return TRUE | Ctrl+D (to fill down) |
What makes this elegant is step 4: we’re not just looking for literal phrases—we’re mapping semantic intent. “Charter” and “Prep” are strong proxies for high school in US education jargon. And yes—this catches the Excel Training for High School Staff role (row 7), even though “Excel” and “High School” are separated by three words. That’s the counterintuitive bit: Don’t force proximity. Prioritize coverage over syntax.
The Result
After filtering for TRUE in column I (I1:I9), here’s exactly what qualifies as 'Excel high school'—i.e., roles demanding Excel skills in a high school context:
| Job Title | Company | Salary | Context Flag |
|---|---|---|---|
| High School Biology Teacher w/ Excel Skills | Summit Ridge HS | $51,900 | w/ Excel Skills |
| Excel + High School Curriculum Designer | EdCore Solutions | $68,400 | Excel + High School |
| High School Counselor (Excel reporting required) | Valley View HS | $56,100 | Excel reporting required |
| High School Math Teacher — Advanced Excel Modeling | Noble College Prep | $58,300 | Advanced Excel Modeling |
| Excel Training for High School Staff | State Ed Dept | $72,000 | Training for High School Staff |
| High School Librarian (Excel data literacy focus) | Riverside High | $47,600 | Excel data literacy focus |
Average salary = =AVERAGE(C2,C3,C4,C6,C7,C8) → $59,050. That’s your answer to “How much is Excel high school?” — not a price tag, but a market-rate benchmark.
What Could Go Wrong
Three real mistakes I’ve seen derail this exact analysis:
- Mistake #1: Using
FIND()instead ofSEARCH().FIND()is case-sensitive. SoFIND("Excel",A1)returns #VALUE! on “excel high school teacher”.SEARCH()handles case variation—and works insideISNUMBER()cleanly. - Mistake #2: Forgetting to anchor search terms in quotes. Typing
=SEARCH(Excel,A1)(no quotes) throws #NAME?. Excel reads “Excel” as a range name—not text. Always quote literals:"Excel". - Mistake #3: Assuming “High School” must appear verbatim. In our sample, row 7 (“Excel Training for High School Staff”) qualifies—but if you only search for “high school”, you’ll miss row 3 (“Excel + High School Curriculum Designer”) because the split creates “high” and “school” in separate cells, breaking contiguous search. That’s why step 4 uses
SEARCH("high school",E1)on the original lowercase string, not the split array.
Next time you see “how much is Excel high school”, skip the Google search. Open your file, go to cell E1, type =LOWER(A1), and press Enter. Then Alt+M, Alt+U, Alt+S—and watch the real story emerge.
