How to Make an Employee Weekly Performance Tracker Using Excel. There is an axiom used in most continuous improvement methodologies that observes, "you can't improve what you can't measure ...

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.

You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.