Some Useful Functions in Excel
In this tutorial we’ll learn the use of different useful functions in Excel.
Author: Niket Kedia
Separate words using Flash Fill 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.
Social Media Dashboard Mobile Template for Tableau
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.
Download Tables from any Webpage to Excel
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
Mobile Template for Tableau Dashboard
This is reusable Mobile Template for Tableau Dashboards. Download and enjoy (inspired by VizCandy).
Trend Arrow Chart in Excel
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.
Find Formula fields in Excel sheet
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.
Count the number of words separated by comma in Excel
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.