Home › Pass AP
Pass AP, EHL BOSC 1 Mathematics & Excel finalPass the EHL Maths & Excel final (AP): Excel guide
Every Excel topic that comes up in the EHL Mathematics & Excel final, explained the way we teach it in private lessons: when the exam asks for it, the exact formula, a worked hotel example, the traps that cost points and a practice question.
- 15 topics
- Free
- Exam-focused
- Worked examples
Functions, counting and logic
$TOPIC 01Cell referencing ($ signs)When you drag a formula, Excel moves the cell references with it. A dollar sign stops that movement. A $…Open →ΣTOPIC 02Core statistical functionsThe basic functions are easy points in the exam, as long as you pick the one that matches the words of…Open →%TOPIC 03Share of total and $ referencesWhen the exam asks for each row's contribution to the total, divide the row by the grand total, and lock…Open →#TOPIC 04COUNTIF / COUNTIFSUse COUNTIF or COUNTIFS when the question asks “how many?” for a specific condition or several…Open →⇄TOPIC 05XLOOKUPXLOOKUP searches for one value in a reference table and returns the related information from another…Open →?TOPIC 06IF / IFS with AND & ORIF tests a condition and returns one result if it is true and another if it is false. IFS checks several…Open →
Percentages, averages and work problems
↑%TOPIC 07Markup % (based on cost)Markup compares the profit with the COST. Whenever the question says markup, the cost is the base (the…Open →↩%TOPIC 08Return % (based on selling price)Return compares the profit with the SELLING PRICE. The selling price is the base (the…Open →ΔTOPIC 09% change and growth rateA single percentage change links the initial value Ko, the final value Kt and the rate r. If you know…Open →×TOPIC 10Successive % changesWhen a value changes several times in a row, each change applies to the new value. So you multiply the…Open →⚖TOPIC 11Weighted averageA weighted average gives more weight to the values that occur more often, for example the average room…Open →⏱TOPIC 12Work problems (hours per day)In a work problem the work rate stays the same: rooms ÷ (workers × days × hours) is equal in both…Open →
Charts and equations
⋰TOPIC 13Scatterplot + trendlineA scatterplot shows the relationship between two numerical variables. With a linear trendline and its…Open →x²TOPIC 14Quadratic equationsA quadratic equation ax² + bx + c = 0 can have two, one or no real solutions. The delta (b² - 4ac) tells…Open →y=TOPIC 15Line equation from 2 pointsWith two known points you can find the straight line y = m*x + c. In Excel, SLOPE gives the slope m and…Open →
Independent study material by YTutor with original examples. Not affiliated with EHL; no official exam papers are used.
Book a lesson
Tell us your course, your exam date and the topics that worry you. We start with what matters most for your grade.
WhatsApp is preferred
The fastest way to book: send us a message and we usually answer the same day.
or email info@ytutor.net
Send a message
We answer by email or WhatsApp.