ExcelExplained

How to find duplicates in Excel using Conditional Formatting

Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas.

Subtotal by item type using SUMIF

If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function.

Sum sales by year using SUMIFS

If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.

Category - Sum

Beautiful Excel line chart

Improve your Excel skills

Learn how to work with functions, create complex formulas and design beautiful charts. All free.

You have Successfully Subscribed!