Microsoft Excel: Expectation and Reality

The first time our teacher told us we are going to discuss Microsoft Excel  on the third quarter, I thought it would be something different, something that wouldn't include hard things. I thought we would start easy, but then my expectations failed me...

                       Expectation:                                                                                            Reality:

                             

Microsoft Excel: Easy Sheet!

Microsoft Excel is a reliable and easy application especially when you are an accountant or a teacher because that thing will really make your work easy. It can be used to compute grades, accounting expenses, and all the like which you can all convert to charts later on. Let us explore the beauty of this software as we know its functions.


          

Microsoft Excel: Pros and Cons

Excel was first developed for the Macintosh computer in 1984. Windows came into the market in 1987 and Excel became a part of the Microsoft package. It is a spreadsheet with database capabilities that has become a mainstay in financial computing.

Advantages:

• Common format, more people would be able to access file 
• Lots of free tutorials available.
• Portable
• Less Computation

Disadvantages:

• Very Expensive
• The Built-in Password Protection is Weak
• May Attach Virus with Macros

Microsoft Excel: Data Types

Microsoft Excel uses many data types but here are 3 main types used.

Text
            The Text Data are common for its use in worksheet headings, names, and for identifying cells of data.

Numbers
            Numbers can be used in calculations. By default, they are right aligned in a cell.

Formulas
          a Formula is a mathematical equation such as adding or subtracting numbers.

Other Data Types:
   1) Currency
   2)  Date
   3) Time
   4) Logical
   5) Accounting
   6) Special
   7) Scientific
   8) Fraction

Microsoft Excel: Data Formatting

In Microsoft Excel, sometimes it’s difficult for you to recognize data, so there is one thing we can do, Data Formatting.

In Data Formatting we can do many things like change font, border style, cell color etc.

Here is how to format cells:

     1) Select the cell you want to format

     2) Right-click on that cell

     3) Select format cell

Now there is a pop-up window. In this window, there are five tabs (Excel 2007) just choose from any of them and you’ll soon get it

Microsoft Excel: Conditional Formatting

Conditional Formatting is data formatting but only made easier.

We only use formulas in formatting cells not formatting them one by one in Cell Formatting.

Here are the steps on how to apply Conditional Formatting:

     1) Input all of your data

     2) Click the cell you want to format

     3) Click Conditional Formatting in the Ribbon

     4) Click New Rule

     5) When adding a rule, make sure you use a formula.

     6) Add your Rule

     7) Click on Format

     8) Select Formatting you want for your cell.

     9) Done : D

Microsoft Excel: Functions and Formulas

The ability to perform calculations is one of the purposes of using a spreadsheet application.

Some examples of the types of calculations that can be done are:

     1) Totals

     2) Subtotals

     3) Average

Entering a Formula requires an equal sign and addresses of the cells whose values will be manipulated with appropriate operands placed in between them.

A Function Instead a Formula is I think harder to use but is also simple to do.

Microsoft Excel: Data Representation

In Microsoft Excel, there are many ways to represent data. One easy way is by Charts or Graphs.

Advantages:

1)    Pleasant To the Eye

2)    Easy Interpretation

3)    Requires Less Effort

Disadvantages:

1)    More Time

2)    Less Space

Microsoft Excel: Macros

In the gaming industry, Hotkeys are very important to give the players easy access to simpler keys that will be helpful casting spells, using items and other things with ease.

In Microsoft Excel, there is a similar thing called Macros. With these Macros the user will be able to do what he wants with ease in a less period of time. For example, you want to bold, italicize, and underline a text. With Macros, you can do it all at once but first you need to record a Macro.

Here’s how:

     1)    Go to View Tab

     2)    Look for the Macros and click the drop down arrow

     3)    Click Record Macros

Now there is a pop-up menu.

     4)    Put your Macro name (without spaces or symbols)

     5)    Assign a Shortcut Key

     6)    Choose where to save the Macro

     7)    Give a Description (optional)

     8)    Press ok

Now it is time for recording.

     9)    Do what you want your Macro to do

    10) Stop the recording with the Stop Button at the Status Bar

    11) You now have your Macro

Microsoft Excel: What a Great Experience

This quarter we were taught the different features Microsoft Excel has, but I have to admit it was a hard journey for all of us but as time goes by we finally realized the importance of Microsoft Excel which we can use sooner in our lives when we are older.