Excel Efficiency Enhancement for Financial Data Analysis

Assignment to design the revenue analysis sheet of a hotel's operation

Project goal I was given the task to assign the revenue analysis statement of a hotel's monthly operation to analyse from which channel they had most bookings.

Solution Their recording and analysis method was outdated and difficult to comprehend. After converting it into graphical and comparative statements, even a layman can understand which channel is better.