A friend of mine asked me to take him through VLookUp Excel function. VLookUp is a powerful function in Excel which when well understood, will make your working with data in excel very easy .
I found a very good tutorial on Youtube by ExcelIsFun which covers VLookUp and HLookUp. It covers over 25 Exercises on VLookUp and HLookUp.
You can check it up here:
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…
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…
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 …
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…
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…
SAS Studio is a very powerful statistical program which are used by many corporations for various analytic and data science tasks. We briefly want to look at how we can check sum frequency statistics on some columns / attributes in our data. lets set the library name for our working directory where our dataset is…
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.
