Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.

Other Excel tutorials and resources Overall, the COUNTIF () function is fairly simple to use — it’s the condition expressed in criteria that might cause confusion.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

Microsoft even provides a template for a simple Excel break-even chart. The template saves time and provides a convenient interface for inputting data as well as clear, easy-to-read results.