Advanced Table in Excel using VBA
Hello friends! Today we’ll be learning about the Advanced Table in Excel using VBA. This post will be very using useful. Advanced Table in excel is very useful in many cases and also to replace pivot table in Excel.
Tag: Data Analytics
Labour Performance Dashboard in Tableau
Labour Performance Dashboard for Manufacturing Industries
I have created Labour Performance reusable dashboard for manufacturing industries. Feel free to use as you want. The dashboard build using complex use of parameters and chart control.
Index-Match Functions in Excel
Today we’ll be learning about one of the very important functions Index function with Match function which is very strong strong combination.
There is always been this debate- which one is better Index-Match or VLOOKUP?
Pivot Tables in Excel
Today we’ll be learning about Pivot Table. Pivot Tables is one of the most powerful features of Excel. Pivots Tables are great way to summarize, analyze, explore, and present your data.
Worksheet is attached for downloading and reuse.
PostgreSQL connection to R
Today we’ll be learning to connect to Postgre SQL like Amazon Redshift to R. So the package available in R is RPostgreSQL.
Quadrant Chart in Tableau
Today we’ll be learning to create Quadrant Chart in Tableau. I have used ‘World Indicators’ data for the tutorial. Tableau workbook is attached for download.
IF, COUNTIF, SUMIF Functions in Excel
Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.
Some Useful Functions in Excel
In this tutorial we’ll learn the use of different useful functions in Excel.