本リポジトリは超絶Excel VBAのサンプルプログラムです。書籍では、「えっ Excelでこんなことができるの？」と本気でExcelを使い倒す方法を紹介します。特に、Excelマクロの機能を活用して、Web ...

Pythonの人気機械学習ライブラリ『scikit-learn』をPythonなしで手軽にExcel VBAから使うためのプロジェクト。 ワークシートにデータを書いて、ラベル列を指定するだけで、機械学習のデータセット ...

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

Visual Basic for Applications, or VBA, is a Microsoft programming language that allows users to create scripts to execute certain actions, automate repetitive functions, and create custom forms and ...

Hamza is a certified Technical Support Engineer. The “Compile error in hidden module” error occurs when you open a VBA project in Microsoft Excel. It occurs when ...

In an Excel workbook it is possible to insert a GIF, although the animation will only work when the image is inserted into a control. This can be done through Control Toolbox, Design mode and ...

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...