MS Office Excel 2007 Insert and Quick Style Table

Compared to MS Office Excel of previous version, the Excel 2007 have numerous improvements and quick easy access of its controls. On this blog, we will talk about how to insert a table and customizing its design/style for a more acceptable and professional design that can be used by students on their presentation or on a business to present a professional look styles and design. Learning features such as this can surely reduce the amount of time required to create different looks of a table. So, let's start one of the steps we can learn to start creating a professional look table.

Note: MS Office Excel 2007 should be running when following the steps provided.

1) Open any existing excel table or data that stored on your computer or create one for training purposes.
See sample illustration below:



2) Highlight the whole table containing data.

3) For a more quick access, we will name this table using the name box to name our table, in this case we will name it as "customer_info". To know the location of name box look at the illustration below:

4) After highlighting data and giving our table a name, go to Insert --> Table. See illustration below:

5) A window will pop-up and showing the range selected. Since our table have its header (title for each column) click on it, then select OK.

6) After clicking OK, existing table will change its looks based on the default style/design of office Excel 2007 and a Filter functions will be added on the header.

7) Now, let's try to modify/customize the style to a different one. To do this, on the right portion of the toolbar click the Quick Styles to select from the library the choice of table style you desire.

This is the library:

From the library we will select the one in red box.

8) After selecting the style desired, it will be applied on the table.

9) That's all. Enjoy.

Microsoft Office Excel 2007 Display Macros Tab, Visual Basic Tab

MS Office Excel 2007 is a really unique and new user interface compared to previous release of Office Excel. Familiarizing first with this controls will absolutely help users to work faster in creating tabulated report or even an automated macro or using visual basic editor to create simple to complex working sheet/ forms. But with Excel 2007, accessing the Developer tab (tab to access visual basic, macro controls) as a default is not shown. For it to be shown together and align with the Home, Insert, Page Layout, Formulas toolbar control a few steps have to be followed. Let's start:

Note: MS Office Excel 2007 should be running before following the procedure/steps numbered below:

1) With the MS Office Excel 2007 running, click the office button as shown in the image below:

2)  After clicking, a window will appear, select and then click Excel Options.

3) Once Excel Options opened, under Popular --> select and checked "Show Developer tab in the Ribbon" --> then click OK.

4) After clicking OK, "Developer" tab should be shown in line with Home, Insert, Page Layout etc. (see illustration below). Try to click on it and menus for Visual Basic, Macros, Source, Import will be shown.

msExcel 2003 - Center Title using merge button

One of the best benefits of using msExcel for students, company or any other projects is its easy to create a good looking presentation. On this blog, i just tackle one of the basic button MERGE available as button of the toolbar. Its primary purpose is to combine selected cells into one. This button with a very simple functions of merging cells into one can be use to create a good looking presentation and neat data tabulation. So, let's talk and follow the short and simple steps i have provided below:

1) Highlight the title or text that you've wanted to be centered or contained into one cell. For example, below title was type in column A and aligned on the left side of the table. Highlight it to select column A to Column K.






















2) Once highlighted, click on Merge button as shown below:






















3) After clicking Merge button, result will be the same as shown below. Notice that columns A to K after merging has been combine as one whole cell.

Set Windows XP IP Address to Obtain address automatically

Internet Protocol address (IP address) are sets of numbers assigned to a computer or devices participating in a network. This unique sets of numbers used by computer make them able to share files, communicate and connect to internet to share information, download and upload files. Sometimes, when connecting to internet makes it difficult or there's a problem in the connection by Resetting it to its Default values can help to resolve the problem. On this blog, we will talk how to reset IP address to its Default value so that network will determine automatically what IP address it can used and available.

Below are just one of the solutions available we can set IP address to obtain automatically its address.

Let's Start:

1) Click on Start --> Control Panel as shown below.




















2) Once Control Panel window opens, click on Network and Internet Connections.
(Below view is in Category View)

3) Network and Internet Connections window will open, click on Network Connections.

















4) Once window for Network Connections open, right-click on Local Area Connection --> Properties.

















5) Under General tab, select Internet Protocol (TCP/IP) --> and click on Properties.

6) Window for Internet Protocol (TCP/IP) Properties will open, below it select Obtain an IP address automatically and make sure that Obtain DNS server address automatically will also be selected then clicked Ok.
Notice that as shown below Use the following IP address and Use the following DNS server addresses are selected and a value is set, once obtain an IP address is set to automatic those box portion will be blank or no value.




















7) After clicking OK, box portion will be blanked as shown below.




















8) Its Finished. Restart you computer and try to connect to internet.

Insert Row x Column in Excel

Let's have some example on how to insert row and column to an existing worksheet with data. Specially for beginners inserting a row or column in an existing worksheet sometimes inserted it in a wrong position, deleting existing data. To avoid this little accident, we will discuss how to do it and what should we clicked properly.

Note:
I used Microsoft Excel 2003, but below steps can also be done with Excel of higher version.
Author suggests that the application MSExcel is running before going thru series of steps.

1. Identify where will the data be inserted. (i.e. as an example we will be inserting row information between Row 7 and Row 8).

2. Left-click row number 8 to select it. (notice that whole row number 8 is highlighted)

3. After row number 8 was selected, press right-click on mouse and a menu will be displayed as shown below. Select Insert to insert a row on top of H and below F.

4. After left-clicking Insert, a new row has been created and data can now be pasted/type-in.

NOTE:
To create a column instead of left-clicking row number select column letter and follow procedure 3-4 to insert a column.

Microsoft Word SuperScript & Subscript

Another way of creating a simple mathematics equation without using the Math Equation of Microsoft Word is using superscript and subscript. These two amazing features can be used specially by students creating a thesis or reports that needs simple equation or format. But if it requires a lot of superscript and subscript i recommend using the math equation instead for an efficient and faster way of completing the projects. Content of this blog, i will show how to do it using toolbars and short-cut keys using the keyboard that can lessen the time and mouse-stroke to create superscript and subscript format. So, let's start and discuss first the process using toolbars afterwards, short-cut keys.

Note:
I used Microsoft Word 2003 but this step can be also done using higher version.


Please note: Microsoft Word application should be running to follow the steps provided.
 
1. Type X2 + Y2 = 0 on Microsoft Word. See below:

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
2. Using mouse highlight the number "2" of X by holding left-click then drag.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
3. Then, click Format --> Font to open Font window.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
4. Once Font window appear, under Effects check Superscript. Observe the preview screen result.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
5. Then click OK, number 2 on the X side will be converted to superscript. See below:

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
6. If subscript is required, follow procedure 1 to 3, then for step 4 instead of checking superscript select subscript.
 
SuperScript and Subscript using Short-Cut Keys (Keyboard)
 
1. Hightlight the value that will be converted to superscript.
 
2. Once highlighted, press simultaneously Ctrl + Shift +  +/= (left side key of backspace).
 
3. Highlighted value converted to superscript.
 
4. For subscript, once desired value highlighted to be converted to subscript, press simultaneously Ctrl +  _/- (underscore/minus, keys on the left side portion of (+/=), second key to the left of backspace).

How to change Microsoft Word Grids to draw scaled size box?

During my high school years in Philippines where computer was only for businesses and people who can afford it drawing a single box was very simple using a 12" ruler. But when projects require creating an 8 dozens of 1/2" squared box and equally spaced top and bottom of 1" that's a little tough and time consuming (actually box is not really the point of the project, it will be used for pasting some cut-out pictures). For students where their family able to afford this magnificent computer during my high school days it was truly fast, neat and efficient way of producing more than 8 dozens of boxes.

So let's talk about how to create boxes with correct size in Microsoft Word. My approach is very simple and easy to follow and in memorizing steps that i have provided below. Enjoy it!
 









Steps:
I used Microsoft Word 2003 but this step can be also done using higher version.
Please note: Microsoft Word application should be running to follow the steps provided.

1. Activate Drawing Toolbar, go to View --> Toolbars --> Drawing.

2. Drawing toolbar will be activated on the lower portion. See Illustration below:

3. To draw desired size of box, on the drawing toolbar click Draw --> Grid. See below:

4.  Once Drawing Grid window opens, under Grid settings change horizontal spacing to 0.25" and Vertical spacing to 0.25" to create a 1/4" square. (1 divided 4 = 0.25 inch). Then, below check Display gridlines on screen.

5. Click OK and draw a box. Grid will be displayed on the screen 1" horizontally and 1" vertically.

Safe & Free Antivirus Software

Surfing internet is fun, entertaining and gives freedom to access all information from almost every topic and interests of people. But surfing can be dangerous without an antivirus reliable enough to remove and intelligent to know and safely remove them on your computer. Virus travel from email to email, files to files and just once access it can ruin every files that stored on your computer without any warnings. Some computer virus can even store information that you type on your computer without knowing it and once it did it will forward its information to its creator giving him full access to all banking accounts or information about the user. This is very risky situation for it will ruin your credit, bank accounts and personal information. The only solution is to call your bank to change information and report this event to police which will take your time and effort while the responsible one is enjoying the life that you've once had.

Yes, we can stop this virus madness and continue to enjoy our life by adding antivirus security in our computer. This antivirus will act as a soldier to clean, remove or quarantine any malicious operation that's happening on your computer. There are several ways we can prevent this malicious viruses to infect our computer before we lost everything (1) get free antivirus offered by company (2) buy an antivirus that requires subscription to update its virus definitions (3) never use your computer.

I wanna share one of the antivirus that i really like and also other users out there that really cleans, protect your computer away from those computer virus. (1) available from http://www.avast.com/ - their free antivirus really clean and remove viruses, automatic update of its virus definitions that makes it reliable to know every new known virus. http://www.avast.com/ offers free code every year and once expired just have to request a new code. But if your a type of don't know much of what your doing in the internet they also offer a subscription antivirus that comes with great features.

I've once used other free antivirus but avast is the one that never gives me any headache or trouble and keeps my computer clean. It is also light in the computer memory unlike other antivirus that will really eat all the computer resources once installed and running making your computer virus free but in return slow computer performance.

Car Buying: New vs Pre-Owned

Car buying options when it comes to decision of which is better owning a New or a Pre-Owned car is sometimes hard to decide specially for people who has tight in budget. There are several questions that we can asked ourselves to help us create a decision, and these questions are also points that i've used when buying my new car and traded-in my old ones. Here are some of them:

1.  What's my purpose of buying a car? - answering this questions can give us an idea of what we really intend to do when we got our car. It gives us more futuristic situation once we buy it and where are we going to used it. By having this kind of reason, we already have a feeling that buying a car can really benefit not just our satisfaction but also our future plans and trips.

2.  What type and size of car should I buy? -after deciding the primary purpose of buying a car, things to consider were is it worth buying a van, suv or a sedan? will i used it for work only or just for family trips? when buying a car it is also good to consider the car size/capacity because it also comes the fuel consumption that is an additional expenses once we bought one. when i bought my first car i consider only 4 cylinder 2.4L engine because i drive in the city and used it everyday in work. It may not have enough power compared to 6 cylinder engine but i ai'nt goint in a race anyway.

3.  What brand of car that i like most? -with a lot of car manufacturers and features that may help us decide, i focus on something worth the next 5 years that i will used it and will come handy in my everyday life. i even consider the looks and one that i've felt i will love to drive everyday but not suffering its price so that its not gonna hurt my pocket. i.e. i bought an mitsubishi outlander because of its very sporty looks, 4 cylinder to help me save money when using it everyday in work, folding gate features that other cars don't have and greatly help me alot when loading and unloading food cooler, stroller for my baby and other stuff that's heavy to carry.

4.  Check car review. -this will help us a lot in deciding which one is better by reading review of car that we really want and what others people feedback.

5.  Get pre-approved in finance. -since most buyer don't buy car in cash, it is a good chance to have a lower APR for banks that is not as famous with other bank. My biggest and worst experience when buying my first car was to have an APR of 19.99% because of short credit history, credit rating doesn't help me a lot even though its above 750.

Above are just my experience when i bought my first old car and then after a 2 years traded-in in exchange of lowering my APR and getting a new one.