Sometimes it is very necessary you get the last Column or last Row of your dataset in Excel This is a simple VBA code to get the Last Column and Last Row in your dataset Sub lastRow1() lastRow2 = Cells(Rows.Count, 2).End(xlUp).Row End Sub What the above code does is that, we are using the
If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data Analytics projects, you will realise that all these languages have similar syntaxes, or at least, can achieve the same objective with very similar codes. Below is a comparison and similarities of these various tools
Let’s assume we have some simple goals we want to achieve. Lets set our goals as follows: We enter our goals / targets in column 1. We have to set up our table correctly to make the Gantt chart creation easier and straight forward for us. We enter our goals in column B In column
We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is
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 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.