EAF #13 - Use Multiple IF Criteria to Edit an Excel Dynamic Dashboard (Table and Chart)

2,549 views · Published 26 April 2012 · 18:25 · Indexed 16 October 2026

Channel: ExcelTricksforSports · 2012 · Education

Watch on YouTube

Excel Tips for Sport Scientists and Sports Performance Analysts
Use functions and built in features of excel 2010 to make your life easier
Make a dynamic chart using drop down boxes to alter input data
Multiple Criteria Data Selection
DATA VALIDATION, IF, AVERAGEIF, AND, OR

More from this channel

• 4:19 EAF#5B - Speed Test Conversion

  ExcelTricksforSports

  1,846 views · 27 January 2012

• 14:37 EAF # 10B - Build an Athlete Training Diary - Part 2

  ExcelTricksforSports

  4,871 views · 7 March 2012

• 9:47 EAF # 10D - Build an Athlete Training Diary - Part 4

  ExcelTricksforSports

  2,717 views · 8 March 2012

• 20:19 EAF # 12B - Excel 2010 Tips and Tricks - Part 2

  ExcelTricksforSports

  1,397 views · 20 April 2012

• 6:36 EAF#25 - Using Evernote to be Awesome at Excel

  ExcelTricksforSports

  4,725 views · 7 June 2012

• 6:17 EAF#31 - Creating and Using the Personal Macro Workbook in Excel 2010

  ExcelTricksforSports

  4,805 views · 27 September 2012

• 9:05 EAF#35 - Excel Hyperlinks

  ExcelTricksforSports

  900 views · 3 December 2012

• 7:23 EAF#36 Part 2 - Index Array with Dynamic Chart

  ExcelTricksforSports

  2,251 views · 9 January 2013