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.