Basic Excel Functions

Basic Excel Functions

Function	Meaning
=Sum(A1:A5)	Adds the total of numbers from range A1 to A5
=Average(A1:A5)	Average of numbers from range A1 to A5
=Max(A1:A5)	Shows the maximum number in range A1 to A5
=Min(A1:A5)	Shows the minimum number in range A1 to A5
=Count(A1:A5)	Calculates the number of entries in range A1 to A5

For non-continuous range, you can use comma to select different range.

 

For continuous range, you can select across different columns.

Download the file: blog_excel_work_files.xlsx from:
http://seanexcel.weebly.com/work-files.html

Combine words from different cells

You can easily combine or 'concatenate' texts and words from different cells into a new cell.
For example, you want to combine 2 words in cell A1 & A2 into cell B1.



Cell A1 contains the text "Alpha".
Cell A2 contains the text "123"
 
In cell B1, you type the formula =A1&A2. The end result: Cell B1 will show Alpha123.

If you want to separate the 2 contents with a space, you need to add a 'blank space'.
 


Cell A4 contains the text "Beta".
Cell A5 contains the text "234" In cell B4, you type the formula =A4&" "&A5. The end result: Cell B4 will show Beta 234.

 

You can also create sentences from the different cells. In the example above, you can write a sentence by combining text and cell data.  

By combining other Excel functions like SUM(), you can also create sentences and display the total of many numbers like above.

Download the file: blog_excel_work_files.xlsx from:
http://seanexcel.weebly.com/work-files.html