VLOOKUP and HLOOKUP functions in Excel
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more
Tag: Excel
Pivot Tables in Excel
Today we’ll be learning about Pivot Table. Pivot Tables is one of the most powerful features of Excel. Pivots Tables are great way to summarize, analyze, explore, and present your data.
Worksheet is attached for downloading and reuse.
Connect your Facebook account to Excel
Today we’ll be learning to connect to Facebook account to download data from your account.
IF, COUNTIF, SUMIF Functions in Excel
Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.
Some Useful Functions in Excel
In this tutorial we’ll learn the use of different useful functions in Excel.
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.
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
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.