Microsoft Excel
-
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 Remove Spaces in Excel? 3 Easy Methods
(Note: This guide on how to remove spaces in Excel is suitable for all Excel versions including Office 365) Dealing with large data in Excel can be quite difficult. Especially, when you copy or import huge data from any database, dealing with them can be a bit complicated. Sometimes, various functions and formulae might be…