Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.
Hello friends! Today I’ll be showing you how to show Indian number format in Tableau. There are many ways by which you can show the numbers in Indian number format but this is most perfect ways to present.
Today we’ll be learning some tips and tricks in Tableau to make out analysis faster. This we’ll be very helpful to increase your efficiency while working with large amount of data and tight deadline.
This article will help you to understand about the different site roles in Tableau Server.
Site Roles for Users
Every user added to Tableau Server must have an associated site role. The site role is assigned by the administrator. The site role determines the levels of permissions allowed for a user, including whether a user can publish, interact with, or only view content published to the server. Administrators are also defined based on the site role.
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?
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more
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
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.