Various Types of Basic Charts For Data Analysis and Exploration – Visualization and Meaning
Sometimes, you need some charts to explore your data and many times when your analysis is done and you want…
Check Address Door Numbers Carefully in Excel
When you run a query , for example, in SQL and you copy and paste the result in Excel, and…
Generate AutoIT GUI and Assign Actions to Form Elements
This is a quick code to create a BUTTON , CHECKBOX and COMBO BOX and assign some action to them…
Add Action to AutoIt Message Box – Catching the Message Box Returned Value
Adding actions to messages boxes Message Boxes, like most functions, return one of these values and their respective meanings Button…
AutoIT simple tutorial on LOOPS – IF, FOR LOOP, WHILE LOOP, DO LOOP
Autoit is a very simple yet powerful tool to automate simple scripts. Today, we are looking at LOOPS. Credit to 403forbidden403….
Free Open Source Data Visualization Tools and Service
There are a couple Free Open Source Data Visualization Tools and Services which you can make use of for your…
Assigning a Simple Button to a VBA Code – Excel Microsoft Visual Basic
This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can…
The Basics – Visual Basics Macro Programming Start Up
This is a quick and simple VBA code with some comments about the structure and how it the basic syntax…
Excel INDEX And MATCH functions Explained from Beginner to Advanced with Examples
For a refresher tutorial or quick look up on INDEX and MATCH Functions in Excel, ExcelIsFun on Youtube explains it very clearly with great…
Python Pandas Pivot Table Index location Percentage calculation on Two columns – XlsxWriter pt2
This is a just a bit of addition to a previous post, by formatting the Excel output further using the…