Let's make a Game

Saan?? Sa Microsoft Excel.. :)

     Sa nakaraang third quarter namen sa kum say medyo kakaiba hindi lang naman sa puro first time pero akalain mo sa excel basics na naituro sa amin nakagawa kami ng simple game gamit ang conditional formatting at macro. Masaya talaga kahit simple lang kasi parang achievement nanaman sa buhay.
Macro at conditional formatting best partners dito.
Nagsisimula ang lahat ng bagay sa maliit.

Macro: Making Your Life Easier

         Kasi nga shortcut ng isang maikli o mahabang proseso na dapt gagawin mo sa excel. Akalain moh just press the designated shortcut in a split seconds magic will happen.

(AWESOME)

         Nirerecord niya yung bawat hakbang na gagawin mo sa excel, sa una lang naman dapat maraming gawin pero pag recorded na siya, effortless na pare. :) 

What IF??

            The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.

                

Syntax

IF(logical_test, [value_if_true], [value_if_false])

The IF function syntax has the following arguments:

• logical_test    Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.
• value_if_true    Optional. The value that you want to be returned if the logical_test argument evaluates to TRUE. For example, if the value of this argument is the text string "Within budget" and the logical_testargument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted (that is, there is only a comma following the logical_testargument), the IF function returns 0 (zero). To display the word TRUE, use the logical value TRUE for thevalue_if_true argument.
• value_if_false    Optional. The value that you want to be returned if the logical_test argument evaluates to FALSE. For example, if the value of this argument is the text string "Over budget" and the logical_testargument evaluates to FALSE, the IF function returns the text "Over budget." If logical_test evaluates to FALSE and the value_if_false argument is omitted, (that is, there is no comma following the value_if_trueargument), the IF function returns the logical value FALSE. If logical_test evaluates to FALSE and the value of the value_if_false argument is blank (that is, there is only a comma following the value_if_true argument), the IF function returns the value 0 (zero).

Remarks

• Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.) Alternatively, to test many conditions, consider using the LOOKUP, VLOOKUP, HLOOKUP, or CHOOSE functions. (See Example 4 for a sample of theLOOKUP function.)
• If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.
• Excel provides additional functions that can be used to analyze your data based on a condition. For example, to count the number of occurrences of a string of text or a number within a range of cells, use the COUNTIF or theCOUNTIFS worksheet functions. To calculate a sum based on a string of text or a number within a range, use the SUMIF or the SUMIFS worksheet functions.

Error!Error!Error!

What are the common errors you'll get?

Examples:

Error	Meaning
#DIV/0!	Trying to divide by 0
#N/A!	A formula or a function inside a formula cannot find the referenced data.
#NAME?	Text in the formula is not recognized.
#NULL!	A space was used in formulas that reference multiple ranges; a comma separates range references.
#NUM!	A formula has invalid numeric data for the type of operation.
#REF!	A reference is invalid.
#VALUE!	The wrong type of operand or function argument is used.

Just try to understand this in case you might encounter these errors.

A little conversation when committing errors.

Me: what?? anyare??

seatmate: haha

me: nu problema??

First Time Pare

Halos lahat ng natututan ko sa kum say feeling ko "first time" lahat ehh..

Lalo na Excel...

Sa una mahirap,minsan OP,minsan kopya kopya lang...pero habang tumatagal EXCELlent ka na pala..

(hihihihi, nagjoke)

Ung una blanko,..


And turns to this..!!

(di ko yan gawa)

Magic diba... :)

Conditional Formatting- make your own rules!

You can use something called Conditional Formatting in your Excel spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on the grade. Here's the spreadsheet we'll be working on.

• Open up your Student Exam spreadsheet (You did complete it, didn't you?)
• Highlight the cells with Overall Grades, which should be cells B11 to I11

The Overall Averages range from 44 to 85. We'll colour each grade, depending on a scale. A different colour will apply to the following grades:

• 50 and below
• 51 to 60
• 61 to 70
• 71 to 80
• 81 and above

So five different bands, and a colour for each. To set the Conditional Formatting in Excel, do the following:

• With your Overall Averages highlighted, click on the Home menu at the top of Excel
• Locate the Styles panel, and the Conditional Formatting item:

The Conditional Formatting menu gives you various options. The easiest one is the Colour Scales option. Select one of these and Excel will colour the cell backgrounds for you:

That's not quite what we're looking for, though. We'd like to choose our own values. So click onMore Rules, from the Colour Scales submenu. You'll see the following rather complex dialogue box:

The one we want is the second option, Format only cells that contain. This will allow us to set up our values. When you click this option, the dialogue box changes to this:

The part we're interested in is the bottom part, under the heading Edit the Rule Description. It says Cell Value and Between, in the drop down boxes. These are the ones we want. We only need to type a value for the two boxes that are currently blank in the image above. We can then click the Format button to choose a colour.

So type 0 in the first box and 50 in the second one:

Then click the Format button. You'll get another dialogue box popping up. This is just the Format Cells one though. You've met this before. Click on the Fill tab and choose a colour. Click OK and you should see something like this under Edit the Rule Description:

The Preview is showing the colour we picked. So we've said, "If the Cell Value is between 0 and 50 then colour the cell Red".

Click OK on this dialogue box to get back to Excel. You should find that one of the cells has turned red. To format the rest of the cells, click on Conditional Formatting on the Styles panel again. From the menu, click on Manage Rules:

You'll get yet another complex dialogue box popping up! This one:

Our first rule is already there - Cell Value Between. The only thing we're doing here is adding New Rules, similar to the one we've just set up. Click the New Rule button then. You'll see the exact same dialogue boxes you used to set up the first rule. Set a new colour for the next scores - 51 to 60. Choose a colour, and keep clicking OK until you get back to the Rules Manager dialogue box. It should now look something like this one:

We now have to colours in our range. Do the rest of the scores, choosing a colour for each. The scores are these, remember:

• 50 and below
• 51 to 60
• 61 to 70
• 71 to 80
• 81 and above

When you've done them all, your dialogue box should have five colours:

The colours above are entirely arbitrary, and you don't have to select the same ones we did. The point is to have a different colour for each range of scores. But click OK when you're done. Your Overall Averages will then look something like this:

Formatting your spreadsheet in this way allows you to see at a glance relevant information. In the spreadsheet above, it's obvious who's failing - just look for the red cells!

Just see this (http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html)

MATH sa COM SCI??

Weeehh?

Yeah check niyo ms excel niyo... :)
Sa aming mga tinalakay gumamit kami ng ibat ibang formula..

Para makabuo ng formula, kailangan ang mga sumusunod:

*Equal Sign ( = ) +
*Mathematical Operators

• Subtraction - minus sign ( - )
• Addition - plus sign ( + )
• Division - forward slash ( / )
• Multiplication - asterisk (* )
• Exponentiation - caret (^ )

It is as Easy as that...

EXCELlent has been CHOP CHOP

EXCELLLL...

Ito ang main topic namen sa third quarter..

Makikita sa larawan ang mga parte ng excellll