本リポジトリは超絶Excel VBAのサンプルプログラムです。書籍では、「えっ Excelでこんなことができるの？」と本気でExcelを使い倒す方法を紹介します。特に、Excelマクロの機能を活用して、Web 巡回(スクレイピ ング)から機械学習まで、昨今の革新的な技術を ...

Imagine you want to fill out a PDF form for 100 employees with a specific name and address for each of them. You got the PDF form and all your staff information in an Excel file. That's when ...

Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

Discover expert Power Query tips to reduce steps, streamline workflows, and optimize performance for cleaner, faster data ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know. I've been writing about computers, the internet, and technology professionally ...