先日、Twitter（現X）でこのポストをしたところ、とても多くの反応をいただきました。 会社でExcel講習の講師をやっていることもあり、よく「これどうしたらいいですか」と相談されます。

株式会社クリーク･アンド･リバー社（C&R社）は2026年2月13日（金）・27日（金）、普段からExcelを使用されている方を対象に無料のオンラインセミナー「『表計算』『データ集計・分析』『視覚化』3つに分けて体系を理解するExcelシリーズ データ集計・分析 ...

Excel’s vast functionality can often feel overwhelming, but mastering a few essential techniques can make a significant ...

毎月のコピペ集計・転記・グラフ作り直しを「更新ボタン1回」にするための記事集です。CSVやExcelの結合、表記ゆれの修正、更新エラーの直し方から、Power BIの月次レポートま… もっとみる ...

Years of accumulated files suddenly became patterns I could see, understand, investigate, and actually deal with.

The January 2017 JofA article “Data Mining Your General Ledger With Excel” presents a step-by-step, formula-based approach to extracting general ledger data and then scrubbing them so that they can be ...

Did you know that data analysts spend up to 80% of their time cleaning and preparing data? If you’re nodding in agreement, you’re not alone. The good news is that tools like Power Query in Excel and ...

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes. Microsoft Power Query ...

Many people avoid Power Query because they think it's too technical, but it's actually one of the safest and easiest ways to organize your data. It handles the dirty work with an intuitive interface, ...

Q. There was a December 2020 article in the JofA about cleaning and joining data using a program called Alteryx, but we don’t have access to this program. Could you explain how to do those tasks using ...