How To APPLY FILTER In EXCEL- Essential Skill
Filtering in Excel is a powerful tool that can help you manage and analyse your data more effectively. Imagine having a magic…
How the SUMPRODUCT formula in Excel can help you work more efficiently
When it comes to performing calculations and analysis in Excel, numerous functions can save you time and effort, one of which is…
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
There are many areas within business reporting where we are looking for the average of a selection of results. A good example…
How to total a range of cells in Excel
The quickest way to total a range of cells in Excel is to use the SUM function. The Sum function is one…
How to Sum only visible cells in Excel when using Filter
A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible…
Excel – How do I sum a range of cells that include #N/A or #DIV/0! errors?
Most of us will agree that error values can be helpful and sometimes extremely unhelpful. For example, the #N/A (Value Not Available)…