For example, using Excel tables, the vertical direction can be departments and names, and the horizontal direction can be items, time and quantity.

Excel formulas can also be used for statistical accounting, such as summation, department summary, sorting and so on.

Now that you have done this job, learn more good working ideas and methods. I wish you success!