By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Random Meal Selector Using Excel

Goal

Enter data to a spreadsheet and have Excel Randomly select the meal for you.

Level
  • Excel only
  • Intermediate to Advanced
  • No VBA

    Will Learn
  • Using existing Sheet to perform a function
  • Formulas
  • Functions
  • Data Entry
  • Column Reference, ex. G:G
  • Cell reference, ex. C7
  • Using Google
  • =CountA( )
  • =Randbetween( )
  • =Address( )
  • =Indirect( )
  • String Concatenation
  • Recalculation
  • =Match( )
  • Math (Subtraction, Addition)
  • =Substitute( )
  • Nested functions

    Exercise
  • Create sheet for lunch
  • Create sheet for Dinner
    • blog comments powered by Disqus