Some times we need to download the tables from the webpages to the Excel for our Analysis. If the number of tables is more than 1 it will be very time consuming to format the table. In this tutorial we’ll learn how to download multiple tables directly into excel sheet and No need of extra formatting. I’ll be using Excel 2016. We will step by step. Read more
This is reusable Mobile Template for Tableau Dashboards. Download and enjoy (inspired by VizCandy).
Trend Charts are very good visualization technique in my earlier post Trend Chart in Tableau. I have used Tableau for the Trend Chart. In this tutorial we’ll learn how to make Trend Charts in Excel and use of Alt Key Codes and Paste Special in Excel.
While working on other’s Excel worksheet sometimes we need to find which columns are formula column, we can find while scrolling to each column but the work can be very tedious if we have more than 10 column. Today we’ll be learning to find the formula column in entire sheet having large number of columns (more than 100) in one go and one more very very useful function F5. I will make a separate tutorial for F5 function.
While working on a Project somewhere I needed to count the number of words in a particular cell. In this tutorial we’ll be learning to Count the number of words in a cell in Excel. The tutorial explained in step by step and worksheet is attached.
Some time we just need to visualize data that shows Year over Year (YOY) growth so we don’t have to drill down the data more for the explanation in others words for better and easy understanding of YOY growth we need some better visualization techniques.
Trend arrows are one of the best visualizations for the YOY growth like we have in stock market trending arrows on daily basis.
In this tutorial we’ll be learning to make create the Trend arrows chart in Tableau.
Sometimes we need our own custom Shapes or pictures to use in the Tableau Chart. In this tutorial you get to learn how to add custom shapes in Tableau (Workbook and Data-set are attached).
Donut Charts can be an effective way to show the comparisons in a unique way (Tableau workbook can be find in the end of the post).
I will be using Sample-store data(available on Tableau desktop as sample data).
