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

Have you ever wished Excel could do more than crunch numbers and organize data? Imagine generating polished PDFs or sending out personalized emails—directly from your spreadsheet—without needing to ...

Creating custom keyboard shortcuts in Excel can significantly enhance productivity by allowing users to perform tasks more quickly. By creating custom keyboard shortcuts tailored to your specific ...

Making a flowchart on paper is easy – you just grab a few pens and get going. The transition to digital makes things more difficult, however, with mice being imperfect tools for drawing. Thankfully, ...

Hagop is passionate about smart home products, especially when it comes to making life easier. He's always eager to try out new technologies to make life easier, in terms of cleaning, automation, and ...

ChatGPT has made a big name in the tech community in a very short time. This AI language model is well-known for its ability to translate language, summarize data, and perform statement analysis.

Flowcharts are one of the most efficient ways of presenting information in a visual and easy-to-understand manner. A flowchart can be used for any business process like sales, production, customer ...

You can draw a flowchart for processes in Microsoft Excel without using an external add-on. There are mainly two methods to do so. You can use one or a combination of both methods to create a ...

Although Microsoft Excel itself is a big calculator, using Excel Macro & VBA remains a popular method to create a calculator. Obviously, lots of coding is required to build a prototype of a calculator ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...