Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Data & Analytics Intermediate

Survey & Customer Feedback Analysis in Excel

Response rates, Likert scales, NPS, cross-tabs, weighting, margins of error, significance tests and open-text coding: 8 labs on one customer survey.

8 lessons 8 labs 2.1 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Turn a fieldwork report into a response rate, a break-off rate and a clean count of usable interviews.
  • Count a 5-point satisfaction question, report its top-2-box share and mean score, and handle "don't know" answers correctly.
  • Sort 60 answers on the 0–10 recommend question into three groups and calculate the Net Promoter Score.
  • Build a customer type × satisfaction cross-tab from raw answers, convert it to row percentages and compare the two segments fairly.
  • Weight 3,000 interviews so each age group counts as much as it does among all customers, and see what weighting costs in precision.
  • Put a margin of error on two survey results, correct it for a small B2B population, and plan how many invitations the next survey needs.
  • Test whether app customers really recommend Brightwell more often than website customers, or whether the gap could be chance.
  • Test whether satisfaction depends on the delivery option with CHISQ.TEST, then code open comments with keyword flags.

About this course

Survey results are easy to collect and easy to misread. This course teaches a careful way through them. You check response rate and sample quality, summarise Likert questions as distributions, top-two-box shares and means, and calculate net promoter score from promoters, passives and detractors. Cross-tabs by segment use row percentages, and weights align the sample with the population. You estimate the margin of error, adjust it for small populations and plan sample size, test the difference between two segments with a z-test and check independence with chi-square. A final lab codes open-text answers into themes. Suited to marketers, customer experience teams, HR analysts and students running their own surveys.

Curriculum

Course content

8 lessons · 8 labs · 2.1 h · final exam

  1. Response Rate & Sample QualityLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Likert Scales: Distribution, Top-2-Box & Mean ScoreLab15 min5 checked tasks
    Unlocked when you buy the course
  3. Net Promoter Score: Promoters, Passives & DetractorsLab14 min5 checked tasks
    Unlocked when you buy the course
  4. Cross-Tabs by Segment: COUNTIFS & Row PercentagesLab16 min4 checked tasks
    Unlocked when you buy the course
  5. Weighting Responses to Match the PopulationLab16 min4 checked tasks
    Unlocked when you buy the course
  6. Margin of Error, Small Populations & Sample SizeLab15 min4 checked tasks
    Unlocked when you buy the course
  7. Comparing Two Segments: Difference in Proportions & z-TestLab15 min4 checked tasks
    Unlocked when you buy the course
  8. Chi-Square Test of Independence & Coding Open AnswersLab18 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Data & Analytics courses →
$9.99one-time payment
Buy course