Microsoft Excel
Excel String Compare – 5 Easy Methods
(Note: This guide on Excel string compare is suitable for all Excel versions including Office 365) Excel is a very reliable spreadsheet tool. In spite of this, errors can creep in due to human oversight. And some of these errors can make or break your database. Let us say, for example, you have a list…
How to Fix the #REF Error in Excel? 3 Easy Methods
(Note: This guide on how to fix the #REF Error in Excel is suitable for all Excel versions including Office 365) Facing error messages is the last thing you want to see in Excel. They are quite frustrating to deal with and often difficult to resolve. The Excel #REF! Error is one of the most…
How to Hide and Unhide Columns in Excel? (3 Easy Steps)
(Note: This guide on how to hide and unhide columns in Excel is suitable for all Excel versions including Office 365) Excel comes with a whole package of features that helps us maintain and keep track of large sets of data. We have been covering these in our blogs. In this guide, let us see…
How to Stop Excel From Rounding? 4 Easy Ways
(Note: This guide on how to stop Excel from rounding is suitable for all Excel versions including Office 365) In Excel, numbers play a very major role. Large numbers can be quite bothersome. But, it is even more annoying when Excel automatically rounds off a larger value into a smaller value. Though in some cases you…
How to Make a Pie Chart in Excel? A Step by Step Guide
(Note: This guide on how to make a pie chart in Excel is suitable for all Excel versions including Office 365) Visual representations like graphs and charts are an amazing and innovative way to educate people on very intricate details. They help denote details in a simpler and easily understandable manner, which would be confusing using…
HLOOKUP vs VLOOKUP – 5 Key Differences
The LOOKUP function works like an index page in a book where we look at the topic to locate its page number. You’ll find the LOOKUP functions like HLOOKUP, VLOOKUP, and XLOOKUP in Excel categorized under Lookup and Reference functions. The LOOKUP function finds a match by comparing cells in a row or column and…
How to Count Unique Values in Excel? 3 Easy Ways to Count Unique and Distinct Values
(Note: This guide on how to freeze rows in Excel is suitable for all Excel versions including Office 365) Working with large amounts of data in Excel can be quite difficult. Some values may be repeated more than once. You might have to take into account multiple entries of data while performing any function to upgrade…
How to Freeze Rows in Excel? 4 Easy Steps
(Note: This guide on how to freeze rows in Excel is suitable for all Excel versions including Office 365) Avoiding clutter in your Excel spreadsheet is a separate skill in itself. They tend to get quickly overcrowded if not managed properly. Fortunately for us, Excel has built-in features to easily handle such situations. The Excel…
How to Sort Dates in Excel? 6 Easy Methods
Excel offers a variety of built-in tools to easily sort data in the spreadsheet. However, when it comes to sorting dates, things may get a bit confusing if you are not exactly sure on which basis to sort (weekdays, months or years). Let us say, for example, you want to arrange your co-workers’ birthdays in…
XLOOKUP vs VLOOKUP – 5 Key Differences
The Lookup functions are one of the most very popular formulas in Excel. They are used to search for one value in a column and return the corresponding value from another column. Over the years, the VLOOKUP function has become one of the most frequently used and must know lookup formulas. But, Microsoft Excel had…
How to Convert Excel to Word? 2 Easy Methods
(Note: This guide on how to convert Excel to Word is suitable for all Excel versions including Office 365.) Have you ever been in a situation where you needed to quickly convert an Excel document into a Word document, but could not find an easy solution. In some cases, you may want to present your Excel…
How to Convert Text to Numbers in Excel? 5 Easy Methods
(Note: This guide on how to convert text to numbers in Excel is suitable for all Excel versions including Office 365.) While using Excel, you will be dealing with lots of data in text and number formats. Sometimes texts and numbers may get accidentally intertwined, making it hard for Excel to differentiate the numbers from the…
