Everlearner Leaderboard Template Tutorial [PREMIUM]

About this course

This self-directed course teaches you how to transform live data from The Everlearner platform into a visual tracking and monitoring tool using a simple conditionally formatted excel spreadsheet found in the Premium Membership package.


Export the raw ‘Live Data’ from The Everlearner Dashboard and transform it into a visual leader board using the conditionally formatted Excel spreadsheet from PE4Learning

The pack contains two resources to transform your raw data into a visually striking leader board.  The basic version is a one-off centre snapshot of a selected group from the Everlearner Platform.

The advanced version allows you to export and convert raw data periodically over the course and show progress over time with elements of the basic centre snapshot version incorporated into the design.  The spreadsheet visually demonstrate progress made not from the start of the course but from each periodic checkpoint to see who has and who has not spent time on the platform since the last time the teacher checked.

Learning outcomes

You will learn how to:

  • export live data from a .csv file
  • copy and paste excel data into a conditionally formatted macro enabled spreadsheet
  • track progress on the Everlearner platform using the PE4Learning created spreadsheet


You will need:

  • access to a desktop PC
  • access to Microsoft Excel
  • access to The Everlearner Dashboard
This course is part of the Premium PRO Membership upgrade package
Take this Course

Course Content

Share This Post
Written by @PE4Learning
Founder of PE4Learning - Sharing Creative PE Ideas and Resources

Leave a Reply