"Excel" category, page 2

#NAME error in Excel: reasons and fixes

Even experienced Excel users may encounter errors while working with complex spreadsheets. One such error is #NAME, which can be frustrating to deal with but is usually easy to fix, especially when you know the reasons behind it. Continue reading

How to edit, copy and delete drop down list in Excel

A drop-down menu in Excel makes data entry easier, faster and less prone to errors. Once a drop-down list is created, you may need to change it for a variety of reasons. For example, you may want to update the list with new options, insert the same picklist in other cells, or remove it from the sheet entirely. Continue reading

How to use EDATE function in Excel with examples

Microsoft Excel provides a variety of functions to calculate dates. When it comes to adding or subtracting months to/from a given date, EDATE is the function to use. Additionally, it can help you calculate expiration dates, anniversary dates, due dates, and a lot more. Continue reading

Excel DROP function to remove rows or columns from range or array

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers or footers. In earlier Excel versions, you'd have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by "dropping" irrelevant data. Continue reading

Excel AVERAGEIFS function with multiple criteria

When it comes to calculating an arithmetic mean of a group of numbers in Excel, you'd generally use the AVERAGE function. To average cells that meet a certain condition, AVERAGEIF comes in handy. To find an average with multiple criteria, AVERAGEIFS is the way to go. Continue reading

Excel conditional formatting Color Scales

Excel conditional formatting is all about visualizing data with colors. You may use contrasting colors to represent data categories or gradients to "map" data with some intrinsic order. When a certain pallet is used to visually represent data, it becomes a color scale. Continue reading

Data Bars in Excel: how to add and customize

To compare different categories of data in your worksheet, you can make a chart. To visually compare numbers in your cells, colored bars inside cells are a lot more useful. Excel can show bars along with cell values or display only the bars and hide the numbers. Continue reading