Use break points, line-by-line step through of code, hover, and the immediate window to check your VBA. This is a video that is connected to videos 78 and 78B
Creator channel
ExcelTricksforSports
15 recent indexed videos · 12,500 subscribers
Latest videos
Fresh from ExcelTricksforSports
Showing 12 of 15 kept videos
Recent video details
Indexed videos from ExcelTricksforSports
EAF #78F - Basic VBA Debugging and Error Checking your Loop
Use break points, line-by-line step through of code, hover, and the immediate window to check your VBA. This is a video that is connected to videos 78 and 78B
Open this video on ExcelTricksforSportsEAF #111 - Using Lookup Tables
Using lookup tables to add references to your data set is quick and easy. Convert to Tables and then apply INDEX&MATCH functions to extract what you need.
Open this video on ExcelTricksforSportsEAF #110 - GPS DATA & WORKING WITH MAX VELOCITY TO IDENTIFY HAMSTRING INJURY RISK
This video shows how you can use Excel to manipulate GPS data and extract maximum velocity and speed threshold information. Tricks used include MAXIFS, AGGREGATE, COUNTIFS. If you are interested in more Excel tutorials check out my three series on Vimeo for...
Open this video on ExcelTricksforSportsEAF #109 - RANKING SCORES WITH NEW DYNAMIC ARRAYS
This video covers traditional and new methods of ranking scores including SORT, FILTER, PIVOT TABLES, MAX, LARGE. The new dynamic arrays formula in Excel are a game-changer. 00:45 MAX, LARGE, INDEX, MATCH 15:45 Pivot Tables 18:45 Dynamic Arrays formula FILT...
Open this video on ExcelTricksforSportsEAF #108 - Monitoring report with variable duration cycles
This video demonstrates how you can extract summary data from your database using formula. It allows you to choose cycle durations of 1-week, 2-weeks, 4-weeks, 8-weeks etc with the click of a drop down list. Uses VLOOKUP, SUMIFS, AVERAGEIFS, DATA VALIDATION...
Open this video on ExcelTricksforSportsEAF #107 - VBA Loop to Delete Blank Rows
If you would like to support me in making more videos then you can buy me a coffee https://www.buymeacoffee.com/CkiIh7tJ5 Simple VBA loop that checks each row and deletes any that are blank. Key trick is to start the loop from the bottom of the data set and...
Open this video on ExcelTricksforSportsEAF #106 - Random Strength Session Generator
Use INDEX and the RANDBETWEEN function to make a strength template that can instantly make a strength session plan.
Open this video on ExcelTricksforSportsEAF #78D - Use VBA to Extract Records to New Workbook
Loop through rows and extract records that meet criteria. Results end as a sheet in a new workbook
Open this video on ExcelTricksforSportsEAF #105 - Data Validation tricks for an Athlete Performance Plan
Creating an individual performance plan for an athlete is easy if you can build connected data validation lists and create a hierarchy of targets, goals and strategies.
Open this video on ExcelTricksforSportsEAF #78C - Excel VBA to search and extract records to new sheet
A follow up to video #78. You have a data set with 1000 records and you want to return the records that match your criteria. Each time you run a search it creates a new sheet to paste the matching records into
Open this video on ExcelTricksforSportsEAF #78B - Excel VBA to search and extract records using multiple criteria
A follow up to video #78. You have a data set with 1000 records and you want to return the records that match your criteria. This video shows how you can search for 3-4 names at the same time
Open this video on ExcelTricksforSportsEAF #104: Use Excel to create a GPS Session Report
This video shows how you can use Excel to create a GPS session report with references to position and team averages, match data and session-specific targets. Tricks used include CHOOSE, AVERAGEIFS, INDEX, MATCH, VLOOKUP, Table References, Data Validation, D...
Open this video on ExcelTricksforSports