In this morning's routine, I started Chapter 2 of Ken Yoshida's book. This time, I performed data processing in Excel VBA while referring to the sample data included with the book. ※The sample data ...
I'm a fan of the open-source philosophy, and given the price of Microsoft 365, the push for desktop alternatives to Microsoft Excel is louder than ever. Yet, I can't make the leap. While these local ...
The day before the deadline. Thinking, 'This task is here again,' while typing the same numbers into the same cells. Aggregating sales by representative, formatting the layout, re-assigning serial ...
Spread the loveEver found yourself staring at a complex project schedule in Microsoft Project, wishing you could just, well, ...
In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, ...
This project provides a complete solution for scraping Morningstar fund data, specifically designed to extract NAV (Net Asset Value) and fund name information. It includes both a Python scraper and an ...
Automated processing of bank statements from multiple banks with different formats. The pipeline normalizes column names, merges data into a single table, and classifies each payment by branch, payer ...