Showing posts with label Microsoft office. Show all posts
Showing posts with label Microsoft office. Show all posts

Wednesday, 22 January 2014

how to create visiting or business card in 10 simple steps with ms excel


If you’re used to putting the Microsoft Excel spreadsheet software to work  for you to calculate figures, charts and finances, don’t rule out the program for other uses, such as making publications. Excel offers the same kind of functionality as its other Office Suite partners for creating and designing materials such as business cards. Use Excel to make custom cards to give your contact details to potential new customers and clients.
1 – Open Excel, which automatically defaults a new, blank spreadsheet on the screen. Click the “Insert” tab at the top of the screen.
2 – Click the “Text Box” button on the toolbar/ribbon at the top of the screen. Hover your cursor over the spreadsheet and notice it changes to an upside down cross.
3 – Press and hold down the left mouse button and drag the cursor to form a rectangle on the screen; the size doesn’t matter at this point. Right-click the rectangle and select “Format Shape.”
4 – Click the “Size” option in the left side column on the “Format Shape” window. Type “3.5″ into the “Height” box and “2″ into the “Width” box.
5 – Click the “Fill” button and click the “Color” menu. Click one of the small colored squares to give your business card a background color. Skip this step to keep the background color white. Click the “Close” button to close the “Format Shape” window and return to the business card.
6 – Click inside the business card box and type your name, title, company, address, phone number and other information such as email address, website and hours of business operation.
7 – Highlight the text, click the “Home” tab at the top of the screen and use the “Font” section of the toolbar/ribbon to change the text font, size and color.
8 – If you’d like to include a digital logo image, click the “Insert” tab at the top of the screen. Click the “Picture” button directly below it. Browse to your logo and double-click the file name. The logo appears on the spreadsheet. Press and hold down the “Shift” button on the keyboard, grab a corner of the logo and shrink it down to size, then drag it onto the business card.
9 – Click the “File” tab, click “Save As,” type a name for the business card file
10- save it to your computer

Tuesday, 21 January 2014

how to create graphs in microsoft office 2007 in 10 simple steps

Enter the desired category data for the information you want to compare in the A column. Each category should be in a cell beginning with A2. In the example below, I used Fuel, Clothing, and Entertainment costs.


  •   Next you should type in the x-axis labels into row 1 that you want. Each label should be in a separate cell beginning with B1. In the example below, I typed in the four months that were being tracked.
  • Enter the values you want for the y-axis data in the correct data cells. The data should correspond to the correct x-axis and category. In my example I entered the amount of money spent for each item for each month rounded to the nearest dollar.
  • Highlight the data in the spreadsheet by clicking on the upper left hand corner of the data table, then drag the mouse across the entire data range.
  • Click on the “Insert” Tab in the menu at the top of the screen. This will be the second tab from the left
  • Click on the type of chart that you want to use to represent your data. For my data, I used a Bar graph because it’s good at showing different x-axis variables that represent different data. Many graphs portray data differently. I will have more information on this in my tips section. The types of charts are listed in the middle of the tab menu such as Column, Line, Pie, Bar, etc. A drop-down menu of Bar Chart designs will be shown after you click on one of them.
  • Select the type of chart that is best suited for the display you want. When you put your mouse over the chart option, you'll see a description of what the chart display is good for. For example, select “2D Bar” in a clustered column for the type of chart. The chart will appear on the spreadsheet using the data in a 2D form.
  • Click on your graph and and then click on the layout tab. To add graph titles or axis titles simply click on the titles tab. A drop-down menu will appear where you can choose the one you prefer.
  • Make changes to the chart as needed in the title, legend, fonts, etc. by clicking on the text and editing it.
  • After you are done formatting and editing the graph you can copy and paste it into other documents. If copy and pasting doesn't work you can always try taking a screen shot of the image and inserting into the selected document
  • © weknowwiki.in All rights reserved | Theme Designed by Seo Blogger Templates