I started teaching Excel for finance about 10 years ago. In 2015, with the launch of Power BI, I began a series of training sessions on this revolutionary data analysis and visualization technology, focused on business management. Today, we are…
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…
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…
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…
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…
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,…