Converting a PDF file into Word document is surprisingly easy. And this feature is available in Word 2013 and all later versions of Microsoft Word. To convert a PDF file into a Word document, Open Microsoft Word > go to the File tab > Open > Browse The Open dialog will be activated > Use…
Until now, Excel doesn’t have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture Lookup in Excel. In this Excel tip tutorial, I will show you how to do Picture Lookup using the existing features in Excel. I have the list of…
In this blog post we will go through 3 different methods to create a Hyperlink to another Worksheet in Excel. Following is the data which we will be using to explain these methods. Given below is the Cost summary of a Highway Project and the Total cost is the consolidation of amounts from the Worksheets…
This blog post is about an Excel formula which will return the Count of a particular Weekday or Weekend between two dates. The following formula will give us the Count of ‘Sundays’ between ’01/01/2022′ and ’31/12/2022′. =SUMPRODUCT(–(WEEKDAY(SEQUENCE(“31-12-2022”-“01-01-2022″+1,,”01-01-2022”))=1)) Let’s see how this formula works. Explanation of the Formula The SEQUENCE function will generate a list of…
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…
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…
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…
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…
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…
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…