VBA (Visual Basic for Applications) was created in 1993 by Microsoft and integrated into version 5 of Excel (who remembers!?). Since then, millions of users around the world have sought to automate repetitive tasks in Excel, often turning Excel into applications that serve the most diverse purposes (some quite funny!).…
Sometimes it is necessary to write a report in text format, in Word, for example, which contains data relating to a specific indicator. The most common process is to write the text separately from the numerical values, filling in the data manually, or through “copy-paste” in the document. Wouldn’t it…
The scenario is common to many companies: they receive hundreds or thousands of documents per year from their suppliers and want to automate the archive according to their business rules. This facilitates organization, auditing, research and internal control. In this article, we’ll look at how to create an automated archiving…
I’m a great fan of Matthew Devaney’s blog on Power Apps, Power Automate and everything else on Power Platform development. His latest post, The fastest way to read large Excel table in Power Automate, immediately got my attention, because we’ve just finished a project for a client in which this…
For companies that build their strategy around the customer and their satisfaction, there are three machine learning models that are relatively easy to apply and can have a high impact: clustering, as a way to understand consumer behavior; association rules, which uncover which products are frequently bought together; and churn…