Excel Basics

How to Find a Named Range in Excel (4 Easy Ways)

For various Excel objectives, we occasionally change the names of cells and ranges to suit our needs. Finding and navigating to a specific named ...

[Fixed!] Excel MATCH Function Not Working

While working on a vast data set you sometimes get stuck with the MATCH function not working issue. So, to help you overcome this issue, we will ...

How to Create a Weighted Sales Pipeline in Excel

Having a comprehensive picture of the leads and sales in a sales pipeline may undoubtedly boost conversion and sales rates. However, this may result ...

[Fixed] Excel Failed to Launch in Safe Mode (4 Easy Solutions)

When any unknown error causes the Excel file to not open, Excel safe mode can be a way to launch the file. This special mode can be run in multiple ...

How to Find and Replace Text Color in Excel (3 Quick Ways)

Certainly, finding and replacing text color in Excel is a common task that we have to perform in order to organize, highlight and present data in a ...

Excel Conditional Formatting for Odd and Even Numbers and Rows

While working with large data sets in Microsoft Excel, you may need to highlight odd and even numbers from the worksheet because of the convenience ...

How to Customize Ribbon in Excel (2 Easy Ways)

In this article, you are going to learn about how to customize ribbon in Excel. In general, the ribbon is the strip of buttons and icons at the top ...

How to Reduce Excel File Size by Deleting Blank Rows

In this article, we will demonstrate how to reduce Excel file size by deleting blank rows. Often a file in Excel becomes very large and takes a huge ...

How to Merge and Center Selected Cells in Excel (4 Ways)

You may need to use the same values in some cells. In that case, you don’t need to insert the same cell value repeatedly, simply you can merge and ...

How to Fix When Excel Not Responding Without Losing Data

Has your Microsoft Excel file suddenly ceased to function and begun to display the Excel Not Responding error message? Further, while attempting to ...

How to Ignore Blank Cells in Excel Sum (6 Ways)

This article will show you how you can ignore blank cells in Excel sum. In the spreadsheet, sometimes we have to sum a data range that has blank ...

[Fixed] Excel Ribbon Keeps Disappearing (5 Easy Solutions)

Excel ribbon is like a navigation tool for the whole Excel workbook. One can access and use excel features using the ribbon tabs. So, it is mandatory ...

How to Use Custom Autofilter in Excel for More Than 2 Criteria

Excel spreadsheet can be used for custom autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In ...

How to Merge Vertical Cells in Excel (6 Easy Ways)

The Merging operation helps us combine more than one cell in Excel. Often, we find a data sheet that contains a lot of columns and rows, and this is ...

How to Link Textbox to Multiple Cells in Excel (4 Easy Ways)

A textbox is a portable tool that is used to cover important text or information in Excel. You can drag the text box anywhere in the sheet. Also, it ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo