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.
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.
