Upwork home
Sign Up
Secondary
Brandon W.

Brandon W.

Omaha, NE

Excel Analyst

I have worked in banking for over ten years—all the while learning how to utilize all of the Excel data analysis tools. Recently I have started using Python for analysis and automation. From system testing to dashboard creation to model development, banking has allowed me to learn many of the finer points of Excel. I have also learned Excel VBA and have used it not only in my banking career but also have done work for a few clients on the side. Those clients are in the hospitality industry and needed to make quick work of several weekly food and beverage inventory audits. We worked together to make file imports nothing more than a simple point and click, then automated the 30 minutes of previously manual data analysis into a mere five minutes! Along the way, we added several custom features to their template, including dynamic drop-downs, data-dependent logic, and conditional formatting. The final result was a dashboard highlighting KPIs and the top products contributing to their customers' expenses and profit. I have also developed a restaurant scheduling template that works off predefined lists and uses a Gantt Chart-like visual to show what shifts are covered and where scheduling gaps exist. This same template also incorporates an estimate of weekly sales, allowing the business manager to keep Labor Cost % under a certain threshold. Since labor cost and estimated sales both exist in the template, managers can make scheduling decisions with immediate feedback on the impact it will have on the bottom line.
Rating is 5 out of 5.
5.00 Mar 9, 2021 - Jul 7, 2021

"Brandon was great. He is competent, insightful, and very nice to work with. Brandon immediately understood what we were trying to do and he expanded on that as well as made clear best practices and methods. I would work with Brandon again. 10/10"

Private earnings
Rating is 4.45 out of 5.
4.45 Apr 5, 2018 - May 7, 2018

"Excellent work on our excel dashboard. Added great ideas for structure and streamlined process as well. Will use again"

Private earnings
Rating is 5 out of 5.
5.00 Jan 23, 2018 - Mar 1, 2018

"The best person I've worked with remotely. Continuously gave updates on progress, implemented his own expertise to make the end result better than what I was asking for. He even came back to me with updated versions after the initial ask was satisfied. I will continue to use Brandon for all of my expert level excel needs. Highly recommended!"

Private earnings
Brandon W. has more jobs. Create an account to review them

Skills

Brandon W.

Brandon W.

Omaha, NE
18
Total Jobs
34
Total Hours

Excel Analyst

Specializes in
I have worked in banking for over ten years—all the while learning how to utilize all of the Excel data analysis tools. Recently I have started using Python for analysis and automation. From system testing to dashboard creation to model development, banking has allowed me to learn many of the finer points of Excel. I have also learned Excel VBA and have used it not only in my banking career but also have done work for a few clients on the side. Those clients are in the hospitality industry and needed to make quick work of several weekly food and beverage inventory audits. We worked together to make file imports nothing more than a simple point and click, then automated the 30 minutes of previously manual data analysis into a mere five minutes! Along the way, we added several custom features to their template, including dynamic drop-downs, data-dependent logic, and conditional formatting. The final result was a dashboard highlighting KPIs and the top products contributing to their customers' expenses and profit. I have also developed a restaurant scheduling template that works off predefined lists and uses a Gantt Chart-like visual to show what shifts are covered and where scheduling gaps exist. This same template also incorporates an estimate of weekly sales, allowing the business manager to keep Labor Cost % under a certain threshold. Since labor cost and estimated sales both exist in the template, managers can make scheduling decisions with immediate feedback on the impact it will have on the bottom line.
Rating is 5 out of 5.
5.00 Mar 9, 2021 - Jul 7, 2021

"Brandon was great. He is competent, insightful, and very nice to work with. Brandon immediately understood what we were trying to do and he expanded on that as well as made clear best practices and methods. I would work with Brandon again. 10/10"

Private earnings
Rating is 4.45 out of 5.
4.45 Apr 5, 2018 - May 7, 2018

"Excellent work on our excel dashboard. Added great ideas for structure and streamlined process as well. Will use again"

Private earnings
Rating is 5 out of 5.
5.00 Jan 23, 2018 - Mar 1, 2018

"The best person I've worked with remotely. Continuously gave updates on progress, implemented his own expertise to make the end result better than what I was asking for. He even came back to me with updated versions after the initial ask was satisfied. I will continue to use Brandon for all of my expert level excel needs. Highly recommended!"

Private earnings
Brandon W. has more jobs. Create an account to review them

Skills

As Needed - Open to Offers

Browse similar freelancers

Sign up to discuss your project with Brandon W.