Monthly Archives: April 2019

The COUNT function

Kornilios Ampatzis/ April 2, 2019/ Functions

The COUNT function provides us with a way to count the number of cells that contain numbers.

The COUNTA function

Kornilios Ampatzis/ April 2, 2019/ Functions

The COUNTA function counts the number of cells in a range, that are not empty.
It is sometimes being confused with its sibling COUNT function.

The SUM function

Kornilios Ampatzis/ April 2, 2019/ Functions

One of the most used functions in Excel is the SUM function. It is used to calculate the sum of a cell range and can be used by itself or in combination with other functions boosting their potential.

How to use Goal seek in Excel

Kornilios Ampatzis/ April 1, 2019/ Tutorials

Some of the most useful features in Excel, are hidden under the data ribbon button, What-If analysis. In this tutorial, we will try to explain and use the Goal Seek feature.