Lesson # 2: CONCATENATE Function in MS Excel

CONCATENATE() formula in MS Excel:

Now, what it does? And how are we going to use it in a spreadsheet?

Let us look how it works:

CONCATENATE = Joins several text strings into one text string.

Syntax or sequence of command:

=CONCATENATE(text1, text2, text3, text4)

and so on.

                Let’s look at our example below:

               

Figure 1

Lesson # 1: Average Function in MS Excel

AVERAGE() formula in MS Excel:

Now, what it does? And how are we going to use it in a spreadsheet?

Let us look how it works:

Average = Returns the average (arithmetic mean) of the arguments.

Syntax or sequence of command:

=AVERAGE(number1; number2; number3; number4)

and so on.

                Let’s look at our example below:

               

Figure 1

The Smartest Way: Running Microsoft Office Application

Shortcuts on running a Microsoft office application when icons are not around.
On an average user, they can’t start an application especially when they do not see icons on the desktop. When the Microsoft windows operating system evolved, some people find it difficult to find icons or start a program. But did you know that there is some kind of shortcuts when running Microsoft office application?

Excel Tips: Control(ctrl) + Enter Keys to fill an entire range with formula

Control(ctrl) + Enter Keys to fill an entire range with formula:

Many times, we have to apply the same formula for a range of cells (see image below).

Trivia # 1

Who was the legendary Benedictine monk who invented champagne? 

Answer: 

Dom Pérignon

Copy Worksheet the Smartest Way

How make a copy of a worksheet the smartest way:

Normally, one would right click a sheet and then click Move of Copy…

Aroma That Can Energize

Location: Bontoy Bantigue, Bantayan, Cebu

                       We hear about aromatherapy from our friends. Most of them like it, most especially the scent of lavender or tangerine, because it helps them unwind after a busy day. I wondered if aromatherapy would really help fire up a working father or a mother early in the morning who didn’t drink coffee at the start of a day.