Office software is the most-used yet most-underrated workplace skill. Plenty of people have used Excel for a decade and still sum by hand; plenty build slides by swapping templates and watch them break the moment a requirement changes.
This guide does not rank by follower count. It groups creators by the specific skill you are missing. Find your gap and follow the right creator.
All ten creators below have profiles indexed on Dawn Island; click a name to see the platform, content focus, and any verified public figures.
Want a complete Office foundation
oeasy
A βdo-everythingβ free educator on Bilibili covering Photoshop, Premiere, Office, audio editing, and more β known for starting from absolute zero, hand-holding through every step, and holding nothing back. The tutorial series is exceptionally complete.
Who it suits: true beginners who want to lay a solid Office foundation in one pass. How to use it: do not pick and choose. Watch his series in order to build the underlying logic of each tool first; return later for specific needs.
PPT design and aesthetics
Pangmen PPT
A leading PPT design educator on Bilibili, focused on layout principles, visual logic, and taste training rather than simply stacking templates.
Who it suits: people who build reports, pitches, and courseware and want them clear and good-looking, not merely acceptable. How to use it: study his βwhy this layoutβ series to build layout judgement instead of copying formats.
Qiuye PPT
A workplace-oriented PPT training brand with strong template thinking, quick-win techniques, and high-frequency scenarios β very practical.
Who it suits: time-pressed professionals who must deliver a passable deck fast. How to use it: treat it as a first-aid kit. Use its quick routines under a deadline; use Pangmen to build taste the rest of the time.
Excel and WPS hands-on
Excel Caozuo
A Douyin channel for practical Excel β functions, pivot tables, and everyday high-frequency operations, explained directly and ready to apply.
Who it suits: anyone living in spreadsheets but feeling stuck at basic operations. How to use it: search his coverage of a specific pain point (vlookup, dedupe, split columns) β more reliable than scattered search-engine answers.
WPS Dalaoban
A Douyin educator in the WPS ecosystem β words, sheets, and presentations in the domestic office suite, close to real Chinese workplace use.
Who it suits: people whose company runs WPS rather than Office and need locally relevant features. How to use it: for WPS-specific functions (document collaboration, template centre) search him first β more on-point than generic Office tutorials.
Bite-sized workplace tips (Douyin)
The five creators below are all Douyin workplace-efficiency accounts with short, punchy styles β good for commute-time brushing, covering shortcuts, template ideas, and small tricks.
Chenge Bangong
Covers Word, Excel, and PPT workplace tips with a fast pace and clear scenarios.
Duidui Bangong
Approaches efficiency from a βdebunk the playbookβ angle, often dismantling inefficient habits β good for anyone wanting to change how they work.
Houge Bangong
Leans toward Excel and data-handling in real office scenarios.
Bingbing jie
Covers multi-tool workplace efficiency and communication, light and easy to pick up.
Sanmiao Office
Ultra-short trick snapshots β good for βlearn one move while waiting for the elevatorβ.
How to use these five: treat them as inspiration and a quick-reference, not as a course. Save useful moves and drill them over the weekend β far better than forgetting them the same day.
How to judge whether an office-teaching channel is worth following long-term
Three workable tests:
Is it systematic? Accounts posting only scattered shortcuts save you seconds but do not grow your skill. Series with a through-line are worth the long follow.
Does it explain the principle? βClick here and it worksβ loses to βwhy you click hereβ. The first leaves you helpless in a new scenario; the second lets you generalise.
Does it match your version? Office and WPS differ a lot in UI and version. A channel still teaching the 2007 menu helps little for someone on the latest WPS.
Common mistakes
- Collecting but not practising. Office software is muscle memory β watching ten times beats nothing; doing it once beats watching ten times.
- Chasing new tools blindly. Master pivots and slide masters first, then consider efficiency plugins, or you invert means and ends.
- Relying entirely on templates. Templates are fine for emergencies, but long-term dependence erodes your independent layout ability β and you stall the moment a non-standard request arrives.
To browse more profiles in this niche, see all indexed office creators.