Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2 - Complementary Training
Excel Tricks for S&C Coaches: Beginner to Advanced – Module 2
Posted by on 19/12/2017 in Membership Content
2 Comments

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.

Limited offer!

With Complementary Training You Always Get More!

Unlock a world of knowledge with our exclusive membership!

With Standard Plan, you’ll instantly get a free access to Google Sheets for Sports Science and Excel Tricks for S&C Coaches courses,
Lean Annual Planner, and the highly sought-after AthleteSR app!

But that’s not all! The first 100 members who join us will receive an extra special bonus – Strength Card Builder, absolutely FREE!

Unbeatable value at just $35/month for Standard membership, offering so much more in return.

Don’t miss out on this incredible opportunity!

Start Your Memberhip Today

And Claim The First Month Bonuses

+

The fastest 100 members who join us get a 1-month membership, ALL the above bonuses + Strength Card Builder

Join NowAnd Save 245$ in Total

Standard Membership
$35 per month

Hurry Up

Only

spots left!

Course Navigation

Introduction

Module 1 Lessons

Module 2 Lessons

Module 3 Lessons

Module 4 Exercises

Tags:, , ,
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

Related Articles

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

Tagged: , , ,

This topic contains 2 replies, has 3 voices, and was last updated by mm Vesna Nikolovski 5 years, 9 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.