Story Tracker

by Matthew Kuo on August 8, 2013

in Excel Templates, MBA

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the

The key to preparing for behavioral interview questions is to ensure that you have proper coverage for all of the core behavioral question types.  To put it another way, you want to make sure that you have a story that applies to every question your interviewer might ask.  What you really want to avoid is being prompted with a question you didn’t prepare for and having to come up with an answer on the spot.  Not only are you likely giving a weak answer, but you’re also wasting an opportunity to make yourself stand out.

The following tracker is intended to provide you a quantitative way to track and measure your readiness for behavioral interview questions.  For additional context on the subject, please visit my posts regarding interview tips and general recruiting tips.

Click below to download the Story Tracker Story Tracker v1.0

Key Features

  • Story Database to track stories in SAR format
  • Question Coverage tab to show preparedness against each major question type
  • List of 12 major behavioral question types
  • Conditional highlighting to show level of coverage
  • Input area for appending additional questions and assessing coverage of those questions

Instructions for Use: Step 1

Go to the Story Database tab and populate all of your stories starting with your most impactful stories first.  It may be a good idea to confer with a colleague to get his or her opinion on which of your stories are the best. Story Tracker 01

  • Be sure to give each of your stories a unique name so you can easily refer back to it
  • Document your stories in the Situation Action Result format with 3 – 4 bullet points for each section
  • Bullet point format is good because you don’t want to sound like you’re reading from a script; having some variety each time you tell it is a good thing
  • I’ve created space for 20 stories in the tracker, though I feel that anywhere between 10 to 15 stories is usually sufficient
  • DO NOT re-sort the order of the stories; the ordering is linked to the next tab we will be using; if you do need to move stories around, just manually copy and paste them over

Step 2

Move to the Question Coverage tab and cross reference each story you listed with each of the core behavioral question categories.  Place an “x” in cells where the story can be applied to the question type. Story Tracker 02

  • This won’t always be the case, but you’ll typically find that your most impactful stories are also applicable to the most question types
  • Make sure you have at least one story for each core question type; if you don’t the “Coverage” column will be highlighted in red
  • Ideally you’ll have two stories for each core question type, but for some of the more unique questions, such as “dealing with an ethical issue,” you’ll probably only have one

Step 3

Now we move to the interview specific section of the tracker.  While still on the Question Coverage tab, get a list of potential / expected questions for your next interview.  Copy and paste them in the Level 2 Section of the Story Coverage Matrix.  Then repeat the previous step by cross referencing your original stories against these new questions. Story Tracker 03

  • Question lists for specific interviews can be derived either online or through a database kept by your MBA career center
  • If you come to a question with no coverage, you’ll probably need to come up with another story
  • There is space for 200 Level 2 questions in this list; you can either save a different version of this file for each interview you do, use the additional Question Coverage tabs, or continue appending to this list so that you have the coverage for all of your interviews tracked in one tab

{ 1 comment… read it below or add one }

Rafael January 6, 2015 at 12:41 pm

Great Excel! Thanks! Would it be possible to get its password? I would like to make some changes in some of the fonts, etc. Thank you!


Leave a Comment

Previous post:

Next post:

Related pages

examples of vlookup in excel 2010excel offset formulaucla accounting departmentvllokup in excelhow to check duplicate values in excelyou can identify duplicate rows in a table using theremove filters in excelremove duplicates in excelexcel show duplicate valuesgaussian function excelms excel tricksexcel 2010 conditional formatting multiple conditionsmultiple if formulas in excelcreate excel chart templatecount formulas in excelucla anderson parkingexcel formula for vlookupremoving duplicate in excelformula to calculate range in exceleasy vlookup instructionsserenity dental culver cityexcel formula cheat sheetbell curve generator onlineremove duplicate rows excelexcel norminveliminate duplicates in excel 2010calculate cpk in excelvlookup tablesvlookup formula excelexcel duplicationmeaning of hlookup in excelvba excel delete rowharvard format case studyexcel shortcut select columnexcel horizontal lookuphow to compare rows in excelexcel symbol codesvlookup formula in excel pdfvlookup using vbamicrosoft office home and student 2007 trial downloadvlookup with multiple resultsplotting bar graphs in excelexcel adding columnsvlookup microsoft excelchart templates excelmatch function in excelfind duplicates in excellis there a way to remove duplicates in exceldelete adjacent duplicatesexcel formula for multiple cellsmicrosoft word 2010 free trial download full versioncumulative graph excellimitation of vlookuptick on microsoft wordvlookup excel worksheetexcel counting formulaucla mba employment reportformulas for excel 2007short cut for paste specialhow to calculate sales forecast in excelhistograms with excelwhere is the tick symbol in exceldelete a row in excel shortcuthow to draw column chart in excelexcel find duplicate entriescreating a stacked column chart in excelsort duplicates in excelucla winter schedulecreate a macro in excelexcel vlookup not workinghow to divide numbers in excelhistogram chart example