Martes, Marso 4, 2014

Making a Game on Excel

Making a game on Excel..
How can you make a game on Excel, through the use of conditional formatting and our friends, macros, you can make a simple game or a gorgeous one in a spreadsheet application just with the proper ideas and imagination.
We'll you should make good use of playing with color..
Changing the color fill of a cell, when it becomes the selected cell.
You can even make Minesweeper, or even Pokemon as long as you have the right use of these things.
Me, myself, tried to make Minesweeper but I felt small when I saw a man that made Monopoly out of that application on the internet.
So, what about you, could you make a cool game out of this spreadsheet application?

Spreadsheets

Spreadsheets, they come in handy if you need to balance or budget some allowance or if you are planning for something.
They can be a well use on business stuffs and used to balance and check your budget for a certain project.
They can also come in handy on academic schools or generally, schools because if ever needed in computing grades, spreadsheets give results as fast as a calculator.
I wish this tips of mine could help.:)

Lunes, Marso 3, 2014

Differentiating Excel from Word

Excel is the same as Word in terms of its tool and options except to the fact that Excel has cells while Word does not have.
They both have fonts, you can both insert a table but I'd definitely recommend it for Excel but you can still do it on Word, have word arts and equations and a lot more on different kinds of stuffs in common.
But word is for xls while word is for docx

Macros

Macros can be used to create commands that aren't on the menu bars of Excel.
They can be a specific command or a series of commands.
The commands I am referring to are those instructions.
They are hotkeys consisting of Ctrl's and Alt's and letters on the alphabet.
You can see the Macro option on View menu bar of Excel:

For starters on the Macro option of Excel, i'd advice you to first turn on the Relative References option for Macros.
Relative reference will make the macro not come back to its original cell where its been created.

Linggo, Marso 2, 2014

Conditional Formatting

Conditional formatting is a set of rules.
But not just rules that you follow, not like the law and the constitution.
But its a law followed by cells.
Its a formula wherein you can use for example, to put the highest scorer's score in a test cell green.
It can be seen on the Home menu bar of Excel:
But take note that for conditional formatting, you should look if there are too much rules to be followed by a certain rule.

Formulas

There are many formulas that can be used to find and give results on each cell.
Example is the sum formulas and other formulas could also be used to render these results.
Formulas could be seen on the Formula menu bar of Excel as follows:
There are many types of these formulas as you've seen above that has been categorized according to its use and the way you're going to use it.

How To Create a Table From MS Excel

You need a picture as a presentation for your current budget in your current company?
Well, you've got Excel handy. Excel has a feature that automatically creates a table out of your given data.
Something like this:
No need for Paint nor those drawing apps. Forming and connecting those apps...
Just go to the Insert option on Excel's menu bar. Select the cells where the data are filled in and after that click the this:
Then it's all done...