Freelancers using WPS Office in ChinaFreelancers using WPS Office in China
ProjectsPeople
shuai yang's avatar
shuai yang
China
Excel Automation Specialist | VBA, Power Query & Power BI
New to Contra
Excel Automation Specialist | VBA, Power Query & Power BI
Cover image for This anonymized business performance report
This anonymized business performance report demonstrates how I use Excel automation to transform complex operating data into a clear management reporting system. Automated calculations connect the executive overview with detailed profitability analysis for more than 200 products, covering revenue, discounts, material costs, labor, logistics, packaging, operating expenses, and profit. Supporting cost schedules make manufacturing, selling, administrative, financial, and tax expenses traceable, reducing manual consolidation and supporting faster business decisions.
0
25
Cover image for I designed and built a
I designed and built a dynamic Excel procurement dashboard using 720 synthetic purchase records. Users can filter the report by date, region, category, and supplier, while all KPIs, charts, and transaction details update automatically. The dashboard tracks total spend, budget savings, purchase-order volume, on-time delivery, quality performance, and average lead time. It also includes a dynamically filtered transaction view, supplier and product master data, performance comparisons, and formula-driven analysis tables. This project demonstrates my ability to transform complex business data into a clear, interactive, and reusable Excel management system for faster procurement decisions.
0
18
Cover image for This video demonstrates an Excel
This video demonstrates an Excel VBA-based inventory workflow covering inbound stock entry, outbound processing, automatic inventory updates, and low-stock alerts. Master data is reused to reduce repetitive entry, transactions are recorded for traceability, and products below the minimum stock level are clearly flagged. It shows how routine warehouse tasks can be transformed into a faster, more accurate, and reusable office automation workflow.
0
36
Cover image for I designed and built an
I designed and built an office automation tool that reads, cleans, validates, and consolidates PDF orders from multiple stores. In this demo, it processes 34 PDF orders across 9 stores and 219 products, then automatically generates an Excel summary and delivery notes. It also provides live processing logs, error alerts, product master data maintenance, and one-click printing—turning a repetitive workflow into a fast, accurate, and reusable automation system.
0
52
WPS Office(1)
Amir Azam's avatar
Amir Azam
Shanghai, China
AI Workflow Assistant | Research Specialist | Educator
AI Workflow Assistant | Research Specialist | Educator
Cover image for AirPods Pro Exploded Architecture Infographic
AirPods Pro Exploded Architecture Infographic
0
105
Cover image for Apple Expected Smart Glasses Concept Infographic
Apple Expected Smart Glasses Concept Infographic
0
116
Cover image for iPhone 18Plus Expected Titanium Frame
iPhone 18Plus Expected Titanium Frame
0
111
Cover image for NVIDIA Blackwell Ultra Exploded Architecture
NVIDIA Blackwell Ultra Exploded Architecture Infographic
0
120
WPS Office(1)