Chang Yanwei Office Knowledge
Home · About

About Chang Yanwei Office Knowledge

Streamlined online tools · Useful, easy, secure

What is Chang Yanwei Office Knowledge

Chang Yanwei Office Knowledge is an independent streamlined online tools site, part of a personal easy-office tool series. It is not affiliated with Microsoft in any way. It includes 39 general tools plus VBA, M, and DAX professional sections. VBA, Excel, Power BI, DAX, and M are registered trademarks of Microsoft. All processing happens in your browser — no data is uploaded to any server.

Who uses Chang Yanwei Office Knowledge

General office / dev / data analysis

Anyone who needs JSON formatting, hash, Base64, URL encoding, character counting in their daily work

VBA upgraders

Developers transitioning from Excel VBA to the modern data stack, who need M / DAX learning paths

Power BI beginners

Data analysts new to Power BI who need VBA → DAX conversion, DAX formatter, error checker

Key audience: VBA upgraders + data analytics beginners (VBA / M / DAX sections are the core)

What Chang Yanwei Office Knowledge can do

General tools (9, live)
  • Timestamp · Base64 · Char Counter · JSON Formatter · Password Generator · Color Converter · URL Encode · Hash · Text Cleanup
Blue ocean tools (5, planned)
  • YAML ⇄ JSON · JWT Decode · TOML ⇄ YAML · Text Diff · CSV ⇄ JSON
VBA / M / DAX pro tools (14 tools, 3 product lines)
  • VBA tools: one-click code formatting · convert VBA to Python/SQL/R · tutorial aggregator
  • M code tools: generate M scripts from plain text · code beautifier · error checker
  • DAX tools: generate measures from plain text · code beautifier · VBA → DAX converter · error checker
Learning paths
  • Complete VBA → M → DAX transition path · 30 must-know DAX formulas · 50 practical M code examples

Roadmap

  1. 9 core tools launched and verified with automated tests
  2. Architecture design and refactoring plan completed
  3. Next.js 15 site launched, VBA / M / DAX tool integration complete
  4. Domestic deployment (ICP filing in progress)
  5. Upcoming: public API + mobile PWA

See Changelog and Git repo for details.

Contact