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.

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.

Wednesday, June 8, 2011

Borders Don't Appear On Every Page

Sometimes we insert borders to a page and they wont appear on all the pages in a document. We think that there is an issue with our Microsoft office but it is just a setting in the Borders and Shading dialog box. 

Print More Than One Copy

This applies to any documents or spreadsheets or presentations. If we want to print more than one copy we may need to change the number of copies in the print dialog box. 

To Change Object's Color Setting

When we want to print a presentation in black and white or in grayscale we may need to choose the same view and print it. After changing the view, if we want to change the black and white color setting of an object in the presentation we may need to do the following. 

Print a Presentation In Grayscale

We can  print slides in a presentation in grayscale or black and white when it is required without changing the original colors design in the original color presentation

Preview A Presentation Before Printing

We can print a presentation as we do the documents and spreadsheets. This can be seen or previewed and the can be printed after making the necessary adjustments to its orientation, margins etc. 

Tuesday, June 7, 2011

Slides Are Not Printing in Color

In Microsoft Power point sometimes we may not be able to print the slides in color or preview them in color. We can easily overcome it by making a simple adjustment.

Stop Specific Workbook At Start up

As we discussed before we can start a specific workbook at the start up of Microsoft Excel.But when we feel that the necessity of that workbook is completed we may stop it from being loaded at the start up.

Alternate Startup Folder for MS Excel

Start up folder is a place where we will have workbooks that will be opened when we start Excel. We can change the default Excel startup folder. 

Open A Specific Workbook When Excel Starts

 Before we start Microsoft Office Excel, we can make sure that a specific workbook or a workbook template or worksheet template that has custom settings opens automatically when we start Excel. If we no longer need a specific workbook to open, we can stop it from being opened when we start Excel. 

Monday, June 6, 2011

Desktop Shortcut For An Office Document

We can create a shortcut to open a same document many times if necessary. We can directly keep that document shortcut on the desktop in a very easy way. Microsoft Office opens any document directly or its shortcut.

Saturday, June 4, 2011

Change Default Chart Type

We can choose the type of chart we insert on the spreadsheet in Excel 2003. This will help us in reducing the time we insert a chart, We can later on change the type of chart as required.

Create A Chart In Microsoft Excel 2003

Microsoft is one of the best spreadsheet applications that are available in the market. We can use it for many calculations and financial data interpretation and analysis.

Rotate Picture In A Document

Pictures play a vital role in communicating a message to readers than making it into a text or readable content. We have an option to insert pictures and rotate them as required. This is one of the best features of Word 2003.

Flip Auto Shapes In Microsoft Word 2003

We insert Auto Shapes to put some message in some part of the document where we may need to insert additional information for a particular word or object or image.

Friday, June 3, 2011

Default Program For Imported Graphics

When we import graphics from other programs or from internet we may need a program to open them. Windows automatically takes the available software that will open the format that we are downloading. For Example if we are downloading .MP3 it will open the file in any of the media players available. Microsoft Word 2003 can be chosen as default program to import graphics.

Graphics Are Not Printed While Printing

When we print documents with pictures or graphics we may not be able to see them. This is a problem that might be due to many reasons. 

Save Graphics In .PNG Format

In Microsoft Office 2003 we have an option to save graphics in .PNG format while browsing on internet. This feature is applicable to Microsoft Word, Excel and Access of Office 2003.
 

Types Of Text In Microsoft Power Point

In Microsoft Power point there are Four types of text that can be added to a Slide. These are text in different formatting options and tools.

Thursday, June 2, 2011

Cannot Select Image On A Slide



Sometimes when we are working with Microsoft Power point we may find that we will not be able to select the text or an object or a picture.It is just a lack of knowledge that the image is background image not the image on the slide. This can happen in 2007 and 2010 versions of the Power point as well.

Troubleshoot Incomplete Graphic

When we insert a graphic sometimes it appears only a part appears and it may reinsert the picture in same way if we remove and re-insert it. This can happen in any of the Microsoft Word programs.

Wednesday, June 1, 2011

Set Defaults For Auto Shape

 Auto Shapes are the styles that we can insert to make the document look more presentable and it solves the purpose. In Microsoft  Word 2003 there is a way where we can keep the default style for Auto shapes.

Add 3-D Effect To A Drawing Object

We have an option to add or apply 3-D effect to any Auto Shape or word Art or any Drawing Object. Microsoft Word has provided a feature to add effects and that has been improved in Microsoft Word 2007 and 2010 versions.

Search This Blog

Followers

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