Excelhelpsu

Hello Friends,

Here we learn how to work on excel, & increase our excel skills for good Job performance & also in studies. We offer a tutorial (Introduction, Basics, Function, Data Analysis) on how to use Excel. Below you can find a complete overview. Want to learn much more Excel? You can find related examples and features. We keep it easy!

Microsoft Excel is a spreadsheet developed by Microsoft. It features calculation, graphing tools, pivot tables and etc.

Open an Excel window as shown in above picture.

Click on Start Button at your task bar then Accessories after then MS OFFICE and then MS EXCEL.

START - ACCESSORIES - MS OFFICE - MS EXCEL

Or

You can search at your task bar button, just type EXCEL.

Now, we are going to start work on excel.

FORMULAS FOR EXCEL : -

• Sum -

Summation, the addition of a sequence of numbers. Addition, the elementary mathematical operations of arithmetic that totals amount of quantities combined.

Sum, an old name for the Finns in East Slavic languages, derived from the work Suomi, "Finland".

A sum is the result of an addition. For example, adding 1, 2, 3, and 4 gives the sum 10, written

As shown in above picture, which cells(quantity) you are going to be add, go to blank cell write =sum(select cells which you want to add)

There is also a shortcut for adding cells

ALT + +(ADD KEY)

• Count - 

1. COUNT IF -

If you need to count the number of cells that contain text (i.e. not numbers, not errors, not blank), you can do so with the COUNTIF function and a wildcard.

COUNTIF counts the number of cells that match the supplied criteria. In this case, the criteria is supplied as thewildcard character "*" which matches any number of text characters.

A few notes:

• The logical values TRUE and FALSE are not counted as text
• Numbers are not counted by "*" unless they are entered as text
• A blank cell that begins with an apostrophe (') will be counted.

A)  To count the number of cells that contain exactly fruit.

B) To count the number of cells that contain exactly fruit + 1 character. A question mark (?) matches exactly one character.

C) To count the number of cells that contain exactly fruit + a series of zero or more characters. An asterisk (*) matches a series of zero or more characters.

D) To count the number of cells that contain fruit in any way. No matter what is before or after fruit, this function finds all the cells that contain fruit in any way.

E) To count the number of cells that contain text.