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

excel highlight columnexel formatvlookup exercisep&l driversvlookup trimexcel vlookup true falsehlookup function in excel 2010the goal eliyahu goldratt cliff noteshow to make a bar graph with excelcalculate underpayment penaltyif iserrorduplicate rows excelexcel formulas tricksreplace excel formularemove conditional formattingall excel formulas in excel sheetvba offsetlook for duplicates in excelexcel macro format cellexcel shortcut to delete rowvlookup cheat sheetiferror formula excelexcel formula formattingprofessional excel chart templatesvlook excelexcel formula commandsucla classes schedulehow to remove duplicates from a listvlookup function excel 2013excel vba histogramhow to use hlookup in excelexcel count arraycareer path deloitte consultinghow to drag down a formula in excelcompare multiple columns in excelcell formatting in exceleliminate duplicatesformula for random numbers in excelexcel random password generator formulainsert check mark in exceloffset vbasumit bansalexcel formula cheat sheetbell shaped curve generatorhow to highlight duplicate rows in excelexcel vba delete duplicate rowsvlookup for two conditionstick in a box symbolirs 2015 withholding calculatortick symbol in powerpointhow to use the vlookup function in excel 2010download free trial microsoft word 2010define conditional formatting in excelcountif not workingexcel sheet vlookupquestions to ask in an mba interviewucla krecexcel 2010 compare two listsucla ackerman storedelete duplicates excel 2010vlookup formula for dummiesmacro for comparing two columns in excelhow vlookup works in excelhow do i compare 2 columns in excelbell curve normal distributionexcel all formulas with example 2007vlookup to find matchessyntax for vlookupcompare two lists in excel for matchesexcel vlookup vbaexcel programming commandsvlookup excel examplevlookup excel tablecountif statementhlook