Gemma C.

Microsoft Excel Automation, Sales Analysis & Strategy

My previous commercial experience, interpersonal skills and analytical skillset is offered on a consultancy basis to businesses in a range of different sectors. Notable services offered include • Sales Analysis & Reporting - both one off sales analysis reports, ideal for presentations, funding and strategy sessions and/or ongoing analysis of the marketplace, with the output documents being based in Excel or PowerPoint Presentations. The raw data being from internal sources, customer data or purchased from external sources such as AC Neilson/ IRI etc. • Forecasting & Planning – creation of bespoke planning tools, tailored to the exact business model to ensure that the sales team, planning, production and logistics departments are all synchronised. • Commercial Analysis - unpick the various sections of the business and shed light on the areas that are commercially viable and working well and hi-light the areas of concern, helping companies focus on the true cause of inefficiency. Bespoke Profit and Loss accounts for each customer and sector of your business. • Cost of Goods Analysis (COGS) - construct a robust pricing database, that calculates the cost per unit, gram or widget, to include all fixed and variable costs, direct and indirect. Using my advanced knowledge of Excel I create a pricing tool which will easily self-calculate all permutations the business is considering going forward. • Change Management - My advanced knowledge of Excel enables me to simplify current processes and time inefficiencies by creating documents that streamline manual intervention, data handling and work towards a best case scenario output. • Complete Business Strategy – Implementation of forward-thinking business strategy. For example detailed SWOT analysis, identifying products that are in your business ‘tail’ and should be delisted; Customers that require a price increase in order to make them profitable or areas where we can find consolidation options; examining data for emerging products and markets and helping shape new product development pathways and internal financial & profitability planning. • Bespoke Excel Tool Creation - Full project management from conception to implementation including training staff on tool usage. • Excel training - individual or team training sessions crafted to incorporate the skills and formulas specifically required. I only joined Upwork on 2nd January 25 so apologies for the lack of work history and testimonials, please head to my linked in page for references; gemma-coles-a66392b9