Archive for the ‘Tips’ Category

Keeping WordPress.com Clean

July 30, 2010

I check WordPress.com latest posts on my dashboard to discover new bloggers. Sometimes, I open a post with a strange title, or I notice the weird name of the author, and I find some illegal content, such as pirated music, hacked software, and content with sexual themes. I simply report the blog by pressing the appropriate button on the WordPress.com toolbar found on the top.

This way, we can keep WordPress.com clean. And honestly, I like reporting blogs!

How to Stop Your Soul from Commiting Sins

July 10, 2010

Do you find yourself indulging many times in either drinking alcohol, watching pornography, cheating on your wife or husband, having a relationship out of wedlock, gambling, badmouthing people, backbiting, or doing other bad things in front of people or in hiding, and suddenly you regain control of yourself and feel ashamed? This feeling is good since it means that you still have control over the desires of the soul.

Remember that Allah is watching you. You do not want Him to see you doing bad things, do you? You would not want the One you respect to feel sad about how lowly you are becoming. Remember that every action you do and every word you spell is recorded in your book and it will be reviewed by Allah in front of all of His creations including your close family members and friends. It would be a very embarrassing situation, I tell you. And do not forget the accumulation of tiny bad things you did, helped to be done, or said which have been recorded, and every bit of them will be weighed on the scale, and alas if the scale touches down because of your big and little tiny sins!

You can change yourself starting from now! Yes. Say with me:

O, Allah! Forgive me for whatever bad things I have ever done to any creations by You! O, Allah! Help me to walk back on the straight path and assist me into not swerving away!

Do you feel the guilt and the regret? Good. Think of every little and big sin you had done and promise Allah not to come back to doing them again. Do not think of them. Try to forget the false sweetness. Ask your friends to help you into staying on the safe path. Pray more, read the Quran, use the TV and the Internet wisely, visit the Masjid and listen to the lectures, spend a lot of time with your family, go out and see Allah’s creations, help others to be good, and do not forget that He is seeing you and expecting good to come from you.

Live life for happiness now, tomorrow and in the hereafter.

Using the Ctrl Button to Select Non-Adjacent Cells

July 5, 2010

Using the Ctrl button on the keyboard, you can select multiple non-adjacent cells that can be far away from each other and you have to use the scroll bar to go down to select them.

Let us take the file named “Example 01.xls” from a previous post as an example:

(1) Open Example 01.xls

(2) Click cell “B4”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

(3) Press the Ctrl button and click cell “B21”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

(4) Scroll down, …

Microsoft Excel 2003: Scrolling Down

… press Ctrl, and click cell “B38”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

And this is how you select a number of non-adjacent cells.

Finding Cell Name in Microsoft Excel

July 4, 2010

It is very easy to find the name of a cell in a Microsoft Excel sheet by reading it in the Name Box:

Microsoft Excel 2003: Name Box

But, let us suppose that the formula bar is not displayed. Let us remove it by clicking Formula Bar found under the View menu:

Microsoft Excel 2003: Formula Bar

The name of a cell in a Microsoft Excel sheet is determined by its position in a column relative to the row it is in. For example, cell “B3” is found in column “B” in row “3”:

Microsoft Excel 2003: Cell Name

And cell “D24” is found in column “D” in row “24”:

Microsoft Excel 2003: Cell Name

To make sure, click the View menu and then click Formula Bar, and the Name Box is displayed:

Microsoft Excel 2003: Cell Name

Freezing Table’s Titles Row in Microsoft Excel

July 1, 2010

Imagine you have a very long table in a Microsoft Excel sheet, such as the one below:

Microsoft Excel 2003: Freezing Panes 1

And imagine that you want to edit entry No. 057:

Microsoft Excel 2003: Freezing Panes 2

If there are many columns, you will be confused as to what to change and what the data are.

You can solve this problem using the Freeze Panes command found under the Window menu:

Microsoft Excel 2003: Freezing Panes 3

To freeze the title row, click the row below it …

Microsoft Excel 2003: Freezing Panes 4

… and then click Freeze Panes in the Window menu. The rows above where you selected will be frozen:

Microsoft Excel 2003: Freezing Panes 5

Note the thin black line under the row containing the titles. It means the rows above this line will not move when you scroll down and up in the sheet.

Similarly, if the titles are in a column, click the column to its right and freeze it.

To unfreeze, click Unfreeze Panes under the Window menu:

Microsoft Excel 2003: Freezing Panes 6

I attached the file for you to experiment with it.


Attachment: Example 01.xls

Dragging in Microsoft Excel

June 28, 2010

Open Microsoft Excel and try the following:

(1) Click any cell. Note the black border:

Microsoft Excel 2003: Cell's Black Border

Move your mouse around the black border and note the black cross which appears only in the lower right corner:

Microsoft Excel 2003: Cell's Black Border's Black Cross

(2) Write something inside the cell:

Microsoft Excel 2003: Writing in the Cell

(3) Drag outside the cell up or down several cells away …

Microsoft Excel 2003: Dragging the Cell Outside

… and release the mouse. You will see the cell copied to the cells you dragged into:

Microsoft Excel 2003: Dragging the Cell Outside - the Copies

(4) Write something in another cell …

Microsoft Excel 2003: Writing in the Cell

… and click any cell outside to deselect it:

Microsoft Excel 2003: Deselect the Cell

Click the cell you wrote inside again and drag to the inside by clicking and moving your mouse from the lower right corner of the border …

Microsoft Excel 2003: Dragging the Cell to the Inside

… release the mouse and the content will be deleted:

Microsoft Excel 2003: Cell's Content Deleted

(more…)

Microsoft Excel Helps in Setting Goals

June 23, 2010

In a previous post, we know that Khawla has a goal: to accumulate AED100,000 in her bank account by the end of 2011. Her only source of income is her salary. Obviously, she can achieve this goal by limiting her monthly expenses (cash outflows).

There is a tool in Microsoft Excel that can help her set her goal. This tool is called Goal Seek which can be found under the Tools menu:

Microsoft Excel 2003: Tools Menu

Assuming that Khawla set her goal for the year 2011, and that her monthly salary is AED10,000, then in a year she can accumulate AED120,000 (10,000*12). But, since she incurs monthly expenses, she sets her goal to accumulate at least AED100,000. How much must her expenses in 2011 be if she wants to accumulate AED100,000 by the end of the year?

Using Microsoft Excel, let us draw the following table:

Microsoft Excel 2003: Inflows, Outflows, and Goal Table

In the table:

(1) Inflows = the accumulated monthly salary in 2011 = AED10,000*12 = AED120,000

– We can write in the empty cell next to “Inflows” the following: =10,000*12
Microsoft Excel 2003: Inflows, Outflows, and Goal Table
– We will call this cell “A“.
– Microsoft Excel will do the calculation. We hit Enter in the keyboard to read the answer.

(2) Outflows = total monthly expenses in year 2011

– Leave the cell to its right empty. Goal Seek will later write the answer for you.
– We will call this cell “X“.

(3) Goal = Inflows – Outflows = A-X = AED120,000-X = AED100,000

– We must define this equation in the cell to the right of “Goal”. Write =, then select the cell A and hit in your keyboard and then select X, and hit Enter.
Microsoft Excel 2003: Inflows, Outflows, and Goal Table

Without using Goal Seek, we can find X. It equals to AED20,000.

Now, in Microsoft Excel, click on Tools from the menus bar and select Goal Seek. You must see the following command window:

Microsoft Excel 2003: Goal Seek Command

Set cell: is our Goal cell. Select it from the Goal Seek command window by clicking on the icon next to Set cell:

Microsoft Excel 2003: Goal Seek Command

… and then select it and hit Enter:

Microsoft Excel 2003: Goal Seek Command

The goal is to accumulate AED100,000. We write 100,000 in the box next to To value:

Microsoft Excel 2003: Goal Seek Command

By changing cell: is cell X, the Outflows. We select it, hit Enter, and then clicking on OK. Microsoft Excel found the answer:

Microsoft Excel 2003: Goal Seek Command

Create and Edit Your Spreadsheets Online with EditGrid

June 21, 2010

EditGrid is a free service offering online spreadsheet editor for you to create, import, and edit Microsoft Excel sheets. You can collaborate with others in working on the same file and chat online.

It is good if you are working on a computer that lacks Windows Office.

Back-Up Your Files

June 18, 2010

Have you, or some one you know, encountered the following situation?

You worked so hard on that spreadsheet for a week to be presented in a meeting. You spent nights working on it. You have finally finished it. You transferred it into a flash memory card. Next day, you take it with you when going to a meeting in another city. Your turn to present the spreadsheet has started. You plug the flash memory card into the computer, but, oh my God! it is crashed!

What to do?

There is only one way to open the spreadsheet anywhere you go without using a flash memory card, and that is to use the Internet. It is very smart to have Plan B ready when Plan A fails you.

Disaster Recovery Plan. Credits: Dilbert.com

Disaster Recovery Plan. Credits: Dilbert.com

Box.net offers you a range of online storage options with 1 GB being the lite free option. Give it a try. It may save your life one day. It sure will.

Microsoft Excel Online Help & How-To

June 18, 2010

If you are using Microsoft Excel version 2003, 2007, or 2010, and if you want some help during your Microsoft Excel work, go ahead to Microsoft’s Excel and How-to page.

Do not forget practice.

Print Screen Including Mouse Pointer

June 16, 2010

I was so furious when I was making a post and I needed to print screen a window to show the shape of the mouse pointer. I used the Print Screen utility in Windows XP and tried the one in Windows Vista, but no mouse pointer!

I looked in the Web and found Gadwin PrintScreen and it solved my problem. Now every screen I capture includes the mouse pointer.

How to Excel in Using Microsoft Excel

June 14, 2010

Here are some tips to keep in mind if you are using Microsoft Excel for the first time:

  1. Do not panic!
    If you get afraid and insist that Microsoft Excel is totally a complicated application, your mind will find it difficult to accept that you can succeed in mastering its use.
  2. Treat the software as an ally rather than a foe.
    Microsoft Excel is designed to make life easier. So, step in and welcome it into your life.
  3. Believe you will master the basic uses of the software.
    Get to know your new friend.
  4. Imagine and proceed.
    It is not correct to start a new project without studying it, is it? Plan what you want on paper and proceed on to designing in Microsoft Excel. It is easy and saves time and whining!
  5. Follow instructions and practice.
    It is not enough to read instructions and apply. Try to practice using the software in real life situations. Make a Personal Balance Sheet to control your cash outflows, for example.
  6. Continue learning.
    You just cannot imagine the might of Microsoft Excel, can you? I cannot. That is why I am in a journey to discovering this great software.