Today we’ll be learning to use Sheet as Filter in Tableau. This is very useful when you want to show the details under that chart. The Used Workbook is attached for download and I have used Superstore data for tutorial.
Today we’ll be learning how to make Toggle switch or Sheet Selector for worksheets or say how to use ‘Parameter as Filter’. This is very useful when you want to show different sheets with different filters and also the use of Parameters in Tableau. Tableau workbook is attached for download and I have used Superstore data for the tutorial.
We already have three sheets in our workbook.
Today we’ll be learning to create Navigation buttons for Dashboards in Tableau. This Navigation button is very useful for final Presentation and cool technique to make our final dashboard better. Tableau Workbook is attached for download.
Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.
In this tutorial we’ll learn the use of different useful functions in Excel.
While working on Excel sometimes we need to separate out words from a single column to multiple columns. Today we’ll be learning to separate First name, Middle name and Last name from a single column to multiple columns using Flash Fill in Excel.
Due to high demand I have created a Social Media Mobile Template Dashboard. I have made the Charts and Dashboard very fast so I have not used action filters in the dashboard. Download, Share and Reuse the Template according to your need.
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
