Sport Science - Data Management and Visualisation with Excel

How to use the .Range and .Cells in VBA

How to get the last row and last column of a dataset to help with automation of your processes.

One of the most important functions to know in VBA (If this, then do this, if it isn't, then do something else)

If you can master a For Loop, then you're pretty much a master at streamlining workflows!

A few important notes on what to lookout for when developing your own datasets.

A brief description on the values presented in the dataset used extensively in this course.

How to check for spaces so it doesn't ruin your analysis.

A way to use the find and replace function to fix inconsistencies in your data.

Tracking down and investigating potential outliers within your data.

Assessing missing data within your datset.

Learn how to extract certain data based on a persons name.

Discover how to extract data by a value and where it may be appropriate to do so.

Extract data based on multiple criteria by using the AND argument within an If Then statement. VERY HANDY TO KNOW!!

Extract data based on multiple criteria by using the OR argument within an If Then statement. VERY HANDY TO KNOW!!

Discover how to extract data from a certain time period and why that may be appropriate in the real world.

Learn how to become more selective of the data you wish to analyse within your datasets.

Discover how to calculate averages that you can use for comparisons and other analysis.

Become even more selective in the type of averages you analyse!

About as technical as you will need for procuring averages from your data.

Standard deviations form a large part of statistical analysis, this lecture shows you how to get them.

Further to the previous lesson, learn to become more specific with the standard deviations you obtain.

Another step towards streamlining your processes by learning the Call command.

Personal bests (and worsts....) are important to know for all players. This lesson shows you how to get them.

Following on from the previous lesson, become even more specific with the personal best (and worsts...) that you obtain.

A super handy skill to know that can provide further rigour to your analysis (i.e., how many samples of data do you have to analyse?????)

Another very handy skill if your situation is relevant to this lesson.

Important considerations for how you want your report to look prior to beginning your code.

Designing formatted tables in their most simplest forms.

Understand this lesson and you'll likely never struggle with tables again (a big call I know)!

Add further meaning to your tables by adding colour through conditional formatting.

Another way to use conditional formatting by using the rank of a value.

Ways of formatting to increase the visual appeal of your tables.

Ways of formatting to increase the visual appeal of your tables.

The absolute basics of inserting a chart, don't worry it gets more complex from here!

As the title suggests, this is how you can format an individual series in anyway you see fit.

As just seen in 'format series for a line chart' this lesson provides a similar example for a column / bar chart.

Add, remove and format text to make your charts more appealing.

An important analytical tool for sport scientists.

HUGELY important skill to master when inferring multiple types of data on one chart.

Further formatting to enhance the quality and readability of your charts.

Further formatting to enhance the quality and readability of your charts.

The final frontier for streamlining your reports, master this and you'll never look back!

Have and endless amount of macros run at the click of a button.

Make your macros instantaneous through change events.

A handy trick to even further enhance your charting and Looping.

A handy tip to remove extra mouse clicks in your reporting processes.

Wishing you all the very best on your next excel journey!