This webpage is a platform for our project called The Vacuum University where we want to educate people how to use their favourite software efficiently and effectively. First, We are now concentrating on how to work with MS excel but we believe that some of our knowledge is transferable to other tools. Second, we are preparing and sharing materials how to go from novice to professional step by step. Last but not least, in future we want to continue with other useful software which is being used, however for starter, we have videos and other materials about the most famous spreadsheet.
Education can make a difference because quotes “I know” and “I don’t know” make the difference. And we know that the best feeling you can have is the feeling when you help someone.
Maybe you still don`t understand where this group is leading to.
Here it is. First milestone is that you know how to build report (it is dummy version of real report). There is daily automated process which consolidates data from three different data sources into one, refreshes all data and pivot tables, creates pdf and sends email to distribution list. Moreover, it takes the consolidated data and does all previous steps for different filters. If you want to automatize a report where you send overall picture to one group and only part of data (but still the same report) and another group, then you are on the right place. Therefore, you can have a global view as well as a partial view from one data source. In fact it is easier to create similar report than some reports you have seen in the past years.
It is not perfect. It is only our first step. Stay on track no matter how long it is.
we are starting Vacuum University and you are more than welcome to join us. You can expect educational materials mainly focused on Excel, Access, SQL, SAP Business Warehouse and whatever we will come to mind.
We are working on basics level as well as professional level of how to be super effective with technology. Last but not least, we have several videos and pdfs by now which we will gradually upload on Youtube and webpages.
We are looking forward to our brighter future full of personal growth.