Hi, I will be able to finish this work in 1 hour.
If you like, I can add more functions to the dashboard. I can create a dynamic dashboard letting you to monitor daily/weekly/monthly/custom-period. Also I can provide you a trend chart.
I specialize in Excel and VBA/Macro in Excel, Word, and Outlook with 20+ years' experience. I will perform any tasks in MS office to automate your business. Excel, VBA macros, custom forms, charts, condition formatting, absolutely any request will be satisfied in time.
Services Offered:
✅VBA Macros Automation for Excel, Outlook, and Word
✅Excel Formulas.
✅Formatting, Conditional formatting.
✅Data Analysis.
✅Approximately lookup/match/search
✅Customer Defined Function: Create new functions to execute special requirement, which cannot be done by Excel build-in functions.
✅Creating User Forms.
✅Charts.
✅Pivot Tables.
✅Dashboard
✅Dynamic table and chart: The content of the table and chart will change dynamically according to different options.
✅Barcode, QR code generation
✅Inventory system
✅Different file conversion: Word, Excel to PDF, PDF, image to Word, or Excel.
✅Data entry with 100% of accuracy.