MS Excel is a good tool for organizational and accounting things and it can be used at any level. It doesn't require a lot of experience, because the tool is making everything seem easy. You can use it for your personal need too, with powerful functions such as advanced vlookup in Excel, find the position of a character in a string, or also count number of occurences of a string in a file.
The best part of using the MS Excel is that it has a lot of features and so you can even count the cells and count characters in a cell. Counting the cells manually is no longer a comfortable thing.
First, we will start with counting the cells. Because the MS Excel has a lot of counting features, there's no need for you to worry if it's right or wrong.
#1 - Click left on an empty cell, where you want the result to appear. Usually, this happens on the right cell after a row or in the bottom on completed cells.
#2 - The formula tab is right above the cells. Because finding the functions it can be quite challenging, you can simply write =COUNTA on the formula tab. After the word '=COUNTA', you will open some round parenthesis and write the number of the cells from which you want to get a result (e.g C1,C2,C3 etc.).
If you want to count the cells with a specific criteria (e.g. consecutive numbers), you will use the COUNTIF function. It works the same way as the COUNT function, but you have to change what's between the round parenthesis.
E.g. You are looking for numbers that are identically with the number in the C19 cell. In the formula tab, you will write: (C1:C2, C19).
How to to count number of cells in Excel matching criteria: =COUNTIF(C1:C99,X)
Counting characters in several cells from a text it is again very interesting and not that hard as any other people would say. You only need to know and use some functions. At least the counting is made by a machine.
There are two functions that works for a smart character counting - SUMPRODUCT and LEN.
#1 - You choose the number of cells that have the text you want to be counted.
C1, C2, C3, C4 and C5.
#2 - In the formula tab you will first write the SUMPRODUCT function and after the LEN function. Always in this order.