I am IT professional, Well versed with Excel dashboards, data analysis, reporting. Trained many professionals in corporate sector on Advance excel concepts like pivot, vlookup, conditional formatting,data analysis,charts,Macros.
Pls check various same type of projects executed on freelancer site.
1. Sales Analysis reports - Done for the fashion beachwear shops. Based on the sales data of the different shops,pivot reports are updated as well user can get idea of sale base on the reorder quantity. This is done with the VBA macro and pivot report.
Check the video :
https://photos.app.goo.gl/yPBD2hAckxBywLRw5
2. Generated Dynamic Dashboard for the Europe based factory,where user can edit data which is reflected automatically on the chart.This is done with the VBA macro.
https://photos.app.goo.gl/pDEgh47xrLWfsNEu8
3. Billing - Generating Invoice for each Customer in PDF file and generating CSV file based on the data updated on control panel.
https://photos.app.goo.gl/dwkTXgYimP86NAyr9
4. Timesheet generation: Generating the various timesheets for different companies as per their requirements. This is done with VBA Macro.