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
What is a Data Warehouse?
In this article we will analyze what Data Warehouse is, what it consists of and what is its usefulness. In the age of IT, managing the ever-increasing data is becoming more and more difficult. We want to leverage the data… 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
How we can use functions in Microsoft Excel
How can we make use of the most useful Microsoft Excel functions? In this article we will analyze some of the most basic and most useful functions and how to use them correctly. Through the functions... read more
