Xiang Z.

I specialize in Excel and VBA/Macro, Office Script 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, Office Script. ✅Excel and Google Sheets, PDF forms ✅Formatting, Conditional formatting. ✅Data Analysis. ✅Power Query ✅Approximately lookup/match/search ✅Customer Defined Function: Create new functions to execute special requirements, which cannot be done by Excel built-in functions. ✅Creating User Forms. ✅Charts, flow chart, organization chart, Gantt chart..... ✅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. ✅AutoHotkey in office automation