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.

Become a member and get unlimited access to all content on our website.

Standard Membership
\$35 per month

OR