Visual update on a Excel project
Clean Excel worksheet
The plan of this project was to automate the most part of a process for the doc team. All the repetitive process, like data extraction from a report sheet, was automate using VBA, and the interface and buttons was added to make the processs and experience of the user more intuitive and faster.
There is now 34 worksheets in this workbook, so a control panel for the user was much needed for a clear navegation between the sheets and the tasks.
From the sketch to current project, a lot of buttons and functions was added, but after a lot of adjustments and improvements, this 4 buttons was the most used.
The buttons 1 to 3 open new tabs, and the 4 is just to visualize and navegate between the 34 sheets.
First idea for a Control Panel
The buttons was working has intended, but the look of the panel was a bit weird. There was a lot of uneven spaces and the hierarchy of the buttons was a bit confusing.
After some updates, i've created a new UserForms for the buttons 1 and 3, and for the sub-buttons on 2. As this buttons was more independent now, came to me the ideia to transform this buttons into icons.
Visual and informational update. The bars are transformed into icons to make a cleaner look, and new informations about the current state of the process and worksheet was added in the left
Since the interface of Excel utilize a lot of space for his own toolbar, my idea was to use more horizontal space than vertical, so the user don't need to scroll at any time.
The buttons was allocated in the top section of the panel in form of new icons that represents itself what each function will do.
New textboxes was added in the left corner of the panel, in order to give constant feedback to the user as to the current state of the process.
Now the space is cleaner and more balanced, making the user find himself easier in his tasks during the process.
