Sometimes, you need some charts to explore your data and many times when your analysis is done and you want to report, you would most likely want to convey your message using charts and graphs. This is a quick look at some charts which are available and their names: We use this raw data in…
When you run a query , for example, in SQL and you copy and paste the result in Excel, and the copied data contains, address and other numbers, it is very good to double check how the pasted data shows in Excel as numbers with hyphens and slashes in between them can be interpreted as…
This is a quick code to create a BUTTON , CHECKBOX and COMBO BOX and assign some action to them using “MessageLoop Format”. The general message loop format is While 1 $iMsg = GUIGetMsg() … … WEnd Action is put into the WHILE LOOP using the SWITCH and CASE STATEMENT. The GUIGetMsg() function polls…
Adding actions to messages boxes Message Boxes, like most functions, return one of these values and their respective meanings Button Pressed Return Values: OK = $IDOK (1) CANCEL = $IDCANCEL (2) ABORT = $IDABORT (3) RETRY = $IDRETRY (4) IGNORE = $IDIGNORE (5) YES = $IDYES (6) NO = $IDNO (7) CONTINUE ** = $IDCONTINUE (11) TRY…
Autoit is a very simple yet powerful tool to automate simple scripts. Today, we are looking at LOOPS. Credit to 403forbidden403. You can check her on Youtbue ;loops ;lets declare a varible $var = 1 ;lets write an if statement if $var = 1 then MsgBox(6,”if Statement Message box”,”How does the message box look?”) endIf This…
There are a couple Free Open Source Data Visualization Tools and Services which you can make use of for your work data exploration and visualization purposes. Below , I list a few ones in no order of importance. Caravel: It is a Python based data exploration and visualization software by Airbnb. It is powerful and…
This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can check him on Youtube Let’s create a simple VBA code in a module A simple code like this will do for our example Sub NameIsNanaKofi() Worksheets.Add Range(“A1”).Value = “My Name is Nana Kofi”End Sub …
This is a quick and simple VBA code with some comments about the structure and how it the basic syntax works for beginners. Credit to WiseOwlTutorials, you can check him out Youtube. Sub createAndLabelNewSheet() ‘create new worksheet // this is a comment. comment is denoted by an ‘apostrosphe sign ‘Basic VBA sentence structure ‘thing.action ‘always name…
For a refresher tutorial or quick look up on INDEX and MATCH Functions in Excel, ExcelIsFun on Youtube explains it very clearly with great examples. His explanation is clear and the examples are real-life and practical enough to let you understand the concepts pretty well. He has done a good job to also provide free practice Excel Practice workbooks which you…
This is a just a bit of addition to a previous post, by formatting the Excel output further using the Python XlsxWriter package. The additions are : Colour formatting has been added to the Total Cost column The “Total Cost” has been given a money formatting The above uses row : column numeric values instead…
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.