Archive for June, 2010

Me and Obsessive-Compulsive Disorder

June 30, 2010

I remember, when I was in high school, counting to a certain number before a TV show starts, before someone opens a door, before someone reminds me of something, or even before my school bus arrives. I also remember doing things before some events occur like when it is exactly at the top of the hour I should have finished washing, eating or reading.

When I reached the university, I used to touch every pillar I walk next to in the campus. I also made sure that I miss one floor tile when walking. Before I leave the dormitory in the weekend, I used to make sure that the electricity is off and faucets are not running maybe three times. I ask my sister to leave to the bus before me, and I quickly get the keys from my handbag, open the room and check the electricity outlets and faucets closely.

I get very relaxed and anxiety-free when I do that.

Obsessive-Compulsive Disorder (OCD) is very tiring. Now, employed, its impact is less than before. But, I still check on the office drawers to make sure they are locked, to see if lights and air conditioners are not on, and if there is no body being locked in the building many times before leaving!

Note: I check my handbag and wallet twice after every purchase!

Advertisements

The Little Prince

June 29, 2010

I remember watching the anime when I was very young. Here is the Japanese opening:

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…)

Area 51 Adventure

June 27, 2010

I am an adventurous girl in nature. I would imagine me going on an adventure like this:

Area 51 and the Frantic Caller

June 26, 2010

I remember when I was young I heard the story about the aliens in Area 51. I would do some searches on this topic. And, I would like you to watch the following video:

Have you been reminded of the movie “War of the Worlds“? I do not like this movie, by the way.

Shortwave Listening (SWL)

June 26, 2010

When I have the mood, I get my Tecsun PL-600 radio and headphones and search in the shortwave bands. There is some kind of mystery feel to shortwave listening. Sometimes, I catch a Number Stations. And sometimes, I catch hams having some conversations. Most of the times, I hear strange stations in SSB that are transmitted in Morse Code.

I love radios. I want to get a good antenna for my radio. But, I am afraid my parents will not allow me to fix one on any wall outside the house!

Go to YouTube and write “strange radio station”. Do similar searches and be hooked all night long!

Web 2.0 Tools and Applications on One Page

June 26, 2010

I like to navigate Go2Web20 to discover the latest Web 2.0 tools and applications.

The First Encounter with Microsoft Excel – Part II

June 25, 2010

We continue our story from where we stopped last time.

Khawla was working on creating a Personal Balance Sheet to control her expenses and to help achieve her goal of accumulating at least AED100,000 in her bank account by the end of 2011. She drew a table for the balance sheet on a piece of paper and tried to recreate it beautifully in Microsoft Excel. She was able to draw the row containing the columns’ titles and here is a part of it:

Microsoft Excel 2003: Cells With Borders

“Since July, 2010 is coming soon, let me add it first in the table.” Khawla wrote “July” in Cell C5, and moved down to Cell C6 using the Down Arrow in her Keyboard and wrote “August”. And she continued until adding December. And here is how she got so far:

Microsoft Excel 2003: Adding 2010 Months

Again, she wants the months centered in the cells. To be exact, everything she is going to write later should be centered. “If there is a way with which the data will get centered beforehand!” Khawla looked at the sheet and noticed something. She noticed that there is a small rectangle between Column A and Row 1 …

Microsoft Excel 2003: Selecting All Cells

… and she clicked it. All the sheet cells have been selected:

Microsoft Excel 2003: All Cells Selected

She tries to right-click anywhere in the sheet and the menu containing Format cells appears:

Microsoft Excel 2003: All Cells Selected

(more…)

One File Uploaded to Several File Hosting Services

June 23, 2010

It is possible to upload one file to several file hosting services at a time using Sharebee.com. With this service, you can make sure that every person can get your file if one of the hosting services is busy or denied access.

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.

The Maximum Number of Rows in a Microsoft Excel Sheet

June 20, 2010

Have you tried to find the exact number of rows in a Microsoft Excel sheet but found it difficult to scroll down since it appeared to you it was an infinite process?

There is a quick way to know the exact number of rows in a new Microsoft Excel sheet:

1. Open Microsoft Excel.

2. Select all the cells in the sheet by either using the shortcut (Ctrl + A) or by clicking on the small rectangle between Column A and Row 1:

Microsoft Excel 2003: Selecting All Cells

3. Right-click on that rectangle and you should see the following menu:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 1

4. Click on Create List…:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 2

You will see the following command window:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 3

Can you see what is written in the text box? It is written “=$1:65536”. It means “Select the range from Row 1 to Row 65536”.

5. Click OK.

6. Go to the end of the sheet using the vertical scroll bar. Easy now, is not it? What is the number of the last row you see?

Microsoft Excel 2003: Finding The Maximum Number Of Rows 4

7. Try to insert a new row by clicking on Row 65536, right-clicking on it, and then click on Insert:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 5

You cannot! Insert is dimmed which means it is impossible to add another row.

There is a quicker way to go to the last row! Hold the scroll bar and move down swiftly:

Microsoft Excel 2003: Scrolling Down

So, the maximum number of rows in a Microsoft Excel sheet is 65536. Why this particular number of rows? I have no idea.