Microsoft Office Support

Support for All Microsoft Office Products and Suites.

Technical Support for everything in and out of the computer

Do you need a quick solution to a technical problem? With our live remote-assistance tool, a member of our support team can view your desktop and share control of your mouse and keyboard to get you on your way to a solution.

Microsoft Office 2007 and 2010 comes with XML editing feature

Since the 2007 version Microsoft has become more effective with the inclusion of XML scripts.

Microsoft Word is the most widely used word processor in the world

Word helps in performing our day to day word processing activities like writing emails, making documents etc.

Microsoft Office professional plus comes with many additions to the home and student edition

There are different versions that comes with additional Microsoft programs like Visio,InfoPath and its designer,Share point etc.

Tuesday, August 23, 2011

Format Paragraph


 
 In Microsoft word we have many formatting options to format a paragraph.In paragraph we can format spacing, font, indentation, first letter.

Thursday, August 18, 2011

Themes In Microsoft Word 2010

When we apply a theme, we simultaneously apply a font scheme, a color scheme, and a set of graphic effects. The font scheme and color scheme from the theme are carried over into the Quick Style sets. This helps increase speed of the program..

Saturday, August 13, 2011

Highlight Selected Text

In Microsoft office Programs like Word, Excel and Power point, when we want to highlight any particular text in the document, we use the Text Highlight Color option.

Remove Highlighting In Microsoft Word 2007

While removing highlighting from a word document in Word 2007 or 2010 we have two options. Either we can remove a part of selection or the whole highlighted part.

Thursday, August 11, 2011

Highlight Multiple Parts Of A Document

This method is best for highlighting multiple parts of a document, because the Highlight tool stays on until you decide to turn it off.We will see how can we highlight color in multiple parts of a Word 2007 or 2010 document.

Quick Find Highlighted Text

In Microsoft Word 2007 and 2010 we can find the highlighted text where ever the  word may be.

SuperScript And Sub Script In Word 2010

Super Script means making a word or letter or a number to be raised as a power of something. Sub Script means making a power to be taken as base of something- for example (10100)2 . Here 2 is the Sub scripted number. Microsoft Word gives us an option to make these two option usable and effective.     

Wednesday, August 10, 2011

Convert Existing Text to Word Art In Power point

In Microsoft Power point we can either directly insert wordart or can change the text already typed into wordart.

Remove Word Art Style In MSOffice Programs


Word art styles are some of the pre-designed word text styles that will make the text look in the way are designed. Word 2007 has brought some styles that will suit different backgrounds and titles. When we remove the WordArt style from our text, the text remains and changes to plain text.

Tuesday, August 9, 2011

What Does Apply As You Type Mean

In Microsoft word auto correct option we will have many options like Replace As you like in auto correct option and  in auto format option.

Change Text Case In Microsoft Word

While working with Microsoft word we have the option to change the text case when ever we wish to change it as per the necessity and the placing of the text. If we start a sentence we will use upper casing for the first letter and small for all the rest, 'I' is always kept used in Upper casing, and some abbreviations are used with uppercase and rest all are printed in small letters or lower casing. Here we will see how we can change the text casing easily. 

Saturday, August 6, 2011

What Does Replace As You Type Option Mean



In Microsoft word 2010 we have auto correct options that will do different auto corrections as selected. We have one of the options as Replace As you type as

Friday, August 5, 2011

Turn On Automatic Formatting Options

When you set options on the AutoFormat As You Type tab, Word can automatically format text as you are typing your document. For example, if you type a number followed by a period or hyphen, followed by a space or tab, followed by text, Microsoft Word makes the text a numbered list.

Add Watermark to Selected Pages

To add a watermark only to selected pages, we must separate the document into sections. For example, if we want to apply a watermark only to the table of contents in a document, we must create three sections: a cover page section, the table of contents section, and the rest of the document text in its own section. When we insert a cover page in a document, it has a separate header so that we don't need to create a separate section for it if we're creating sections to add a watermark only to selected pages.

Thursday, August 4, 2011

Turn A Picture Into A Watermark


We can turn a picture, clip art, or a photo into a watermark that we can use to brand or decorate a document. Microsoft word 2007 makes it easy for us to do a watermark.

Add AText Watermark To Document

Watermarks can be viewed only in Print Layout and Full Screen Reading views and on the printed page. We can insert a predesigned watermark from a gallery of watermark text, or we can insert a watermark with custom text. We will see how do we select

Wednesday, August 3, 2011

Change The Starting Point For Gridlines

In Microsoft word 2007 we can change the starting point for gridlines. Initially, the grid begins at the upper -left corner of the page. Word displays gridlines only within the margins of the page, even though the grid may extend beyond the margins. To view the gridlines beyond the margins of the document, use this procedure.

Tuesday, August 2, 2011

Show Gridlines In Microsoft Word 2007

 Gridlines help in setting the tabs or estimating the spacing between the lines or showing the borders, start and stop of page. In Microsoft word we can do it in a single step.

Change The Spacing Between the Drawing Gridlines

Spacing has to be there between any two objects or text or paragraphs without which it will look congested .

Monday, August 1, 2011

Data Validation-Microsoft Excel 2003

When we are working with tables where we need to type the same thing for a list of rows we may use this data validation as list. It is there in Microsoft Excel 2003 and next versions.

Saturday, July 30, 2011

To Remove A Page Border

We can remove the borders for a page as we do it for any other pictures or text box or drawing object. In Microsoft we  have to use almost the same screen to remove borders for many different objects.

Friday, July 29, 2011

REMOVE A BORDER FROM A DRAWING OBJECT



Drawing Objects are placed in Drawing Canvas that will hold all the objects and also pictures and text boxes. Microsoft Office Word can remove the border so as it can place the border for Drawing object.

Remove Borders From Picture And Table

Microsoft Word helps in removing the borders for all the objects we find in it. We can remove borders to pictures, tables and drawing objects.

Thursday, July 28, 2011

Add Border To A Picture Or Table Or Text

Pictures can also be given borders so as tables and text to be highlighted. This will help in highlighting the picture or Table. Word 2007 has given a option with which we can apply borders to Pictures, Tables and Text.

Add A Border To A Drawing Object

To add a border to a drawing object, we must place the drawing object in a drawing canvas first and proceed to add a border.

Wednesday, July 27, 2011

ADD A BORDER TO A PAGE


Page borders will make the page look good and gives a professional look to the document. Microsoft word 2007 offers a wide variety of border styles that suits different occasions.


Set the Sound Start and Stop Options



To set sound option in Microsoft power point 2007 we may need to do custom animation for all the slides to set the start and stop duration to all the slides.

Tuesday, July 26, 2011

Hide The Sound Icon



While playing the sound in power point presentation we can hide the sound icon while giving the presentation. In 2007 and 2010 we have it in Sound options group.

Play A Sound Across Multiple Slides


As we did it in one slide to play sound in a file we can do it on multiple slides as well. Power point gave us an option to do in on all the slides.

Monday, July 25, 2011

Play A Sound Continuously

We can play a sound continuously during just one slide or across many slides while presenting a presentation in power point 2007.

Saturday, July 23, 2011

Preview A Sound In Presentation



While playing sounds in presentation we may need to listen to them before we attach to the picture. So we need to preview them before playing the presentation. Power point gives us an option to preview the file before play.

Friday, July 22, 2011

Add and Play Sounds In a presentation



Sounds make a presentation more attractive and will help in effective presentation. Microsoft power point presentation with the help of sounds will make any project more presentable.

Wednesday, July 20, 2011

Add A Picture From Scanner Or Camera




In Microsoft Power point Photo album we can make photos and edit or improve the brightness and contrast of them easily. To the photo albums we can add pictures not only from the computer but also from the scanner or camera.

Adjust Brightness Of A Picture In Photo Album

 Brightness is one of the characteristics of a picture that will have an impact on its display and will also help in visibility of a picture. Power point has an option to change it when we use a photo album option.

Add A Textbox Into A Photo Album

Microsoft power point 2003 has given an option to insert a text box in  photo album. This is an added advantage which will help in adding some note to the photo album.

Adjust Contrast Of A Picture In Photo Album

While working with photo albums in power point we will have to change the picture display in brightness and contrast. Microsoft power point has an option to change that as well.

Tuesday, July 19, 2011

Layout And Design Options In Photo Album



We can also change the layout and design options in a photo album in Power point 2003. It is an advantage and is similar to other photo editing programs that  gives us photo editing features.

Delete A Picture from Photo Album

The Microsoft powerpoint has given us an option to remove a picture or add a picture from a photo album in Powerpoint 2003.

Move A Picture In A Photo Album

While working with photo albums in power point, we will have to get the photos in order. When we place them in disorder we can move them up or down to get them sorted.

Rotate A Picture In A Photo Album

Photos can be rotated in photo albums created in Power point. This is a feature that helps us assist in editing the power point. 

Monday, July 18, 2011

Compare Documents In Microsoft Word 2010

Microsoft word 2010 has an option to compare two documents where we see the changes in the second document.

Saturday, July 16, 2011

Add Caption To A Photo Album

Photo albums help in creating great memories for all and keep them alive for decades. we can make photo albums using Microsoft power point. We can add photos and give captions for each photo.

Create A Photo Album

Microsoft PowerPoint creates a new presentation when you use the photo album feature. Any presentations you currently have open in PowerPoint will not be affected by this task. 

Add A Picture To A Photo Album


We can add a photo to an existing photo album in Power point. We can edit albums easily - we can add a photo, remove a photo or edit a photo and many more.

Friday, July 15, 2011

Image Looks Cropped In Presentation



Sometimes when we are working on Microsoft Power point and are trying to give a projector presentation, the image looks cropped and the text will be of poor quality.

Saturday, July 9, 2011

The Image Dispalys Vertical Lines



While presenting a presentation in Microsoft Power point on a projector we might sometimes see vertical lines on the images and also some spots. This is due to inappropriate settings in the screen brightness or projector lens might not have been cleaned from a long time or so on. 

No sound is emitted from the projector


When we are running a presentation on a portable computer and a projector, the projector does not play any of the sounds in the presentation. This happens for many reasons.

Start Presentation On Two Monitors

When we have two monitors we have an option to project the presentation on two screens by adjusting the settings in the slide show set up.

Friday, July 8, 2011

Desktop Image Is Not Projected On Screen



When we are running a presentation on a portable computer and a projector, sometimes, the image of the desktop from the computer will not be projected. This is because of the lack of signal transmission between the computer and the projector. 

Black Out The Screen During Slide show



While presenting a presentation in power point we can pause the slide show by making the screen black out temporarily. To do this, we must be running the show on more than one monitor and select to use presenter view during the slide show. This turns the audience's monitor black, but maintains the presenter view on the primary monitor. The slide area in presenter view is black to reflect the audience's view.

Start A Slide Show Presentation

In Microsoft Excel power point we have an option to start a slide show of a presentation in three ways.

Set Up A Presentation To Start Automatically

Presentation is a way of presenting a project in a pictorial form. This will improve the productivity of a company in a very better way by saving a lot of time. Microsoft power point helps us in making presentations. we can make a set up where we can start a presentation automatically.

Thursday, July 7, 2011

Play A Flash Animation In Powerpoint

Flash Animation

Flash player is helpful in playing moving objects and animations at any point. In Microsoft Power point we can play flash files and can make it more entertaining and presentable.

Change Case of Slide Title Style

In Microsoft Power point we have the default slide text that is big in the middle and the sub title which is small. We have an option to change the default text or font case in Slide title.

Change Pen Color In Presentation

While presentation we can use mouse pointer as a Laser pointer. To set the color of pointer we may need to change the color of it in slide show settings. 

Set Up Slide Show

Power point helps us in making presentations and it does in the form of slide shows. We need to set up a slide show and time it with different designs and layouts.

Wednesday, July 6, 2011

Shortcuts For Navigating A Presentation

Microsoft Power point presentation provides us with a feature that make the presentation of a project easier. To navigate through the slides while presenting, there are few shortcuts that will help in moving smoothly throughout the slideshow. 

Create A Screen Saver

A screensaver is a type of computer program initially designed to prevent phosphor burn-in on CRT and plasma computer monitors by blanking the screen or filling it with moving images or patterns when the computer is not in use. Now it has become a fashion to fill the monitors with different screen savers that are very entertaining. We can create screensavers using Microsoft Power point.

Save a File As .BMP File

In Microsoft Power point, we have an option to save the presentation or a slide as a .bmp file. This means Bitmap file, the default file format of Microsoft paint application.

Diagrams In Microsoft Power Point 2003

Diagrams are a way of representing the whole story made short and very easy and beautiful way. They help us reduce the time and paper in communicating the message which is why organizations use diagrammatic way of presenting their projects or company's projections etc. Power point has an option to insert a diagram and also to edit them in our desired way.

Tuesday, July 5, 2011

Convert Text-Format Numbers Using Paste Special

Here, we multiply each selected cell by 1 in order to force the conversion from a text-formatted number to a regular number. Because we're multiplying the contents of the cell by 1, the result in the cell looks identical. However, Excel actually replaces the text-based contents of the cell with a numerical equivalent.


Share Workbook Among Users

Microsoft Excel gives us an option to share workbooks. We can add users who can work or edit a workbook. We can give them the level of editing capability. We can keep a track of changes made by other users.

Select Entire Column Or Row

There is an easier option to select whole column or row at a time in Microsoft Excel .

Change The Position Of Worksheets

When we are working with Excel sometimes we may need to move the sheets or we may need to refer the sheet 3 first and then sheet 2 or sheet one later at that time we can easily change the positions of the sheet by simple dragging.

Monday, July 4, 2011

Convert Text Format Numbers By Error Check

If we import data into Excel from another source, or if we type numbers into cells that were previously formatted as text, we may see a small green triangle in the upper-left corner of the cell. This error indicator tells us that the number is stored as text..




Saturday, July 2, 2011

Turn Off Error Checking For Number




With error checking turned on in Excel, you see a small green triangle if you enter a number into a cell that has text formatting applied to it. If you don’t want to see these error indicators, you can turn them off.
 

Turn Off Error Checking

With error checking turned on in Excel, we see a small green triangle if you enter any message or number or text into a cell. If we don’t want to see these error indicators, we can turn them off.

How to Select Range Of Cells

When we are working with Excel we may sometimes need to select cells in a range or cells that are scattered in different rows and columns, at that time may do one of the following.

Friday, July 1, 2011

How To Verify Number Format

While using Microsoft Excel we may have many formats like numbers, text, date and time etc. We have to give the same number format as input in that cell or it will not understand.

Filtering Same Records

In Microsoft Excel when we apply filters and get the data that is redundant be it in one column or multiple columns. In higher versions of Excel that is 2007 and 2010 we have filtering that is row specific and data specific.

Filter And Copy To Different Place

Once we filter the data we can copy that data in other cells as well in Excel sheet.

Change Sort Order To Rows

While sorting we may need data to be sorted in the row wise actually using different columns. Sometimes we may need to sort column wise from left to right in selected rows. Even this can be done in Excel 2003.

Thursday, June 30, 2011

Sorting In Microsoft Excel 2003

Microsoft Excel has an option to sort the data with any criteria as needed by us. In 2003 version we may have the option to do it column wise as well.

Filter For Above or Below Average Numbers

In Microsoft Excel 2007, we can filter the numbers for an average value. We can select two numbers and for an average value above and below it.

Filter By Cell Color

Filtering cells by color in Excel has been very helpful in choosing all the cells that are same colored and required data.
 

Clear Filters

We can clear a filter for a specific column or clear all filters at same time in Excel 2007 and 2010.

Wednesday, June 29, 2011

Filter By Selection


 Filtering is done by many ways and here we see how we can filter by selecting the text in Excel.

Types Of Filters In Microsoft Excel

In Microsoft Excel depending on the search criteria we have two types of filters. Filters are useful in selecting the search criteria and helps in finding the required data easily. 

Filter option In Microsoft Excel 2010

Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list. The following illustration shows three methods for quickly filtering data. Excel has introduced this feature since 2003 version.

Tuesday, June 28, 2011

Sub Totals In Microsoft Excel

Microsoft Excel has a subtotal feature calculates subtotals and grand totals for columnar data. The feature supports eleven calculating processes: sum, count, average, maximum, minimum, product, count number, and more.

Hide The Formula From Being Displayed

In Microsoft Excel 2003, we have an option to hide a formula in a cell and make it invisible to others viewing that sheet.

Protect Worksheet From Being Edited

Microsoft Excel has an option to protect the worksheet from being edited. We can choose the option of formatting that needs to be protected. To restrict users to make changes we need to protect the worksheet by keeping a password and restricting the required changes.

Monday, June 27, 2011

Fill Color In A Cell or Group Of Cells

In Microsoft Excel we can fill a cell or group of cells with a color. That can be done in two ways.

Saturday, June 25, 2011

Angle Text In Microsoft Excel

We enter text in cells in Microsoft Excel. If we want that text to be rotated in clockwise or anti clockwise we can do the following. 

Turn TaskPane On or Off

Task pane is a place where we can see the currently running tasks, previous tasks and an option to go online and connect to Microsoft Office site for further queries or document search. It will be there in all the Microsoft Office Programs. 

Friday, June 24, 2011

How To Get Drawing Toolbar In Excel

Drawing toolbar helps in editing any drawing object or picture that has been put on the document or spreadsheet. In Microsoft Excel it may not be visible by default. We can view it in following ways.

Merge Cells and Align Text To Center

In Microsoft Excel when we type something to keep as heading we may end up typing the whole thing in one cell and Excel covers it up with the next column. We can make it into a single cell and align it to the center.

Create A Form Using An Auto Forms

 Auto Forms are the forms that come with the Office while installing it. There will be some pre-created forms that will come with Microsoft Access by default.

Thursday, June 23, 2011

Create A Form In Design View

We can create forms even in Design View while entering the data in to the database. Here we can create fields and enter data as well.

Create A Form Using Table Or Query







In Microsoft Access we can create a form in many ways. One of the simplest ways is to go to the database main window and create a form.

Modify Hyperlink Stored In A Table

Microsoft Access gives us an option to modify the hyperlink that is there inside a table or stored in a table.

Wednesday, June 22, 2011

Modify Hyperlink Of A Label, Picture

When we want to modify the hyperlink of a label or picture of a command button in Microsoft Access we may change either the text or the address that hyperlink points to. 

Move Between Fields Using GoTo Field Box

Microsoft office has given all its products a very beautiful feature which will help us in searching or navigating to the  desired cell, or word or field.

Microsoft Access Terminology

 Here we will see what are the different terms that we use in Microsoft Access 2003. These terms will help us in understanding the Access and maintaining the database perfectly.

Tuesday, June 21, 2011

Create An Empty Database Without Wizard

Microsoft Access have three ways of creating a database. One is using a wizard where it has some steps where we get pre-defined column fields and following them. Second way is by using templates that have already been created. Third way of creating a database is creating a blank database and adding fields.

Add Columns For a Database

Once we access the database for entering the data into it after creating it, we can edit the columns either add or delete them. Microsoft Access has an easier way of doing it.

Thursday, June 16, 2011

Copy Row Labels To The Additional Rows


Label is a name we add in any chart, we can add it for rows and columns as well. We can simple copy row labels to additional rows.

Excel Prints Only A Portion Of Worksheet


Microsoft Excel sometimes prints a portion of worksheet and leaves the rest of the sheet. It is because of there print area that might have been selected or defined but it is given to print whole document.

Wednesday, June 15, 2011

Page Numbers At Each SubDocument Start


In Microsoft Word 2003, we have an option to start the page numbers at the start of each sub-document. Generally we will have it in every main or master document start but we can change it at the start of every sub document.

Convert SubDocument Into Master Document


We can convert a sub document into a part of master document in Microsoft Word 2003. This can be done with out any problem in Office 2003 and higher versions.

Tuesday, June 14, 2011

Hide Rows In Excel 2003

If we want to see the non adjacent row's data together we may need to hide the rows on the worksheet and can see the selected rows. Microsoft Excel do not delete the rows that are hidden. They will be in the background and it will show only the selected cells.

Hide Columns In Microsoft Excel 2003

In Microsoft Excel we may need to take print of adjacent columns and we don't want to delete the columns in between. In this situation we may hide the columns we don't want to print and can take the print without those columns very easily. 

Excel Ignores The Page Breaks

If our workbook is set up so that Excel fits our printed work on a specific number of pages, Excel ignores the manual page breaks we've set and reduces the size of the printed worksheet. This we can see under Page Setup on the File menu, by clicking the Page tab, and check the Fit to option under Scaling.

Excel Prints Too many Rows And Columns

Microsoft Excel sometimes prints many rows and columns than the given number which is due to the set area not set into correct level.

Set Header or Footer Margins

When we see a few documents we will find that the header and footer are very small or they might have been set to different margin size. We can change the margin size to our desired length and width in the Microsoft Office 2003 programs. 

Monday, June 13, 2011

Columns or Rows Printed On Wrong Page

Column widths, row heights, page margins, and page breaks determine the number of columns and rows that print on a page. Sometimes when we print the excel sheet some rows and columns will get printed in the next page or wrong page.

Saturday, June 11, 2011

Print Charts Together On A Page



In Microsoft Excel 2003 we have an option to print charts that are there on a single page together for quick reference or comparison.

Friday, June 10, 2011

Can't Scale A Chart To Print Size



In Microsoft Excel we may need to scale the charts when we print them else we may not be able to print them as usual. For chart sheets, set the print size. If the chart is on a chart sheet, you can scale it when you print it.

Excel Wont Print Multiple Print Areas

If a print area contains nonadjacent areas of a worksheet, Excel prints each area on a separate page by default. However, we can specify that separate parts of a worksheet print on the same page by using one of the following methods.

Prevent Columns or rows From Spilling

We can avoid columns and rows from spilling over the edge by adjusting the sheet content or by shrinking the sheet. So that it will be one page wide or one page tall.

Thursday, June 9, 2011

Excel Added Extra Rows To Worksheet

Excel formats empty cells out to the bottom row or last column if we select an entire row or column. We need to click the row number or column letter before applying formatting. Excel then stores the formatting information for all of the otherwise empty cells and the file gets very large.

Borders Can't Be Removed From WebPage

In Microsoft word there will be instances where we want to remove the borders for an object that has been created or download from the browsers, but we will not be able to remove them.

Can't See Outlines Of A Drawing Object

If wee add a drawing object and add a 3-D effect to it, the outline for that object will be erased. And when we want to see the outlines for that objects we may need to change the color of it. 

Can't Remove Shadings From The Page

Sometimes we may not be able to remove the shadings from the page in a document. We can trouble shoot that issue easily with the Microsoft word watermark or background option. 

Page Border Does Not Move When Changed

Sometimes when we type, the text goes  outside or it leaves a space in the end because of the page border setting. We may need to change it and has to adjust the text. In Word 2003 the page border does not seem to change when we change it.

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More