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.
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
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
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.
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.
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.
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
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
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.
Tuesday, June 14, 2011
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.
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
Saturday, June 11, 2011
Friday, June 10, 2011
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.
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
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.
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.
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.
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.
