Visual Basic - VBA
Get Last Column And Last Row Using VBA
Sometimes it is very necessary you get the last Column or last Row of your dataset in Excel This is
May 15, 2018
No Comments
Data Science
Java Python R SQL Excel Compared Similarities For Data Science and Data Analytics – The Basics
If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data
June 9, 2017
No Comments
Business Intelligence - BI
Creating a Gantt Chart Graph In Excel
Let’s assume we have some simple goals we want to achieve. Lets set our goals as follows: We enter our
January 21, 2017
No Comments
Automatically Open Excel and Send Report Using Batch and VBA
We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do
November 6, 2016
No Comments
Business Intelligence - BI
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
October 30, 2016
1 Comment
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
October 29, 2016
No Comments
Excel
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
October 20, 2016
No Comments
Excel
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
October 19, 2016
1 Comment
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
October 13, 2016
No Comments
Business Intelligence - BI
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
October 9, 2016
No Comments
DataPandas LTS
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs