Making and analyzing points lists with Excel: Multi-day training

Do you want to better analyze the performance of your students? Take this series of lessons and learn how to organize data using pivot tables, filters, formulas, and charts. This allows you to make better informed decisions to guide your students.

In this course you will learn how Microsoft Excel can be an added value in education, but this is only the starting point for discovering the many possibilities of the program.

These items are covered:

• use of advanced functions (logic, text, date and search functions);
• advanced filters;
• slicers;
• vertical search;
• visual effects (colors) to check/follow up data (conditional
formatting-create newline);
• drop-down lists;
• import and export data ;
• references between files;
• securing data;
• pivot tables;
• Graphs;
• practical exercises.