How to find Spelling Mistakes in Excel

This blog post is about two methods to spot the misspelled words in an Excel Worksheet. Following is data which we will be using to explain these methods. Spelling tool in Excel to find the misspelled words Select the cells containing data > go to the Review tab of the Excel ribbon > click on…

Convert PDF to Excel using Power Query

Excel with Microsoft 365 has a PDF connector which enables us to extract data from PDF files. The beauty of this method is that the extracted data will automatically update for the changes in the source data. Let’s see how to extract the Tables in a PDF file using Power Query in Excel. Following is…

How to get the Decimal part of number in Excel

This blog post is about 3 different methods to extract the decimal part of a Number. TRUNC function to extract the Decimal part of a Number The TRUNC function in Excel truncates a number to the given precision. The formula =TRUNC(4.159) will return 4. The following formula will extract the decimal part of the number…

How to save an Excel Table as Picture

This blog post is about 5 methods to convert data in an Excel worksheet to a Picture. Copy and Paste as Picture Select the cells containing data > Right-click > Copy Right-click on the cell where you want to place the picture > Paste Special… > Select Picture (U) from the Other Paste Options And…

How to Remove Duplicates in Excel (7 Ways)

This tutorial is about 7 different methods to Remove Duplicates in Excel. I will be using the following data to explain the different ways to get rid of the records that repeat multiple times. Remove Duplicates tool in Excel The Remove Duplicates feature in Excel is the most popular tool for removing duplicates and is…

Very Hidden Sheet in Excel

In Excel, there can be two types of hidden Worksheets. One is ‘hidden‘ and other one is ‘very hidden‘. The normal ‘hidden’ mode is known to most of the Excel users. But the ‘very hidden’ mode is less known and Advanced Excel users make use of this feature. Very Hidden Worksheets are often used to…

Two Way Lookup in Excel

In Excel, we have the VLOOKUP function to perform Lookup in Vertical direction (Rows) and the HLOOKUP function to Lookup in Horizontal direction (Columns). But for 2 Way Lookup? i.e. to perform Lookup in both columns and rows? No. Excel doesn’t have a dedicated function for this purpose. We should create the formula for 2…

How to Remove Formulas and keep data in Excel

This blog post is about 5 methods to remove formulas from an Excel worksheet without altering the results. In the following dataset we have formulas in the columns D and E. Let’s see how to remove the formulas in the columns D and E while keeping the results intact. Copy and Paste as Values To…

Different methods to Display Formulas in Excel

This blog post is about 4 different methods to Display Formulas in Excel. Following is the screenshot of the data used to explain the different ways for displaying formulas. Show Formulas button To display all those formulas used in a worksheet, go to the Formulas tab in the Excel ribbon and click on Show Formulas…

Different methods to Extract only Numbers from a Column

In this tutorial, I will show you 5 different ways to Extract only Numbers from a list of Strings. Following is a Table containing Text as well as Numeric Values and we will be using this data for explaining the different methods. FILTER Function to extract Numbers The ISNUMBER function in Excel can be used…