カイケイテックのPower Query実践講座

Field notes

The course demonstrates an eight-operation Power Query recipe that reshapes a branch-by-month sales sheet into a long table, with one branch and month per row. Its teaching model pairs each lesson with a deliberately messy practice file and translates terms such as query, merge, and null into ordinary Japanese. The page also draws explicit boundaries: it targets recurring table cleanup, not cell formatting, screen automation, or datasets beyond Excel's one-million-row limit.