Try Office 2007 FREE for 60 days!*

Download a free 60-day trial of Office Professional or Home and Student edition today.

Try Office 2007 FREE for 60 days!*
Download a free 60-day trial, with the option to buy

1.Word 2007 provides editing and reviewing tools that help you create professional documents more easily than ever before.

2.PowerPoint 2007 enables users to quickly create high-impact, dynamic presentations, while integrating workflow and ways to easily share information.

3.Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions.

4.OneNote 2007 helps you save, organize, and retrieve notes and information. With powerful search tools and shared notebooks, OneNote makes it easier for people to work together.

* You can launch the application for a total of 25 times within the 60 day time period before having to enter the Product Key and Activating the product.

Microsoft Security Assessment Tool

Microsoft Security Assessment Tool

Use this free tool to assess weaknesses in your current IT security environment.

Microsoft Security Assessment Tool
The Microsoft Security Assessment Tool (MSAT) is a free tool designed to help organizations like yours assess weaknesses in your current IT security environment, reveal a prioritized list of issues, and help provide specific guidance to minimize those risks. MSAT is an easy, cost-effective way to begin strengthening the security of your computing environment and your business. Begin the process by taking a snapshot of your current security state, and then use MSAT to continuously monitor your infrastructure’s ability to respond to security threats.
At Microsoft, the security of our customers' networks, business servers, end-user computers, mobile devices, and data assets are a top priority. We are committed to providing security tools like MSAT to help you improve the security state of your business.

Understanding Your Risks
MSAT is designed to help you identify and address security risks in your IT environment. The tool employs a holistic approach to measuring your security posture and covers topics including people, process, and technology.
MSAT provides:
Easy to use, comprehensive, and continuous security awareness
A defense-in-depth framework with industry comparative analysis
Detailed, ongoing reporting comparing your baseline to your progress
Proven recommendations and prioritized activities to improve security
Structured Microsoft and industry guidance
Visit the Trustworthy Computing site to find out more about the Microsoft commitment to trustworthy computing.
Read the most current Microsoft Security Intelligence Report. For further information, visit the Malware Protection Center.

The MSAT Process
MSAT consists of over 200 questions covering infrastructure, applications, operations, and people. The questions, associated answers, and recommendations are derived from commonly accepted best practices, standards such as ISO 17799 and NIST-800.x, as well as recommendations and prescriptive guidance from the Microsoft Trustworthy Computing Group and other external security sources.
The assessment is designed to identify the business risk of your organization and the security measures deployed to mitigate risk. Focusing on common issues, the questions have been developed to provide a high-level security risk assessment of the technology, processes, and people that supports your business.
Beginning with a series of questions about your company's business model, the tool builds a Business Risk Profile (BRP), measuring your company’s risk of doing business due to the industry and business model defined by BRP. A second series of questions are posed to compile a listing of the security measures your company has deployed over time. Together, these security measures form layers of defense, providing greater protection against security risk and specific vulnerabilities. Each layer contributes to a combined strategy for defense-in-depth. This sum is referred to as the Defense-in-Depth Index (DiDI). The BRP and DiDI are then compared to measure risk distribution across the areas of analysis (AoAs)—infrastructure, applications, operations, and people.
In addition to measuring the alignment of security risk and defenses, this tool also measures the security maturity of your organization. Security maturity refers to the evolution of strong security and maintainable practices. At the low end, few security defenses are employed and actions are reactive. At the high end, established and proven processes allow a company to be more proactive, and respond more efficiently and consistently when needed.
Risk management recommendations are suggested for your environment by taking into consideration existing technology deployment, current security posture, and defense-in-depth strategies. Suggestions are designed to move you along a path toward recognized best practices.
This assessment—including the questions, measures, and recommendations—is designed for midsize organizations that have between 50 and 1,500 desktops in their environment. It is meant to broadly cover areas of potential risk across your environment, rather than provide an in-depth analysis of a particular technologies or processes. As a result, the tool cannot measure the effectiveness of the security measures employed. This report should be used as a preliminary guide to help you develop a baseline to focus on specific areas that require more rigorous attention. From the guidance provided by MSAT and security activities implemented, you can run the tool as often as you would like to gain further knowledge on your progress against an established baseline MSAT report.
Assessment Tool Overview
This Microsoft Security Assessment Tool is designed to assist you with identifying and addressing security risks in your computing environment. The tool employs a holistic approach to measuring your security posture by covering topics across people, process, and technology. Findings are coupled with prescriptive guidance and recommended mitigation efforts, including links to more information for additional industry guidance as needed. These resources may assist you in learning more about the specific tools and methods that can help you change the security posture of your IT environment.
The assessment is made up of over 200 questions, broken down into four categories:
1.Infrastructure
2.Applications
3.Operations
4.People
The questions that make up the survey portion of the tool and the associated answers are derived from commonly accepted best practices around security, both general and specific. The questions and the recommendations that the tool offers are based on standards such as ISO 17799 and NIST-800.x, as well as recommendations and prescriptive guidance from Microsoft’s Trustworthy Computing Group but also other external security sources.

The following lists the areas that are included in the security risk assessment.
Infrastructure and
Importance to Security
Perimeter Defense
Perimeter defense addresses security at network borders, where your internal network connects to the outside world. This constitutes your first line of defense against intruders.
Authentication
Rigorous authentication procedures for users, administrators, and remote users help prevent outsiders from gaining unauthorized access to the network through the use of local or remote attacks.
Management and Monitoring
Management, monitoring, and proper logging are critical to maintaining and analyzing IT environments. These tools are even more important after an attack has occurred and incident analysis is required.
Workstations
The security of individual workstations is a critical factor in the defense of any environment, especially when remote access is allowed. Workstations should have safeguards in place to resist common attacks.

Applications and
Importance to Security
Deployment and Use
When business-critical applications are deployed in production, the security and availability of those applications and hosting servers must be protected. Continued maintenance is essential to help ensure that security bugs are patched and that new vulnerabilities are not introduced into the environment.
Application Design
Design that does not properly address security mechanisms such as authentication, authorization, and data validation can allow attackers to exploit security vulnerabilities and thereby gain access to sensitive information.Secure application development methodologies are key to ensuring that in-house or contracted developed applications address security threat models that could leave an organization open to exploits.Integrity and confidentiality of data is one of the greatest concerns for any business. Data loss or theft can negatively impact organization revenue as well as its reputation. It is important to understand how applications handle business critical data and how that data is protected.

Operations and
Importance to Security
Environment
The security of an organization is dependent on the operational procedures, processes and guidelines that are applied to the environment. They enhance the security of an organization by including more than just technology defenses. Accurate environment documentation and guidelines are critical to the operation team's ability to govern, support and maintain the security of the environment.
Security Policy
Corporate security policy refers to the collection of individual policies and guidelines that exist to govern the secure and appropriate use of technology and processes within the organization. This area covers policies to address all types of security, such as user, system, and data.
Backup and Recovery
Data backup and recovery is essential to maintaining business continuity in the event of a disaster or hardware/software failure. Lack of appropriate backup and recovery procedures could lead to significant loss of data and productivity. Company reputation and brand could be at risk.
Patch and Update Management
Good management of patches and updates is important in helping secure an organization's IT environment. The timely application of patches and updates is necessary to help protect against known and exploitable vulnerabilities.

People and Importance to Security
Requirements and Assessments
Security requirements should be understood by all decision-makers so that both their technical and their business decisions enhance security rather than conflict with it. Regular assessments by a third party can help a company review, evaluate, and identify areas for improvement.
Policies and Procedures
Clear, practical procedures for managing relationships with vendors and partners can help protect the company from exposure to risk. Procedures covering employee hiring and termination can help protect the company from unscrupulous or disgruntled employees.
Training and Awareness
Employees should be trained and made aware of security policies and how security applies to their daily job activities so that they do not inadvertently expose the company to greater risks.

Photosynth

Download Photosynth for free

Imagine being able to view your photos in a three-dimensional space. Now you can with Photosynth.

What is Photosynth?
Imagine being able to share the places and things you love using the cinematic quality of a movie, the control of a video game, and the mind-blowing detail of the real world. With nothing more than a bunch of photos, Photosynth creates an amazing new experience.

Whether it’s a quiet creek in the woods of Pennsylvania, or the grandeur of the interior of St Paul’s cathedral, Photosynth puts you there like nothing else can.

It can capture the sweeping scale of a mile of the Grand Canal in Venice, and focus in on the exquisite rot at the waterline of a beautifully decaying palazzo doorway.

Want to share your amazing new room with your friends—after all what justice do a bunch of thumbnails do for a room that took you a month to decorate? Only a synth can capture every detail.

And it’s not just for spaces and places. Photosynth is an amazing way to share the full juicy details of the stuff in your life.
Go on, get synthing.
How does it work?
Photosynth is a potent mixture of two independent breakthroughs: the ability to reconstruct the scene or object from a bunch of flat photographs, and the technology to bring that experience to virtually anyone over the Internet.
Using techniques from the field of computer vision, Photosynth examines images for similarities to each other and uses that information to estimate the shape of the subject and the vantage point each photo was taken from. With this information, we recreate the space and use it as a canvas to display and navigate through the photos. Photosynth was inspired by the breakthrough research on Photo Tourism from the University of Washington and Microsoft Research. This work pioneered the use of photogrammetry to power a cinematic and immersive experience
Providing that experience requires viewing a LOT of data though—much more than you generally get at any one time by surfing someone’s photo album on the web. That’s where our Seadragon™ technology comes in: delivering just the pixels you need, exactly when you need them. It allows you to browse through dozens of 5, 10, or 100(!) megapixel photos effortlessly, without fiddling with a bunch of thumbnails and waiting around for everything to load.
More information on the history of Photosynth is available here.
About this Release
Photosynth comes from a passionate little startup of two dozen people in Microsoft Live Labs. We are scientists, engineers, and designers working like crazy to deliver on Photosynth’s promise.

What you see on this site is the first of many versions of Photosynth. Call it beta, call it 1.0, call it whatever you want… just know we are hard at work adding support for more browsers, more platforms, and more hardware, and just making the experience that much more amazing.
Where it will go from here will be shaped by your feedback. We can’t wait to hear from you.
Want to know even more?
Read the latest information about Photosynth in our blog. Get advice on making that one synth turn out perfectly in our community forum or get some help on our support site.

OTHERS

1.Inviting Others to Your Workspace

You can invite others to join your workspace at any time. When team members accept your invitation, they receive a copy of the workspace. You or another member of the workspace must be online for invitees to receive the workspace. E-mail invitees can receive the workspace only from you.

1. Open the workspace from the Launchbar.

2. In the Send Invitation pane, type the name of the person whom you want to invite in the To field. If you’ve worked with the person in Microsoft Office Groove 2007 before, his or her name appears automatically after you type the first few letters. If you do not see the person’s name, type his or her e-mail address. If you want to invite more than one person, click Add More.

3. Select a role for the invitees from the Role drop-down list.

4. Type an optional text message, and then click Invite.

1.Tell Your Friends Whether You're Busy or Free in Communicator

Microsoft Office Communicator 2007 has an automatic setting to display your availability. You can configure this by clicking Rules on the Options menu. By default, your status changes to Away when your computer is idle for five minutes. On the Options menu, you can also set this to a longer or shorter time.

One more tip: Communicator connects to Microsoft Office Outlook to get your calendar and out-of-office appointments, so you have to enter your appointment details only once. Mostly, this automation is helpful—but sometimes you definitely don't want to be interrupted, and other times you are free despite having an appointment on your calendar. To indicate such a situation, you can submit an additional note for others to read. To do this, click your name in Communicator, click Set Note, and then type your note. However, don't forget to reset your note when it is no longer applicable.

2.Drag-and-Drop Inviting

A quick way to invite multiple contacts or a folder of contacts to a workspace is to drag them from the Launchbar. Here’s how:

1. With a workspace open, open the Launchbar on top of it.

2. Use the CTRL key and your mouse to select multiple contacts, or select one or more folders of contacts.

3. Drag the contacts or folders on top of the Workspace Members area. A workspace invitation window appears, prepopulated with all the contacts.

3.Synchronization Suggestions—Download Settings

If you travel frequently, work from slow connections, or work with large files, you may not want all files in your Microsoft Office Groove workspaces to synchronize automatically. With download settings, you decide which files are synchronized and which you prefer to download manually.
Here’s how to choose your download settings:1. From the Files tool or Groove SharePoint Files tool, right-click any folder, click Properties, and then click the Download tab.2. Choose the download settings that you want.

1.Record Audio and Video Clips

With your computer’s internal microphone or an external microphone attached to your computer, or a webcam or its equivalent, you can record audio and video clips by using Microsoft Office OneNote. The audio will be linked to your typed or digitally handwritten notes, so you can easily jump to specific points in the recordings by clicking the relevant typed notes.
To record audio or video clips:

1. Attach the recording device to your computer (not necessary if you're using the internal microphone on your computer).

2. Click the page on which you want to create the recording.

3. On the Insert menu, click Audio Recording or Video Recording.

4. Start and stop the recording by using the Audio and Video Recording toolbar.

5. To play back the recording, double-click the Windows Media icon on the page where you made the recording. You can skip to certain points in the recording by clicking a word in your linked

text notes, and then clicking Play in the margin.

2.Attach Files to Pages of Notes in Your Notebook

You can drag or insert files onto a page in your notebook. The file appears as an icon, as in Windows Explorer, and Microsoft Office OneNote keeps track of the location of the original file (even if you move it around), so you can easily open it at any time.

1. Drag the file that you want to attach from Windows Explorer onto a OneNote page.

2. When you release the mouse button, you’ll see a dialog box. Select the Insert a copy of the file onto the page check box.3. To open the file, double-click the file icon.

3.Send Web Pages Directly to OneNote from Internet Explorer

With Microsoft Office OneNote 2007, you can conveniently send information from Windows Internet Explorer directly to your notebook. Here’s how:

1. Browse to a Web page in Internet Explorer.

2. On the Tools menu, click Send to OneNote.

3. Switch to OneNote, where the Web content will appear on a page in your Unfiled Notes section.

4. Drag the page to where you want it in your notebook.

4.Taking Mobile Notes

Microsoft Office OneNote 2007 provides two-way synchronization with Windows Mobile–powered Smartphones or Pocket PCs so that you can stay productive no matter where you are.
To synchronize Office OneNote 2007 with your mobile device:

1. Connect the device to your computer. Microsoft ActiveSync starts.

2. When prompted, download Microsoft Office OneNote Mobile to your device.

3. Take notes on your mobile device.

4. The next time you connect your mobile device to your computer and open OneNote, the notes you took will be copied to the OneNote Mobile Notes notebook in OneNote. Information you put in the Mobile Notes notebook will be viewable on your device.

5.Navigate Notebooks Easily

Microsoft Office OneNote 2007 has a new navigation pane that makes it easy to see and navigate within and among all of your notebooks.To show more detail about the notebooks and the sections they contain, expand the navigation pane by clicking the arrow at the top of the pane.To create more space on the screen, collapse the navigation pane by clicking the arrow at the top of the navigation pane.To jump to a different notebook, click the name of the notebook (or section) within the navigation pane.

1.Generate a PivotDiagram from Excel Data

In Microsoft Office Visio Professional 2007, you can now generate a PivotDiagram from data such as a Microsoft Office Excel worksheet. A PivotDiagram has very similar functionality to an Excel PivotTable, but it displays your data graphically.
To generate a Visio 2007 PivotDiagram, on the File menu, point to New, then point to Business, and then click PivotDiagram. Follow the wizard steps to select your data and generate your PivotDiagram page.
If your source data is in an Excel 2007 table, you can generate the page even more quickly from Excel. To do this, click in the Excel 2007 table and then, on the Table Tools Format tab, click Export, and then click Export Table to Visio PivotDiagram. After the diagram page is set up, click in the PivotDiagram pane to add categories or values to your diagram, and Visio automatically generates the shapes with applicable data.

2.Use Shape Operations to Customize Shapes

You can split a shape into multiple shapes, cut pieces out of a shape, or merge multiple shapes into one. To customize shapes, first select the shapes on which you want to act. On the Shapes menu, point to Operations, and then click the operation you want from the available options. For example, to draw horizontal lines completely through a triangle, select the triangle and all lines, and then click Fragment on the Operations menu to create a custom pyramid diagram in no time. In this example, the fragment operation uses the lines to split the triangle and does not retain the lines.

1.Derive a Strategic Value Score for Projects

You can use the intuitive Prioritization Wizard in Portfolio Optimizer to derive a strategic value score for projects. Here’s how:

1. In the Builder Scorecard, select an organization, and then in the main navigation bar, click Optimizer.

2. Click the Analyze link to open the Open Dialog page in the Prioritization Wizard.

3. Select a completed pair-wise comparison matrix and impact matrix, and then start the Prioritization Wizard.

4. Click the button to automatically derive the business driver priorities.

5. Click the button to open the project to business driver impact matrix.6. Click the button to automatically derive a strategic value score for each project.

2.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.

1.Save Time Editing Lists

To add content to a Microsoft SharePoint list, especially if it involves more than one item (for example, when you're creating a contact list), rather than adding each item at a time, you can copy in bulk.

1. Click Edit under Datasheet View on the bar at the top of the list.

2. Type in items or copy them from an existing Microsoft Office Excel spreadsheet.

3. Click Save, and then click Close.

2.Access SharePoint Documents Offline

You can read your Microsoft SharePoint documents in Microsoft Office Outlook. Click Doc Library, click Actions, and then click Connect to Outlook. All the contents of your chosen document library will then be synchronized to a folder in Outlook.

MICROSOFT OFFICE - GENERAL

1.Customize Your Quick Access Toolbar

In each 2007 Microsoft Office system program where you see the Ribbon (Word, Excel, PowerPoint, Access, and parts of Outlook), you also see a Quick Access Toolbar, which appears by default above the Ribbon, beside the Office button. To add the commands you use most to the Quick Access Toolbar in each program, right-click a command on the Ribbon, and then click Add to Quick Access Toolbar. You can also click the arrow that appears at the right edge of the Quick Access Toolbar, and then click More Commands to open the Customize tab of the Options dialog box for the program you are using. In this box you can add commands that don’t appear on the Ribbon, or create a custom Quick Access Toolbar for an individual document or template.

2.Customize Which Commands Appear on the Status Bar

The Status bar is the bar that appears across the bottom of the screen in many programs and provides information about the active file. For example, the Status bar in Microsoft Office Word provides information such as active page number, number of pages in the document, and word count.
In most cases, you can also click the Status bar option for more information or to perform an action. For example, click Page in the lower-left corner of Word to access the Go To tab of the Find and Replace dialog box.
In several of the 2007 Microsoft Office system programs, including Word, Excel, PowerPoint, and Access, you can customize what appears on the Status bar. To do this, right-click the Status bar, and then click to show or hide the options you want.

3.Keep Important Documents Handy at All Times

When you click the Office button in the 2007 Microsoft Office system programs Word, Excel, or PowerPoint, you see a Recent Documents list, similar to that which appeared on the File menu in previous releases. However, in the 2007 release, you now see a pushpin icon next to each file name. Click that icon to pin the applicable document to the Recent Documents list so that it’s always accessible at a click. When you click the pushpin icon, it changes in appearance to show that the pin has been activated for that document.
Also note that you can change the number of recent documents that appear in the list. To do this, click the Office button, then click [Program] Options (for example, Word Options), and then click Advanced. Scroll down to the Display section, where you’ll see the option to change the number of recent documents displayed.

OFFICE 2003 Versus 2007

1.2003 to 2007 Mark as Final

To make a Microsoft Office Word 2003 document read-only, you need to close the file, right-click it in Windows Explorer, click Properties, and then select the Read-only check box. If it's a Microsoft Office Word 2007 document, you can save yourself the trouble and change the document to read-only from within the program.

1. Click the Office button, and then point to Prepare.

2. Click Mark as Final. Not only is the document now read-only, but the editing commands on the Ribbon are unavailable. To enable editing again, follow the same steps to turn the Mark as Final feature off.

2.2003 to 2007 Document Information Panel

When you pause your mouse on your document in Windows Explorer, does it list the author as someone you worked with five years ago? If you started with an existing document, the document property information is probably out of date. With Microsoft Office 2003 documents, most people don't take the time to right-click the file in Windows Explorer, click Properties, and then edit the document information. With the Document Information Panel in Microsoft Office Enterprise 2007 and Office Professional Plus 2007, you can edit document properties directly in the program.
1. Click the Office button, and then click Prepare.

2. Click Properties. The Document Information Panel appears below the Ribbon.3. Enter the appropriate information and save the document.
Keep in mind, search engines like the ones included in Windows Vista and Microsoft Office SharePoint Server 2007 use document properties to deliver search results that are more relevant. So if you want to make something easier to find, make sure your document properties are up to date.

3.2003 to 2007 Tri-Pane Review

In Microsoft Office Word 2003, you can use the Compare Side-by-Side command to display two documents next to each other so that you can compare them. However, this is only a view and doesn't indicate actual changes to the document. The Compare and Merge command shows document changes but automatically merges the two together, regardless of whether or not you're ready.

In Microsoft Office Word 2007, a side-by-side view is still available if you want it, but the Compare feature now offers a tri-pane review: the original document in one pane, the revised document in another pane, and a combined version of the document with changes marked in a third pane. The tri-pane view shows document changes even if the other person forgot to turn on the Track Changes feature. If you want to keep the combined document, you can simply save it as a separate file.

To use tri-pane review:1. Click the Review tab, and then click Compare in the Compare section.2. Click Compare, and then select the original and revised documents that you want to view.

4.2003 to 2007 Page Layout Tab

It’s not always easy to make page-level changes to your Microsoft Office Word 2003 document. Every time you want to adjust the margin or change the page layout, you have to browse to Page Setup on the File menu and make your changes in a dialog box that has multiple tabs.
In Microsoft Office Word 2007, you can make many of these changes from the Page Layout tab on the Ribbon. For example, if you want a slimmer margin, click the Margins button, and then click Narrow. If you're printing on legal paper, click the Size button, and then click Legal. With many of the options, like Margins, you see a live preview of your change before you apply it. If you need greater customization, click the diagonal arrow in the lower right of the Page Setup section to open the familiar dialog box.

5.2003 to 2007 Categories and Tasks

In Microsoft Office Outlook 2003, you can use colored quick flags to flag e-mail messages for follow-up based on their relation to each other. For example, you can use blue flags for action items related to an upcoming sales meeting, yellow flags for personal items, and red flags for urgent issues. However, these flags are visual cues only; they do not automatically create an Outlook task that you can track and manage.
In Microsoft Office Outlook 2007, colored quick flags are broken out into Colored Categories and Flags. If you need to visually group related items together, you can assign a color category. If you need to act on something, you can assign a flag. When you flag a message in Outlook 2007, it's automatically added to your Outlook task list, your calendar, and the To-Do Bar (which shows your upcoming appointments and tasks for the day). You can assign categories and flags by right-clicking the appropriate icon in your Inbox, or by opening the e-mail message and clicking the commands on the Ribbon.

WINDOWS - SHORTCUTS

WINDOWS SHORTCUT KEYS

Alt + Esc Switch Between open applications on taskbar.

F2 Renames selected Icon.

Ctrl + F4 Closes Window in Program.

Ctrl + Space bar Drops down the window control menu.

WINKEY + Pause / Break key Open the system properties window.

Windows system key combinations
· F1: Help
· CTRL+ESC: Open Start menu
· ALT+TAB: Switch between open programs
· ALT+F4: Quit program
· SHIFT+DELETE: Delete item permanently

Windows program key combinations
· CTRL+C: Copy
· CTRL+X: Cut
· CTRL+V: Paste
· CTRL+Z: Undo
· CTRL+B: Bold
· CTRL+U: Underline
· CTRL+I: Italic

Mouse click/keyboard modifier combinations for shell objects
· SHIFT+right click: Displays a shortcut menu containing alternative commands
· SHIFT+double click: Runs the alternate default command (the second item on the menu)
· ALT+double click: Displays properties
· SHIFT+DELETE: Deletes an item immediately without placing it in the Recycle Bin

General keyboard-only commands
· F1: Starts Windows Help
· F10: Activates menu bar options
· SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
· CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item)
· CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
· ALT+DOWN ARROW: Opens a drop-down list box
· ALT+TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
· SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
· ALT+SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
· ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
· CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
· ALT+underlined letter in menu: Opens the menu
· ALT+F4: Closes the current window
· CTRL+F4: Closes the current Multiple Document Interface (MDI) window
· ALT+F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed, ALT+F6 switches between the Find dialog box and the main Notepad window)

Shell objects and general folder/Windows Explorer shortcuts
For a selected object:
· F2: Rename object
· F3: Find all files
· CTRL+X: Cut
· CTRL+C: Copy
· CTRL+V: Paste
· SHIFT+DELETE: Delete selection immediately, without moving the item to the Recycle Bin
· ALT+ENTER: Open the properties for the selected object
To copy a file
Press and hold down the CTRL key while you drag the file to another folder.
To create a shortcut
Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.

General folder/shortcut control
· F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
· F5: Refreshes the current window.
· F6: Moves among panes in Windows Explorer
· CTRL+G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
· CTRL+Z: Undo the last command
· CTRL+A: Select all the items in the current window
· BACKSPACE: Switch to the parent folder
· SHIFT+click+Close button: For folders, close the current folder plus all parent folders

Windows Explorer tree control
· Numeric Keypad *: Expands everything under the current selection
· Numeric Keypad +: Expands the current selection
· Numeric Keypad -: Collapses the current selection.
· RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
· LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent

Properties control
· CTRL+TAB/CTRL+SHIFT+TAB: Move through the property tabs

Accessibility shortcuts
· Press SHIFT five times: Toggles StickyKeys on and off
· Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
· Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
· Left ALT+left SHIFT+NUM LOCK: Toggles MouseKeys on and off
· Left ALT+left SHIFT+PRINT SCREEN: Toggles high contrast on and off

Microsoft Natural Keyboard keys
· Windows Logo: Start menu
· Windows Logo+R: Run dialog box
· Windows Logo+M: Minimize all
· SHIFT+Windows Logo+M: Undo minimize all
· Windows Logo+F1: Help
· Windows Logo+E: Windows Explorer
· Windows Logo+F: Find files or folders
· Windows Logo+D: Minimizes all open windows and displays the desktop
· CTRL+Windows Logo+F: Find computer
· CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
· Windows Logo+TAB: Cycle through taskbar buttons
· Windows Logo+Break: System Properties dialog box
· Application key: Displays a shortcut menu for the selected item

Microsoft Natural Keyboard with IntelliType software installed
· Windows Logo+L: Log off Windows
· Windows Logo+P: Starts Print Manager
· Windows Logo+C: Opens Control Panel
· Windows Logo+V: Starts Clipboard
· Windows Logo+K: Opens Keyboard Properties dialog box
· Windows Logo+I: Opens Mouse Properties dialog box
· Windows Logo+A: Starts Accessibility Options (if installed)
· Windows Logo+SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
· Windows Logo+S: Toggles CAPS LOCK on and off

Dialog box keyboard commands
· TAB: Move to the next control in the dialog box
· SHIFT+TAB: Move to the previous control in the dialog box
· SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
· ENTER: Equivalent to clicking the selected button (the button with the outline)
· ESC: Equivalent to clicking the Cancel button
· ALT+underlined letter in dialog box item: Move to the corresponding item

DOWNLOADS

Play Bubble Town online or download a free deluxe trial

Check out Bubble Town: One shot and you'll be hooked on this arcade puzzler.

Bubble Town Game Overview
Save Borb Bay from disaster!Just one shot, and you’ll be hooked on this arcade-puzzler. Use the cannon to fire Borbs to match three or more in order to remove them from the board. Be careful where you aim because wasted shots clutter the board, and if the Borbs reach the yellow danger zone, the game is over. With two modes of play (Straight-Up and Ball), you’ll find challenge and excitement with every shot.
1. Straight-Up PlayLine up the cannon to shoot the different Borbs until you make three (or more) of a kind. Use the sides to make tricky bank shots to score extra points. Knock out all Borbs before any reach the yellow danger zone!
2. Ball PlayUp for a challenge? Try pick off three or more matching Borbs using the cannon. However with every shot, the game board rotates, so pick your shots with care. Knock off every Borbs before they reach the danger zone!
3. Power Up Your PlayCollect powerups by freeing them from the game board. Powerups allow your cannon different abilities, like firing targeted shots or fires shots that changes the color of Borbs. Use them wisely, and you can clear a lot of Borbs in one shot.
4.Ready to play? Select a mode of play above to get started.

Visual Studio Gallery

Find products and extensions that work with Visual Studio.

Download Windows Media Player 11
Windows Media Player 11 for Windows XP offers great new ways to store and enjoy all your music, video, pictures, and recorded TV.

Overview
Windows Media Player 11 offers great new ways to store and enjoy all of your digital media. It's easier than ever to access all of your music, video, pictures, and recorded TV on your computer. Play it, view it, organize it, and sync it to a portable device for enjoying on the go, or share with devices around your home - all from one place. Windows Media Player 11 is designed to work with all editions of Windows XP Service Pack 2 (SP2), and can also be used to restore Windows Media Player and related technologies to N and KN editions of Windows Vista. PLEASE NOTE: Many of the great stores you know in Windows Media Player 10 are available in this version of the Player. Check out a list of online stores at the Online Stores page.

System Requirements

Supported Operating Systems: Windows Vista Business N; Windows Vista Home Basic N; Windows XP Home Edition N; Windows XP Media Center Edition; Windows XP Professional N; Windows XP Service Pack 2; Windows XP Tablet PC Edition.

Instructions

This download is available to customers running genuine Microsoft Windows. Click the Continue button in the Validation Required section above to begin the short validation process. Once validated, you will be returned to this page with specific instructions for obtaining the download.

Windows Live Messenger for free

Chat, play, and share from the Web, your PC, and your mobile phone.

Instantly In Touch
Connect to your favorite people or groups so you can exchange IM messages in a flash. There are lots of fun ways to personalize Messenger to reflect the real you! It’s the perfect way to chat, play games, or share photos instantly.Download now
Works great with:
Hotmail
Hotmail
Stay in touch with Web-based e-mail.Learn more
Mobile
Mobile
Use your Hotmail, Messenger, and Windows Live Spaces accounts on the go.Learn more
Mail

Read and reply to multiple e-mail accounts in one place.

Internet Explorer

See how we help you search smarter, work faster, and browse more safely-all within a familiar environment. Download Windows Internet Explorer 8, Microsoft Silverlight, and MSN Toolbar all in one click.

Overview
Internet Explorer 8 is the latest version of the familiar web browser you are most comfortable using, helping you get everything you want from the web faster, easier, more privately and securely than ever before.
Faster Internet Explorer 8 is more responsive with new pages and tabs, opening up fast and reliably. You can now get to the information you care about most, in fewer steps; one click access to your webmail, favorite news sites or other online services.
Easier Reduce the steps to accomplish many common tasks, and automate your access to real time information updates. You can keep track of your favorite sports team, news, weather with a single click.
More Private Helps protect your privacy and confidential information where ever you go on the web.
More Secure Helps protect and stop malicious software from reaching your PC, and makes it easier to detect when a website is an imposter.

OUTLOOK EXPRESS

1.Color-Code Meetings

You can use color codes in Microsoft Office Outlook to highlight key diary dates and additional activities, such as traveling. When you create a new appointment in the Outlook calendar, you can categorize it as an internal or external meeting so that you can easily see when you need to leave the office. On the Appointment tab, in the Options section, click Categorize, choose a color category, and rename it with a suitable label (like Needs Preparation or Travel Required).

For meetings already in your calendar:

1. Right-click, click Categorize, choose the color you want to use, and rename it with a suitable label. To rename all the color categories, right-click, click Categorize, and then click All Categories; or, in the Calendar view, click Edit, click Categorize, and then click All Categories.

2. Choose one of the existing color categories and rename it.

You can automatically color all appointments that meet a condition, much like setting up a message rule.

1. Click Edit, click Automatic Formatting, and then click Add.

2. Give the rule a name, choose a color, and then click Condition to choose which appointments will be color-coded.

2.Get the Right People in a Meeting from the Start

You can clearly indicate in a meeting request who is required for a meeting and who is only optional.

1. In the meeting request, click Invite Attendees and add all relevant names (including the conference room if applicable).

2. After the names have been resolved, click Scheduling.

3. For each name, determine Required or Optional status by clicking the small red arrow next to each name.

4. Indicate the conference room as a resource (and it will be automatically added as the meeting location).Also be sure to include the meeting agenda in the invitation, rather than in a separate e-mail message.

3.Choose a Signature for Different Recipients in Microsoft Office Outlook 2007

If you want to use a different e-mail signature for different recipients (a different one for coworkers than for customers, for example), you can change your signature with two mouse clicks. Right-click your signature, and then click the other signature that you want to use.

4.Dragging Your Files to Outlook

When you select a file and drag it to Microsoft Office Outlook, the action that Outlook takes depends on which folder you place the file in. If you drag the file to the Tasks folder, Outlook will create a new task with your file attached. If you drag it to the Calendar folder, Outlook will create an appointment where you placed the file, and your file will be attached. If you drag it to the Mail folder, Outlook will create a new e-mail message with your file as an attachment.

5.Using the To-Do Bar

You can organize your daily activities by using the new To-Do Bar in Microsoft Office Outlook. The To-Do Bar, located on the right side of your Outlook Inbox, brings together tasks, calendar information, and e-mail messages flagged for follow-up into one view. Now you don’t need to switch back and forth between your Inbox, diary, and task list.

6.See Tasks in the Calendar

In Microsoft Office Outlook, you can link tasks to calendar days to increase your productivity and provide a record of when tasks were completed. If you complete them on the designated day, they're linked to that day to show a record of your work completed. If not, tasks roll over to the next day and continue to accumulate until completed. You can see a list of current tasks displayed below a specific day on the calendar. You can add your tasks to the list on any day you choose.

7.Avoid Constant Interruptions for Quiet Work Time

How many interruptions do you get every day? It's nearly impossible to complete anything when you allow constant interruptions from the phone, people stopping by your office, and instant messaging.
In Microsoft Office Outlook, you can book yourself a recurring appointment for an hour a day to process e-mail, and mark the time as Busy. During this time, don't answer the phone or permit interruptions, and work only on dealing with your Inbox.
At first, keeping these appointments will take discipline. But over time, it will become a habit. And after you get to zero e-mail in your Inbox, you'll see the value of this one hour a day and stick to it.

8.Rearrange the Outlook Window for Smaller Screens

You can create plenty of room on the screen in Microsoft Office Outlook 2007, even with all of the new views in Outlook. Here's how:1. Click the chevrons at the top of the folder pane and the To-Do Bar. This will give you a clear view with summary bars for the folders on the left and for the To-Do Bar on the right.2. Click Navigation Pane on the summary bar at left to get a pop-out view of the full navigation pane.3. Click To-Do Bar on the summary bar at right for a similar pop-out. The resulting view has plenty of room for e-mail messages and the preview pane, even on a small laptop screen.

9.Categorizing Calendar Appointments

By using the Automatic Formatting feature in your Microsoft Office Outlook calendar, you can highlight different types of appointments by using different colors.

1. Right-click an appointment, and then click Automatic Formatting.

2. Use the Rules Wizard to display that meeting or person's name in the color of your choice.
If you repeat this procedure for other types of appointments, you can build different categories within your Outlook calendar for easy recognition—for example, weekly team meetings, customer visits, and personal appointments.

10.Finding E-Mail Messages Quickly

You can search for a specific e-mail message in Microsoft Office Outlook without expanding the Search box. Here’s what to do:
In the Outlook Search box, type your target. For example, to find a particular e-mail message from John Smith, type from:John Smith. This search request quickly lists e-mail messages from that person, but not messages that contain his name.
This tip also works for other criteria, such as folders. For example, searching for folder:expenses quickly lists only those folders that contain "expenses" as the subject.

11.Creating a Meeting Request by Using Fewer Clicks

You can quickly create a meeting request with one or more attendees by using the New Meeting Request With feature in Microsoft Office Outlook 2007. Here’s how:While viewing one or more colleagues' calendars, right-click the desired time, click New Meeting Request With, and then select the recipients.

12.Delete a Meeting Without Notifying Invitees

If you have set up a meeting, and your attendees have declined to come, it's obviously an irritation for them to then receive an e-mail message confirming the cancellation of the meeting. Instead, you can delete the meeting without sending a notification.

1. Right-click the meeting, and then click Delete.

2. In the notification e-mail message, delete all the addresses from the To field, and type your own e-mail address instead.

3. Click Send.

13.Manage Meeting Resources

Here’s how Microsoft Office Outlook can help you schedule resources and plan meetings within a group.
1. Create a group schedule.a. Go to Calendar view in Outlook, and on the Actions tab, click View Group Schedules.b. In the Group Schedules dialog box, click New, and then type the name of your schedule.c. Click OK.
2. Add all the resources you need to the Group Members column (for example, all the conference rooms in your building). You will see the free/busy information for all the resources in one view. You can use the same technique to book other resources, like audio/video equipment.
3. Plan your meeting.a. By using the Group Schedule view, find the appropriate resources that are free for your time slot.b. Click the Make Meeting button, and then click New Meeting as Resource.
4. A meeting request form appears, prefilled with the time booking information and the resource allocation. Just fill in the rest of the meeting details, and then click Send. The resources you requested will be booked automatically for you.

14.Easier Access to Centralized Calendars

1. Connect team members’ calendars via Microsoft Office SharePoint Server 2007. Browse your team calendar within your company's SharePoint portal and select a detailed view of it from Select a View.2. Click the Link to Outlook button to integrate your team calendar into Microsoft Office Outlook 2007. Your team appointments will be displayed within your personal calendar—with additional direct access to edit the central SharePoint calendar from Outlook.

ACCESS - DATA BASE

1.Creating Forms To assist with data entry,

Microsoft Office Access 2007 offers different types of forms. To create a simple form:

1. Open the table that has the fields you want to include in your form.

2. On the Ribbon, on the Create tab, click Form.

The split form is new to Office Access 2007, and it enables you to see both a datasheet view of your data and a traditional form view of your data at the same time. You can use the splitter bar to adjust the size of the datasheet.

WINDOWS VISTA

1.Getting Help

As a reminder of how easy it is to access Help in Windows Vista, just look at every Explorer window. You can click the question mark to get the latest online assistance. Help is contextual, so wherever you are, it will give information on that topic.

2.Windows Update

Windows Vista tracks your system and can be configured to automatically install important updates at a time that is convenient for you.1. Click Start, and then click Control Panel.2. Under Security, click Check for updates.3. Click Change Settings in the left navigation pane.4. Enter your desired configuration.

3.Windows Mail

Windows Vista includes a program that can provide you with communications and e-mail access. Although not as comprehensive as many e-mail and communication software packages, it does offer basic management capabilities.
Here’s how to access Windows Mail:

1. Click Start.

2. Click All Programs.

3. Click Windows Mail.

4.Windows Sidebar

Windows Sidebar is a desktop tool that provides a number of small gadgets (minimal-resource applications) that you can access quickly. To turn on Windows Sidebar:

1. Click Start.

2. Type sidebar in the Quick Search box.

3. Click Windows Sidebar.
You can customize the sidebar by adding more gadgets and configuring how the sidebar is displayed.

5.Command Prompt

You can run your programs via the command prompt as follows:

1. Click Start.

2. Type command in the Quick Search box.

3. Click Command prompt.
Alternately, you can simply type the program name in the Quick Search box, and use any parameters that may be required.

POWER POINT

1.Fine-Tuning Objects in Presentations

When working with text in Microsoft Office PowerPoint, you can use the F2 key to switch between selecting text in a placeholder and selecting the placeholder itself. So the next time you've edited some text and want to reposition it on the slide, instead of clicking the tiny edges of the box, just press F2. The entire text box will instantly be selected for you, ready for alignment.

2.Use Search to Find E-Mail Messages

In Microsoft Office Outlook, e-mail search helps you locate messages by keyword or phrase. You can also use search folders to find mail by type of message.
To locate specific keywords or phrases within e-mail messages:Type a word or phrase in the Search box at the top of your Outlook Inbox. The search starts automatically as soon as you stop typing. Search results will appear in the main window of your Inbox. To return to your normal Inbox, click Clear Search (the green ×) to the right of the Search box.
You can enable search folders from the mail pane on the left of your Inbox. To expand the folders tree, click Search Folders. Outlook comes with three default search folders: For Follow Up, Large Mail, and Unread Mail.
To add new search folders, click File, point to New, and then click Search Folder.
To build a custom search folder:1. Click Search Folder, and then either click a predefined folder name, or scroll down and click Create a custom Search Folder.2. Click Choose, give the new folder a name, and then click Criteria to fill in the search terms.

3.Add More Levels of Undo

You can go back farther in Microsoft Office PowerPoint to undo actions.

1. With PowerPoint open, click the Office button, and then click PowerPoint Options.

2. On the Advanced tab, change the Maximum number of undos from the default 20 to any number from 3 to 150.

4.Save PowerPoint Picture to Picture Files

To save a picture from a Microsoft Office PowerPoint 2007 presentation in any popular picture format:Right-click the image, click Save as, and then click Picture.

5.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.

6.Use Your Own Pictures in SmartArt

You can insert your own pictures into Microsoft SmartArt graphics in your presentation.

1. Click the Insert tab on the Ribbon, click SmartArt, and then click the SmartArt graphic that you want to insert.

2. Select the picture that you want to add to your presentation.

3. Right-click an individual shape in SmartArt, and then click Paste to insert the picture you selected.

4. Repeat steps 2 and 3 for each shape.

5. Complete your presentation by applying your preferred background design.

WORD

1.Create Tables to Your Own Specifications

Want to add a table with specific dimensions to your Word document? Here’s how:

1. Position the cursor on the area of the document where you want to insert your table.

2. On the Insert tab of the Ribbon, click Table, and then click Draw Table.

3. Define the table size. Right-click to select the area where you want the table to appear.

4. Use the mouse to draw the internal table lines the way you want them. To erase any lines you've drawn by mistake, press the SHIFT key, and the pointer will change from a pencil to an eraser.

Note: The design tools in Microsoft Office Word 2007 give you plenty more features—for example, the ability to create other tables within those you've already designed.

2.Reuse Tables in Word To save a table in Microsoft Office Word for reuse in the future:

1. Select the table that you want to save.

2. On the Insert tab of the Ribbon, click Table, point to Quick Tables, and then click Save Selection to Quick Tables Gallery.

3. In the Create New Building Block dialog box, give the table a name, classify it with some basic parameters, and then click OK.

To reuse a saved table:

1. Position your cursor where you want to insert a saved table.

2. On the Ribbon, click Insert, click Table, and then point to Quick Tables.

3. From the list, click the table you saved previously. This table will now be inserted into the document.

3.Pre-define the Format for Pasting in Word 2007

In a Microsoft Office Word 2003 document, each time you paste some text or an image, you can select the format (source formatting, destination formatting, or text only) by clicking the clipboard icon. In Microsoft Office Word 2007 and Microsoft Office Outlook 2007, you can still do this manually or, more conveniently, set the default paste formatting mode.

Here’s how:Go to Advanced Options or click the Set Default Paste option when the clipboard icon appears, and then set your preferences. The pasted text and images will now be formatted automatically according to your settings.

4.Rearrange Paragraphs in Word

Swapping paragraphs in Microsoft Office Word can be complicated. As well as having to cut and paste, you often have to reformat line breaks afterward to make the paragraph line up properly. Instead, you can use the SHIFT+ALT keyboard shortcut.Click the paragraph that you want to move, hold down SHIFT+ALT, and move the paragraph up or down by using the arrow keys. Each press of an arrow key causes your selected paragraph to jump over one adjacent paragraph.

5.Line Breaks Without Bullets

When you're creating a bulleted or numbered list in Microsoft Office Word or Microsoft Office PowerPoint, you might want an item to appear in the list without a bullet or without incrementing the number. You can start a new line without a bullet by pressing SHIFT+ENTER. The next time you press the ENTER key, the new line will continue the bulleted or numbered list.

6.Get More Information from the Microsoft Office Word Ruler

You can get helpful layout information from the ruler in Microsoft Office Word.

1. On one of the rulers (horizontal or vertical), click a tab or margin marker and hold down the left mouse button.

2. Now click the right mouse button. Hold both buttons down. The normal ruler measurements disappear, and instead you can see distance measurements that help you lay out your document.

7.Change the Microsoft Office Word Smart Quote Auto-correct Setting

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.

EXCEL

1.Changing the Color of Excel Comments In Microsoft Office Excel,

Comments appear in little yellow boxes by default. Here’s how you can change the color of a comment:

1. Right-click its border, and then click Format Comment from the shortcut menu.

2. On the Colors and Lines tab, choose a color from the Color list.

Changing the default color for comments is a little more involved; here’s how to do it:

1. Right-click any blank area of your Windows desktop, and then click Properties from the shortcut menu.

2. Click the Appearance tab, and then click the Advanced button.

3. Select ToolTip from the Item list.

4. Click the arrow next to the Color box, and then choose a color for your comments.

5. Click OK.

2.Copying a Worksheet

Here’s how to copy a worksheet to another place in your Excel workbook:1. Click the tab of the worksheet that you want to copy.2. Leave your mouse pointer on the tab.3. Press and hold down the CTRL key.4. Press and hold down your left mouse button and drag the worksheet that you want to copy to the left or right. Watch for the little black arrowhead that follows your mouse pointer as you drag left or right.5. When you release the mouse button, Microsoft Office Excel inserts a copy of the worksheet where the arrowhead is pointing.

3.Zooming to Fit a Selection

1. Select the range of cells that you want to focus on.

2. Click the View tab, and then click Zoom to Selection.

4.Create Random Numbers

Sometimes it's useful to have random numbers in a Microsoft Office Excel spreadsheet—even if it's just for creating test data. To put a random number in a cell, type the formula =RAND(). For bulk random numbering, copy that formula to a large number of cells—each will be random.

5.Enter a Fraction in a Cell

Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.

6.Step Through Formulas

When you're writing complex formulas, a slight difference in brackets, for example, can entirely change the result of the calculation of a formula. Microsoft Office Excel adheres to the standard order of precedence for calculations, with percentages, exponents, multiplication, and division performed in that order before finally calculating addition and subtraction. For example, 7+5*3 = 22, because the 5*3 is calculated first. (7+5)*3 = 36, because the parentheses force the addition to be completed first.
If you're unsure how Excel is evaluating a formula:1. Click the cell, click the Formulas ribbon, and then click Evaluate Formula in the Formula Auditing section.2. Click the Evaluate button to watch as each part of the formula is successively calculated, ensuring that each step of the calculation is valid.

7.Paste into Non-sequential Cells in Excel

You can use the CTRL key for multiple selections. Sometimes, you want to copy a formula or piece of data into a series of non-sequential cells in Microsoft Office Excel. You can do this quickly without having to paste into each cell individually.

1. Copy the data from the source cell.

2. Hold down the CTRL key as you click to select each destination cell.

3. After all the cells are highlighted, paste the data by pressing CTRL+V. You have to paste only once.

Similarly, you can type data into a series of cells simultaneously.

1. While holding down the CTRL key, click all the cells that you want to type the same text (or value) into.

2. Type the entry, and then press CTRL+ENTER. The text will be added to all the selected cells.

8.Creating a Watermark in Excel

To add a watermark at the top of your Microsoft Office Excel worksheet:

1. In your Excel file, click Insert, and then in the Text section, click Header & Footer.

2. With your pointer in the center section of the header, click Picture in the Header & Footer Elements section of the Design tab, browse your hard disk drive to find the picture you want, and then click OK.

3. You may need to press ENTER several times to center the watermark on the page.

9.Organize Colored Cells More Efficiently

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.

10.Working with Large Formulas

With previous releases of Microsoft Office Excel, working within the formula bar at the top of the worksheet can be cumbersome, because although the formula bar expands when necessary, it often overlaps the sheet itself. To get around this in the 2007 Microsoft Office system, pause on the bottom of the formula bar, and then drag it to adjust it to any size you need. This adjustment gives you a larger working area and makes it easier to navigate a document sheet that has large formulas.

11.Showing Formulas in Microsoft Office Excel Instead of Their Results

Sometimes in an Excel worksheet you want to display formulas instead of their results. Here’s how:1. Click the Office button, and then click Excel Options at the bottom of the menu.

2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.

12.Copy Data from a Table in a Web Page to Excel

If you see a data table on a Web page and you want to import it into Microsoft Office Excel:

1. Copy the URL (address) of the page.

2. In Excel, on the Data tab, in the Get External Data section, click From Web.

3. In the New Web Query dialog box, paste the URL into the Address box.

4. Select the table that contains the data you want to work with, and then click Import.

5. In the Import Data dialog box, indicate where you want the data to appear, and then click OK.

13.Turn Multiple Hyperlinks into Text in Microsoft Office Excel

1. Select the cell or group of cells that contain hyperlinks, right-click, and then click Copy.2. Select the cells where you want your text to go (this might be the same selection as in step 1).3. Right-click, and then click Paste Special.4. In the Paste section, click the option that you want applied to the text (such as Values or Comments), and then click OK.