Admin
Sometimes you do not know the number of elements in an array before runtime. In most other programming languages, working with arrays and adding and deleting elements is easy. In VBA, this is not the case. However, there is a simple solution to dynamically populate arrays, with the ReDim statement. … Read more
Sending emails via VBA can be very useful. You can create powerful Excel macros, which help you automate your tasks and do your job faster and more efficiently. In this guide, I will show how to create a simple Excel macro with VBA, which you can use to send emails … Read more
In this article, I will teach you how to create beautiful interactive sales dashboards in Excel, using Pivot tables and Power Query. The guide is intended for people already familiar with basic concepts related to using Pivot tables and to some extend Power Query. However, you do not need to … Read more
Welcome to qDataLab. This site is meant as a valuable resource for professionals looking for advanced tools and guides for Microsoft Excel, Power BI, VBA, Power Query, and Dax. The topics will be related to business intelligence, data analytics, and the aforementioned tools in general. If you have a topic … Read more