Microsoft Office Help

Steal the Ultimate edition of Microsoft office at “The Ultimate Steal”

2009-12-17T02:24:00.000-08:00

For college students who want to enjoy the advanced features in Microsoft Office 2007, but cannot afford to pay Microsoft a fortune, the software giant is giving them an easier option “Steal it”. Now, most of you would be amazed if Microsoft is encouraging piracy? Well, actually Microsoft has introduces a promotional offer for the students names as The Ultimate Steal, which allows college students to buy Microsoft Office 2007 Ultimate edition for a mere price of $59.95.

The retail market price for this is whooping $680. The other editions which are offered to students at a discounted price are

• Microsoft Office Visio Professional 2007 [$55.95]
• Windows Vista Ultimate upgrade [$64.95]
• Microsoft Office Language Packs [$9.95]

Microsoft Office Ultimate 2007 comes as a complete package with all the mainstream programs such as Word, PowerPoint, Excel, Office Outlook, Publisher, Access and Accounting Express 2008. This promotional offer started on 30th April 2008 and covered countries like Canada, United States, United Kingdom, France, Italy and Spain etc. Microsoft Officials are glad and announced that they take care of students who often require MS office for their studies but need more flexible ways to get it. The company has tried the pilot program in Australia before introducing the Microsoft Office Ultimate Steal in United States.

Microsoft has also faced much criticism that always comes along with good offers. Many school students who could not avail this offer claimed that by college it will be too late and Microsoft should open it for high school students as well. Some critics said that the high-end programs and applications that are available along with the ultimate edition are mostly of no use to students. All they need is Word, excel and PowerPoint. Microsoft should come up with some flexible offer in which students need to pay for only what they need.

In spite of the minor criticism, the overall launch of Microsoft Office Ultimate Steal was a grand success. The process to avail this offer is simple as well. All you need to do to meet the eligibility criteria is to have a valid e-mail address from an educational institution that ends with “.edu” or your educational institute should be listed in select institution. The eligibility criteria as posted in Microsoft’s Website –

1. You should have a valid e-mail address from an educational institution that ends with the domain suffix i.e. “.EDU”. For example Johj@oxford.edu. OR should have a valid e-mail address at one of the educational institutions listed here.

You must be a student at a U.S. educational institution and must be actively enrolled in at least 0.5 course credit and be able to provide proof of enrollment upon request

Windows 7 with full 64-bit support

2009-11-01T21:53:00.000-08:00

Microsoft’s upcoming Windows 7 with 64-bit version runs beautifully with 4GB of RAM, enabling you to manage tons of applications with zero slowdown. This new version of Windows 7 also makes your system more futureproof, allowing you to take your system to 8GB, 32GB or even a terabyte, before too long.64 bit

However, hardware is the biggest issue. You cannot work with your 64-bit OS, if a gadget doesn’t have 64-bit drivers, as 32-bit drivers aren’t supported.

There are some software problems too. For example, sometimes Google’s Chrome may not operate efficiently with Windows 7 64-bit. Although Adobe Flash doesn’t run with 64-bit browsers, it can be operated with the regular 32-bit browser.

Using a 64 bit OS for a 64 bit processer can address far more than 4GB of memory, which is suitable for avid gamers, CAD, video editors and huge multi-taskers. While any 32 bit software will still be restricted to 4GB memory, a 64 bit CPU, OS and applications will take full advantage of the additional RAM.

However, if you possess a 64 bit capable CPU but use older hardware, then staying with a 32 bit version for the time being will be safer to ensure that you don’t require extra upgrades.

But if you have the latest hardware and drivers, it may be beneficial to step up to a 64 bit OS. For a user working regularly with 64 bit optimised resource hungry applications – like video editing, CAD and image packages – it would be especially advantageous to be able to work with more than 4GB of RAM along with the other improvements.

64-bit computing will soon be a common standard, as all hardware from the last couple of years has been customized accordingly. However, there is still a strong case for some users to stick with 32 bit Windows for the time being until a complete upgrade cycle has passed for the majority of users.
it's all about Windows 7 features .

Look for more things with better search option

2009-10-22T22:12:00.000-07:00

The starter pack of Windows 7 makes it easier for small notebook PCs to use the operating system as it takes less time to boot, involves less clicking, and less hassle connecting to networks.

This edition combines the latest in reliability and responsiveness with the familiarity and compatibility of Windows. Although in previous Microsoft OS, Windows Search has a
familiar user interface for instant finding of files and e-mail messages located on your PC.

Windows 7 Home premium edition makes it easy to establish a home network and share all your favorite photos, videos, and music. With the help of Window 7 or windows xp 7 you can even watch, pause, rewind, and record TV.

With Windows 7 Professional edition, you can run many Windows XP productivity programs in Windows XP Mode and recover data easily with automatic backups to your home or business
network. With Windows 7 you can also connect to company networks easily and with more security.

The Ultimate version of Windows 7 combines remarkable ease-of-use with the entertainment features of Windows 7 Home Premium and the business capabilities of Professional. And

for enhanced security, you can encrypt your data with BitLocker and BitLocker To Go. You can also work in any of 35 languages with this edition of Windows 7. These are the

features that give you a definite edge over earlier versions of Microsoft OS. I also think that the view your active networks section now looks much nicer and easier to understand.

Another interesting feature in Windows 7 is Reliability Monitor that allows you to know any future problem in advance. We often come across problems which might have been solved
if known earlier. But how to know what our system is lacking?

Reliability monitor

Windows 7 Reliability Monitor offers a solution. It demonstrates how well is your system by measuring the hardware and software performance of your computer. The tool calculates

the stability index of your system and specifies results in the range from 1-10 and thus from the results, you can get an overview of the overall performance of your system.

This feature was present in Windows Vista by the name of Reliability and Performance monitor but it has been renamed and further enhanced in Windows 7.

You can access this feature by following these steps:

STEP 1. Go to Windows 7 Action Center by clicking the Action Center icon in the system tray and and then choose Open Action Center.

STEP 2. Expand the Maintenance category, and click the View reliability history option.

STEP 3. Windows 7 will generate the reports in a graphical format and will display the stability of your system in the form of a graph. From here, you will be able to get an

idea about how well your system is performing.

Any failure will be marked down in the graph, which can provide the complete information. Hence, an easy way to know any abnormality in the system.

ReadyBoost: A way to speed up Windows 7

2009-10-19T21:51:00.000-07:00

Microsoft has included an enhanced version of ReadyBoost on Windows 7, a new feature that speeds up your computer even in a low memory situation by using flash memory, in its latest operating system Windows 7, scheduled to be launched on October 22.

ReadyBoost, which also comes with Vista, make use of a USB flash drive or card as memory and it works with most of the flash storage devices.

In Windows 7, it can handle more flash memory and even multiple devices up to eight, for a maximum 256GB of additional memory. When you plug a ReadyBoost-compatible storage device into your system, the AutoPlay dialog box offers you the option to speed up your computer using ReadyBoost. If you select this option, you can choose how much memory on the device to use for this purpose.

When you set up a device to work with ReadyBoost, Windows shows you the space recommended for an optimal performance. For ReadyBoost to effectively speed up your computer, the flash drive or memory card should have at least 1GB of available space. If enough space is not available for ReadyBoost, you’ll see a message asking you to free some space on the device if you want to use it to speed up your system. You can enable or disable ReadyBoost for a specific flash drive or other removable storage device.

Follow the given guidelines to enable this feature in Windows 7 :

STEP1: Connect a flash drive or flash memory card into your computer.

STEP2: Click Speed up my system, in the Autoplay dialog box, under General options.

STEP3: In the Properties dialog box, click the ReadyBoost tab, and then do one of the following:

To turn ReadyBoost off, click Do not use this device.

To use the maximum available space on the flash drive or memory card for ReadyBoost, click Dedicate this device to ReadyBoost. Windows will leave any files already stored on the device, but it will use the rest to boost your system speed.

To use less than the maximum available space on the device for ReadyBoost, click Use this device, and then move the slider to choose the amount of available space on the device you want to use.

STEP4: Click OK.

Automate Administration with PowerShell

2009-10-19T00:31:00.000-07:00

Windows PowerShell 2.0, a useful feature in Microsoft’s latest operating system, Windows 7, is a great boon to IT professionals yearning for a elevated management of computers in enterprises.

PowerShell 2.0 is built on the Microsoft .Net Framework and is especially designed for system administration providing great help to IT professionals to automate the administration of Windows operating system. The command tools in Windows PowerShell, named cmdlets, allows you to manage computers in enterprise.

Microsoft latest Windows 7 version also helps you to access data stores and supports Windows Management Instrumentation classes. The tool is designed to easily permit the addition of new features. Your own cmdlets, providers, functions and scripts can be added which enables you to use Windows technologies such as Active Directory Domain Services, Windows BitLocker Drive Encryption, the DHCP Server service, Group policy, etc.

IT professionals and developers might be most interested in these improved features in Windows 7 as it helps them to manage Windows at the command line. Developers can also use it to build script language

In a nutshell, following are the changes included in Windows 7 PowerShell:

1. More than 100 new cmdlets are included in Windows PowerShell.

2. Interactive session can be created with single computer and as many as computer can be run with the single command. A session can be established with it which allows you to receive remote commands from multiple computers.

3. With Windows PowerShell background jobs, you can continue to work on your session as the commands run in the background. Background jobs can be run on a local as well as on the remote computer.

4. With debugger, you can debug functions and scripts. Breakpoint can be set and removed with it and you can also check the values of the variables.

5. Modules in Windows PowerShell allows you to function as independent entity. Module package containing your cmdlets, providers, scripts, functions and other files can be distributed to the other users.

6. It supports new event infrastructure and transaction.

7. The messages and text can be displayed to users in multiple languages, with script internalization.

8. For enhanced user experience, not only help at the command line but also new online parameters are included in Get-Help cmdlet which opens updated version of each help topic.

The Improved Calculator in Windows 7

2009-10-17T00:49:00.000-07:00

Windows 7 allows you to calculate fuel economy, distance, and fuel used in gallons or liters. Sometime you need to calculate a vehicle's fuel economy based on its distance and fuel used. To perform these, you do not need to visit websites or download additional software. Just use the improved calculator in Windows 7.
First, click the Start button- All Programs- Accessories then open Calculator. After that you can click on next and select "View", then "Worksheets", then one of the two worksheets to perform calculations involving miles or liters. These are Fuel economy (mpg) and Fuel economy (L/100 km).
From fuel economy worksheet pane you can perform three types of calculations such as Distance, Fuel economy and Fuel used.
Enter the needed values that will depend on the type of calculation. Click "Calculate" to display the result. You can select "Edit" - "Copy" to copy the result to the calculator, a Notepad file, or other document.

Windows 7 also allows users to prevent Security or Maintenance Messages in the Action Center. You will just have to disable unwanted messages in Windows 7.

Action Center alerts you about various computer problems such as the virus protection being out of date, a backup needing to occur, or if your computer needs to be restarted. Sometime you don't want theses messages to appear. You can disable these messages with the help of given steps.
Open Action Center by clicking the Start button, type “action center” or alternatively click on Windows Action Center flag in the Windows Taskbar. Click Change Action Center setting in the left pane in Action Center windows. On the next screen, uncheck boxes next to messages you do not wish to see. Message categories include: Security messages & Maintenance messages. Click "OK" to save your settings, then close the "Action Center" window.
In Windows 7 you can also access your favorites sites and folder from Taskbar by adding an additional Toolbar. In Windows 7, you can click the Start button and type in the name of a web address or folder to open up your web browser or Explorer. However, if you perform these tasks frequently then you can create an additional Toolbar. An "Address" Toolbar is easy option of navigating to web sites or folders. Just type in the name of your website or folder and press the Enter key. You can follow these steps to perform this task. Right-click an empty area of the Taskbar. Select "Toolbars" - "Address".

Your Account Picture How to change in windows 7

2009-10-16T04:01:00.001-07:00

Microsoft’s Windows 7 release will be a boon for users as now they will be allowed to change the picture that appears on the Start Menu and Welcome screen in Windows 7.
While using Windows 7 you must have noticed a picture that appears when you click the Start menu or access the Welcome screen. A picture represents your account. You can replace this default picture with your favorite one.
You can follow these steps to perform this task. Click the Start button and then click on your account image to open the "User Accounts" Control Panel. When the "User Accounts" Control Panel opens, click "Change your picture" and then choose the one you like from the gallery and set as a default picture for your account.
After that you will have to click the "Change Picture" button, and then close the "User Accounts" Control Panel.
Taking up another issue, you can use setup to show the computer name on your Windows 7 taskbar.
You usually check computer name manually by right-clicking on My Computer and choosing Properties. But in Windows 7 release you can display it on Taskbar.
You just have to create a new folder in Document folder with the same name as your computer name. You can find your computer name by right-clicking on My Computer and choosing Properties. Right-click on an empty area in the taskbar and choose Toolbars, then click on New Toolbar. Now you want to browse to the location of the folder you just created. Choose that folder and click the Select Folder button.
Thats all. Now your computer name will appear on the Windows 7 taskbar.
Another Windows 7 update is that you can also get an effective package from Dr. Web CuireIt against all virus and spyware in Windows 7
When you update your system with Windows 7, then you need a comprehensive package because your existing antivirus will lose the compatibility.
Dr. Web comes with a most efficient Anti-Virus called Dr. Web CuireIt. Its extensive scanner and virus will scan the complete system even without installation. You can get it from the website link http://www.freedrweb.com, absolutely free. You can combine this package with Windows 7 install package. First, open the website with the above link. Press the button of "Download." Save the file on your desktop. Double click on the file and run the set up. Follow the prompt and at the end accept the Agreement form. Click on "Finish" after the process is complete.
You can run this program anytime, to scan your startup files and main memory. Depending upon the area you want to scan you can run this program under complete scan or custom scan. Press "Scanning" after selecting. After scanning the incurable files are moved to the quarantine directory.

How to Browse Internet on Windows 7 E Version

2009-10-12T21:59:00.000-07:00

Microsoft introduced Windows 7 Version in reaction to statements made by the European government with respect to Internet Explorer. The EU introduced antitrust case against Microsoft to the group of IE with Windows and therefore the exploitation of dominant market position. The government claimed that "the linking of Microsoft Internet Explorer for the Windows operating system harms competition among web browsers, undermines the product innovation and ultimately reduces consumer choice."

Windows 7 version E is a response to this that shows that Microsoft must comply with the law. The E version is without any type of browser and therefore welcomes the European markets with Windows without any type of Internet browser now so they can use any browser of your choice. However, the question remains: HOW? If no browser at all how is it possible to download any web browser?

Microsoft has provided detailed information about installing Windows 7 E on its website. However, the instruction also includes an extra step for customers in Europe with regard to keeping the browser of choice in some external hard drive. Therefore, European customers that Windows 7 will save the web browser on a CD, DVD or USB or other storage media and install the browser once the Windows 7 has been completely installed.

This is a genius step taken by Microsoft, as they show they are following the laws, and to be able to get more revenue by providing additional CD web browser with the operating system.

John James is a professional writer with extensive work experience in the development of web services industry. The author has written several useful and informative articles on various topics related to IT and computer help .

iYogi Re-Defines Technical Support With Proactive Approach

2009-07-29T04:33:00.000-07:00

Remote managed services are gaining a lot of attraction these days. Companies are looking to outsource the maintenance and monitoring of their IT infrastructure to a third party to improve efficiency and save costs. BizTech2.com caught up with Uday Challu, founding partner and CEO, iYogi, to see what the company has to offer in this space.
As far as Enterprise and SME customers are concerned, which verticals are you focusing on?
Our focus will mostly be on small companies with around five to 100 users and also firms that have multiple small branch offices like travel agencies, retail stores etc.
What kind of support services do you provide to your customers? What is the Green PC service?
iYogi provides the next generation of remote computer support services for consumers and businesses. For consumers, our live 24/7 support extends to technologies we use everyday, including hardware, software applications, devices, peripherals and networking equipment. iYogi also offers a full range of business IT solutions including managed monitoring, managed services, set-up and installation services, and incident-based services.
Green PC Service
With the current state of the global climate and increasing dependency on the computer, iYogi helps PC users reduce their carbon footprint and save money at the same time. iYogi’s Green PC service is the first in the independent computer support industry to offer customers a way to save money, conserve energy and protect the environment by optimising their PC’s efficiency. Consumers and businesses can save up to $200 per year, per desktop, in energy costs with iYogi’s Green PC application. This green application makes the computer environmentally friendly by reducing power consumption by almost 50 percent.
Our Green PC dashboard helps customise power settings and calculate power savings in kWh (kilowatt hour). The Green PC dashboard also gives a status on the reduction of CO2 and how responsible usage will benefit the environment by saving trees. A customised service that increases the energy efficiency of computers, undertakes the below-mentioned three primary initiatives:
- Computer assessment, analysing settings and PC energy use- Customised efficiency planning geared specifically to the individual’s usage patterns- Implementing setting changes to maximise the computer’s energy use
What are the technologies that allow you to offer 24/7 support and ensure there is no downtime at the client site?

We have invested significantly in developing a comprehensive monitoring and management tools stack. This enables us to manage and monitor all devices in the office network as well as for branch offices and mobile users. Our tools continuously monitor the customer’s network and notify our NOC (Network Operations Centre) in case of problems. Based on the set of events, tickets are automatically generated and escalated to corresponding teams. Over and above our proactive approach, the customer always has an option to call our 24X7 support line for issues that are not identified via the monitoring tools.
Please throw some light on your proprietary iMantra technology.
iMantra is a CRM system, which is tailor-made to suit the emerging business needs at iYogi. It allows for the formation of individualised customer relationships with the aim of providing personalised services to each subscriber. This tool is built on the latest java technology with a layered architecture that makes it scalable and secure. This architecture provides a seamless workflow and independent channels for various business needs: sales, support, quality and customer service. The entire system can be exposed in the form of secure APIs and Web services, which makes it a re-usable entity.
Your business model is similar to BPOs in India providing technical support to offshore customers. What unique values do you bring to this ecosystem that would help a potential client choose you over a competitor?
iYogi’s business model is different from traditional BPOs. Some key factors that differentiate iYogi include:

- Direct-to-consumer and -small business: iYogi delivers technical support services directly to consumers and small businesses and is a global technical support brand based out of India. Unlike traditional BPOs in India, iYogi does not provide any private label support and/ or work on behalf of large OEMs or software publishers.
- Optimised Processes: iYogi has developed proprietary processes for consistently delivering on a resolution rate of 87 percent, which is among the highest published benchmarks in the support industry, where averages hover in the range of 50 percent.

- Comprehensive technology platform: iYogi’s global delivery platform, iMantra, gets smarter with every customer interaction. It documents every problem, the solution and relevant hardware and software aspects, while capturing each customer’s demographic information and creating a behavioural profile. All of this information is at the fingertips of iYogi’s Global Tech Experts. This set-up combines a knowledge base with a comprehensive set of tools and technology expertise. iYogi offers a range of tools that complement its remote support services for helping customers maintain technology at peak performance levels. iYogi’s products include iYogi Smart PC Scan, iYogi Support Dock, iYogi Green PC and iYogi PC Optimisation.

How do you plan to move up the value chain in the times to come?
The growing use and penetration of the Internet and new Web-based applications has consequently opened the door to threats and vulnerabilities, which affect the system performance and ultimately lead to degrading performance. If the threats are diagnosed early on, the impact on efficiency can be minimised considerably. Currently, a user only realizes that he needs technical support once the damage has occurred and reactive methods of support are used to recover from the loss.

At iYogi, we are developing our capabilities to not only provide support when demanded, but to also monitor, pre-empt and fix threats before they can cause any damage to the computer. This will be possible only by combining technology with processes that are capable of re-defining the way technical support is delivered today.

What is your India strategy?
Technically, we are capable of servicing any geography including India. At this stage, we are looking for the right kind of partners to find access to potential customers and provide them a consolidated, 360-degree solution and services for issues relating to hardware, software, network etc. We aim to launch our India services in the coming six to eight months. Our services will offer clients a one-stop solution for all their business needs.

Red Herring Awards 2008 iYogi For Asia America 100

2008-12-15T05:04:00.000-08:00

Award Recognizes the 100 “Most Promising” Asian Companies Driving the Future of Technology

Silicon Valley, CA, Dec 9th, 2008— Red Herring today announced that iYogi is a winner of the Red Herring 100 Award, a selection of the 100 most innovative private technology companies based in Asia.

IYogi delivers technical support services directly to consumers and small businesses and is the first, global, technical support brand based out of India with more than 50,000 customers. The company offers consumers an unlimited, annual subscription service for $119.99 per desktop that includes support for a wide range of technologies, including PC hardware, Microsoft Products Support, Windows Operating systems, Computer Support, Software applications, MP3 players, Networking devices, Digital camera, Printers and scanners etc.

The Red Herring editorial board diligently surveyed the entrepreneurial scene throughout Asia and identified the top 100 out of more than 1,000 closely evaluated companies that are leading the next wave of innovation.

“Our winners and Finalists demonstrate that Asia is increasingly becoming a leader in innovation, contrary to common stereotypes", said Joel Dreyfuss, editor-in-chief of Red Herring. " It was tough to choose just the top 100 finalists from such a large list of excellent contenders, and we are very happy with the quality of the companies we selected as finalists."

“We believe consumers and small business owners should have low-cost access to the highest quality support available on the planet", said Uday Challu, CEO of iYogi. “We are thrilled that our innovative approach to solving everyday technology problems for consumers and our managed services for small businesses has been recognized by Red Herring’s keen-eyed leadership. We are continuously innovating in adding new services that includes PC recovery, anti-virus, anti-spyware, data back-up and PC optimization in providing the best tech support experience for our customers”, adds Uday.

The 100 winning companies have been announced at the Red Herring Asia event in Hong Kong. The CEOs of the winning start ups presented their innovative ideas and technologies to an audience of leading entrepreneurs, financiers, and corporate strategists at the event at the Hong Kong, JW Marriott Hotel earlier this week.

About iYogi

iYogi is the first direct-to-consumer and small business technical support service from India. Providing an annual unlimited subscription to technical support, iYogi now boasts of more than 50,000 customers. The company employs 600 professionals servicing customers in the US, UK, Canada, Australia and fast expanding to 12 new geographies across the globe. iYogi’s resolution rate of 87 percent and customer satisfaction rate of 93 percent are amongst the highest published benchmarks in the industry. For further information, please visit www.iyogi.net.

iYogi Contact

Vishal Dhar

President Marketing, iYogi Inc.

Phone: 212 229 0901

Email: vishal@iyogi.net

How to use ANOVA tools in Excel

2008-11-18T02:04:00.000-08:00

Many functions require the calculation of the sum of squared deviations about a mean. To do this accurately, Microsoft Office Excel 2003 and later versions of Excel use a two-pass procedure that finds the mean on the first pass, and then calculates squared deviations about the mean on the second pass.

In precise arithmetic, the same result occurs in earlier versions of Excel that use the "calculator formula." This formula is so named because it was in widespread use when statisticians used calculators instead of computers. With the calculator formula, earlier versions of Excel sum the squares of the observations, and then subtract from this total the following quantity:

((sum of observations)^2) / number of observations

This calculation occurs in a single pass through the data.

In finite precision arithmetic, the calculator formula is subject to roundoff errors in extreme cases. Excel 2002 and earlier versions of Excel use the calculator formula for most functions that require a sum of squared deviations about a mean (such as VAR, STDEV, SLOPE, and PEARSON). However, these versions of Excel also use the more numerically robust two-pass procedure for the CORREL, COVAR, and DEVSQ functions.

Experts in statistical computing recommend that you do not use the calculator formula. The calculator formula is presented as "how not to do it" in texts about statistical computing. Unfortunately, all three of the Analysis ToolPak (ATP) ANOVA tools make widespread use of the calculator formula or an equivalent single-pass approach in Excel 2002 and in earlier versions of Excel.

Excel 2003 and later versions of Excel use the two-pass procedure for all three ATP ANOVA models. This article discusses the following computational improvements in ATP's three ANOVA models:
• Single Factor
• Two-Factor with Replication
• Two-Factor without Replication

Single Factor
A simple example with data is as follows.
ANOVA 1 BASIC MODEL:
1 2 3
2 4 4
3 6 5
4 8 6
5 --7
6 --8
Anova: Single Factor

SUMMARY
Groups Count Sum Average Variance
Column 1 6 ---21 --- 3.5 ----- 3.5
Column 2 4 --- 20 --- 5 ------- 6.666667
Column 3 6 --- 33 --- 5.5 ----- 3.5

ANOVA
Source of Variation SS df MS ----F --------P-value F crit
Between Groups 12.75 2 6.375 1.506818 0.257897 3.805567
Within Groups 55 13 4.230769

Total 67.75 15
Excel 2002 and earlier versions of Excel use the following pseudocode to calculate the sums of squares:

GrandSum = 0;
GrandSumOfSqs = 0;
GrandSampleMeanSqrd = 0;
GrandMeanSqrd = 0;
GrandSampleSize = 0;

For s = 1 to Number_of_Samples do
GrandSum = GrandSum + sum of observations in s-th sample;
GrandSumOfSqs = GrandSumOfSqs + sum of squared observations in s-th sample;
GrandSampleMeanSqrd = GrandSampleMeanSqrd +
(sum of observations in s-th sample^2)/size of s-th sample;
GrandSampleSize = GrandSampleSize + size of s-th sample
Endfor;

GrandMeanSqrd = (GrandSum^2) / GrandSampleSize;

TotalSS = GrandSumOfSqs – GrandMeanSqrd;
BetweenGroupsSS = GrandSampleMeanSqrd – GrandMeanSqrd;
WithinGroupsSS = GrandSumOfSqs – GrandSampleMeanSqrd;

This approach is essentially the calculator formula. This approach computes the sums of squares of observations, and then subtracts a quantity from them, just as VAR computes the sum of squares of the observations, and then subtracts sum of observations^2/sample size. Similar pseudocode for the model 2 and model 3 has been omitted.

Again, for model 2 and model 3, sums of squares are calculated and a quantity is subtracted from the sum of squares as in the calculator formula. Unfortunately, basic statistics texts frequently suggest approaches for ANOVA such as the one that is shown earlier in this article.

Excel 2003 and later versions of Excel use a different approach to calculate the various entries in the SS column of the ANOVA table. For illustration, this article assumes that the numeric data in the earlier example appear in cells A2:C7 with missing data in cells B6 and B7.
• Total SS is just DEVSQ applied to all the data, such as DEVSQ(A2:C7). DEVSQ works correctly even though data is missing.
• Between Groups SS is Total SS minus the sum of DEVSQ applied to each column, such as DEVSQ(A2:A7) + DEVSQ(B2:B7) + DEVSQ(C2:C7).
• Within Groups SS is Total SS minus Between Groups SS.

#VALUE error when you add text and values in Excel

2008-11-12T21:51:00.000-08:00

In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error. In this post i will given some idea for Microsoft Excel Support to slove that type of problems.

Although some functions correctly evaluate cells and ignore text strings, if you add the cells by using arithmetic operators such as addition (+), subtraction (-), multiplication (*), or division (/), an error value may occur.

Do the following for Resolution

Instead of using an individual mathematical operator, use its equivalent worksheet function instead:
SUM (adds)
PRODUCT (multiplies)
QUOTIENT (divides)
For example, if you type the following information in cells A1:A7 of a worksheet

A1: 10
A2: text
A3: 20
A4: =A1+A2+A3
A5: =SUM(A1+A2+A3)
A6: =SUM(A1,A2,A3)
A7: =SUM(A1:A3)

the formulas in cells A4 and A5 return a #VALUE! error; however, cells A6 and A7 return the correct value of 30.

How to use startup folders in Excel

2008-11-07T01:48:00.000-08:00

Folders that Excel uses at startup
If you install Excel in the default location, Excel opens files from the following paths:
• In Microsoft Office Excel 2003, the path is C:\Program Files\Microsoft Office\Office11\Xlstart

In Microsoft Office Excel 2007, the path is C:\Program Files\Microsoft Office\Office12\Xlstart
• C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART

In this path, User_name is your logon user name.
• The folder that is specified in the At startup, open all files in box

Note
To find the At startup, open all files in box in Excel 2003, click Options on the Tools menu, and then click the General tab.

To find the At startup, open all files in box in Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Advanced. The At startup, open all files in box is under General.

Accepted file types during Excel startup

You typically use startup folders to load Excel templates and add-ins. You can also use startup folders to load workbooks. When you load the following types of files from a startup folder, the files have the important characteristics that are described in the following list.
Templates
If you save a workbook named Book.xlt, and then put it in a startup folder location, that workbook is the default workbook when you start Excel or open a new workbook.

To use additional templates, you must save them in the following folder:
C:\Program Files\Microsoft Office\Templates\1033
To use the templates in Excel 2003, follow these steps:
1. On the File menu, click New.
2. In the New Workbook task pane, click On my computer under Templates.
3. In the Templates dialog box, double-click the template for the type of workbook that you want to create on the Spreadsheet Solutions tab.

To use the templates in Excel 2007, follow these steps:
1. Click the Microsoft Office Button, and then click New.
2. Under Templates, click Installed Templates.
3. Under Installed Templates, click the template that you want, and then click Create.
Add-ins
Add-ins (.xla files) that you put in a startup folder do not typically appear when you start Excel. The add-ins are loaded in memory. The add-ins run any auto macros.

You can use these add-ins by whatever method the add-in provides (for example, a command on a menu or a button on a toolbar).
Workbooks
Workbooks (.xls files) that you put in a startup folder are loaded and appear when you start Excel, unless the workbook is saved in a hidden state.

New Field button is unavailable in Show Field dialog boxes in Outlook

2008-11-04T01:41:00.000-08:00

When you use the Field Chooser or Show Fields options in Microsoft Outlook, the resulting dialog boxes may display the New Field button as dimmed (unavailable), or if available, when you click the New Field button, you may receive the following message:
You do not have permission to add a custom field to the folder. Any field you create will appear only in the current view.

To fix this Outlook problem we have to care on You can only create MAPI folder to which you have sufficient privileges.

How to Access Show Field Option

To access the Show Fields option, on the View menu, point to Current View, point to Customize Current View, and then click Fields.

Note In Outlook 2003, on the View menu, point to Arrange By, point to Current View, click Customize Current View, and then click Fields.

The New Field button is not available for one of the following reasons:

- The current folder is a file system folder. For example, if the folder banner shows that the active folder is My Documents, then the New Field button will be unavailable.

- You do not have sufficient permissions to the selected MAPI folder. If the current folder is a MAPI folder, such as a public folder, you must have sufficient permissions to that folder to allow the creation of fields. Have the folder owner ensure create permission is available to you for the active folder. The folder owner, or another user with sufficient permissions, can access the permission settings for the folder by right-clicking the folder in the Outlook Bar or Folder List, and then clicking Properties on the shortcut menu.

To validate that the New Field button is working properly, follow these steps:

1. Select the Inbox or another MAPI folder to which you know you have sufficient permissions.
2. Right-click a column header and click Field Chooser on the shortcut menu.
3. Confirm that the New Field button is available by clicking the button

Subscript characters are displayed incorrectly when you insert them in Excel 2003 or in Excel 2002

2008-10-29T02:18:00.000-07:00

SYMPTOMS
When you insert subscript characters in Microsoft Office Excel 2003 or in Microsoft Excel 2002, the characters are displayed incorrectly. For example, an empty rectangle is displayed when you insert subscript one.

CAUSE
When you insert subscript characters, Excel 2003 and Excel 2002 use the Arial Unicode MS font if one of the following is not installed on the computer:
• An appropriate font, such as MS MIncho or MS Gothic
• Support files for the East Asian languages
The Arial Unicode MS font cannot resolve all characters correctly.

WORKAROUND
To work around this issue, use one of the following methods:

Method 1
Install the MS MIncho font or the MS Gothic font on the computer. To do this, follow these steps:
1. Click Start, click Run, type Fonts, and then click OK.
2. Click Install New Font in the File menu.
3. In the Add Fonts dialog box, locate the font file for the MS MIncho font or for the MS Gothic font, and then click OK.

Method 2
Install the East Asian languages support files. To do this, follow these steps:
1. Click Start, click Run, type Intl.cpl, and then click OK.
2. Click the Languages tab, click the Install files for East Asian languages check box, and then click OK.

APPLIES TO
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition

source spport.microsoft.com

Error message when you try to import or to export files in Outlook: "Microsoft Outlook cannot start the required translator"

2008-10-21T01:08:00.000-07:00

SYMPTOMS
When you try to import or to export files in Microsoft Office Outlook 2003, you receive the following message:
Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?
Additionally, when you insert the Outlook 2003 CD-ROM or the Office 2003 CD-ROM, you may receive the following error message:

Error 1311. Source file not found C:/MSOCACHE/All Users

When you try to import or to export files in the 2007 Microsoft Office system, you may receive one of the following error messages:
Error 1334. The file '.SAM_1033' cannot be installed because the file cannot be found in cabinet file 'OutlkLR.CAB'. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package.
The file ‘C:\MSOCache\All Users\{}\’ is not a valid installation package for the product () 2007. Try to find the installation package ‘OutlookMUI.msi’ in a folder from which you can install MUI () 2007.
Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\DOCUME~1\\LOCALS~1\Temp\Setup0000043c\SETUP.CHM.

CAUSE
This issue occurs if certain translator files or certain database converters are not available because they were not installed during Setup. Converters in Outlook are installed on demand. Additionally, the local install source folder (Msocache) may be damaged or missing.

This issue also applies to third-party personal information management (PIM) files and to file types that use Open Database Connectivity (ODBC).

RESOLUTION
To resolve this issue, use one of the following methods, as appropriate for the version of Outlook that you are running.

Outlook 2003
Click Yes when you receive the message that is mentioned in the "Symptoms" section of this article. After you click Yes, Microsoft Windows Installer starts and then installs the database converters and translator files for the file that you want to import or to export.

If this resolution does not resolve the issue, run the Microsoft Office Setup program and install the filters directly. To do this, follow these steps:
1. Exit Outlook 2003.
2. Remove the Msocache folder. For more information about how to remove the Msocache folder, click the following article number to view the article in the Microsoft Knowledge Base:
825933 Local Install Source (Msocache)
3. Click Start, and then click Control Panel.
4. Click Add or Remove Programs.
5. In the Currently installed programs list, click Microsoft Office 2003, and then click Change.
6. In the Microsoft Office 2003 Setup dialog box, click Add or Remove Features under the Maintenance Mode Options area, and then click Next.
7. Under the Custom Setup area, click to select the Choose advanced customization of applications check box, and then click Next.
8. Under the Choose update options for applications and tools area, expand Microsoft Office Outlook.
9. Click the down arrow next to Importers and Exporters, and then click either the Run from My Computer option or the Run all from My Computer option.
10. In the Microsoft Office 2003 Setup dialog box, click Update.

Microsoft Office Outlook 2007
Insert the CD or DVD media when you are prompted. If you installed Outlook 2007 from a network share, make sure that the share is accessible from your workstation.

After you provide the setup files, the setup process will complete successfully. Additionally, any missing or corrupted files in the \MSOCache folder will be replaced.

If the same error occurs in the future, delete the \MSOCache folder, and then run the Online Microsoft Outlook setup 2007 process again. When run Setup again, make sure that you select the Repair option in the Change your installation window.

MORE INFORMATION

PIM formats
The following PIM program data files can be imported to Outlook 2007:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM program data files can be imported to Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• Schedule + 7.x and Schedule + SC2 ACT! 3.x,
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM formats can be exported from Outlook 2007 and from Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS

Note: Click For Online Email Support

External link: http://support.microsoft.com/kb/829985/en-us?spid=2520&sid=312

mail Word 2007 Document For Reviews and Tracking Changes

2008-10-13T04:36:00.000-07:00

Emailing a Word 2007 document to another user for review, meaning any changes they make it will track those changes in Word 2007, is a snap!

Getting it setup takes a few more steps than previous version of Word 2000, Word XP (2002) and Word 2003. Because in those versions it was a simple: File>Send To>Mail Recipient (For Review), and then click the Send (b) to email it off.

Stop bloviating and tell me where to do the same with Word 2007 you opine! Fine. But let me warn you that writing more than steps is not only therapeutic for me when it comes to blogging, but downright fun!

Email Word 2007 Document For Review and Tracking Changes Steps. First you have to add the Send For Review (b) to you QAT (Quick Access Toolbar). Yeah! I know there’s not another easier way I know of. So Right /QAT toolbar>Customize, /Choose commands arrow>All, scroll to & //Send for Review, /ok. Now on your QAT toolbar /Send for Review (b) and it will do two things: first attach your Word 2007 document into an email, and also it turns on the Track Changes (b) on the Review tab. Now just type in an email address and /Send (b) to email your document off to one of your Super Friends!

Once Wonder Woman (one of your Super Friends) opens the attachment and makes any changes to the document, it will track it i.e. if she deletes a word it will put a red line through it, and if she adds text it will color it in green. So when she’s done all she has to do email those changes back to you where you can, with the help of Reviewing tab, accept or reject her changes i.e. removing the red lines for deletions, or removing her added text.

You know you can just as easily open Word 2007, /Review tab & /the Track Changes (b) and turn on the changes yourself and the /Word’s Office Logo (b)>Send and email without having to add the Send For Review (b) to your QAT toolbar.

Having said that I bet you’re thinking: I wouldn’t choose Wonder Woman as a Super Friend with only a magic lasso to protect me, and second anybody can turn off the “Track Changes” feature and then I couldn’t protect my document from unwanted, trackable changes!

Yes, you’re right and so the only way to “protect” someone from messing with your document without being trackable, or seeing their changes is to follow these steps: /Developer tab>Protect group & /Protect Document (b)>Restrict Formatting and Editing, in Task Pane’s Editing restrictions section check “Allow only this…” box and /its arrow>Tracked changes & /Yes, Start Enforcing Protection (b) and type in your password.

Now that’s protection! Okay, having password protection on a document is like having a Super Friend like Superman protecting you. Invincible he is until some krptonite is found - iyogi computer help services breaks the password, but better than nothing eh?

Microsoft Training Tips

2008-09-26T05:27:00.000-07:00

When it comes to learning Microsoft Office, there are some real challenges for many individuals. First of all, most people simply open up Microsoft Office and try to navigate through the software without ever truly learning how to use it. This is all fine and good for those who are software savvy, but for those who are not it usually results in a lot of lost time and they still do not learn the program. So, what can individuals do who need to learn to use Microsoft Office but who really have no clue how to get started? For these people there are options like online Microsoft Office training. There are many benefits to online Microsoft Office training and it is highly recommended for anyone who will use this program.

For others who find that online training is not the right option for them then they can choose to use a Microsoft Office training CD. This training CD is an excellent option for anyone who wants to learn Microsoft Office or even those who are already familiar with the program but want to brush up on a few areas. It is so easy to sit down in front of a computer and simply start going through the tutorial and focusing on the areas where you really need help and skipping or just brushing over the ones that are not that important. You might dread taking a tutorial or course like this, but when you actually get involved in it you will realize that it really is a great idea and one that will help you significantly in your career and every day use of Microsoft Office.

There are some tips you should follow, however, before you begin taking any online class and tutorial. And, the first one is to prepare yourself to learn. If you go into the tutorial focusing on other things then you will never really learn all that Microsoft Office has to offer. The same goes for allotting time to take the training. If you are short on time and try to cram an hour's worth of tutorial into 15 minutes then you really will not benefit much from the tutorial. Because of this, it is really important that you focus on time allotment and make room for your Microsoft Office course. You will be glad you did in the end because you will learn so many different things about this software that you never knew and it will really help you in your job and daily life as a result.

Caitlina Fuller is a freelance writer. For these people there are options like online Microsoft Office Support. There are many benefits to online Microsoft Office training and it is highly recommended for anyone who will use this program. For others who find that online training is not the right option for them then they can choose to use a Microsoft Office Support CD. This training CD is an excellent option for anyone who wants to learn Microsoft Office or even those who are already familiar with the program but want to brush up on a few areas.

Use Word 2007 to open documents created in previous versions of Word

2008-08-29T04:50:00.000-07:00

When you open a document in Microsoft Office Word 2007 that was created in Microsoft Office Word 2003, Word 2002, or Word 2000, Compatibility Mode is turned on, and you see Compatibility Mode in the title bar of the document window. Compatibility Mode ensures that no new or enhanced features in Office Word 2007 are available while you are working with a document, so that people who are using previous versions of Word will have full editing capabilities.

You can work in Compatibility Mode or you can convert your document to the Office Word 2007 file format. Converting your document allows you to access the new and enhanced features in Office Word 2007. However, people who are using previous versions of Word may be prevented from or have difficulty editing certain portions of the document that were created by using new or enhanced features in Office Word 2007

Convert a document to Office Word 2007

Click the Microsoft Office Button , and then click Convert.
In the Microsoft Office Word dialog box, click OK.
Do one of the following:

To replace the original file with a file in the Office Word 2007 file format, click the Microsoft Office Button, and then click Save.
To save the original document in its original file format and create another document in the Office Word 2007 file format, click the Microsoft Office Button, click Save As, and then type a new name for the file.

How to create distribution list in Outlook

2008-08-27T03:26:00.000-07:00

A distribution list, also known as a mailing list, is a collection of email addresses. You can use distribution lists to send an email message to several people at one time. The list can contain a few addresses, or many.

All email systems at Indiana University provide ways to create, manage, and send to distribution lists. For example, you may use Exchange mailing lists to send mail to a group of people. For more information, see How do I send an email message to a group of people? Note that the commands, options, and capacities vary on each system. Furthermore, lists housed on specific systems are unavailable for shared use on other systems. It post provides Outlook Support for creating distribution list and how to manage distribution list. The following method is used to do it.

Create a distribution list using names in the Address Book

On the File menu, point to New, and then click Distribution List.
In the Name box, type a name.
Click Select Members.
In the Show names from the list, click the address book that contains the e-mail addresses you want in your distribution list.
In the Type name or select from list box, type a name you want to include. In the list below, select the name, and then click Members. Do this for each person you want to add to the distribution list, and then click OK.

If you want to add a longer description of the distribution list, click the Notes tab, and then type the text.

The distribution list is saved in your Contacts folder by the name you give it.

Create a distribution list by copying names from an e-mail message

In the e-mail message you want to copy the names from, select the names in the To or Cc box (To, Cc, and Bcc boxes: A message is sent to the recipients in the To box. Recipients in the Cc (carbon copy) and Bcc (blind carbon copy) boxes also get the message; however, the names of the recipients in the Bcc box aren't visible to other recipients.).
On the Edit menu, click Copy.
On the File menu, point to New, and then click Distribution List.
In the Name box, type a name for the distribution list.
Click Select Members.
In the Add to distribution list list, right-click, and then click Paste on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).

Excel Text don't appear correctly on the Web page

2008-08-08T07:07:00.000-07:00

Upgrade to Microsoft Internet Explorer version 4.01 or later To view a Web page that was saved with interactive data and have all the text appear correctly, you must use Microsoft Internet Explorer 4.01 or later and have the Microsoft Office Web Components (Microsoft Office Web Components: Interactive components, such as worksheets, charts, and PivotTable lists on Web pages that facilitate data analysis. To use these components, you must have a Microsoft Office license.) Installed.

Modify cells that contain automatically wrapped text You might have formatted cells with wrapped text before you published or saved the data as a Web page. In an interactive PivotTable list or spreadsheet on a Web page, text does not wrap within cells. To prevent text from being cut off when you publish or save it, you can shorten the text, use multiple cells for text, or widen the column in your worksheet, and then republish the data.

Do not use CSS for font formatting If you are using a browser that doesn't support cascading style sheets (CSS), do the following:

On the Tools menu in Excel, click Options, and then click the General tab.
Click Web Options, and then click the Browsers tab.
Clear the Rely on CSS for font formatting check box.
Republish your data.

Introduction to Outlook e-mail account types

2008-08-04T08:14:00.000-07:00

You can get e-mail accounts from sources such as your Internet service provider (ISP) (ISP: A business that provides access to the Internet for such things as electronic mail, chat rooms, or use of the World Wide Web. Some ISPs are multinational, offering access in many locations, while others are limited to a specific region.), your employer, or Web services such as Yahoo! Mail, Google Gmail, and Windows Live Mail. Microsoft Office Outlook does not create or issue e-mail accounts. It only provides access to your e-mail accounts (e-mail account: The server name, user name, password, and e-mail address used by Outlook to connect to an e-mail service. You create the e-mail account in Outlook by using information provided by your administrator or Internet service provider (ISP).).

E-mail account types
• POP3 Post Office Protocol 3 (POP3) is the leading e-mail account type on the Internet. With a POP3 e-mail account, your e-mail messages are downloaded to your computer and then usually deleted from the mail server. The main disadvantage of POP3 accounts is the difficulty to save and view your messages on multiple computers. Also, messages that you send from one computer are not copied to the Sent Items folder on the other computers. There are some workarounds for these issues. For more information about working with POP3 accounts on multiple computers, see the links in the See Also section.
• IMAP With an Internet Message Access Protocol (IMAP) account, you have access to mail folders on the mail server, and you can store and process mail without downloading it to the computer that you are working on. Thus, you can use a different computer to read your messages wherever you are. IMAP can save you time because you can view the headers of your e-mail messages — who the message is from and the subject — and then choose to download only those messages that you are interested in reading. Your mail is saved on the mail server, which is usually safer, and is backed up by your mail administrator or ISP.
• MAPI Messaging Application Programming Interface or MAPI is used in Outlook with a mail server that is running Exchange. MAPI is a lot like IMAP, but it provides many more features when you use it from within Outlook with an Exchange account.
• HTTP These accounts use a Web protocol to view and send e-mail. HTTP accounts include Windows Live Mail. Outlook does not natively support HTTP accounts, but there are add-ins that allow you to use Outlook with certain providers. For example, Microsoft Outlook Live includes the MSN Connector for Outlook, which allows you to access your Windows Live Mail account from within Outlook

Microsoft Outlook 2000 Web Feature

2008-07-30T05:01:00.000-07:00

Managing Communications on Your Intranet
Microsoft Outlook 2000 provides the following ways to manage information from the Internet or your intranet. It provides best Outlook Support to Handle Email services on outlook. Users can use the Contacts folder to do the following:
• Keep track of contacts’ Web sites.
• Open the Web history folder from within Outlook 2000.
• Share a catalog of Web sites in a public folder.
Browse Web pages in Outlook
In Outlook 2000, you can select a Web page from the Favorites menu or use the Web toolbar to enter a URL and display a Web page in Outlook. Or you can send the Web page that you are currently viewing in Outlook as the body of an e-mail message by clicking Send Web Page by E-Mail on the Actions menu
System Policy Tip If you do not want your users browsing the Web from Outlook 2000, you can disable commands on the Web toolbar by using a system policy. In the System Policy Editor, disable the commands in the Microsoft Outlook 2000\ Disable items in user interface\Predefined category that you do not want available to your users. For more information, see Using the System Policy Editor.

How AutoRecover and AutoSave work

2008-07-29T02:21:00.000-07:00

The AutoRecover option (in these Microsoft Office programs: Word, Excel, PowerPoint, Publisher, and Visio) and AutoSave option (in Microsoft Office Outlook) can help you avoid losing work in two ways:
• Your data is automatically saved If you enable Auto Recover or AutoSave, your file (such as a Microsoft Office Word document) or item (such as an Outlook Support and Outlook e-mail message) is automatically saved as often as you want. Therefore, if you have been working for a long time but forget to save a file or if your power goes out, the file you have been working on contains all or at least some of the work you have done since you last saved it.
• Your program state is automatically saved In Microsoft Office Excel, Microsoft Office Outlook, Microsoft Office PowerPoint, and Microsoft Office Word, there is an additional benefit to enabling AutoRecover or AutoSave. In these programs, if you enable this option, some aspects of the state of the program are recovered when the program is restarted after it closed abnormally.
For example, you are working on several Excel workbooks at the same time. Each file is open in a different window, with specific data visible in each window. In one of the workbooks, a cell is selected to help you keep track of which rows you already reviewed, and then Excel crashes. When you restart Excel, it opens the workbooks again and restores the windows to the way they were before Excel crashed.
Although not every aspect of your program's state can be recovered, in many cases, the Recovery feature can help you recover more quickly.

How to Repair a corrupted workbook

2008-07-24T02:51:00.000-07:00

I am continuing with Computer Help for Excel Application. It post help to repair corrupted file in Excel. When you open a workbook that has been corrupted, Microsoft Office Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.

Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually.

You can also try other methods to recover workbook data when repairing a workbook is not successful. As a preventive measure, you may want to save your workbook often and create a backup copy every time that you save it. Or you can specify that Excel automatically creates a recovery file at specific intervals. This way, you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted.

Repair a corrupted workbook manually

Click the Microsoft Office Button , and then click Open.
In the Open dialog box, select the corrupted workbook that you want to open.
Click the arrow next to the Open button, and then click Open and Repair.
Do one of the following:

To recover as much of the workbook data as possible, click Repair.
To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Add In Excel data on the Web

2008-07-09T03:18:00.002-07:00

Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description:

The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest, such as stock quotes, weather temperature, ect, into a spreadsheet and keeping that data “up-to-date”. That is, if the webpage data changes, the spreadsheet can be updated by a click of the data “Refresh” button. Also note that the add-in can automatically learn from a user’s selection and optionally select similar items to help save time. You can put Excel sheet data over the Network. Microsoft Office 2007 apply this facility through Outlook Support and using Outlook it will done.

Would you like your employees to be able to access, from a Web page, sales data for their territories compared to sales data for other employees? Or how about a spreadsheet for standard cost calculation? Or maybe you want to use a Web page to show the profits in different areas of your company in a chart.

You can save a Microsoft Excel workbook or part of the workbook, such as a single item on the worksheet, as a Web page and make it available on an HTTP (HTTP: Internet protocol that delivers information on the World Wide Web. Makes it possible for a user with a client program to enter a URL (or click a hyperlink) and retrieve text, graphics, sound, and other digital information from a Web server.) site, an FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) site, a Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), or a network server for users to view or interact with. For example, if you have sales figures set up on an Excel worksheet, you can publish the figures along with a chart to compare figures on a Web page, so that users can view or even work with the numbers in their browsers without having to open Excel.

Add a command to the Quick Access Toolbar

2008-07-07T04:58:00.000-07:00

I am continuing with the Microsoft Office 2007 with Outlook Suppor t .Today I am discussing about Microsoft Excel 2007.The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
You can add a command to the Quick Access Toolbar directly from commands that are displayed on the Office Fluent Ribbon.
1. On the Ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.
Notes
• You cannot increase the size of the buttons representing the commands by an option in Microsoft Office. The only way to increase the size of the buttons is to lower the screen resolution you use.
• You cannot display the Quick Access Toolbar on multiple lines.
• Only commands can be added to the Quick Access Toolbar. The contents of most lists, such as indent and spacing values and individual styles, which also appear on the Ribbon, cannot be added to the Quick Access Toolbar.

How Excel Services supports connections to external data sources

2008-07-03T03:11:00.000-07:00

PivotTable reports are designed to aggregate a lot of numerical data into sums and totals, and to work with multidimensional data that is organized into a hierarchy. On the other hand, external data ranges are two-dimensional tables structured as rows and columns, that display nonaggregated records of source data.

When you use the Data Connection Wizard or Microsoft Query to connect to external data, you usually create an external data range. The only exception to this is when you create a PivotTable report that is connected to external data. A PivotTable report does not create an external data range. This difference in the way that connections are created is important to understand when you publish a workbook to Excel Services, because Excel Services only supports external data connections based on PivotTable reports and does not support external data ranges.

I want to sahre my experience with Microsoft Office Outlook Support and also discussed about Email Support

Composing different types of documents

2008-07-01T04:42:00.000-07:00

You can use templates to quickly create all kinds of documents. Word 2007 comes with numerous templates, and you can download many more. When you start a new document based on a template, the document contains its own design elements, and the template's predefined styles ensure that all your paragraphs work harmoniously together.

Start the document

Choose New from the Office menu to display the New Document dialog box.
With Blank And Recent selected in the left pane, review any templates you've used recently, and double-click the one you want.
If you don't see the one you want, click Installed Templates to see the Microsoft templates that were either installed on your computer or downloaded, and double-click the one you want.
If you still don't see the one you want, click My Templates, and, in the New dialog box that appears, double-click one of the custom templates.
If you want to download a template from Office Online, click a topic to see templates of that type that are available for download, and double-click the one you want.
If you want to use an existing document as the basis for a new document, click New From Existing, and locate and double-click the document in the New From Existing window that appears.
Templates are completely customizable and can come from a variety of sources, so you're likely to encounter substantial differences both in design and in ways you can complete a document based on a template. Try to choose a template that's easy to use and whose design is correct for your purposes.

Complete the document

If you aren't already in Print Layout view, click the Print Layout View button.
Save the document with the file name you want, in the location you want.
If the Show/Hide ¶ button on the Home tab isn't already turned on, click it so that you can see all the elements in the template.
If information such as the date is inserted automatically, don't modify the information—it was inserted using a Word field that's automatically updated and formatted.
Click a content control—in this case, an Address content control—and replace any placeholder text with your own text.
Don't delete any of the special design elements—doing so could ruin the layout of the document.
Complete the document, and then save, print, and distribute it.

A paragraph mark contains the paragraph's formatting, so don't delete a paragraph mark unless you want to remove that paragraph's elements from your document. When you delete a paragraph mark, any special formatting that was designed for that paragraph will be lost.

I want to share my experience with Microsoft Outlook Support and Computer Help

What's new in Word 2007?

2008-06-27T05:18:00.000-07:00

The first conspicuously new feature you'll encounter when you start Word will undoubtedly be the Ribbon, which is part of the new interface called Microsoft Office Fluent user interface. And if you've used previous versions of Word, you'll wonder where the menus and toolbars have gone. That's the beauty of the Ribbon. No longer do you have to wander through the maze of menus, submenus, and toolbars searching for what you want. On the Ribbon are all the commands, styles, and resources you need, arranged on task-oriented tabs. The one remaining toolbar is the Quick Access toolbar, where you can place your most frequently used commands and resources for easy access, regardless of which tab of the Ribbon is active.

Another part of the new Microsoft Office Fluent user interface interface is the galleries. These are the graphical equivalents of drop-down menus, except that they show you samples of all the choices that are available for you to “try on.” There are many different galleries—for styles, for themes, for page numbers, and so on. The galleries provide you with the ability to look before you leap. With Live Preview, you can see how the formatting you choose will change your text, pictures, or other content, or how the overall look of your document will change when you switch the theme simply by pointing to the different items in the galleries.

Some of the biggest changes you'll encounter are the new file types. Word uses a whole new file structure that, unfortunately, isn't directly compatible with earlier versions of Word. Of course, you can open and use files from earlier versions, but people who are using any earlier version of Word will need to download and install a converter so that they can open the documents you create using the Word 2007 file format. However, the good news is that the new file format is what enables many of the improvements in Word 2007.

Word 2007 also includes an entirely new graphics tool, SmartArt, which is designed to help you create diagrams and lists that graphically present your information. If you work with technical or legal documents into which you need to insert citations, a full bibliography, a list of works cited, or a legal table of authorities, you'll find that Word's bibliography and citations features are great new ways to take care of these often tedious and time-consuming chores.

And it's not only all the new stuff that's great. Some of Word's existing features have been much enhanced too. Checking your grammar and spelling has become more accurate, and you can now check the contextual use of words. If you're involved in mathematics, science, or engineering, you'll appreciate the enhanced Equations feature, which not only supplies some predesigned equations that you can edit but also makes it easy to create your own equations and save them for future use. Whether you need legal blacklining to indicate changes in a document or you need to track the changes reviewers make to your documents, you'll find the enhancements to the Track Changes feature—including the ability to distinguish between what has been added or deleted and what has been moved—really invaluable.

Word 2007 has also greatly improved document safety and security. You'll be better able to control access to your documents—for example, you can indicate when a document is completed and that no further changes may be made to it. You can easily check for and remove any sensitive or personal information in your documents that you don't want other people to have access to. You can digitally sign a document to provide verification in the electronic file that it really was you who signed it, and you can even attach a scanned image of your signature right there in the document. With Word's improved document-recovery system, your files are now more secure from loss, and the new file system also assists you in being able to recover files if they've become corrupted. And if you end up with system problems involving Word and your computer, you can easily run a series of diagnostics that can determine the problem and can then either fix it or get you the help you need to get it fixed.

I want to share information about Microsoft Outlook and all applicatio of Microsoft Office Like

Outlook Support

Email Support

Create charts in Excel 2007

2008-06-25T06:24:00.000-07:00

I want to share my experience with Outlook Support and Email Support, and continuing with some information about Microsoft Excel 2007.
Charts can convey much more than numbers alone can because charts present data in a visual way that makes it easier to see the meaning behind the numbers. And with the new charting capabilities in Microsoft Office Excel 2007, it's easier than ever to turn raw data into meaningful information.
Charts start with data. In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them in the dialog box — you don't have to spend time applying different selections to find the look you want. And when your chart is exactly the way you want it, you can save it as a template to use again, in Excel or in other 2007 Office system programs such as Word 2007.
Watch the demo to see how quickly and easily you can go from raw numbers to a powerful visual aid.

Proofing Tools of Power Point 2007

2008-06-23T01:34:00.000-07:00

The following are some new features of the spelling checker:
The spelling checker has been made more consistent across the 2007 Microsoft Office system programs. Examples of this change include the following:
Several spelling checker options are now global. If you change one of these options in one Office program, that option is also changed for all the other Office programs. For more information, see the article Choose how spelling and grammar checking work.
In addition to sharing the same custom dictionaries, all programs can manage them by using the same dialog box. For more information, see the article Use custom dictionaries to add words to the spelling checker.
The 2007 Microsoft Office system spelling checker includes the post-reform French dictionary. In Microsoft Office 2003, this was an add-in that had to be separately installed. For more information, see the article Choose how spelling and grammar checking work.
An exclusion dictionary is automatically created for a language the first time that language is used. Exclusion dictionaries let you force the spelling checker to flag words you want to avoid using. They are handy for avoiding words that are obscene or that don't match your style guide. For more information, see the article Use exclusion dictionaries to specify a preferred spelling for a word.
The spelling checker can find and flag some contextual spelling errors. Have you ever typed a mistake similar to the following? I will see you their. In Office PowerPoint 2007, you can enable the Use contextual spelling option to get help with finding and fixing this type of mistake. This option is available when you check the spelling of documents in English, German, or Spanish. For more information, see the article Choose how spelling and grammar checking work.
I want to share my experience with Microsoft Office Like
Outlook Support
Microsoft Outlook
And some thing about Email Support

Microsoft Office Communications Server

2008-06-18T23:42:00.000-07:00

Microsoft Office Communications Server 2007, OCS 2007, is an enterprise real-time communications server, providing the infrastructure to allow instant messaging, presence, audio-video conferencing and web conferencing functionality.
Client Software
Microsoft Office Communicator 2007 (MOC07) and Live Meeting console are the client side applications paired for use with OCS 2007. Microsoft Office Communicator leverages the OCS server to find, monitor, and communicate (instant messages, presence, and telephony) with other users within an organization.
Features
One basic use of Office Communications Server is instant messaging and presence within a single organization. This includes support for rich presence information, file transfer, instant messaging as well as voice and video communication. (These latter features are often not possible even within a single organisation using public IM clients, due to the effects of negotiating the corporate firewall and Network Address Translation).
OCS 2007 also supports remote users, both corporate users on the internet (e.g. home workers) as well as users in partner companies. OCS 2007 supports "federation" - enabling interoperability with other corporate IM networks. Federation can be configured either manually (where each partner manually configures the relevant edge servers in the other org) or based on use of the appropriate SRV records in the DNS.
Microsoft Office Communications Server uses the Session Initiation Protocol (SIP) for signaling along with the SIMPLE extensions to SIP for IM and presence. Media is transferred using RTP/SRTP. The Live Meeting client uses PSOM to download meeting content. The Communicator client also uses HTTPS to connect with the web components server to download address books, expand distribution lists, etc. By default, Office Communications Server encrypts all signaling and media traffic using SIP over TLS and SRTP. There is one exception to this - traffic between the Mediation Server and a basic media gateway is carried as SIP over TCP and RTP.
Compliance
OCS 2007 also has the capability to log and archive all instant message traffic passing through the server and to create Call Detail Records for conferences and voice. These features provide a measure of compliance, increasingly a legal requirement for many organizations, however the Archiving server is not an overall end-to-end compliance solution. Archiving requires you to install the Archiving Server and to configure front end servers accordingly.
Public IM Connectivity (PIC)
OCS 2007 also enables organizations to interoperate with the three of public IM providers: AOL, MSN, and Yahoo. PIC was first introduced with Service Pack 1 for Live Communications Server 2005, PIC is licensed separately.
I want to share my experience with Outlok Support and Email Support.

Office Excel 2007 product overview

2008-06-16T23:33:00.000-07:00

Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Office Excel 2007, combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server 2007, provides significant improvements for sharing data with greater security. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Office Excel 2007 and Excel Services, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.

I want to share my experience about Microsoft Office Outlook Support and Email Support.

Microsoft Office Word

2008-06-13T00:17:00.000-07:00

New style sheets (quick styles) and ability to switch easily among them.
Word count listed by default in the status bar. The word count dynamically updates as you type.
New contextual spell checker, signified by a wavy blue underline analogous to the traditional wavy red underline for misspellings and wavy green underline for grammar errors, sometimes catches incorrect usage of correctly spelled words, such as in "I think we will loose this battle".
Translation tool tip option available for English (U.S.), French (France), and Spanish (International Sort). When selected, hovering the mouse cursor over a word will display its translation in the particular language. Non-English versions have different sets of languages. Other languages can be added by using a separate multilingual pack.
Automated generation of citations and bibliographies according to defined style rules, including APA, Chicago, and MLA. Changing style updates all references automatically. Connect to web services to access online reference databases.
Rearchitected native mathematical equation support with TeX-like linear input/edit language or GUI interface. Also supports the Unicode Plain Text Encoding of Mathematics.
Preset gallery of cover pages with fields for Author, Title, Date, Abstract, etc. Cover pages follow the theme of the document (found under the Page Layout tab).
Document comparison engine updated to support moves, differences in tables, and also easy to follow tri-pane view of original document, new document, and differences.
Full screen reading layout that shows two pages at a time with maximal screen usage, plus a few critical tools for reviewing.
Document Inspector which strips Word documents of information such as author name and comments and other "metadata".
Building Blocks, which lets one save frequently used content, so that they are easily accessible for further use. Building blocks can have data mapped controls in them to allow for form building or structured document authoring.
The ability to save multiple versions of a document (which had existed since Word 97) has been removed.
Blog entries can be authored in Word itself and uploaded directly to a blog. Supported blogging sites include Windows Live Spaces, WordPress, SharePoint, Blogger, Community Server etc.

I will come back to more information about Microsoft Office like Outlook Support, Online Outlook Support and try to discuss about email support.

How to install individual 2007 Office features

2008-06-10T22:51:00.000-07:00

Typically, when you first try to use a feature that is not installed, the 2007 Office program installs the feature automatically. If the feature that you want is not automatically installed, follow these steps:

Exit all programs.

Click Start, and then click Control Panel.

Double-click Add or Remove Programs.

Click Microsoft Office Edition 2007, and then click Change.

Note In this option, Edition represents the Microsoft Office edition that is installed on the computer.

In the Microsoft Office Edition 2007 dialog box, click Add or Remove Features, and then click Continue.

Expand the program that you want to customize, click the icon to the left of the feature name, and then click one of the following installation options, as appropriate:

•	To install a feature immediately, click Run from My Computer.
•	To install a feature and all its sub features immediately, click Run all from My Computer.
•	To install a feature when it is requested for the first time, click Installed on First Use.
•	To remove a feature, click Not Available.

Click Continue.

I want to share my experience with Outlook Support and Email Support, you have any email problem you can get online email support.

Microsoft Office 2008 for Mac

2008-06-09T00:32:00.000-07:00

Microsoft office 2008 for Mac is the most recent version of the Microsoft Office productivity for suite for Mac OS X. It supersedes Office 2004 for Mac and is the Macintosh equivalent of office 2007, the latest version for Windows. It was developed by Microsoft’s Macintosh Business Unit and released on January 15, 2008.

Office 2008 for Mac was originally slated for release in the second half of 2007; however it was delayed until January 2008, citing the need to fix lingering bugs. Office 2008 is the first version of Office for Mac supplied as a Universal Binary.

Unlike Office 2007 for Windows, Office 2008 was not offered as a public beta before its scheduled release date.

Features

Office 2008 for Mac includes the same core programs currently included with Office 2004 for Mac: Entourage, Excel, PowerPoint and Word.

Mac-only features included are a publishing layout view, which offers functionality similar to Microsoft Publisher for Windows, a "Ledger Sheet mode" in Excel to ease financial tasks, and a "My Day" application offering a quick way to view the day's events.

Office 2008 supports the new Office Open XML format, and defaults to saving all files in this format. On February 21, 2008 Geoff Price revealed that the format conversion update for Office 2004 would be delayed until June 2008 in order to provide the first update to Office 2008.

Microsoft Visual Basic for Applications is not supported in this version. As a result such Excel add-ins as solver, which are dependent on VBA, were not bundled in this latest release. Excel in Office 2008 for the Mac also still lacks Pivot Chart functionality, which has long been a feature in the Windows version. Microsoft has announced that VBA will be making a return in the next version of Microsoft Office for Mac. AppleScript and the Open Scripting Architecture is, however, supported.

I want to share some thing my experience about Outlook Support, Online email support and Computer Help.

What is an Office Community?

2008-06-04T23:09:00.000-07:00

If you are unfamiliar with the ins and outs of conversing with others over the Internet, don't worry. Once you take the plunge and join in, you'll find that working with discussion groups is not as difficult as you might think.

An Office Community is an online forum where you can interact with fellow Office users, get your questions answered, share ideas, and learn more about the Office products and technologies that interest you. This interaction with fellow Office users takes place in discussion groups (also known as newsgroups).

A discussion group is a place on the Internet where people interact by posting and reading messages about topics that are of interest to them and the rest of a community. Discussion groups in the Office Communities are organized by Office program, such as the Outlook New Users discussion group. Each discussion group contains a number of discussion threads, each of which contains a series of related messages. Each individual message either responds to an earlier message, or addresses the overall discussion group topic in some way. In contrast to e-mail messages that are sent to specific individuals and visible only to them, messages posted in a discussion group are visible and available to anyone and everyone.

Note: I have to sketch out the details once again before this Monday for a official presentation. But then what i want to share here with you is my experience of sharing the Microsoft Outlook and providing computer Help.

Collaboration features of Office 2007

2008-06-03T23:54:00.000-07:00

SharePoint

Microsoft Office 2007 includes features geared towards collaboration and data sharing. As such, Microsoft Office 2007 features server components for applications such as Excel, which work in conjunction with SharePoint Services, to provide a collaboration platform. SharePoint works with Microsoft Office SharePoint Server 2007, which is used to host a SharePoint site, and uses IIS and ASP.NET 2.0. Excel server exposes Excel Services, which allows any worksheet to be created, edited and maintained via web browsers. It features Excel Web Access, the client-side component which is used to render the worksheet on a browser, Excel Calculation Service which is the server side component which populates the worksheet with data and perform calculations, and Excel Web Service that exposes Excel functionalities as individual web services. SharePoint can also be used to host Word documents for collaborative editing, by sharing a document. SharePoint can also be used to hold PowerPoint slides in a Slide Library, from which the slides can be used as a formatting template. It will also notify users of a slide automatically in case the source slide is modified. Also by using SharePoint, PowerPoint can manage shared review of presentations. Any SharePoint hosted document can be accessed from the application which created the document or from other applications such as a browser or Microsoft Office Outlook.

Groove

Microsoft Office Groove 2007

Microsoft Office 2007 also includes Groove, which brings collaborative features to a peer-to-peer paradigm. Groove can host documents, including presentations, workbooks and others, created in Microsoft Office 2007 application in a shared workspace, which can then be used in collaborative editing of documents. Groove can also be used in managing workspace sessions, including access control of the workspace. To collaborate on one or more documents, a Workspace has to be created, and then those who are to work on it have to be invited. Any file shared on the workspace are automatically shared among all participants. The application also provides real-time messaging, including one-to-one as well as group messaging, and presence features, as well as monitoring workspace activities with alerts, which are raised when pre-defined set of activities are detected. Groove also provides features for conflict resolution for conflicting edits. Schedules for a collaboration can also be decided by using a built-in shared calendar, which can also be used to keep track of the progress of a project. However, the calendar is not compatible with Microsoft Outlook.

Themes and Quick Styles

Microsoft Office 2007 places more emphasis on Document Themes and Quick Styles. The Document Theme defines the colors, fonts and graphic effects for a document. Almost everything that can be inserted into a document is automatically styled to match the overall document theme creating a consistent document design. The new Office Theme file format (.THMX) is shared between Word, Excel, PowerPoint and Outlook email messages. Similar themes are also available for data reports in Access and Project or shapes in Visio. Quick Styles are galleries with a range of styles based on the current theme. There are quick styles galleries for text, tables, charts, SmartArt, WordArt and more. The style range goes from simple/light to more graphical/darker.

File formats of Office 2007

2008-06-01T22:51:00.000-07:00

Office Open XML

Microsoft Office uses a new file format, called Office Open XML, as the default file format. Word documents (without macro extensions) are now saved using a .docx extension rather than the traditional .doc extension. Word 2007 can also save documents in the old format which is compatible with previous versions of Word. In addition, Microsoft has made available a free add-on known as the "Microsoft Office Compatibility Pack" that lets Office 2000-2003 editions open, edit, and save documents created under the new 2007 format.

Office Open XML is based on XML and uses the ZIP file container. According to Microsoft, documents created in this format are up to 75% smaller than the same documents saved with previous Microsoft Office file formats, owing to data compression.[18] Microsoft Office Excel and Microsoft Office PowerPoint also use the new OOXML file formats. Word files containing macros are saved with the extension .docm.

PDF

Microsoft had initially announced that it will support exporting to Portable Document Format (PDF) in Office 2007. However, due to legal objections from Adobe Systems, Office 2007 does not have PDF support out of the box, but offers it rather as a separate free download

XPS

Office 2007 documents can also be exported as XPS documents; via another free plug-in that is also a separate download.

Open Document

Microsoft backs an open-source effort to support Open Document in Office 2007, as well as earlier versions (up to Office 2000), through a converter add-in for Word, Excel and PowerPoint, and also a command-line utility.[21] As of 2008, the project supports conversion between ODF and Office Open XML file formats for all three applications.

User assistance system

In Microsoft Office 2007, the Office Assistants have been completely removed because of the much-improved help system. One feature of the new help system is the extensive use of Super Tooltips which explains in about one paragraph what each function performs. Some of them also use diagrams or pictures. These appear and disappear like normal tooltips, and replace normal tooltips in many areas. The Help content also directly integrates searching and viewing Office Online articles.

New Feature of Office 2007

2008-05-27T22:56:00.000-07:00

User interface

The new user interface (UI), officially known as Microsoft Office Fluent, has been implemented in the core Microsoft Office applications: Word, Excel, PowerPoint, Access, and in the item inspector used to create or edit individual items in Outlook. These applications have been selected for the UI overhaul because they center around document authoring. The rest of the applications in the suite will also be upgraded to the new UI in subsequent versions. The default font used in this edition is Calibri. Original prototypes of the new user interface were revealed at MIX 2008 in Las Vegas

Office button

The Office 2007 button, located on the top-left of the window, replaces the File menu and provides access to functionality common across all Office applications, including but not limited to opening, saving, printing, and sharing a file. It can also close the application. Users can also choose color schemes for the interface.

Ribbon

The Ribbon, a panel that houses the command buttons and icons, organizes commands as a set of Tabs, each grouping relevant commands. Each application has a different set of tabs which expose the functionality that application offers. For example, while Excel has a tab for the Graphing capabilities, Word does not feature the same; instead it has tabs to control the formatting of a text document. Within each tab, various related options may be grouped together. The Ribbon is designed to make the features of the application more discoverable and accessible with fewer mouse clicks. as compared to the menu-based UI used until Office 2007. It is not possible to remove the Ribbon, modify it, or replace it with menus with the normal Office 2007 functions. However, the Ribbon can be minimized simply by double clicking the active section's title, e.g the Home text in the picture below. There are third party add-ons that can bring menus to Office 2007.

Contextual Tabs

Some tabs, called Contextual Tabs, appear only when certain objects are selected. Contextual Tabs expose functionality specific only to the object with focus. For example, selecting a picture brings up the Pictures tab, which presents options for dealing with the picture. Similarly, focusing on a table exposes table-related options in a specific tab. Contextual Tabs remain hidden when the object it works on are not selected.

Live Preview

Microsoft Office 2007 also introduces a feature called "Live Preview", which temporarily applies formatting on the focused text or object when any formatting button is moused-over. The temporary formatting is removed when the mouse pointer is moved from the button. This allows users to have a preview of how the option would affect the appearance of the object, without actually applying it.

Mini Toolbar

The new "Mini Toolbar" is a type of context menu that is automatically shown (by default) when text is selected. The purpose of this feature is to provide easy access to the most-used formatting commands without requiring a right-mouse-button click, as was necessary in older versions of the software. Because the Mini Toolbar is automatically displayed, it remains semi-transparent until the mouse pointer is situated on the control in order to allow an almost-unobstructed view of what is beneath it. It also appears above the right-click menu when a user right-clicks on a selection of words. The Mini Toolbar is currently not customizable.

Quick Access Toolbar

The Quick Access toolbar, which sits in the title bar, serves as a repository of most used functions, regardless of which application is being used, such as save, undo/redo and print. The Quick Access toolbar is fully customizable similar to toolbars in previous Office versions. Any command available in the entire Office application can be added to the Quick Access toolbar, including commands not available in the Ribbon and macros. Keyboard shortcuts for any of the commands on the toolbar are also fully customizable, similar to previous Office versions.

I have to sketch out the details once again before this Monday for a official presentation. But then what i want to share here with you is my experience of sharing the Microsoft office support and providing Computer Help

Microsoft Office Version Compatibility

2008-05-22T02:00:00.000-07:00

Latest versions for platforms

Windows NT 3.51-Office 97
Windows 95-Office 2000
Windows NT4/98/ME-Office XP
Windows 2000-Office 2003
Windows XP/2003/Vista/Home Server/2008-Office 2007
Mac OS 7.5-8.0-Office 98
Mac OS 8.1-9-Office 2001
Mac OS 10.1-Office X
Mac OS 10.2-10.3-Office 2004
Mac OS 10.4-10.5-Office 2008

Windows

Beginning in 2002, Microsoft instituted a policy of Support Lifecycles including: Earlier versions than Office 97 (including Outlook 97) are no longer supported.

Office 97 (including Outlook 98) – Mainstream hotfix support ended on August 31, 2001. Extended hotfix support ended on February 28, 2002. Assisted support ended on January 16, 2004.
Office 2000 – Mainstream support ended June 30, 2004. Extended support will end on July 14, 2009.
Office XP – Mainstream support ended July 11, 2006. Extended support will end on July 12, 2011.
Office 2003 - Mainstream support will end on April 14, 2009. Extended support will end on April 8, 2014.
Office 2007 - Mainstream support will end on April 10, 2012. Extended support will end on April 11, 2017.
Current and future versions - Mainstream support will end 5 years after release, or 2 years after the next release, whichever time is later, and extended support will end 5 years after that.

I have to sketch out the details once again before this Monday for a official presentation. But then what i want to share here with you is my experience of sharing the Microsoft Office and providing computer Help

Discontinued applications and features

2008-05-15T00:00:00.000-07:00

Microsoft Binder – Incorporates several documents into one file and was originally designed as a container system for storing related documents in a single file. The complexity of use and learning curve led to little usage and was removed from releases after Office 2000.
Microsoft FrontPage – Web design software (also requires its own server program for some functionality). Offered only as a stand-alone program for the 2003 version. In 2006, Microsoft announced that this was to be discontinued and to be replaced by two different software packages: Microsoft SharePoint Designer and Microsoft Expression Web.
Microsoft Mail – Mail client (in old versions of Office, later replaced by Microsoft Schedule Plus and subsequently Microsoft Outlook).
Microsoft PhotoDraw – A graphics program that was first released as part of the Office 2000 Premium Edition. A later version for Windows XP compatibility was released, known as PhotoDraw 2000 Version 2. Microsoft discontinued the program in 2001.
Microsoft Photo Editor – Photo-editing/raster-graphics software in older Office versions up to Office XP. It was supplemented by Microsoft PhotoDraw in Office 2000 Premium edition.
Microsoft Schedule Plus – Released with Office 95. It featured a planner, to-do list, and contact information. Its functions were incorporated into Microsoft Outlook.
Microsoft Virtual PC – Included with Microsoft Office Professional Edition 2004. Obsolete from 2006 onward due to new Macs possessing the same Intel architecture as Windows PCs. It emulated a standard PC and its hardware.
Microsoft Vizact 2000 – A program that "activated" documents using HTML, adding effects such as animation. It allows users to create dynamic documents for the Web. Development has ended due to unpopularity.
Microsoft Data Analyzer 2002 – A business intelligence program for graphical visualization of data and its analysis.
Office Assistant, included since 1997 as a part of Microsoft Agent technology, is a system that uses animated characters to offer unrequested context-sensitive suggestions to users and access to relevant parts of the help system. The Assistant is often dubbed "Clippy" or "Clippit," due to its default to a paper clip character, coded as CLIPPIT.ACS. The Office Assistant was hidden by default in Office XP and following mixed public response, not installed by default in Office 2003. It has been removed entirely in Office 2007.

Support lifecycle of Microsoft Office

2008-05-11T22:02:00.000-07:00

Windows

Beginning in 2002, Microsoft instituted a policy of Support Lifecycles including:

Earlier versions than Office 97 (including Outlook 97) are no longer supported.
Office 97 (including Outlook 98) – Mainstream hotfix support ended on August 31, 2001. Extended hotfix support ended on February 28, 2002. Assisted support ended on January 16, 2004.
Office 2000 – Mainstream support ended June 30, 2004. Extended support will end on July 14, 2009.
Office XP – Mainstream support ended July 11, 2006. Extended support will end on July 12, 2011.
Office 2003 - Mainstream support will end on April 14, 2009. Extended support will end on April 8, 2014.
Office 2007 - Mainstream support will end on April 10, 2012. Extended support will end on April 11, 2017.
Current and future versions - Mainstream support will end 5 years after release, or 2 years after the next release, whichever time is later, and extended Computer support will end 5 years after that.

Common features of Microsoft Office

2008-05-06T22:48:00.000-07:00

Most versions of Microsoft Office (including Office 97 and later, and possibly 4.3) use their own widget set and do not exactly match the native operating system. This is more apparent in the 2002 or XP release of Microsoft Office where the standard menus were replaced with a colored flat looking, shadowed menu style. Similarly, Microsoft Office 2007 introduces a whole new widget system, dubbed "Ribbon", but now known as the "Fluent user interface". ^[5] The same widget used in Microsoft Office is also used in the Visual Studio product line, though the "Fluent UI" was not announced to be included in future versions of Visual Studio. Both Windows and Office use "Service Packs" to update software, Office used to release non-cumulative "Service Releases", which were discontinued after Office 2000 Service Release 1.

Programs in past versions of Office often contained substantial Easter eggs. For example, Excel 97 contained a reasonably functional flight-simulator. Versions since Office 2000 have not contained any easter eggs in the name of Trustworthy Computing.

Microsoft Office Server applications

2008-05-02T01:46:00.000-07:00

Microsoft Office Share Point Server - collaboration server

Excel Services
InfoPath Forms Services

Microsoft Office Communications Server (formerly Live Communications Server) - real time communications server
Microsoft Office Forms Server - allows InfoPath forms to be accessed and filled out using any browser. Office Forms Server is a standalone server installation of InfoPath Forms Services.
Microsoft Office Groove Server - centrally managing all deployments of Microsoft Office Groove in the enterprise
Microsoft Office Project Server - project management server
Microsoft Office Project Portfolio Server - allows creation of a project portfolio, including workflows, hosted centrally
Microsoft Office Performance Point Server - allows customers to monitor, analyze, and plan their business

Other desktop applicationsm of Microsoft Office

2008-04-28T23:02:00.000-07:00

Microsoft Publisher – software for creating newsletters, business cards, flyers, greeting cards or even postcards.
Microsoft InfoPath – an application to design rich XML-based forms.
Microsoft OneNote – Note-taking software for use with tablet PCs or regular PCs.
Microsoft Office SharePoint Designer – a WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage (it is not bundled in any Office 2007 suite).
Microsoft Project – Project management software to keep track of events and to create network charts and Gantt charts (it is not bundled in any Office 2007 suite).
Microsoft Visio – Diagram and flowcharting software (it is not bundled in any Office 2007 suite).
Microsoft Office Accounting – a tool for managing business finances (it is not bundled in any Office 2007 suite, except for the Express edition).
Microsoft Office Communicator – Integrated communications client for conferences and meetings in real time (Is bundled with Office 2007 Professional Plus and Enterprise 2007).
Microsoft Office Document Imaging – an application that supports editing scanned documents.
Microsoft Office Document Scanning – a scanning and OCR application.
Microsoft Office Groove – a proprietary peer-to-peer software package aimed at businesses.
Microsoft Office InterConnect – Business-relationship database available only in Japan.
Microsoft Office Picture Manager – Basic photo management software (similar to Google's Picasa or Adobe's Photoshop Elements). Replaced Microsoft Photo Editor.

Component of Microsoft Office Desktop Application

2008-04-24T02:30:00.000-07:00

Microsoft Office Outlook

Hi, I am continue with another post about Microsoft Office Outlook, Access and I want to share my experience with Computer Support and Computer issue.

Microsoft Outlook (full name Microsoft Office Outlook since Outlook 2003) is a personal information manager from Microsoft, and is part of the Microsoft Office suite.

Although often used mainly as an e-mail application, it also provides a calendar, task and contact management, note taking, a journal and web browsing.

It can be used as a stand-alone application, but can also operate in conjunction with Microsoft Exchange Server and Microsoft Office SharePoint Server to provide enhanced functions for multiple users in an organization, such as shared mailboxes and calendars, Exchange public folders, Sharepoint lists and meeting time allocation.

Microsoft Outlook, not to be confused with Outlook Express, is a personal information manager and e-mail communication software. The replacement for Windows Messaging, Microsoft Mail and Schedule+ (Plus) starting in Office 97, it includes an e-mail client, calendar, task manager and address book. Although historically it has been offered for the Mac, the closest to an equivalent for Mac OS X is Microsoft Entourage, which offers a slightly different feature set.

Microsoft Office Access

Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system.

Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container (including MySQL and PostgreSQL). Skilled software developers and data architects use it to develop application software. Relatively unskilled programmers and non-programmer "power users" can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool.

Access was also the name of a communications program from Microsoft, meant to compete with ProComm and other programs. This proved a failure and was dropped. Years later Microsoft reused the name for its database software.

Component of Microsoft Office Desktop Application

2008-04-21T22:22:00.000-07:00

Microsoft Word

Microsoft Word is a word processor and was long considered to be the main program of Office, although with the rise of electronic communication that distinction has now passed to Outlook. Word possesses a dominant market share in the word processor market. Its proprietary DOC format is considered a de facto standard, although its most recent version, Word 2007 can also use a new XML-based, Microsoft Office-optimized format called .DOCX which has been standardized by ECMA as Office Open XML. Word is also available in some editions of Microsoft Works. It is available for the Windows and Mac platforms. The first version of Word, released in the fall of 1983, was for the DOS operating system and had the distinction of introducing the mouse to a broad population. Word 1.0 could be purchased with a bundled mouse, though one was not required. The following spring Apple introduced the Mac, and Microsoft released Word for the Mac, which became the most popular Mac application and which, like all Mac apps, required the use of a mouse.

Microsoft Excel

Microsoft Excel is a spreadsheet program. Like Word, it possesses a dominant market share. It was originally a competitor to the dominant, but it eventually outsold it and became the de facto standard. It is available for the Windows and Mac platforms. The current Mac version (Office 2008) has removed Visual Basic functionality so macros cannot be used and those generated in previous iterations of Office no longer work.

Microsoft PowerPoint

Microsoft PowerPoint is a popular presentation program for Windows and Mac. It is used to create slideshows, composed of text, graphics, movies and other objects, which can be displayed on-screen and navigated through by the presenter or printed out on transparencies or slides. This is convenient for school or work presentations.Office Mobile for Windows Mobile 5.0 and later features a version of PowerPoint called PowerPoint Mobile. It also possesses a dominant market share. Movies, videos, sounds and music, as well as wordart and autoshapes can be added to slideshows. It is available for the Windows and Mac platforms.

Introduction to Microsoft Office

2008-04-16T22:21:00.000-07:00

Microsoft Office is a set of interrelated desktop applications, servers and services, collectively referred to as an office suite, for the Microsoft Windows and Mac OS X operating systems. Office was introduced by Microsoft in 1989 on Mac OS, with a version for Windows in 1990. Initially a marketing term for a bundled set of applications, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Additionally, a "Pro" version of Office included Microsoft Access and Schedule Plus. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications (OBA) brand.

The current versions are Office 2007 for Windows, launched on January 30, 2007 and Office 2008 for Mac OS X, released January 15, 2008. Office 2007/Office 2008 features a distinct user interface and a new XML-based primary file format. There is no current version for Mac OS Classic.