Skip to content

5.003 Thesaurus, Research Task Pane and Personalize Spelling Option in Microsoft Excel 2007

Other the Spelling, there are another two most commonly used proofing tools, which are Thesaurus and Research task pane. Sometimes when you are not too sure what words to use in your spreadsheet, then you can activate Thesaurus to help you.

Let’s enter the word “Adjust” in the cell A4, put your cursor on the cell A4, now activate Thesaurus from the path: Review — > Thesaurus.

 

You will actually activate the Research task pane with Thesaurus option. You will find other options within the Research task pane, which includes Thesaurus, translation service, and dictionary from multiple online research channels.

 

You may activate the Research task pane by the path: Review — > Proofing — > Research.

On the last task pane of the Proofing toolbar, you may personalize the spelling options by going through the path: Office Button — > Excel Options — > Proofing

 

 

You will see the default setting of the Proofing options, which includes AutoCorrect options and When correcting spelling in Microsoft Office programs.

By default, the following options have been checked:

Ignore words in UPPERCASE

Ignore words that contain numbers

Ignore Internet and file addresses

Flag repeated words

The following options are open for selection :

Enforce accented uppercase in French

Suggest from main dictionary only

You may change the default dictionary by clicking on Custom Dictionaries button.

If you wish to change your settings, you may do so by selecting the option you need and click OK to save the changes you made.

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 5. Tagged with , , , , .

By Luis T
March 13, 2009

No comments

5.002 Spell Check, a Double Check Tool in Microsoft Excel 2007

Microsoft Excel has a double check tool which includes spelling check to confirm the words in the spreadsheet are properly established. It helps to proof that the document you have created is correctly presented.

To run a spell check, go through the following path: Review — > Proofing — > Spelling.

 

Let’s test out this Proofing tool, purposely enter a wrongly spelled word, key in “Adjus” into Cell A3. Then, enter again a correctly spelled word “Adjust” into cell A4. Now activate Spelling tool in the Proofing group using the path above.

You will see a Microsoft Office Excel dialogue box “ Do you want to continue checking at the beginning of the sheet? “. Enter Yes button.

 

Another dialogue box appears, Spelling dialogue box. Cell A3 with word “Adjus” detected as wrongly spelled word. The Spelling dialogue box comes with suggestions to replace the misspelled word. In this example, there are two suggestions recommended: Adjust and Adjusts.  

 

Click on button Change to correct the misspelled word. Microsoft Excel will jump to the next word once you click the Change button to find the second misspelled word. But in this case, there isn’t any, you will see the message in a dialogue box “The spelling check is complete for the entire sheet” .

 

Under the circumstance where many misspelled words are detected, Microsoft Excel will continue the spelling check and make necessary suggestions until all have been corrected.

Just click on Change button each time you want to make the changes, or just click Ignore button if you want to keep the words.

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

 

Posted in Chapter 5. Tagged with , , , , , , .

By Luis T
March 11, 2009

No comments

5.001 Printing a Worksheet in Microsoft Excel 2007

When you have completed your file and is ready to print a hardcopy, you may want to print it out. You may want to make some adjustments before printing, which may include adding a header, a footer and other information as needed. Over in this article, I will show you how you could do that in Microsoft Excel 2007.

Now open any excel file in your computer, or you may copy this article and paste it over to your Excel worksheet so that I could show you how to perform certain pre printing functions.

First of all you will have to make sure the content fit into one page, it is usually meaningless if you are not able to see all the content in one page, it would be partial in multiple pages that you will find  it hard to find the connection between one and another.

Follow the path: Office Button — > Print — > Print Preview — > Page Setup

 

 

You will see a Page Setup Dialogue box,

 

By default, pages are created in portrait, and you could change it landscape using the dialogue box. Portrait pages have height that is taller than width, with landscape vice versa.  The changing of orientation is relatively simple, you could do it by just simple click on the box to the left of each selection (portrait or landscape).

On the Scaling selection, you could choose the scale the size of the content. You could choose to enlarge or shrink the size of the content by adjusting the percentage of the content relative to the normal size.

Also you could choose to fit the content into one page, this is the second selection in the Scaling (Fit to: )

 

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 5. Tagged with , , , , , .

By Luis T
March 9, 2009

No comments

4.008 Table Customization in Microsoft Excel 2007

In Microsoft Excel, you are able to customize your table according to the preset template that equipped with summary rows and columns that completes your table.

Let’s create a small table containing data from Cell A1 to B4, for example, let’s input the cells with number “1” to generate a table for practice purposes.

 

To activate the customization of table, you may follow the path below:

Step 1: Insert — > Table

 

Step 2: Create Table Dialogue Box — > Highlight the cells that you want to customize your table. In this example, it would be from Cell A1 to B4. You will see a moving dash lines cover the cells A1 to B4.

 

Step 3: Table Tools Design Tab appeared.

 

Step 4: There are 5 groups on the Design Tab that will helps you with your customization.

Table Name: You can change the name of your table here. By default, it is named Table1. It is advisable to rename the table according to your needs to help you remember the content of the table.

Resize Table : Helps you to redefine your table accordingly. Click on the Resize Table will bring up the Resize Table Dialogue Box

 

You can change the starts and ends of the table, so that you are able to include those missing data that was not included previously.

Table Style Options: This option allows you to change the visibility of rows and columns, at the same time change the format of the columns and rows within the table.

Table Styles: A collection of table styles that you could choose to fit into your requirements. It is a collection of styles that will change the formatting of table immediately (Live Previews).

 

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , , .

By Luis T
March 7, 2009

No comments

4.007 Filter and Sort data in Microsoft Excel 2007

In Microsoft Excel, you may change the orders of the data on hand, you may change the order in ascending or descending order. We called it Sorting. Another way of managing the data is by filtering the data in rows, you may take out the data from the rows of data base on the cells content. We called it Filtering.

To initiate the Sort command, follow the path : Home — > Sort & Filter, you  have 3 choices, namely Sort A to Z, Sort Z to A and Custom Sort.

Sort A to Z: You can sort numbers from smallest to Largest.

Sort Z to A: to sort numbers from largest to smallest.

Custom Sort: To sort the numbers by the color of the cell or font

To initiate the Filter command, follow the path: Home — > Sort & Filter — > Filter, you may decide to include or to take out data base on your preference. There are a couple of filters methods, which would suit to your needs in your data management. You may find the following selection:

1.       Equal

2.       Doest Not Equal

3.       Greater Than

4.       Greater Than or Equal To

5.       Less Than

6.       Less Than or Equal To

7.       Between

8.       Top 10

9.       Above Average

10.   Below Average

11.   Custom Filter

You may customize your own filtering requirements by going through the path:

Number Filters — > Custom Filters or Text Filters– > Custom Filters.

You are not able to perform the Sort or Filter on multiple table. All the data must be defined in one table, say if there is an blank row in the table, the filter or sort command would not be able to extend it’s function to the data below the blank row.

 

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , , .

By Luis T
March 5, 2009

No comments

4.006 Understand the Standard Chart Elements in Microsoft Excel 2007

In Microsoft Excel 2007, a chart is a presentation of data in a visible way. There are made up of many different elements, which includes Chart Title, Grid lines, Walls, Axis ( X or Y axis), Value, Bars, Series, Legend and Labels.

Let’s talk about each element one by one:

Chart Title: A short description of the data in the chart, usually a conclusion on what you are trying to bring up to the reader.

Grid Lines: Represent the scale of the data, generally given a set of grid lines for X or Y axis.

Walls: A defined area of the chart for the plotting to happen.

Axis: X and Y axis, where the values for the data are shown. (Two dimensional). There is third dimension which we call it Z axis to represent three dimensional charts.

Values: Data for the plotting of charts.

Bars: Graphics used to represent the data value. It could be a bar, line, piece (Pie Chart) or others.

Series: Represent each set of values within your data. Usually refer to column and row that represent the X and Y axis of the values.

Legend: A table that shows the relationship between the data and chart representation. Usually links by color, for example in line chart, you may see different color on the legend that represent the plotted data in the chart. Legend is a list of labels.

Labels: Summary of what each set of value representing. It could be sales, month, time, or anything that you want the reader to know.

These are some of the basic elements of Microsoft Excel chart. You have the choice to either turn it on or off, or remove them from the chart.

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , , , .

By Luis T
March 3, 2009

No comments

4.005 Introduction of Different Chart Type in Microsoft Excel 2007

In Microsoft Excel 2007, you can change the chart type easily follow the path: Chart Tools — > Change Chart Type. There are basically 11 type of different charts for your selection.

Column Chart: This is the fundamental or default chart of Microsoft Excel, it is presented as vertical bar with their height representing the value of the data.

Bar Chart: The only difference between bar and column chart is the direction of the “bar” in the chart. In Bar chart, the direction is horizontal where Column Chart the direction is vertical.

Line Chart: This type of charts is used to show the progression of data with time or other factors. For example, if you want to see the progress of the sales value over a duration of time (let’s say 12 months), you will find it easier to present with Line Chart.

Pie Chart: This type of charts is used to show the relationship between one series of data to another. It shown in terms percentage coverage on a complete pie shape.

Area Chart: This type of chart is used to compare your data, it is a Line chart alike chart where data are overlapped for you to differentiate the relationship easily.

Scatter Chart: This type of chart is used for finding the trend on data plot points on the chart. It is similar to Line Chart, but show the trend after considering all plot points. This is different from Line Chart where it shows how each data move over a period of time.

Stock Chart: This type of chart helps you to evaluate how stocks perform over time.

Surface Chart: This type of chart shows chart 3 dimensionally, where data are correlated (categories and series).

Doughnut Chart: It is a pie chart with multiple of series over time.

Bubble Chart: A scatter chart is ball shape.

Radar Chart: Plot chart base on apparently non comparable value.

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , , , , .

By Luis T
March 1, 2009

No comments

4.004 Fine Tune Your Chart in Microsoft Excel 2007

Microsoft Excel 2007 has relatively better fine tuning tools as compared to Microsoft Excel 2003, where you could easily find the tools in buttons. Let’s say you have a simple bar chart with data (any chart that you can find in your own), select the chart and follow the instruction below.

In your following steps, you will learn how to change the axis of the chart. Follow the path: Chart Tools Layout — > Axes — > Axes, you will bring up a list of axes from your chart. Select the Primary Vertical Axis option followed by Show Axis in Thousands. The complete path to this process is : Chart Tools Layout — > Axes — > Axes — > Primary Vertical Axis — > Show Axis in Thousands. You will actually change the scale of Y axis of your chart into unit thousand. Say for example initially the Y axis value ranging from 1000, 2000, 3000 and so on. Now with Show Axis in Thousands, you will actually simplify the value to just 1, 2, 3 and so on. It helps you to understand the numbers on the chart easier.

 

Now repeat the process but this time go to More Primary Vertical Axis Options. The complete path is: Chart Tools Layout — > Axes — > Axes — > Primary Vertical Axis — >More Primary Vertical Axis Options, then followed by selecting Number at the left side of the pane. You will find the option to change the decimal points of the axis. Also, you will have the choice to include or to exclude 1000 Separators (,). Navigate through the options that you have in other list, you will find a lot more changes that you could make to the axis.

 

Now, go to style selection by the path: Chart Tools Design — > Chart Styles — > Style 25, you find the ability to change the chart type into a 3D bars. It appears that instead of a flat bar, it becomes a 3D bars with “thickness”.

 

Also, you may want to change the Chart Type. Go to path: Chart Tools Design — > Type — > Change Chart Type, you will find that instead of the original bar chart, you will be able to change it to line chart, pie chart and many others.

 

These are some useful options that you have from Microsoft Excel 2007, the display is a lot better than what you have in Microsoft Excel 2007.

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , , .

By Luis T
February 27, 2009

No comments

4.003 Creating a Chart in Microsoft Excel 2007

You can plot a two dimensional chart in Microsoft Excel 2007 easily. Fundamentally it would be a vertical bar chart with data representing the data in the selected cells. I am going to show you how you could plot a chart in Microsoft Excel 2007 in just a few steps.

Let’s get the data ready for the chart, now on cell B3, key in “Y”. And on cell B4 key in “1”, follow by “2” on cell B5 and “3” on cell B6. We are creating the Y axis of the chart. For the X axis, please key in “X1” on cell A4, “X2” on cell A5 and “X3” on cell A6 ( you are creating the X axis for the chart).

 

You had just created a basic element of a two dimensional chart, you will understand the logic when you see the complete picture of the chart.

Now, select the cell from A3 to B6, followed by the path: Insert — > Charts — > Column — > Clustered Column. You will immediately see a simple chart being created immediately on the worksheet.

 

Now try to change the chart type of the chart, you will see there are many choices for you on how you would want to present your data.

 

 

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , , .

By Luis T
February 25, 2009

No comments

4.001 Create a Basic Formula In Microsoft Excel 2007

One of the most powerful ability of Microsoft Excel is the ability to compute difficult calculations. Instead of having to use calculator manually, you could instruct Microsoft Excel to work out the answer for you using formulas. Formula could be as simple as summation, analysis or even financial computations.

Let’s start with creating a basic formula, the most fundamental method is giving the instruction (in formula format) to Microsoft Excel to compute the value on cells on the worksheet with answers on the pre-specified location.

Let’s do a simple summation on the worksheet, now on cell A3, enter “3” (a number) and Cell B3 enter “4” (a number). Then on the cell C3, enter “=A3+C3”, followed by pressing Enter on your keyboard. The answer you will find on cell D3 is “7”.

 

Now again on cell C3, change “=A3+B3” to “=A3-B3” (we are going to do subtraction), Then press Enter on the keyboard. You will find the answer is “-1”.

Let’s divide cell A3 with B3, change cell C3 to “=A3/B3”, you will find the answer on cell C3 changed to “0.75”. Repeat the process to multiply both the value in cell A3 and B3, change the cell C3 to “=A3*B3”, and press Enter on the keyboard.

Now you have gone through 4 basic calculations that will help you greatly in your journey in worksheet. You will soon find that whenever you change the value in cell A3 or B3. Say for example, if you change the value in cell A3 from “3” to “5”, you answer in cell C3 will also change accordingly.

=A3+B3                                : 9

=A3-B3                 : 1

=A3/B3                 : 1.25

=A3*B3                                : 20

 

 

 Visit www.ExcelExpertUser.com today for more details about Microsoft Excel 2003 and Microsoft Excel 2007

Posted in Chapter 4, Microsoft Excel 2007. Tagged with , , , , , , .

By Luis T
February 21, 2009

No comments