How to use Microsoft Excel for Strength & Conditioning Coaches скачать в хорошем качестве

How to use Microsoft Excel for Strength & Conditioning Coaches

This is video is How to use Microsoft Excel for Strength & Conditioning Coaches. The content is geared toward S&C coaches who are starting off using Excel. I will cover everything from writing in a cell to using dropdown menus, vlookup, mround, and iferror functions. Hopefully by the end you can write your own training cards for your athletes. These are my methods, please feel free to share your own in comments below. Jump ahead using QUICKLINKS below: 0:41 - Writing in a cell demo 2:06 - Resizing cells demo 3:14 - Wrap text demo 3:41 - Part I Recap (Writing in a cell, resizing rows/columns, wrap text) 3:54 - Insert table/ Exercise menu demo 7:08 - Part II Recap (Making exercise menu) 7:19 - Merging cells demo 8:14 - Part III Recap (Merging cells) 8:21 - Borders demo 13:08 - Part IV Recap (Borders) 13:16 - Insert/Delete Rows/Columns demo 13:28 - Delete demo 14:39 - Insert demo 16:50 - Part V Recap (Insert/Delete rows & columns) 17:00 - Insert/Delete cell demo 18:46 - Part VI Recap (Insert/Delete cells) 19:11 - Dropdown menu demo 22:21 - Part VII Recap (Dropdown menu) 22:28 - Adding maxes demo 22:59 - VLOOKUP demo 24:49 - Part VIII Recap (VLOOKUP) 25:08 - Copy & paste VLOOKUP function 27:40 - Part IX Recap (Copy & paste VLOOKUP) 27:48 - MROUND demo 30:20 - Part X Recap (MROUND) 30:30 - Dragging out formula & formatting demo 31:49 - Part XI Recap (Dragging out functions) 33:17 - IFERROR demo 35:15 - Part XII Recap (IFERROR) 35:25 - Quick modifications demo 37:39 - Part XIII Recap (Quick modifications) 37:45 - Printing 38:13 - Print area demo 39:28 - Scale to fit 41:18 - Part XIV Recap (Printing)