I'll be saying goodbye to the 3rd Quarter. And I am now ready to face the Last Quarter and again, make my brain more awesome by learning more stuff about technology. :)

I hope you learned a lot from my blog and I wish you'll be able to apply these techniques in MS Excel.

 Ciao! :D

Image Source: https://images.search.yahoo.com

Macro

What is a Macro?

When is it used?

What is it for?

How do you do it?

A macro is a symbol, name, or key that represents a list of commands, actions, or keystrokes. Many programs allow you to create macros so that you can enter a single character or word to perform a whole series of actions.

Can you believe that you can be able to create a game because of Macros? The game, Minesweeper has macros applied to it. Yes, that's how powerful Macro is. And that's how efficient MS Excel is. Now, you know. :)

Reference: http://www.webopedia.com/TERM/M/macro.html

              http://en.wikipedia.org/wiki/Macro_%28computer_science%29

Image Source: https://images.search.yahoo.com

                    http://gifsoup.com/view/4486833/minesweeper.html

Types of Charts

I want to enumerate some kinds of charts that can be used in Excel so you will be able to know what type of chart to insert at instances.

 
First is the Column Chart.

It is useful for showing data changes over a period of time or for illustrating comparisons among items.

There are two types namely the Clustered Column Chart and the Stacked Column Chart.


Second is the Line Chart.

it displays continuous data overtime, sets against a common scale, and is therefore ideal for showing trends in data at equal intervals.

Line-With-Markers. This is the default Line Chart. But other options also include Stacked Line.

 

Third is the Pie Chart.

It shows the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are displayed as a percentage of the whole pie.




 

Fourth is the Bar Chart.

It illustrates comparisons among

individual items. It is advisable to be used when the axis labels are long and the values that are shown are durations.

 

 

Fifth is the Area Chart.

It emphasizes the magnitude of change over time, and can be used to draw attention to the total value across a trend.







Reference: http://peltiertech.com/Excel/ChartsHowTo/ChartType.html
                  http://moodle.pshs-brc.edu.ph/pluginfile.php/4913/mod_resource/content/0/Charts.pdf
Image Source: https://images.search.yahoo.com

Data Representation

 

 Can you insert charts and graphs in MS Excel?

Yes, you surely can!

If you think that you can only enter the data in the cells and do nothing else to make it more presentable, you are wrong.

There are different ways to display data. Aside from just inputting the data into the cells, you can also express it in charts and graphs.

For example, if you are trying to communicate relations, such as how displacement changes with respect to force, it would be better if you will use a graph. 

These graphs and charts are more visual (qualitative). So if you hate numbers that much, try to use these, at least there would be some graphics in the sheet. :D

Reference: http://faculty.up.edu/lulay/MEStudentPage/graphexamples-how-to-do.pdf

Image Source: https://images.search.yahoo.com

Conditional Formatting

 






What is the use of conditional formatting?

Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, when the data in that cell meets the conditions that you have set.

                                           Where can we apply conditional formatting?

The use of conditional formatting is very efficient.

We can apply conditional formatting for the dates, for duplicating data and for values that are above or below the average value in a range of cells.

Reference: http://spreadsheets.about.com
Image Source: https://images.search.yahoo.com

IF Function

What is the IF Function for?

This returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

                                                           Reference:http://moodle.pshs-brc.edu.ph/pluginfile.php4818/mod_resource/content/0/IF.pdf 
                                                           Image Source:https://images.search.yahoo.com

   This was the activity I did applying the IF Function:

Logical Operations

 

 
First, let us define logic and operation.

Logic is the branch of philosophy that analyzes inference.

And Operation means data processing in which the result is completely specified by a rule.

So when we say logical operation in the branch of Computer Science, it is defined as an operation that follows the rules of symbolic logic.

 

The logical data type represents true or false states.
These logical operations are used to execute conditional codes.


 
 References: http://www.thefreedictionary.com
                     http://www.mathworks.com
Image Source: https://images.search.yahoo.com