In continuation of the previous article we will see some more VBA (Visual Basic for Applications) routines that we can use in Microsoft Excel. These routines can be executed by calling them on a button or after some… read more
How do we connect a Microsoft Excel to SQL Server
Microsoft Excel, although we use it every day and is one of the most well-known and oldest Microsoft programs, hides many possibilities. In this article we will see how to connect a SQL Server database... read more
How to make charts in Microsoft Excel using Python
In Microsoft Excel, in addition to using functions and pivoting, we have the possibility to add graphs based on this data. But we know that graphs can also be made using Python with libraries such as matplotlib and seaborn.… read more
How do we automatically save attachments we receive in email (Microsoft Outlook)
How would it feel if attachments sent by a certain sender with perhaps a certain title and many others perhaps, could automatically be archived in a computer folder dated? We also wouldn't be able to upload them like that... read more
Useful VBA routines in Microsoft Excel (Part 1)
We have talked in a previous article about what VBA (Visual Basic for Applications) is and what possibilities it has within Microsoft Excel. In this article we will look at some routines I have written that can be executed by calling the… read more
How to record who last modified the record in shared Microsoft Excel
We all know Microsoft Excel as one of the most basic and first programs created for use with a graphical environment on computers. Many times we have a shared Excel file that is being edited by multiple users. Maybe for… read more
Pivoting in Microsoft Excel using Python
In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
Vlookup with Python without using Microsoft Excel functions
Microsoft Excel is very efficient when managing a small amount of data. But it requires the use of functions which are very easy to modify by mistake or to forget to remove them before saving the result. Somewhere there comes the… read more
What is VBA and how to use it in Microsoft Excel
We all know Microsoft Excel as one of the most basic and first programs created for use with a graphical interface on computers. Excel is a program that manages spreadsheets. It is a mini database that… read more
