The First Encounter with Microsoft Excel – Part II

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

“It can be done this way!” She clicks on Format cells, clicks on the Alignment tab, and chooses Center for both Horizontal: and Vertical: and this how it is so far:

Microsoft Excel 2003: Months Centered

Now, she wants to add “2010” in the “Year” column. She selects the cells in the “Year” column to the left of 2010 months and merges them:

Microsoft Excel 2003: Merging the Year Cells

Then, she double-clicks inside to add “2010” and writes it down:

Microsoft Excel 2003: Writing the Year

When she looks at the sheet, Khawla decides it is good:

Microsoft Excel 2003: Needs Borders

Now, she wants to add borders and color to the table. Selecting the cells, right-clicking, choosing Format cells, and then Border, Khawla experimented different border widths and colors and was pleased with the following:

Microsoft Excel 2003: Table Colored Borders

She expands the “Month” column, selects the row title (the year), clicks Ctrl on the keyboard to select the column titles as well as the row title (the year), and then clicks on B in the Formatting Toolbar

Microsoft Excel 2003: Bold Face Tool

… to change the fonts to bold-face:

Microsoft Excel 2003: Changed to Bold Face

Again, both “Start Balance” and “End Balance” columns require expanding. Khawla expands them. She looks at the “2010” cell and thinks of adding a background color to it to make it distinguishable from year 2011 which she will be adding soon. She clicks the cell, right-clicks and selects Format cells. She then clicks the Patterns tab and experiments with it and she likes the following:

Microsoft Excel 2003: Adding a Pattern to a Cell

Then, she changes the color of “2010” to white by clicking on the cell and then clicking on Font Color in the Formatting Toolbar

Microsoft Excel 2003: Font Color

… and selecting the white color from the drop-down menu:

Microsoft Excel 2003: White Font Color

And so far, here is how the table looks like:

Microsoft Excel 2003: 2010 Table

STOP.

Save your work.

And, that is for today. See you next time.

Advertisements

Tags: ,

One Response to “The First Encounter with Microsoft Excel – Part II”

  1. The First Encounter with Microsoft Excel – Part III « Odd Number 7 Says:

    […] The First Encounter with Microsoft Excel – Part III By Khawla Continuing the lesson from Part II: […]

Comments are closed.


%d bloggers like this: