Given the proprietary nature of the work that I have done for my clients, I am unable to provide examples of previous work, so below are documents that I have created to demonstrate some of my skills.
I am continuously upgrading my skills so all documents utilize the latest capabilities of Microsoft Office 365. Some of the functions like slicers, XLookup, and custom formatting may not work if you don’t have the latest version of Office. Even Office on-line does not support some of the more advanced features being used. I have provided descriptions below of the tools employed in each document. Some documents are formatted strictly for laptop / desktop, and tablets. For best viewing, avoid opening the files on your phone.
The documents can be found on my OneDrive through this link.
Sales Analysis Excel Document
My mock sales analysis Excel document is based loosely on the wireless infrastructure company that I was involved with, Voxaura Technologies Inc.
The 1st worksheet consists of a dynamic dashboard of graphs and pivot graphs detailing various sales analytics. All the graphs can be manipulated through slicers, located at the bottom of the dashboard.
On the other worksheets, the dashboard is supported by a main table consisting of various sales related variables that feed into multiple pivot tables where the graphs and pivot graphs were created.
Functions and nested functions were used to manipulate the data for the graphs. If, index, and match functions were used. Some basic visual basic was also used for formatting purposes.