How to Calculate the Matrix Determinant on the Fly in MS Excel

Calculating the Matrix Determinant on the Fly
1. Create a square matrix in Microsoft Office Excel with values.
2. Type an equal sign (=) followed by MDETERM in an empty cell. While typing, you’ll notice that Excel automatically gives you a list of functions beginning with what you have already written. Many more functions are available in Microsoft Office Excel 2007.
3. After the opening parenthesis, select your matrix data. You'll instantly see the determinant being calculated. Excel updates this value if you change the source data

How to manage photo gallery in windows Vista

Photo Gallery

Windows Vista makes managing your media files even easier. Windows
Photo Gallery is an improved way of looking at images and includes
better organizational features catered to media. You can use the
properties tools to add tags for additional references.
Here’s how to open Windows Photo Gallery:
1. Click Start.
2. Click All Programs.
3. Click Windows Photo Gallery.

How to use Local Users and Groups

How to use Local Users and Groups using your computer

You might need to be logged on as an administrator or a member of the Administrators group in order to perform some tasks.
Local Users and Groups manages users and groups of users for your computer. You can create new users and groups, add users to groups, remove users from groups, disable user and group accounts, and reset passwords.

To open Local Users and Groups

1. Open Computer Management (Local).
2. In the console tree, click Local Users and Groups.

Notes

1. To open Computer Management, click Start, and then click Control Panel. Double-click Administrative Tools, and then double-clickComputer Management.
2. For information about using Local Users and Groups, in Computer Management, click Help on the Action menu.

How to Use Removable Storage

You might need to be logged on as an administrator or a member of the Administrators group in order to perform some tasks.

Removable Storage makes it easy for you to track your removable storage media (such as tapes and optical discs) and to manage the libraries that contain them (such as changers and jukeboxes).

To open Removable Storage

1. Open Computer Management (Local).
2. In the console tree, click Removable Storage.

Notes

1. To open Computer Management, click Start, and then click Control Panel. Double-click Administrative Tools, and then double-click Computer Management
2. For information about using Removable Storage, in Computer Management, click Help on the Action menu.

How to Use System Properties

You might need to be logged on as an administrator or a member of the Administrators group in order to perform some tasks.

System Properties is a Windows Management Instrumentation (WMI) tool that lets you view and change system properties on a remote computer or local computer. Using System Properties, you can restart a remote computer to apply settings changes or to detect new hardware, view the computer name and domain information for other computers on your network, and change the settings for the virtual memory paging file on a computer that might run programs requiring a lot of memory.

To open System Properties

1Open Computer Management (Local).
2.In the console tree, right-click Computer Management (Local), and then click Properties.

Notes

1. To open Computer Management, click Start, and then click Control Panel. Double-click Administrative Tools, and then double-click Computer Management.
2. For information about using System Properties, in Computer Management, click Help on the Action menu.

How to use Microsoft Management Console

The Microsoft Management Console (MMC) is a tool used to create, save, and open collections of administrative tools, called consoles. Consoles contain items such as snap-ins, extension snap-ins, monitor controls, tasks, wizards, and documentation required to manage many of the hardware, software, and networking components of your Windows system. You can add items to an existing MMC console, or you can create new consoles and configure them to administer a specific system component.
Open MMC
Notes
1. To open MMC, click Start, and then click Run. In the Open box, type mmc.
2. For information about using MMC, on the Action menu, click Help.

How To Use Back Up

The Backup utility helps you create a copy of the information on your hard disk In the event that the original data on your hard disk is accidentally erased or overwritten, or becomes inaccessible because of a hard disk malfunction, you can use the copy to restore your lost or damaged data.

Open Backup
Notes

1. To start Backup, click Start, point to All Programs, point to Accessories, point to System Tools, and then click Backup.
2. The Removable Storage service must be started for Backup to work properly. For more information, click Related Topics.
3. You can also use the Automated System Recovery Wizard in the Backup utility to help you repair your system.
4. For information about using Backup, click the Help menu in Backup.

How to know whichPrograms included with Windows XP

Windows XP provides the tools you need to work and play in today's high-speed communications environment. Your toolbox includes system tools that help you set and adjust system resources, users and user groups, and scheduled system tasks. Accessories help you get the job done, no matter what the job is. You can create documents and images, calculate figures, schedule your time, and have online meetings with co-workers. When it's time to enjoy some music, browse the Internet, or play a few games. Your communications and entertainment tools will help you relax.

Whats new in windows XP

Windows XP brims with new features, improved programs, and tools. See what’s new; take an entertaining tour; learn about the programs Windows XP contains, including systems, accessories, and communications and entertainment programs. Read articles containing full descriptions for performing key tasks from start to finish. Look up unfamiliar terms in the glossary.

Does When u Double click on Drive... New Window opens?

Whenever ppl double-click on any folder in Computer,

it opens in a new window even if selected the option “Always open folders in same window” in “Tools -> Folder Options”.
For this kind of Problem

Download following zip file, extract it and then run .REG file and confirm the action:

Download

Updated trick for enabling Folder option

Many times Windows users face a common problem. The “Folder Options” in “Tools” menu is not visible. Even It can’t be accessed from Control Panel. Also “Registry Editor” is disabled.
Follow the simple steps mentioned in this tutorial and your problem will be solved:

1. If Folder Options is disabled but Registry Editor is still working in your system, then you can enable Folder Options by editing Windows Registry.
Type regedit in RUN dialog box and press Enter.
it’ll open Registry Editor, now go to following keys:
HKEY_CURRENT_USER\Software\Microsoft\Windows\Current Version\Policies\ExplorerHKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Current Version\Policies\Explorer
In right-side pane, check whether a DWORD value named NoFolderOptions exists or not? If it exists, delete it.

2. If you are not familiar with editing the registry, then you can simply download following file, extract it and then run the .REG file:
Folder_option.zip

................................................................................................................
If u cant run regedit ....
Seems like your system is infected with a virus. Pls follow following link:
http://www.askvg.com/is-your-system-infected-with-a-virus-spyware-adware-trojan/

..................................................................................................................
Some ppl find that "show hidden files and folders" option ll not b enabled..
though enabled they cant c the hidden folders...
for that dont worry
--open RUN
--type regedit
--HKEY_CURRENT_USER\Software\Microsoft\Windows\Current Version\Explorer\Advanced
And in right-side pane, change value of “Hidden” to 1 and refresh My Computer window and you’ll be able to see hidden files again

Secret Codes for Nokia

Codes :
1) *#06# For checking IMEI(international Mobile Equipment Identity)
2) *#7780# Reset to factory settings
3) *#0000# To view software version
4) *#2820# Bluetooth device address
5) *#746025625# Sim clock allowed status
6) #pw+1234567890+1# Shows if ur sim as any restrictions

How to Collect Your Favorite Shapes for Easy Access in MS Office Visio

Collect Your Favorite Shapes for Easy Access
Do you frequently use the same shapes from several different stencils when creating diagrams? Instead of opening several stencils each time you start a new diagram, just save your frequently used shapes to the Favorites stencil for easy access from one location. To save a shape to the Favorites stencil, right-click the shape in its existing stencil, point to Add to My Shapes, and then click Favorites.
Notice that, from the Add to My Shapes options, you can also create your own custom stencils and add favorite shapes to those. (After you create a custom stencil, it will appear under the Add to My Shapes options as well.) To access the Favorites stencil or your custom stencils, on the File menu, point to Shapes, and then point to My Shapes.

How to Speed Up Displaying Documents with Many Graphics in ms word

Now you can see your documents with many graphics to do this just follow the instructions

1. Click the Office button, and then click Word Options.
2. Click Advanced, scroll down to the Show document content section, and select Show picture placeholders.
3. Click OK. Pictures will be shown with placeholders, markers that maintain the structure of the document without showing the picture itself.

How to Create Reminders to Follow Up on E-Mail You've Sent MS Outlook

Create Reminders to Follow Up on E-Mail You've Sent

You can set reminders to follow up on e-mail you've sent. When drafting an e-mail message, click the Follow Up flag. Previously, although this would create a flag both for you and for the recipient, you still had to look for it in your Sent Items folder. Microsoft Office Outlook 2007 now places a flag in your To-Do Bar tasks for this e-mail message by default.

How to Create a Project Proposal in MS Office Project

Create a Project Proposal

By using proposals, you can define high-level project plans to provide key project information, milestones, and resource demands.
1. In Microsoft Office Project Web Access, click Proposals and Activity Plans in the left Action pane.
2. On the New menu, click Proposal.
3. In the New and Import section, click New.
4. Enter the name of the project, description, start date, finish date, and plan owner. You can also add details with tasks or resources with a resource plan or build team.
5. Click Publish. You have now created a complete Project proposal, pending approval.

How to manage All External Data Source Connections in MS eXcel

Managing All External Data Source Connections

With a Microsoft Office Excel workbook open, click the Data tab, and then click Connections. You can then view the data sources used in the workbook. If you select one, you can also see where that connection is used by clicking the Properties button. This feature is especially helpful when working with online analytical processing (OLAP) cubes via Excel.

How to Check for Hidden Content Before Sharing Your Documents

Check for Hidden Content Before Sharing Your Documents in Microsoft Windows Office

The 2007 Microsoft Office system programs Word, Excel, and PowerPoint include a new built-in Document Inspector tool that enables you to search for and remove potentially private hidden content before sharing your documents. To access the Document Inspector, first save your document. Then, click the Office button, point to Prepare, and then click Inspect Document.

Depending on the program you are using, this tool searches for different content types—such as comments, unresolved tracked changes, and headers and footers in Word 2007. Of course, just because the tool finds relevant content (such as headers and footers) doesn’t mean you should remove that content. The Document Inspector finds content that may be hidden depending upon the individual document’s settings or the way you view the document. Review for yourself the content found by the tool to determine if you want to remove it from your document. Keep in mind that some types of content the Document Inspector finds (such as custom XML data) may be required for the document to function properly.

How to Find the Right Shared Calendar in MS Out Look

Question:-How to Quickly Find the Right Shared Calendar in MS Out Look?
Answer:-Quickly Find the Right Shared Calendar

To create calendar groups:
1. In the Navigation Pane at left, click Add New Group.
2. A new group appears at the bottom of your calendars. Give it a name of your choice.
3. Drag as many of your calendars as you want to the new group's name bar to enter them into that group.

To arrange your new group by name:
Right-click the group name, and then click Arrange By Name. This is a quick and easy way to find the calendar you're looking for

How to use 2003 to 2007 Sharing Requests

Question:-how to view 2003 to 2007 Sharing Requests?
Answer:-2003 to 2007 Sharing Requests

In Microsoft Office Outlook 2003, you can view multiple calendars side-by-side. However, before you can view a colleague's calendar, that person must first share his or her Outlook 2003 calendar by clicking Share My Calendar in the left pane of the Calendar view.

With Microsoft Office Outlook 2007 and Microsoft Exchange Server 2007, you don't have to wait for someone to share his or her calendar with you; you can invite the person to do it right now. Clicking Share My Calendar in the Outlook 2007 Calendar view opens a sharing request. A sharing request is essentially an e-mail message with two check boxes: One enables you to share your calendar with the recipient, and the other asks the recipient to share his or her calendar with you. When the request appears in the recipient's Inbox, he or she can use the buttons that appear in the Reading Pane to allow or deny your request.

How to Use Side Notes in MS Office OneNote

Question:-How to Use Side Notes in MS Office OneNote?
Answer:-Use Side Notes in MS Office OneNote
You can use side notes to easily drag content into Microsoft Office OneNote, even when it isn’t open on your screen. Right-click the OneNote icon in the notification area, and then click Open New Side Note (keyboard shortcut: Windows logo key+N).

How to Move PowerPoint Pictures Around Quickly

Question:-How to Move PowerPoint Pictures Around Quickly?
Answer:-Move PowerPoint Pictures Around Quickly?

Microsoft Office PowerPoint 2007 removes the hassle normally involved in adjusting the size and position of overlapping images on slides. You can simply drag one picture over another. The top picture will become transparent, so that you can position it accurately over the other

How i can Put my Vacation in Team Calendars in MS Outlook

Question:-How to Put Your Vacation in Team Calendars in MS Outlook?
Answer:-Put Your Vacation in Team Calendars in MS Outlook

If you are planning a vacation, you can send a meeting request to your teammates for the duration of your break, with your name and the phrase "vacation schedule" in the subject line. In the Show As box, select Free so that you’re not blocking out time in their calendars. Select the All day event check box so that it appears only at the top of each day for your teammates. Don’t forget to create another appointment in your own calendar, marking your time as Out of Office so that no one can schedule you for a meeting.

How to Add Office Groove 2007 to the Windows Start Menu

Question:-How to Add Office Groove 2007 to the Windows Start Menu?
Answer:-Add Office Groove 2007 to the Windows Start Menu
Although synchronization occurs automatically, you must be running Microsoft Office Groove 2007 to send and receive updates. Adding Groove to your Windows Start menu will help you remember to log on to Groove.
1. Go to the Launchbar, click the Options menu, and then click Preferences.
2. Click the Options tab, and then select the Launch Groove when Windows starts up check box.

How to Filter Data in a Microsoft PivotTable View in MS Excel?

Question:-How to Filter Data in a Microsoft PivotTable View in MS Excel?
Answer:-Easy Filtering of Data in a Microsoft PivotTable View in MS Excel?

There is a better way to select multiple report filters than dragging the filter down to a row. It is quicker to select additional filters directly from the original filter.
1. Select the filter, and then click multiple items at the bottom.
2. The filter selection changes to check boxes. Simply select the boxes you require.

How to Use Drag-and-Drop Functionality with Sections and Pages in MS Note One?

Question:-How to Use Drag-and-Drop Functionality with Sections and Pages in MS Note One?
Answer:-Use Drag-and-Drop Functionality with Sections and Pages

With the new Microsoft Office OneNote 2007 navigation pane, you can easily use drag-and-drop functionality to reorganize your notebooks, sections, and pages. To drag a notebook, section, or page to a new location:
1. Click and hold the notebook in the navigation pane, or the tab of the section or page that you want to move.
2. Drag it to a new location.
With the new Microsoft Office OneNote 2007 navigation pane, you can easily use drag-and-drop functionality to reorganize your notebooks, sections, and pages. To drag a notebook, section, or page to a new location:
1. Click and hold the notebook in the navigation pane, or the tab of the section or page that you want to move.
2. Drag it to a new location.

How to Move the Cursor in Any Direction During Data Entry in MS Excel

Question:-How to Move the Cursor in Any Direction During Data Entry in MS Excel?
Answer:-Move the Cursor in Any Direction During Data Entry in MS Excel

By default, the cell pointer in Microsoft Office Excel moves down when you press ENTER after entering data in a cell. You can, however, change the direction in which the cell pointer moves.
1. Click the Office button, click Excel Options, and then click Advanced.
2. Select the After pressing Enter, move selection check box if it isn't already selected, and then on the Direction menu, click the direction in which you want the pointer to move.

Also, when working in a document, you can make the pointer move in the opposite direction from the one you've chosen by holding down the SHIFT key while you press ENTER.

How to Follow Up on Mail in MS Outlook

Question:-How to Follow Up on Mail in MS Outlook?
Answer:-Follow Up on Mail in MS Outlook

You can flag a message by using the INSERT key. Select the message that you want to highlight in Microsoft Office Outlook, and then press INSERT. This will flag the item and enable you to insert a start date and due date. If your To-Do Bar is active, it will appear in your task list.

How to do 2003 to 2007 Auto Account Setup in MS Office

Question:-How I can do 2003 to 2007 Auto Account Setup in MS Office?
Answer:-2003 to 2007 Auto Account Setup in MS Office
To set up a Microsoft Office Outlook 2003 e-mail account, you need to know not only your user name and password, but also server names and port numbers. Auto Account Setup in Microsoft Office Outlook 2007 can detect and configure most e-mail accounts by using just your e-mail address, user name, and password. If your mailbox is on a Microsoft Exchange Server 2007 server, your account will be created automatically via your network credentials.

To create a new Outlook 2007 e-mail account:
1. Click Start, right-click the Outlook icon, and then click Properties.
2. Click E-mail Accounts, and then click New on the E-mail tab.

How I can Tag a Contact in Office Communicator

Question:-How to Tag a Contact in Office Communicator?
Answer:-Tag a Contact in Office Communicator

When you want to send an instant message to a contact, his or her status in Microsoft Office Communicator may be set to Do Not Disturb. You can’t tell when the contact switches back to being Online, and starting Office Communicator every few minutes to see if the contact is available takes time and is hard to remember.

Instead, you can set Office Communicator to notify you automatically when the contact's status changes to Online.
1. Open Office Communicator and find the person’s name in your list of contacts.
2. Right-click the name of your contact, and then click Tag Contact.

If it’s someone you often need to send a message to, leave the name tagged; if not, clear the tag after you’ve spoken to the person to avoid unnecessary alerts

How to Edit in Print Preview in MS Word

Question:-How I can Edit in Print Preview in MS Word?
Answer:-Editing in Print Preview in MS Word

After you have worked on a document in Microsoft Office Word, click the Office button, point to Print, and then click Print Preview. You can still edit in print preview mode: Disable the magnifier by clearing the Magnifier check box on the Preview tab, and edit the document as you want.

How I can Link Contact and Task Information in MS Out Look

Question:-How to Link Contact and Task Information in MS Out Look?
Answer:-Linking Contact and Task Information in MS Out Look

You can link contacts with specific tasks. To add individual contacts to individual tasks, click the Contacts button on the lower-left side of each Task form. This opens the address book, from which you can select one or several contacts. You can then add these to the task as links so that the next time you need a particular contact who relates to the task, all you have to do is click the link.

If you don’t see the Contacts button on the Task form, here’s how to make it appear:
1. Click Tools, click Options, and then on the Preferences tab, under Contacts and Notes, click Contact Options.
2. Under Contact Linking, select the Show Contact Linking on all Forms check box.

How to Build Own Workflow for Document Collaboration in MS Share Point

Question:-How I can Build My Own Workflow for Document Collaboration in MS Share Point?
Answer:-Build Your Own Workflow for Document Collaboration in MS Share Point

1. Start Microsoft Office SharePoint Designer 2007, and then connect to your SharePoint site from the File menu.
2. Click Files, click New, and then click Workflow. The Workflow Designer wizard helps you build your custom workflow step by step.

How I can Organize Colored Cells More Efficiently in MS Outlook

Question:-How to Organize Colored Cells More Efficiently in MS Outlook?
Answer:-Organize Colored Cells More Efficiently in MS Outlook
 
When using the filter option for large Microsoft Office Excel worksheets in the 2007 Microsoft Office system, you can filter the document by color. Click the down-pointing filter arrow on your filtered column, and then click Filter by Color. The colors display as a list, from which you can select the color that you want to display.

How I to Move the Quick Access Toolbar from Its Default Position in MS Powerpoint

Question:-How I to Move the Quick Access Toolbar from Its Default Position in MS Powerpoint?
Answer:-Moving the Quick Access Toolbar from Its Default Position
 
You can position the Quick Access Toolbar in one of two places: the default position in the upper-left corner beside the Office button, or below the Ribbon. To move it from the default position, click the Customize Quick Access Toolbar arrow, and then click Show Below the Ribbon.

How i can Keep Track of Projects and Team Responsibilities in Office Outlook

Question:-How to Keeping Track of Projects and Team Responsibilities in Office Outlook?
Answer:-Keeping Track of Projects and Team Responsibilities in Office Outlook 
 
You can create folders within the Tasks folder to keep better track of activities. In Microsoft Office Outlook, begin by creating a Done folder within Tasks, and transfer to it all tasks from My Views that you've already completed. You can do this with just one click and without needing to reopen each task. You can then create subfolders within this Done folder to save documents that relate to different types of activities, such as phone calls and visits.

How I can Make Form Automatically Resize able in MS Access?

Question:-How to Make Your Form Automatically Resize able in MS Access?
Answer:-Make Your Form Automatically Resize able in MS Access 
 
To help your form best use the available screen space, use the Anchoring gallery on the Layout tab. From there you can anchor a control to the right or bottom of your form, or even stretch it. In seconds, you can make your forms automatically resize as your window size varies.

How to Organize Your Records in MS EXcel

Question:- How I can Organize Your Records the Way I Want Them in MS excel?
Answer:-Organize Your Records the Way I Want Them in MS excel 
 
You can customize how you sort your records by using a filter. To activate a filter:
1. In Microsoft Office Excel 2007, click Filter on the Data tab.

2. To choose your sorting options, click the filter arrow on the column that you want to sort, point to Sort by Color, and then click Custom Sort.

3. Create a customized sort order.
a. In the Sort dialog box, under Column, click the drop-down arrow next to Sort by, and choose the field that you want to be sorted. Values should appear in the Sort On field.
b. In the Order field, click Custom List. This will open a window that offers an entirely custom sort list.
c. In the left pane, list the values (each separated by a comma) in the order that you want them to be sorted, and then click Add.
d. In the right pane, select the list you've created, and then click OK.
e. In the Sort dialog box, click OK.

From now on, your records will be sorted according to your customized list.

How to Add a Network Printer in MS Vista

Question:-How I can Adding a Network Printer in MS Vista?
Answer:-Adding a Network Printer

Most printers are networked, primarily for efficient use of resources. There are three basic ways to add a printer. The first way is through Control Panel. The second way is to use Network Explorer as follows.

1. Click Start.
2. Click Network.
3. Click Add a printer at the top of the screen (do this when you are adding your network resources).

The third (and even quicker) way is to type printer in the Quick Search box.

How to Manage Resources in Office Project

Question:-How to Manage Resources in Office Project?
Answer:-Managing Resources in Office Project
When you start assigning resources to tasks in Microsoft Office Project, the durations of the tasks automatically change. To understand why, you need to understand how Project allocates resources. Project follows one formula for all internal resourcing calculations: Work = Duration × Resources. In other words, if two men take four hours to mow a lawn, one man will take eight hours, or four men will take two hours, to mow the same lawn. Now you know why task durations constantly change if you add or remove the resources allocated to those tasks.

You can stop Project from recalculating time schedules in this way by configuring it to keep one parameter fixed and calculate just the others.
1. Open the task's properties.
2. On the Advanced tab, configure the task type as being Fixed Duration, Fixed Work, or Fixed Units (that is, resources). By changing this setting, you can tell Project what parameters in the equation should remain the same, no matter what changes you make to the task.

How to Change the Microsoft Office Word Smart Quote Auto-correct Setting in MS Word?

Question:-How I can Change the Microsoft Office Word Smart Quote Auto-correct Setting in MS Word?
Answer:-Change the Microsoft Office Word Smart Quote Auto-correct Setting in MS Word?
By default, Word replaces straight quotes with smart quotes. To change this setting:
1. Click the Office button.
2. Click Word Options.
3. Click Proofing, and then click AutoCorrect Options.
4. Click the AutoFormat tab.
5. Clear the Straight quotes with smart quotes check box.
6. Click the AutoFormat As You Type tab.
7. Clear the Straight quotes with smart quotes check box.
8. Click OK twice.