Microsoft Excel
How to Custom Sort Excel Data? 2 Easy Steps
(Note: This guide on how to custom sort Excel data is suitable for Excel 2016, 2019, 2021 and Microsoft 365 versions) In this article, let us see how to use Excel custom lists to sort information in a list or table in a specific order. You’ll learn: Custom Sort Excel – An Overview Step 1…
Battle of the Excel Lookup Functions: VLOOKUP vs INDEX/MATCH vs XLOOKUP
(Note: This article on Excel Lookup functions is suitable for Excel 2019, 2021 and Microsoft 365 users) In this article, let us explore the three popular methods of performing lookups in Excel and see how they fare against each other. You’ll learn: Excel Lookup Functions – An Overview VLOOKUP INDEX MATCH XLOOKUP Excel Lookup Functions…
How to Print Gridlines in Excel?
Note: This tutorial on how to print gridlines in Excel is suitable for all Excel versions including Office 365. Gridlines are faint grey lines that are visible around the cells of an Excel worksheet. These Gridlines define columns, rows, and cell boundaries in Excel. They help you visually differentiate between cells and read the data…
Arrow Keys Not Working in Excel – 4 Easy Fixes
Note: This troubleshooting guide on the “Arrow keys not working in Excel” problem is suitable for all Excel versions including Office 365. Arrow keys have become an integral part of our day to day work involving computers. All the more so in Excel spreadsheets. The arrow keys help you easily navigate and scroll through thousands…
How to Record a Macro in Excel? In 6 Easy Steps (For Dummies)
Note: This tutorial on how to record a macro in Excel is suitable for all Excel versions including Office 365. Macros can be very intimidating to both Excel experts and newbies alike. But, that should not prevent you from using them altogether. Let me introduce you to the macro recorder in Excel. The Macro recorder…
6 Easy Methods to Strikethrough in Excel
Note: This tutorial on strikethrough in Excel is suitable for all Excel versions including Mac and Office 365. Excel is a great program for crunching numbers and there is no doubt about that. However, when it comes to formatting text, it can be a little confusing if you are not already familiar with some of…
How to Use the Excel IFS Function? – 2 Easy Examples
Note: This tutorial on the IFS function in Excel is suitable for Excel 2016 version and later, including Office 365. Have you wondered if there is a simpler way to handle multiple nested-IF statements in one step? Meet the Excel IFS function. Introduced in Excel 2016, it is designed to eliminate complex nested-IF statements. It…
How to Delete a Named Range in Excel? 3 Easy Methods
(Note: This guide on how to delete a named range in Excel is suitable for all Excel versions including Office 365) Named ranges are helpful in decluttering your spreadsheet, especially if you have numerous formulas and an abundance of data in your spreadsheet. If you are a regular Excel user, you would have come across…
How to Use the TEXTJOIN Excel Function? 3 Easy Examples
(Note: The TEXTJOIN Excel function is suitable for Excel 2019 and Office 365 versions) TEXTJOIN Excel Function: A Summary The TEXTJOIN Excel function, as the name suggests, joins two or more text strings into a single output string. It is not that different from the CONCAT function, except TEXTJOIN concatenates by default by including delimiters. …
How to Use the Excel DATEDIF Function? 3 Easy Examples
The Excel DATEDIF formula calculates the gap between two date ranges in the format of years, months, or days. It was originally introduced in a very old Excel version and documented only in Excel 2000. But, it can still be used in the latest versions of Excel including Office 365. In this tutorial, I’ll show…
How to Insert a Checkbox in Excel? 3 EASY Examples
(Note: This tutorial on how to insert a checkbox in Excel is suitable for all Excel versions including Office 365.) A checkbox is a graphical tool to select or deselect a variable or an option. Surely you have come across checkboxes at least once over the internet. These are extensively used to create forms, checklists,…
How to Combine Two Columns in Excel? 2 Easy Methods
Note: This tutorial on how to combine two columns in Excel is suitable for all Excel versions including Office 365. Manually merging columns in Excel can take a lot of time and effort. Here’s how to combine two columns in Excel the easy way. In this article, you will learn: How to Combine Columns in…
