Tiger Solutions/Excel For Coaches - EXCEL FOUNDATIONS COURSE

  • £150 or 2 monthly payments of £90

Excel For Coaches - EXCEL FOUNDATIONS COURSE

  • Closed


The ultimate Excel learning resource for coaches  
In around 8 hours, Aaron (practising coach) and Chris (practising Excel consultant in sport) take you through what you need to know to power forward your career as a coach with better Excel data analyses.

A Unique Excel Course For Coaches

Regardless of where you coach, how you coach or the level you coach, the Excel For Coaches Foundations course is your fastest route to real confidence working with Excel.

Say goodbye to endless internet searches and hours spent 'trying to get Excel to work'.  Say hello to efficient processes, organised spreadsheets and powerful analyses that you and your athletes will love.

The 5 Parts Of The Excel Foundations Course

1. GET TO KNOW EXCEL

Get familiar with the Excel interface and start building some Excel formulae.  No prior knowledge is assumed but even coaches who are experienced Excel users will pick up useful tips from our introductory module.

2. EXCEL MODELLING

Formulae are the defining feature of Excel for many coaches.  We cover the 5 Excel formulae coaches need to know from both a technical and practical perspective.  All taught through an example based on what coaches typically want to do with data.

3. EXCEL DATA ANALYSIS

Many sports coaches feel overwhelmed by data.  This module teaches how to quickly analyse data using powerful Excel formulae.  Say goodbye to endless sorting and filtering - you'll love the alternatives taught in this module.

4. EXCEL DATA INPUT

Data input is the most basic thing coaches do with Excel, yet many problems coaches experience in Excel are caused by how data is initially put into a file.  In this module we learn how to do it professionally and avoid problems further down the line.

5. EXCEL AUTOMATION

Tired of those manual jobs in Excel?  Endless repetitive work and copy / pasting from one athlete template to another?  All coaches have been there!  In this module, we learn how to use VBA to automate a typical time-consuming Excel task, saving you hours of time.

FAQs

Are Excel Files Included In the Course?

Yes! All the files Chris and Aaron show in the videos are included in the course.  The file download links are easily accessible next to the videos.

How Do I Access The Course?

You gain instant access to The Excel For Coaches Foundations course once your purchase is complete.  Simply sign into your account on this website, click on the course title and start working through the videos.  The interface is easy-to-use and allows you to easily move from one part to the next, whilst monitoring overall progress.  The Excel files are downloadable next to each video.  The system shows you which videos are complete, which are not, and even remembers the point you watch to on a video so you can pick up where you left off.

I'm An Absolute Beginner. Is The Course Suitable For Me?

Yes, though parts of the course are challenging for beginners.  The course is taught with no prior knowledge assumed, and sessions are structured progressively so one part leads logically to the next.  What parts might you find challenging?  Part 5 is about automating Excel and uses Excel's coding language - VBA.  This is difficult for a beginners, but Chris explains what you need to do, step-by-step.  With the right commitment on your part, an absolute beginner can get huge value from this course.

I'm An Experienced Excel User. Is The Course Suitable For Me?

We think even experienced Excel users will get value from the Excel For Coaches Foundations course.  Even coaches who have used Excel for years may lack a clear overall approach to their Excel practice, and a sense, for example, of what technique to use in what situation.  The course equips you with these things.  Further, the course includes challenging content such as a guide to automating manual processes with Excel's coding language - VBA.  This is likely to challenge the more experienced Excel users too; but, if you can handle it, you'll love the game-changing power of Excel VBA.

Are Power BI and Power Query included in this course?

No.  That's because there are easier and more foundational ways to get the results that these tools can get.  At Excel For Coaches, we prefer simple formulae and techniques (at least at first) and we are confident you will get huge value from them too.

About Your Excel Coaches

Chris Mortimer BA MSc

Chris has worked in Excel data analysis for more than 10 years and is founder of Excel Consultancy Tiger Spreadsheet Solutions.  Over 70 000 people subscribe to Tiger's YouTube channel that provides Excel (VBA) guidance and tutorials.  In his consulting practice, Chris has worked with a range of sports coaches at elite level including The Football Association (UK) and English Institute of Sport (UK).

Aaron Zimmerman BSpEx

Aaron is an elite-level strength and conditioning coach with experience in a range of sporting contexts.  In addition to his work with professional sports clubs, he is founder of A2Z Strength.  The need to develop analytical tools that would be his own intellectual property triggered his interest in Excel and he has since harnessed Excel to create a suite of tools that have revolutionised his coaching practice.

Ready To Get Started?

Ready to power forward your coaching career with better Excel data analysis skills?

This is a course for anyone who feels they need to up their Excel game, learn some fundamental basics of what Excel can do for them, and then how to apply it to their everyday coaching lives.

Click BUY above to get started.  We can't wait to see you inside.

Contents

Part 1: Get To Know Excel

Get familiar with the Excel interface and start building some Excel formulae.  No prior knowledge is assumed but even coaches who are experienced Excel users will pick up useful tips from our introductory module.

This module features coverage of the technique and theory with Chris and explanation of real-world application with Aaron.

SESSION TITLES

  • Data Input And Arithmetic Formulae
  • Plan And Format A Spreadsheet
  • Summing Up, %s and Absolute References
  • Charts And Conditional Formatting
  • Effective Worksheet Layout and Presentation
Excel Basics Part 1 Session 1.mp4
PART 1. SESSION 1.mov
Excel Basics Part 1 Session 2.mp4
PART 1. SESSION 2.mov
Excel Basics Part 1 Session 3.mp4
PART 1. SESSION 3.mov
Excel Basics Part 1 Session 4.mp4
PART 1. SESSION 4.mov
Excel Basics Part 1 Session 5.mp4
PART 1. SESSION 5.mov
Excel Basics Part 1 START.xlsm
Excel Basics Part 1 END.xlsm

Part 2: Excel Modelling For Coaches

Formulae are the defining feature of Excel for many coaches.  We cover the 5 Excel formulae coaches need to know from both a technical and practical perspective.  All taught through an example based on what coaches typically want to do with data.

This module features coverage of the technique and theory with Chris and explanation of real-world application with Aaron.

SESSION TITLES

  • Dropdown Menus And Working Across Sheets
  • The VLOOKUP Formula
  • The MATCH Formula
  • The OFFSET Formula
  • the IF Formula
Excel Basics Part 2 Session 1.mp4
PART 2. SESSION 1
Excel Basics Part 2 Session 2.mp4
PART 2. SESSION 2.mov
Excel Basics Part 2 Session 3.mp4
PART 2. SESSION 3.mov
Excel Basics Part 2 Session 4.mp4
PART 2. SESSION 4.mov
Excel Basics Part 2 Session 5.mp4
PART 2. SESSION 5.mov
Excel Basics Module 2 END.xlsm
Excel Basics Part 2 START.xlsm

Part 3: Excel Data Analysis For Coaches

Many sports coaches feel overwhelmed by data.  This module teaches how to quickly analyse data using powerful Excel formulae.  Say goodbye to endless sorting and filtering - you'll love the alternatives taught in this module.

This module features coverage of the technique and theory with Chris and explanation of real-world application with Aaron.

SESSION TITLES

  • Foundational Skills and Concepts In Data Analysis
  • Apply FREQUENCY And Create A Column Chart
  • Sort And Filter Data In Excel
  • Single Criteria Analysis In Excel
  • Multiple Criteria Analysis In Excel
  • Powerful Data Analysis Formulae

Excel Basics Part 3 Session 2.mp4
Excel Basics Part 3 Session 1
Excel Basics Part 3 Session 3.mp4
Excel Basics Part 3 Session 4.mp4
Excel Basics Part 3 Session 5.mp4
Excel Basics Part 3 Session 6.mp4
Excel Basics Part 3 END.xlsm
Excel Basics Part 3 START.xlsm

Part 4: Excel Data Input For Coaches

Data input is the most basic thing coaches do with Excel yet many problems coaches experience in Excel are caused by how data is initially put into a file.  In this module we learn how to do it professionally and avoid problems further down the line.

SESSION TITLES

  • Planning Data Input In Excel
  • Advanced Data Validation In Excel
  • Data Validation and Dates
  • Present A Worksheet For Data Input
Excel Basics Part 4 Session 1.mp4
Excel Basics Part 4 Session 2.mp4
Excel Basics Part 4 Session 3.mp4
Excel Basics Part 4 Session 4.mp4
Excel Basics Part 4 START.xlsm
Excel Basics Part 4 END.xlsm

Part 5: Excel VBA Automation For Coaches

Tired of those manual jobs in Excel?  Endless repetitive work and copy / pasting from one athlete template to another?  All coaches have been there!  In this module, we learn how to use VBA to automate a typical time-consuming Excel task, saving you hours of time.

SESSION TITLES

  • Your First Excel Macro
  • Interacting With Cells Using a=b
  • Excel VBA Variables For Beginners
  • Position Control With Excel VBA 1
  • Position Control With Excel VBA 2 And More Variables
  • Excel VBA Loops For Beginners
  • Combining Excel VBA Techniques In A Powerful Macro
Excel Basics Part 5 Session 2.mp4
Excel Basics Part 5 Session 1.mp4
Excel Basics Part 5 Session 3.mp4
Excel Basics Part 5 Session 4.mp4
Excel Basics Part 5 Session 5.mp4
Excel Basics Part 5 Session 6.mp4
Excel Basics Part 5 Session 7.mp4
Excel Basics Part 5 START.xlsm
Excel Basics Part 5 END.xlsm