Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2 - Complementary Training
Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2

Excel Tricks for S&C Coaches: Beginner to Advanced

MODULE 2: Lesson 1 – Getting started with Excel Formula

Today, we are presenting you a Module 2, in which John is demonstrating more advanced excel functions, or in other words, everything that you need to know about formulas and functions. In Module 1, you have learned pretty much all about the basic things, but in Module 2, with John’s assistance, you are going to really develop some knowledge with thelp of this educative and simple course – Excel Tricks for S&C Coaches. Formulas and functions are one of the most important excel features, which are very useful, yet many people do not know anything about them. Most of them are actually intimidated by the concept of formulas and functions itself. However, they need to be mastered if you want to improve & boost your excel skills and make your everyday job routine much easier.The lessons that will be covered in Module 2, from Excel Tricks for Sports course are the following:

  • Getting started with Excel Formula (8m 55s)
  • Writing Formula with Math Operators (4m 43s)
  • Vlookup (15m 27s)
  • Hlookup (3m 27s)
  • Supercharge your Lookups with Index and Match (14m 32s)
  • Using Indirect to Look Across Multiple Tables (12m 53s)
  • Speed up Formula Writing with Offset & Rows Functions (8m 16s)
  • Perform Basic Analysis (13m 23s)
  • Advanced Analysis Functions (24m 43s)
  • Logic (30m 00s)

After all of the modules are covered, there are Practical Exercises where you can practice your skills and find out how much work you need to do, or how ready you are to work on projects.

excel-tricks-for-sc-coaches-video1

Ready to watch this course?
Become a member and get unlimited access to all content on our website.

Course Navigation

Introduction

Module 1 Lessons

Module 2 Lessons

Module 3 Lessons

Module 4 Exercises

mm
I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »
free-memeber-button
free-memeber-button

Welcome to Complementary Training Community! Forums Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2

This topic contains 2 replies, has 3 voices, and was last updated by mm Vesna Nikolovski 6 years, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.