Friday, March 26, 2010

How to inspect for hidden & Personal information

  1. Open the workbook that you want to inspect for hidden data and personal information.
  2. Click the Microsoft Office Button 
  3. click Save As, and then type a name in the File name box to save a copy of your original workbook.
  4. In the copy of your original workbook, click the Microsoft Office Button, point to Prepare, and then click Inspect Document.
  5. In the Document Inspector dialog box, select the check boxes to choose the types of hidden content that you want to be inspected.
  6. Click Inspect.
  7. Review the results of the inspection in the Document Inspector dialog box.
  8. Finish

Friday, March 12, 2010

Adding Images to a Document

To add an image to a document:
  • Firts you need to go to the insert tab. 
  • Once you are in the insert tab go to the illustrations group and click on the picture button. 
  • Then you can choose which picture you want and just insert it. 
To add a background:
  • First go to the page layout tab 
  • In the page setup group click on the background button. 
  • After that you can choose which picture you want to put as the page background.
  • And lets say that you don't like the background you can delete the page background by going to the page layout tab and under the page setup group click on delete background. 

Changing the Appearance od Data Based on Its Value

To change the apperance of data:
  • first select what you want to change the appearance. 
  • Then go to the home tab. 
  • In the styles group click on conditional formatting. 
  • Then click on any of the choices and you can pick which appearance you want for the group of data that you have and what the data's value is based on.

Making Numbers Easier to Read

To make numbers easier to read:
  • first you need to select the cell that you want to change.
  • Second thing that you need to do is to go to the home tab
  • Then go to the font group and click the dialog expander.
  • After the dialog box opens you have to click on what you want to change the number to from the category list. 
  • Once you choose something from the category list then you can customize it for example you can put a dollar sign or stuff like that and that's it.

Applying Workbook Themes and Table Styles

To apply an existing theme:
  • first go to the page layout tab 
  • Second go to the themes group and click on the themes button. 
  • Then you can choose from various themes the one you want for your workbook.
  • You can apply a new table style by going to the styles group on the home tab
  • click on the format as table button. 
  • Then click on the new table style button and you can then customize how you want the new style to look.

Thursday, March 11, 2010

Definig styles

To Define a style is very easy for example:
  •  first go to the home tab.
  •  go to the styles group and click on cell styles.
  • There are multiple styles that you can choose.
  • You can also create a new style by going to the home tab and going to the styles group and clicking on cell styles.
  • Then click on new cell style.
  • A style dialog box will pop up and you can name the new style to whatever you want it to be named.
  • Then click on the format button and the format cells dialog box will pop up and you can customize the new style the way you want it by clicking on the different tabs and creating it the way you want it to look.

Monday, March 8, 2010

Formating cells

How to format cells is easy:
cells are easy to do depending on what you want to format and most of the tools that you need are available in the home tab. Formating cells is easy first you have to select the cell or cells that you want to format and lets say that you want to make it bold so you select the cells first and the click the bold button that is on the home tab and in the font group.

What i learned from this activity is that you can select non-adjacent cells by holding the control key and select your cells.