

Category Archives for "Excel Tips"

22 How to Compare Two Columns in Excel (for matches & differences)

Compare Lists in Excel - matches are shown as TRUE

The one query that I get a lot is – ‘how to compare two columns in Excel?’. This can be done in many different ways, and the method to use will depend on the data structure and what the user wants from it. For example, you may want to compare two columns and find or […]

27 How to Create a Data Entry Form in Excel (Step-by-step Guide)

Excel has many useful features when it comes to data entry. And one such feature is Data Entry Form. Why Do You Need to Know About Data Entry Forms? Maybe you don’t! But if data entry is a part of your daily work, I recommend you check out this feature and see how it can […]

5 Excel Sparklines – A Complete Guide with Examples

Sparklines feature was introduced in Excel 2010. In this article, you’ll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can […]

15 Find the Last Occurrence of a Lookup Value a List in Excel

In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. […]

15 100+ Excel Interview Questions & Answers To Make You Job Ready

Excel Questions for Job Interview - Cover

Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the work […]

7 [FREE Invoice Generator Template] Save Excel Invoice as PDF

I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings. Once you have a GST number, you need to file your tax return every month (in India). So every month, my Charted Accountant would reach out to me asking for sales invoices […]

9 Extract Data From PDF to Excel with this Converter (FREE TRIAL)

Convert Button Convert to Excel dialog box

Want to convert a PDF to Excel? Here is a tool that you can use to extract data from PDF to Excel with a high accuracy and format. You also don’t need to give your email address or upload your PDF files anywhere. This tools is completely secure and convert PDF to Excel in seconds.

« Previous 1 2 3 4 5 … 34 Next »