|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-league-tables-and-tournaments/
课程评论：没有评论
Coursera 课程：在 Excel 中创建体育联赛排名和锦标赛 本课程旨在教授学员如何利用 Excel 创建体育联赛排名表和锦标赛对阵图。通过掌握 Excel 的强大功能，您可以自动计算杯赛抽签结果以及联赛排名的升降。 课程内容涵盖： **1. 创建联赛排名表：** * 学习如何实现结果输入后自动计算联赛排名。 * 了解如何根据不同的排名标准（如净胜球、进球数、客场胜场数等）调整排名算法。 * 通过足球和橄榄球的实际案例进行演示。 **2. 创建杯赛锦标赛：** * 学习如何在 Excel 中创建淘汰赛制锦标赛，包括随机抽签和根据比赛结果自动晋级。 * 通过斯诺克和网球的实际案例进行演示。 **3. 板球世界杯 T20 锦标赛：** * 专门学习如何计算板球比赛的统计数据和赛果，因为板球的独特性。 * 以世界杯 T20 锦标赛为例，演示如何计算净胜率、投球三振率和总投球数等关键数据。 **通用性：** 尽管课程无法涵盖所有体育项目的具体细节，但所学技术可以广泛应用于任何体育竞赛的赛事管理和数据统计。 通过本课程，您将能够熟练运用 Excel 为各类体育赛事创建高效、自动化的联赛排名和锦标赛管理工具。所有练习所需的电子表格文件均可下载，方便学员练习或作为自定义模板使用。
This course shows you how to create spreadsheets for sports tournaments and league tables. Use the power of Excel to automatically calculate cup draws and league table rankings.Whether your league table rankings are determined by goal difference, goals scored, number of away wins or something else. You will learn how you can use this criteria to automatically determine a team or players league position.Spreadsheets are available for download along the way for practice, or to use as a template to adapt to your needs. The course is broken down into three sections. Creating League Tables Learn how to automatically calculate league table rankings when results are entered onto a spreadsheet. We look at adapting the league table to apply different ranking criterion. A football/soccer and a rugby union example are used for demonstration. Create Cup Tournaments Learn to create cup tournaments in Excel including random cup draws and calculating match results to automatically move a player or team to the next rounds draw. A snooker and a tennis example are used for demonstration. Cricket World Twenty20 Tournament A section is dedicated to learning how to calculate cricket statistics and match results due to the unique nature of the sport. The World Twenty20 tournament is used to demonstrate how to calculate match results and statistics like net run rate, bowling strike rate and total balls bowled.Let's Do It Although the course cannot possibly cover all sports examples, the techniques learned can be adapted for any sports competition. Let's get started.
