Welcome to My Office Power

Are you still not concern with Ms Office Just see Ms Office Movie

noreply@blogger.com (Admin) — Mon, 15 Nov 2010 21:43:00 +0000

Hey guys do you believe this Ms Office movie!!! yes it's true Movie on Ms Office 2010

I was amazed and happy to see a movie on ms office which could be a good impact on the brains of dummies of the globe. An ex-poser to ms office hopefully create new users around the world. Dont watch it just as a movie this is something you can use it feel it and realise it. Just do it to believe it. :)

Enjoy Ms Officing!!

Get started on your job hunt with Word templates

noreply@blogger.com (Admin) — Wed, 10 Nov 2010 20:23:00 +0000

Applies to Ms Word 2002 and 2003

Looking for a new job can be challenging, but sometimes a tiny boost can give you a huge head start. You can find the boost you need at the Templates on Microsoft Office Online Web site, which offers hundreds of preformatted templates and example documents that you can download to use with Microsoft Office 2003 and Microsoft Office XP.

By using templates that are designed just for your job search — including resumes, cover letters, and letters of acceptance — you can avoid the overwhelming task of starting with a blank page. Templates give you a starting point as you modify job information to match your own experience. The formatting and layout are already done, so you can focus instead on the words and content that really make you stand out.

Use templates from the Office Templates site

Click one of the links listed, or find a template that you want to use on the Office Templates Web site.
When you find the template that you want, click the Download Now button to download the template. A new document, based on the selected template, opens in Word.
To save the document to your computer, click Save As on the File menu.
You can now edit and customize the document.

Resumes for any style, experience, or situation

You can choose from hundreds of resume templates to find the style, employment background, or specific situation that has led you to look for a new job.
You can find resumes for specific situations — for example, if you are a high school graduate and have previous work experience, if you want to transfer to a different department within your company, or if you are looking for advancement in your career. You can also find templates that are tailored for particular positions or fields, or you can choose templates that are formatted with different styles and themes

Transfer within company resume
Audio/visual production specialist resume
Chronological resume (Blue Line theme)
Functional resume emphasizing education
Legal firm accountant resume

Note The following templates are for Word 2003 only:
Chronological resume (Traditional theme)
Functional resume (Minimalist theme)

Letters of reference

In addition to cover letters, there are templates to help you secure letters of reference. You can ask former employers for letters of recommendation. Then you can send them thank-you letters. You may even want to point your references to the list of templates for employee reference letters.
Request for reference from ex-boss
Note The following templates are for Word 2003 only:
Reference list
Request for reference from manager

Following up

After you send out a stellar resume and cover letter with references, and you interview for the position, a template can help with your interview follow-up. You can also get started preparing letters to respond to job offers.
Follow-up to cover letter and resume submission
Withdrawal from consideration for open position
Note The following templates are for Word 2003 only:
Thank-you for interview
Acceptance of job offer
Thank-you for successful reference

source: office.microsoft.com

Spirograph in Excel

noreply@blogger.com (Admin) — Thu, 28 Oct 2010 01:49:00 +0000

Besides excel's excellent features there is yet another face of excel which amuses every excel user with fun and games in ms excel. Take a look at the fun of spirographing in excel. Hope you will enjoy this post.

This is a fun little spreadsheet that lets you create a spirograph. Try playing with the slider bar and modifying some of the parameters to change scaling and the number of "spokes".

Download Now

source: vertex42.com

OffiSync integrates Google Docs with Microsoft Office

noreply@blogger.com (Admin) — Sun, 17 Oct 2010 21:36:00 +0000

Seattle startup has done what two giant companies haven’t done: get Google Docs to work well with Microsoft’s Office software.

OffiSync, a self-funded startup run by entrepreneur Oudi Antebi, has created an Office add-on that integrates Google Docs, Google Apps and Google search into Microsoft office. When you open up Microsoft Word, for instance, you can see the Google functions on the menu, as if they were a Google toolbar. The software will be available as a beta download today.

Microsoft is slowly moving in this direction. It has promised to integrate software and services into the Office suite by 2010 to give the desktop software more features that make it seem like a cloud-based solution. When Antebi heard that was the plan a year ago, he decided to hire a bunch of contractors and do it himself.

“We are Googleizing Microsoft Office,” he said in an interview.

OffiSync works with Microsoft Office 2003 or Office 2007, and it will be available for the Mac in the future. It supports Word, Excel or PowerPoint documents. One of the best features is desktop-web synchronization. You can save a document to the desktop using Office, or you can tap Google Docs to make that document available on the web.

Antebi showed me a demo of the software, and I could clearly see that the Office document he was working on could be saved as a Google Doc on the web, stored somewhere in Google’s cloud where a user could access it from any web-based computer. You can work on either document at high speed, since Antebi’s software caches a version of it in local memory.

You can also use Google search from the Office toolbar to find any of your Google Docs documents in a matter of seconds, and you can collaborate with someone else at the same time, as is possible with Google Docs but not with the desktop version of Office. When Microsoft launches Office 2010, customers will need to get that version to use Office on the web.

But Oudi’s ambition is to make it so that no one needs to upgrade to Office 2010 in order to get Google Docs-style web functionality in Office. That means there might be half a billion Office users wondering if they have to upgrade to Office 2010 at all.

After the initial release, Antebi said OffiSync will add more features for real-time collaboration, better search integration, and additional Google services (perhaps Google Maps). Google Docs debuted in 2006, but it’s surprising that Google itself hasn’t done this integration yet. Others have tried to do this. DocSyncer tried, but it shut its doors last year.

OffiSync will be free for individuals, but a paid enterprise version will debut later to let large businesses work in a mixed Google Docs/Office environment. Antebi said thousands of people have already signed up for the beta. Here’s a video of it.

source: www.venturebeat.com

Microsoft's Office moves online

noreply@blogger.com (Admin) — Sun, 17 Oct 2010 21:12:00 +0000

The new suite of web applications will massively extend the reach of Office 2010, but is it enough to make businesses upgrade?

________________________________________________________________________________

Stephen Elop, president of the Microsoft Business Division, introduces new capabilities for Office 2010 at the Worldwide Partner Conference 2009

Microsoft is finally putting versions of its Office applications suite online, as part of its move to Office 2010. The new Office Web Applications, demonstrated on video, don't have all the capabilities of desktop versions, but do feature the ribbon-based user interface. They seem to be far more powerful than Google's three-year-old online applications, and should offer much better compatibility with Microsoft Office files.

The suite of Office Web Applications - Word, Excel, PowerPoint and OneNote - will be available to consumers, free of charge, as part of Microsoft's Windows Live service, which has more than 400 million users, thanks mainly to the popularity of Hotmail. However, they are not limited to Windows users: Microsoft demonstrated them running in Firefox and Apple's Safari browser.

Small businesses will also be able to use the online versions as part of Microsoft's cloud-based subscription service Business Productivity Online Suite, while large companies will be able to host them on in-house servers, as well as running desktop versions of Office. Chris Adams, an Office product manager at Microsoft UK, says it offers "the ultimate choice". Customers can decide how much they want to do on the desktop and how much online, and they can either control the service or have it managed for them.

Office Web Applications can also be used with any mobile phone that has a compatible microbrowser.

When it comes to the desktop, Office 2010 is completing the migration to the Fluent user interface introduced with Office 2007. The new versions of Outlook, OneNote, Publisher and SharePoint Server now have ribbon-based interfaces, which can be customised.

As with Windows 7, Microsoft is reducing the number of different packages. When it appears next year, Office 2010 will be offered in five versions, but only three will be available to consumers. The Office Home and Student edition comprises Word, PowerPoint, Excel and OneNote, while the Home and Business edition has Outlook as well. The Professional version also includes Access and Publisher.

Anti-piracy price point

Adams says the Home and Student version of Office 2007 has done well, with amazon.com selling a copy every 20 seconds. Amazon sells a three-user package for $90; it's currently £66.69 in the UK, which should be cheap enough to limit piracy.

Microsoft's Business Division, which includes Office, generated $19bn in sales in fiscal 2008, and $12bn in operating profits. There are fears that Microsoft's cash cow could lose sales to the online versions, which could account for the company's tardiness in adding a web-based Office.

But the industry analyst Tom Austin, chief of research (software) at Gartner, reckons that by introducing cloud services, Microsoft "will generate more revenue than licences alone did. Albeit, the new revenue will come at a lower profit level, but it will be incremental to the bottom line." He says "the 'free stuff' on the web is a spoiler to slow down Google's market penetration ... and a teaser" that will attract paying customers to the cloud-based offerings.

With the launch of Azure, supported by huge new data centres, Microsoft is investing massively in a move to cloud computing.

Another worry is that the online services will cut out the middleman and lead to conflict with Microsoft's partners - and Microsoft makes more than 95% of its revenues via more than 640,000 partners. While the most obvious ones are PC manufacturers, many more are employed in building applications for Microsoft products, and selling, installing, customising, managing and supporting them.

It's not a coincidence that Microsoft made its Office 2010 announcements at its Worldwide Partner Conference in New Orleans, Louisiana, on Monday - it needs to keep these partners happy.

Catering for customers

The long-time Microsoft watcher Joe Wilcox says his first reaction to the videos of Office Web Applications was "So what? Everything's about preserving Microsoft's application stack" - the end-to-end connection of Windows and Office, back-office servers such as Exchange and SharePoint, and online services based on Azure - "and that's going to be replaced by the mobile phone going straight to the server," he says. He thinks Microsoft is "catering for old-style customers, and helping them to move forward".

To keep its "application stack" in sync, Microsoft also likes to sell new versions of Office with new versions of Windows for desktops and servers. Can Office 2010 help drive Windows 7 upgrades?

"They're not going to be released together, but that doesn't matter," says Wilcox. "Businesses are going to take a long time to test before they deploy them anyway. But I'm surprised there's not more synergy between the two, and there's no sign of it around things like the touch interface [in Windows 7]. But just because we've not heard about it, doesn't mean it's not going to happen."

If businesses started a new "refresh cycle" by installing new PCs running Windows 7 and Office 2010, a depressed computer industry would be grateful. It didn't happen with Vista and Office 2007, so many business PCs must be getting old and expensive to maintain. However, most companies are probably more concerned with reducing costs and holding on to cash, so make-do-and-mend seems more likely.

Whether the economic scene will have changed next year, when Office 2010 finally ships, remains to be seen. But Microsoft isn't the only company that hopes so.

source : www.guardian.co.uk

Get Every Thing Free from OpenOffice

noreply@blogger.com (Admin) — Sun, 10 Oct 2010 02:36:00 +0000

OpenOffice.org 3 is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.

Even the Microsoft People doesn't Know about this!!

noreply@blogger.com (Admin) — Fri, 01 Oct 2010 05:04:00 +0000

Hi you might have shocked to read this post headline, I really don't know if it is true but of course there is a magic in Ms word which i have not yet heared or seen even on ms site, why it happens in Ms word ?

It is said that, even the Microsoft people don't know about this why and how it happens. Just try it and see the magic. Dont worry by doing this nothing will happen to your

computer nor the Ms word application just do the following

Open Microsoft Word and type

=rand (200, 99)

And then press ENTER

Then see the magic…

Calculate a weighted average

noreply@blogger.com (Admin) — Thu, 23 Sep 2010 19:54:00 +0000

To do this task, use the SUMPRODUCT and SUM functions.
This example calculates the average price paid for a unit across three purchases, where each purchase is for a different number of units at a different price per unit.

	A	B
	Price per unit	Number of units
1	20	500
2	25	750
3	35	200
	Formula	Description (Result)
	=SUMPRODUCT(A2:A4,B2:B4)/SUM(B2:B4)	Divides the total cost of all three orders by the total number of units ordered (24.66)

This post is brought to you from the microsoft website

Excel Cell Formating

noreply@blogger.com (Admin) — Mon, 14 Dec 2009 09:44:00 +0000

Today I would like to present you some tips on excel formatting;

1. Formatting an excel cell to Text, Number, Date
, Time, Currency, Accounting, special or custom.

Select any excel cell and then on the menu click on Format then click
on cell you can also use shortcut to open the cell formatting box directly
by holding Ctrl+1 key, as shown in the following figure.

As in the above figure
you can see Category box from where you can change the cell format to your
desired format. You can do lot more than format in an excel cell. Make
your excel cell a digital clock or digital image viewer, whatever you want
just imagine and do it by using all the advanced features of cell
formatting to know more about how to do it just give a comment to
this post.

Powerpoint Slide Designs

noreply@blogger.com (Admin) — Fri, 13 Nov 2009 13:20:00 +0000

Powerpoint Slide Designs!

Hey find stunning exciting powerpoint slide designs and template simply download and enjoy from the creator and the king softwares Microsoft. I have visited many sites in search of power point slide shows back grounds and etc etc. I found it as the best please check visit this site of microsoft.
http://office.microsoft.com/en-us/templates/CT101427471033.aspx?av=ZPP000 . hope you will find it usefull too!!. look the below slide.

Microsoft Word shortcut keys

noreply@blogger.com (Admin) — Thu, 29 Oct 2009 19:31:00 +0000

Below is a listing of all the major shortcut keys in Microsoft Word.

Shortcut Keys	Description
Ctrl + A	Select all contents of the page.
Ctrl + B	Bold highlighted selection.
Ctrl + C	Copy selected text.
Ctrl + E	Aligns the line or selected text to the center of the screen.
Ctrl + F	Open find box.
Ctrl + I	Italic highlighted selection.
Ctrl + J	Aligns the selected text or line to justify the screen.
Ctrl + K	Insert link.
Ctrl + L	Aligns the line or selected text to the left of the screen.
Ctrl + M	Indent the paragraph.
Ctrl + P	Open the print window.
Ctrl + R	Aligns the line or selected text to the right of the screen.
Ctrl + T	Create a hanging indent.
Ctrl + U	Underline highlighted selection.
Ctrl + V	Paste.
Ctrl + X	Cut selected text.
Ctrl + Y	Redo the last action performed.
Ctrl + Z	Undo last action.
Ctrl + Shift + F	Change the font.
Ctrl + Shift + >	Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]	Increase selected font +1pts.
Ctrl + Shift + <	Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [	Decrease selected font -1pts.
Ctrl + Shift + *	View or hide non printing characters.
Ctrl + <left arrow>	Moves one word to the left.
Ctrl + <right arrow>	Moves one word to the right.
Ctrl + <up arrow>	Moves to the beginning of the line or paragraph.
Ctrl + <down arrow>	Moves to the end of the paragraph.
Ctrl + Del	Deletes word to right of cursor.
Ctrl + Backspace	Deletes word to left of cursor.
Ctrl + End	Moves the cursor to the end of the document.
Ctrl + Home	Moves the cursor to the beginning of the document.
Ctrl + Spacebar	Reset highlighted text to the default font.
Ctrl + 1	Single-space lines.
Ctrl + 2	Double-space lines.
Ctrl + 5	1.5-line spacing.
Ctrl + Alt + 1	Changes text to heading 1.
Ctrl + Alt + 2	Changes text to heading 2.
Ctrl + Alt + 3	Changes text to heading 3.
Ctrl + F1	Open the Task Pane.
F1	Open Help.
Alt + Ctrl + F2	Open new document.
Ctrl + F2	Display the print preview.
Shift + F3	Change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert	Paste.
F4	Repeat the last action performed (Word 2000+)
F5	Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6	Opens to another open Microsoft Word document.
F7	Spell and grammar check selected text and/or document.
Shift + F7	Runs a Thesaurus check on the word highlighted.
F12	Save as.
Shift + F12	Save.
Ctrl + Shift + F12	Prints the document.
Alt + Shift + D	Insert the current date.
Alt + Shift + T	Insert the current time.

In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.

Mouse shortcuts	Description
Click, hold, and drag	Selects text from where you click and hold to the point you drag and let go.
Double-click	If double-click a word, selects the complete word.
Double-click	Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-click	Double-clicking anywhere after text on a line will set a tab stop.
Triple-click	Selects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheel	Zooms in and out of document.

Relative and Absolute Cell References

noreply@blogger.com (Admin) — Mon, 19 Oct 2009 09:35:00 +0000

Relative and Absolute Cell References

Excel uses two types of cell references to create formulas. Each has its own purpose. Read on to determine which type of cell reference to use for your formula.

Relative Cell References

This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.

Example:

=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.

Absolute Cell References

Situations arise in which the cell reference must remain the same when copied or when using AutoFill. Dollar signs are used to hold a column and/or row reference constant.

Example:

In the example below, when calculating commissions for sales staff, you would not want cell B10 to change when copying the formula down. You want both the column and the row to remain the same to refer to that exact cell. By using $B$10 in the formula, neither changes when copied.

A more complicated example:

Let's pretend that you need to calculate the prices of items in stock with two different price discounts. Take a look at the worksheet below.

Examine the formula in cell E4. By making the first cell reference $C4, you keep the column from changing when copied across, but allow the row to change when copying down to accommodate the prices of the different items going down. By making the last cell reference A$12, you keep the row number from changing when copied down, but allow the column to change and reflect discount B when copied across. Confused? Check out the graphics below and the cell results.

Copied Across

Copied Down

Now, you might be thinking, why not just use 10% and 15% in the actual formulas? Wouldn't that be easier? Yes, if you are sure the discount percentages will never change - which is highly unlikely. It's more likely that eventually those percentages will need to be adjusted. By referencing the cells containing 10% and 15% and not the actual numbers, when the percentage changes all you need to do is change the percentage one time in cell A12 and/or B12 instead of rebuilding all of your formulas. Excel would automatically update the discount prices to reflect your discount percentage change.

Summary of absolute cell reference uses:

$A1	Allows the row reference to change, but not the column reference.
A$1	Allows the column reference to change, but not the row reference.
$A$1	Allows neither the column nor the row reference to change.

There is a shortcut for placing absolute cell references in your formulas!

When you are typing your formula, after you type a cell reference - press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities. For example, in the first absolute cell reference formula in this tutorial, =B4*$B$10, I could have typed, =B4*B10, then pressed the F4 key to change B10 to $B$10. Continuing to press F4 would have resulted in B$10, then $B10, and finally B10. Pressing F4 changes only the cell reference directly to the left of your insertion point.

I hope this tutorial has made these cell reference types "absolutely" clear!

Converting PDF file to Ms Word

noreply@blogger.com (Admin) — Mon, 12 Oct 2009 14:17:00 +0000

Some times you may come across a situation where you would be looking for a software which can convert your PDF file to Word. So dont worry it is simple and easy!!. Here i am providing your some of the sites which will let you convert your PDF document to Ms Word for free of cost. Please follow these links

1. http://www.pdfonline.com/pdf2word/index.asp
2. http://convertpdftoword.net/

Some sites provide you PDF to word converting software for a nominal charge. You may also check from the google search engine by typing " convert PDF to Word" that's it. Enjoy! :) Happy Converting!!

Cell Locking in Microsoft Excel

noreply@blogger.com (Admin) — Sat, 10 Oct 2009 11:55:00 +0000

There's pretty much just two reasons for locking cells:

To restrict entry (locked cells may not be changed)
To allow tabbing to different cells for entry (unlocked cells can be
tabbed through)

The points you should know are these:

All cells are locked by default
Cell locking doesn't take effect until you protect your worksheet (ToolsàProtectionàProtect
Sheet to "lock" or ToolsàProtectionàUnprotect
Sheet to "unlock")
If you want most cells locked, then only unlock those you want users to be
able to change
If you want most cells unlocked, then unlock them all first, and then lock
only those you want prohibit users from changing

Select All Cells

Just click the button above Row 1 and to the left of Column A. This selects
all the cells on your worksheet.

Lock/Unlock Cells

Go to FormatàCells. Choose the
Protection tab. Lock or unlock the cells as desired.

You can quickly lock/unlock cells by locking or unlocking one or
more cells, then continue by using the F4 button, which repeats the last
command. So, while you may have 30 different cells on a worksheet that you want
to unlock, you can select, F4, select, F4...

www.officearticles.com

Excel Games

noreply@blogger.com (Admin) — Mon, 05 Oct 2009 16:06:00 +0000

Excel Games:

Besides you work with excel for your office you can also have fun playing exciting games in excel

look at this

and try it click here to download

this is a sample game from excelgames.org

Microsoft Office 2007

noreply@blogger.com (Admin) — Wed, 30 Sep 2009 19:12:00 +0000

Microsoft Office 2007 (officially called 2007 Microsoft Office System) is the most recent Windows version of the Microsoft Office System, Microsoft's productivity suite. Formerly known as Office 12 in the initial stages of its beta cycle, it was released to volume license customers on November 30, 2006[1] and made available to retail customers on January 30, 2007. These are, respectively, the same dates Windows Vista was released to volume licensing and retail customers. Office 2007 contains a number of new features, the most notable of which is the entirely new graphical user interface called the Fluent User Interface[2] (initially referred to as the Ribbon User Interface), replacing the menus and toolbars – which have been the cornerstone of Office since its inception – with a tabbed toolbar, known as the Ribbon. Office 2007 requires Windows XP with Service Pack 2 or higher, Windows Server 2003 with Service Pack 1 or higher, or Windows Vista.[3]
The 'Ribbon User Interface' is a task-oriented Graphical User Interface (GUI). It features a central menu button, widely known as the 'Office Button'. The Ribbon Interface stayed in Microsoft Office 2010.
Office 2007 also includes new applications and server-side tools. Chief among these is Groove, a collaboration and communication suite for smaller businesses, which was originally developed by Groove Networks before being acquired by Microsoft in 2005. Also included is Office SharePoint Server 2007, a major revision to the server platform for Office applications, which supports "Excel Services", a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.
Microsoft FrontPage has been removed from the Office suite entirely. It has been replaced by Microsoft Office SharePoint Designer, which is aimed towards development of SharePoint portals. Its designer-oriented counterpart Microsoft Expression Web is targeted for general web development. However, neither application is included in any of the Office suites.
Speech recognition and handwriting recognition are now part of Windows Vista. Speech and ink components have been removed from Office 2007.[4][5] Handwriting and speech recognition work with Office 2007 only on Windows Vista or Windows XP Tablet PC Edition. However, XP users can use an earlier version of Office to use speech recognition.

Excel Drop Down List

noreply@blogger.com (Admin) — Sat, 26 Sep 2009 09:21:00 +0000

Excel is excellent and lets see how it helps you using this drop down list features !
If you don't want to risk an item being miss-typed in a cell, drop down lists are an ideal solution. So These lists display all of the available choices to the user so that they can click on their preference. Excel allows you to place two different types of drop down list on your worksheet - either a validation list or a form object.
A validation drop down list
These lists are contained within a cell on your worksheet and the drop down arrow (to the right of the cell) does not appear unless the cell is selected. To add a list to a worksheet place the cursor in the required cell and then selectData Validation Settings. In the dialog box select 'Allow: List' and ensure the 'In-cell dropdown' box is ticked. The source data refers to a range of cells containing the selection of options. If you use the mouse to point to a range of cells (e.g. H12:H15), they must normally be contained on the same worksheet. If however you have named the range of cells (e.g. '=ConsNames') containing your data, it can be anywhere in the workbook.
In the example (right) the list has been placed in cell B2. Having selected 'Mrs Plain' the formulae in the table (B3:D8) lookup values in a range of data and summarise it. The consultant name can be referred to by the cell name (B2). If you wish to know the position of the selected item within the original range of options (i.e. the four names), an additional formula is needed. In cell B9, the formula =MATCH(B2, H12:H15, 0) determines that Mrs Plain is the second item in the list.

Using a combo box or a list box

These are independent objects (or controls) that can be placed onto a worksheet and are not contained within a cell as such. The example (left) contains a combo box but your choice of object can depend on the amount of space on your worksheet and the number of options.

To obtain these controls you must open the Forms toolbar (View Toobars Forms). Then click on either of the list buttons and drag an outline for the object on your worksheet. To instruct the new control where to find it's source data, right click on it, then choose Format Controlfrom the short menu. On the 'Control' tab of the dialog box, enter the range of cells containing the list options. The 'Cell Link' refers to a cell where you wish the list box to place a numeric value representing selected item. In the example above cell B21 is linked and indicates that the third list item was selected. You cannot refer directly to the value in the list box, but the option number in your worksheet cell is automatically updated to reflect any change in the control object.
To determine the actual name of the selected item (i.e. Dr Tiswas), use a formula such as =OFFSET(H11, B21, 0) where H11 is the cell immediately above the options list and B21 contains the option value. (Click here for details about the OFFSET function).

credit:www.meadinkent.co.uk

Get Up To Speed With Microsoft Word 2007

noreply@blogger.com (Admin) — Tue, 01 Sep 2009 23:44:00 +0000

Released in January 2007, Microsoft Word 2007 has undergone some drastic changes, most noticeable of which is the replacement of the old menu and toolbar system with the new ribbon. The ribbon is the focal point of a new user interface designed to make it even quicker and easier to perform professional document authoring tasks. Once you are familiar with using the ribbon in Word 2007, you will find the transition to all the other products in Office 2007 a doddle - the ribbon is common to them all. And so are new concepts like themes and content controls.

Whether you create newsletters, articles, annual reports or update a blog, Microsoft Word 2007 enables you to create, edit and share content in a variety of formats. Themes allow you to change the entire look of a document with just a few mouse clicks. Building blocks give you the opportunity to create reusable content, helping you to cut down time spent on the creation and cross referencing of key information like document title, subtitle etc. Pictures you have inserted into your document can be enhanced quickly and easily with Quick Styles (effects include drop shadows, reflections, borders and more).
Briefly, Word 2007 is laden with a plethora of other new features, such as:
* mini toolbars
* key tips (adapting keyboard shortcuts)
* themes
* content controls
* blog integration
and the list goes on!
You can use the tutorials on this site to get up to speed with Microsoft Word 2007.

post from word07.com

Microsoft InfoPath

noreply@blogger.com (Admin) — Mon, 24 Aug 2009 00:59:00 +0000

Microsoft InfoPath (full name Microsoft Office InfoPath) is an application used to develop XML-based data entry forms, first released as part of the Microsoft Office 2003 suite of programs in late 2003 and later released as part of Microsoft Office 2007. Initially given the codename XDocs, the main feature of InfoPath is its ability to author and view XML documents with support for custom-defined XML schemata. It can connect to external systems using XML Web services through MSXML and the SOAP Toolkit, and back-end and middle-tier systems can be configured to communicate by using Web services standards such as SOAP, UDDI, and WSDL. Additionally, because InfoPath documents are raw XML, it is possible to directly repurpose the data in other XML processors.
In InfoPath, the user can complete a form while off-line. InfoPath may check some fields on the form for validity, and the user can attach a digital signature. The user later connects to the server and submits the form (in XML form), which may be routed for approval. When the user connects to the server, the form template may be automatically updated.

Market Share Ms Office Publisher

noreply@blogger.com (Admin) — Mon, 24 Aug 2009 00:56:00 +0000

Publisher has a relatively small share of the desktop publishing market, which is dominated by Adobe InDesign and QuarkXPress.[2] Publisher has historically been less well-liked among high-end commercial print shops, compared with other desktop publishing applications.[3] Publisher's position as an entry-level application aggravates many issues (particularly in older versions) such as fonts unavailable and embedded objects not available on service providers' machines (however, Publisher does come with tools to pack related files into a self-expanding application). Many higher end features like transparency, object shadowing, slugs, text on paths, built-in PDF output, etc. are either not fully-functional or simply unavailable (especially in previous versions). However, recent versions have greater capabilities concerning color separations and proper process coloring output. Publisher 2007 also includes the capability to output commercial press quality PDF with embedded fonts as an optional download from the Microsoft website.
Publisher is included in high-end editions of Microsoft Office. This reflects Microsoft's emphasis on Publisher as an easy-to-use and less expensive alternative to the "heavyweights" and also its focus on the small business market where firms do not have dedicated design professionals available to make marketing materials and other documents.[2][4]
Publisher's proprietary file format (.pub) is unsupported by most other applications, with the exception of Adobe PageMaker. Publisher supports numerous other file formats, including the Enhanced Metafile (EMF) format which is supported on Windows platforms.

Ms office Publisher 2003

noreply@blogger.com (Admin) — Wed, 19 Aug 2009 02:36:00 +0000

Microsoft Publisher, officially Microsoft Office Publisher, is a desktop publishing application from Microsoft. It is an entry-level application, differing from Microsoft Word in that the emphasis is placed on page layout and design rather than text composition and proofing.Ms Office Publisher 2003 is blended with many features that can help you in works related to publications including web publishing. Read more....

by David Bartosik, MVP

As a Microsoft Publisher MVP and Office 11 beta tester, I've had ample time to get to know all the changes that have been made to the products web design functionality in this latest release. In this article I'll share some of these with you along with some input on my experience.
Personally my favorite thing about this version is that the products Personal Info Dialog Box finally has an option to turn it off. Through each version I have never used the Personal Info feature and that pop up dialog on each new publication has always annoyed me. The dialog now has a check box so if you aren't planning to use the Personal Info feature and you check that box you can launch your future new publications a little faster and with a few less mouse clicks.
I do have another favorite thing about this version and like that dialog this has been a Pet Peeve of mine through previous versions. A feature that's been long over due and in fact has been present in Word for at least the prior two versions. That new feature being Pixels as a measurement unit option. Pixel measurement provides the accuracy to achieve a more professional look and feel in your layout and designs.
Of more significant importance this version corrects issues that were introduced with the 2002 version, such as variable page lengths, hyperlinks in filled text boxes, and custom page naming.
Version 2003 introduces new templates that make it very easy to create a professional looking web site and new wizards and visual cues that make web publications simpler and easier to understand.
This version introduces what MS has coined "Incremental Uploading". What that means in English is that the whole site no longer has to be uploaded after modifying the web publication file. This feature when turned on keeps track of which pages are modified in the publication file and only uploads those files.
Publisher achieves this through the use of XML. Which is one of the factors behind the larger web file size in this version compared to previous versions.
The more code in a file the larger the file size. Here is a comparison:
Under v.2002 SP2, select Accent web template, Export as web page, result is :index.htm (11 kb)7 image files created equaling 26 kb totaltotal load size for home page is 37 kb (11 + 26)Under v.2003, select Accent template, Publish to web, result is :index.htm (41 kb)12 image files created equaling a total of 40kb (extra files due to VML in 2003)total load size for home page is 81 kb (41 + 40)
In testing Incremental Uploading I have been pleased with the results. It will definitely be a time saver for larger sites. Technically you don't get the full benefits of it until after the third time the site is published.
An issue that was found during testing of this feature is that on some web servers the sites supporting folder (containing all pages after the home page) is hidden, not visible when logged on to the server and viewing the contents. MS identified this as being an issue with the web servers handling of xml files. The user can contact their web host about this permissions issue or they can elect to not use the supporting folder option.
I've already pointed out the subject of file size. File size is the only down side I see with this version. In addition to what I've already mentioned some other nice things are - a return to naming the home page to index.htm by default, more nav bar placement options, separation of nav bar titles and page titles, and lots of pre-made topic pages.
I've published a sample site at this address— http://www.davidbartosik.com/2003samples/network_easy_web/
This sample site generated 114 files with a total file size of 2.2 MB. The index file (home page) is 112 kb. The site is comprised of only 12 pages. You can CLICK HERE to view the file listing for the site. This listing also illustrates the new default file naming convention of this version (yes they changed it again).
Those users with free web space and/or limited web space will most likely find that 2 MB for a 12 page site is an obstacle. Business users implementing a site on a local intranet can be less concerned.
I welcome and encourage feedback on this sample site and the topics I've discussed here in the Microsoft Community. CLICK HERE to visit the Community.
Whether you have an existing web site from Publisher or are considering creation of a web site with Publisher, you the user will need to determine for yourself whether the enhancements of this latest version out weigh the down side of the web page file size.

What makes your office work fast!!

noreply@blogger.com (Admin) — Sat, 15 Aug 2009 15:35:00 +0000

If you really want to work faster in ms offfice applications. At the time of installation you should keep in mind that, install minimal application then as and when needed get it upgraded that really works faster. Check by reinstalling ms office application on your machine.

Ms Office Tools MS Access Snapshot viewer

noreply@blogger.com (Admin) — Tue, 11 Aug 2009 06:36:00 +0000

Discover the new things in ms office tools if you are new ...

Today I am going to put forth the information about snapshot viewer. You may have come across this before or may have never. So lets check what's ultimate microsoft people has done for the ms office users around the world. First lets learn about snapshot viewer

Snapshot Viewer is a program that you can use to view, print, and mail a snapshot, such as a report snapshot. Snapshot Viewer version 9.0 consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), a help file, and other related files. By default, Snapshot Viewer is automatically installed by Microsoft Access 2000 the first time you create a report snapshot. You can also install Snapshot Viewer from the Setup program, or from a World Wide Web software download page located at the Microsoft Access Developer's Web site. You can use the Snapshot Viewer control to view a snapshot from Microsoft Internet Explorer version 3.0 or later or from any application that supports ActiveX controls, such as Access or Microsoft Visual Basic for Applications.

This is what about the snapshot viewer the programme help says all about.

Getting words from figures is excellent in excel

noreply@blogger.com (Admin) — Tue, 28 Jul 2009 06:15:00 +0000

Amazing attribute of ms excel you can get your figures converted to words is as easy as 123. Only simple thing you got to know is this.....

------------------------------------------------------------------------------------
here is the formula!! you can copy this formula directly from here !!
---------------------------------------------------------------------------------------
Function ConvertCurrencyToEnglish(ByVal MyNumber) Dim Temp Dim Rupees, Paise Dim DecimalPlace, Count
ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion "
' Convert MyNumber to a string, trimming extra spaces. MyNumber = Trim(Str(MyNumber))
' Find decimal place. DecimalPlace = InStr(MyNumber, ".")
' If we find decimal place... If DecimalPlace > 0 Then ' Convert Paise Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2) Paise = ConvertTens(Temp)
' Strip off Paise from remainder to convert. MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If
Count = 1 Do While MyNumber <> "" ' Convert last 3 digits of MyNumber to English Rupees. Temp = ConvertHundreds(Right(MyNumber, 3)) If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees If Len(MyNumber) > 3 Then ' Remove last 3 converted digits from MyNumber. MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop
' Clean up Rupees. Select Case Rupees Case "" Rupees = "" Case Else Rupees = " Rupees " & Rupees End Select
' Clean up Paise. Select Case Paise Case "" Paise = " " Case Else Paise = " and " & Paise & " Paise" End Select
ConvertCurrencyToEnglish = Rupees & Paise If Trim(ConvertCurrencyToEnglish) <> "" Then ConvertCurrencyToEnglish = ConvertCurrencyToEnglish & " Only" End Function
Private Function ConvertHundreds(ByVal MyNumber) Dim Result As String
' Exit if there is nothing to convert. If Val(MyNumber) = 0 Then Exit Function
' Append leading zeros to number. MyNumber = Right("000" & MyNumber, 3)
' Do we have a hundreds place digit to convert? If Left(MyNumber, 1) <> "0" Then Result = ConvertDigit(Left(MyNumber, 1)) & " Hundred " End If
' Do we have a tens place digit to convert? If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & ConvertTens(Mid(MyNumber, 2)) Else ' If not, then convert the ones place digit. Result = Result & ConvertDigit(Mid(MyNumber, 3)) End If
ConvertHundreds = Trim(Result) End Function
Private Function ConvertTens(ByVal MyTens) Dim Result As String
' Is value between 10 and 19? If Val(Left(MyTens, 1)) = 1 Then Select Case Val(MyTens) Case 10: Result = "Ten" Case 11: Result = "Eleven" Case 12: Result = "Twelve" Case 13: Result = "Thirteen" Case 14: Result = "Fourteen" Case 15: Result = "Fifteen" Case 16: Result = "Sixteen" Case 17: Result = "Seventeen" Case 18: Result = "Eighteen" Case 19: Result = "Nineteen" Case Else End Select Else ' .. otherwise it's between 20 and 99. Select Case Val(Left(MyTens, 1)) Case 2: Result = "Twenty " Case 3: Result = "Thirty " Case 4: Result = "Forty " Case 5: Result = "Fifty " Case 6: Result = "Sixty " Case 7: Result = "Seventy " Case 8: Result = "Eighty " Case 9: Result = "Ninety " Case Else End Select
' Convert ones place digit. Result = Result & ConvertDigit(Right(MyTens, 1)) End If
ConvertTens = Result End Function
Private Function ConvertDigit(ByVal MyDigit) Select Case Val(MyDigit) Case 1: ConvertDigit = "One" Case 2: ConvertDigit = "Two" Case 3: ConvertDigit = "Three" Case 4: ConvertDigit = "Four" Case 5: ConvertDigit = "Five" Case 6: ConvertDigit = "Six" Case 7: ConvertDigit = "Seven" Case 8: ConvertDigit = "Eight" Case 9: ConvertDigit = "Nine" Case Else: ConvertDigit = "" End Select End Function
--------------------------------------------------------------------------------------
You have to paste this formula in a module in an excel sheet. Please check the below image
---------------------------------------------------------------------------------

Click here to download sample file:

Brief Case Helps you just update files on a single Click

noreply@blogger.com (Admin) — Thu, 09 Apr 2009 22:06:00 +0000

How To Use the Briefcase Feature in Windows XP
__________________________________________

Using Briefcase
The Briefcase feature in Windows XP helps you keep your files updated by automatically synchronizing multiple copies of individual files. In other words, Briefcase keeps track of the relationship between files on two or more computers. For example, if you use a desktop computer at the office, and you use a portable computer when you are on the road, Briefcase synchronizes and updates the files on your desktop computer to the modified versions when you reconnect your portable computer to the desktop computer. Briefcase stores and displays the update status of files. It keeps track of whether a file is linked to the original file on your main computer, or whether it is an orphan file (a file stored in Briefcase that is not linked to another file). You can use this information to keep your files organized and to keep track of the most recent versions of your files. Use Briefcase when you use two or more computers to work on files, and when you need to frequently transfer files between computers by using a direct cable connection or a removable disk.

---------------------------------------------------------------

How to Create a New Briefcase
Click Start, and then click My Computer.
Click the folder in which you want to create a new briefcase.
On the File menu, click New, and then click Briefcase. The new briefcase is created. To open the briefcase, double-click it. If you want to create a new briefcase on your desktop, right-click an empty area of your desktop, click New, and then click Briefcase.

How to Use Briefcase to Synchronize Files on Two Computers
NOTE: The following steps assume that you use a desktop computer as your primary computer and a portable computer as your secondary computer. Connect your portable computer to your desktop computer. You can connect your computers either over a network or by using a direct cable connection. Start Briefcase on your portable computer, and then drag the files or folders that you want to work with from your desktop computer to Briefcase. NOTE: Before you copy folders and files from your desktop computer to Briefcase, the folders containing the files must be shared.
Start Briefcase, and then make the changes that you want to the files. When you have finished working on the files, reconnect your portable computer to your desktop computer (if they were disconnected), and then start Briefcase on your portable computer. Do one of the following:
To update all files, click Update All on the Briefcase menu. -or-
To update only some of the files, select the file or files that you want to update, and then click Update Selection on the Briefcase menu.
The Update dialog box is displayed. Confirm the update action on the files or folders that are displayed in the dialog box, and then click Update.The files on your desktop computer are updated with the modified versions of those files in Briefcase on your portable computer.

How to Use Briefcase to Synchronize Files Stored on a Floppy Disk
NOTE: The following steps assume that you work with a desktop computer as your primary computer and a portable computer as your secondary computer.
Insert a floppy disk into the floppy disk drive on your desktop computer.
Start Briefcase, and then copy the files or folders that you want to work with from your computer to Briefcase.
Drag Briefcase to the floppy disk. The files and folders in Briefcase are copied to the disk.
Remove the floppy disk from your desktop computer, and then insert the disk containing Briefcase into the floppy disk drive on your portable computer.
Start Briefcase from the floppy disk, and then make the changes that you want to the files.
When you have finished working on the files, remove the floppy disk from your portable computer, and then reinsert it into the floppy disk drive of your desktop computer.
Start Briefcase from the floppy disk, and then do one of the following:
To update all files, click Update All on the Briefcase menu. -or-
To update only some of the files stored in Briefcase, select the files that you want to update, and then click Update Selection on the Briefcase menu.
The Update dialog box is displayed. Confirm the update action on the files or folders that are displayed in the dialog box, and then click Update.The files on your desktop computer are synchronized with the updated versions of those files in Briefcase on the floppy disk.

How to Check the Status of Files Stored in Briefcase
Start Briefcase, right-click the file that you want to check, and then click Properties. Click the Update Status tab. If the Briefcase file and its counterpart outside Briefcase (the original copy of the file on another computer) are synchronized, an Up-to-date icon is displayed. If the Briefcase file and its counterpart are not synchronized, a Replace arrow is displayed. The arrow points towards the copy of the file that requires updating. Click Update to synchronize the files. The file stored in Briefcase and its counterpart outside Briefcase are synchronized.

How to Split Files Stored in Briefcase from Their Counterparts
When you split a file stored in Briefcase, you separate the Briefcase copy of the file from its counterpart outside Briefcase. The resulting orphan file stored in Briefcase can no longer be synchronized. To split files stored in Briefcase from their counterparts, follow these steps:
Start Briefcase, right-click the file that you want to split, and then click Properties. Click the Update Status tab. Click Split From Original, and then click Yes when you are prompted, to prevent any future updates of the file. Click Close, and then quit Briefcase.The file is now an orphan.
Troubleshooting
When you attempt to synchronize a file, you receive the following error message after you copy it to, and edit it, in Briefcase:
File name is an orphan. It was not updated. This behavior can occur if the original file was moved. Briefcase keeps track of the original location of all the files that you copy to Briefcase. However, it cannot track the files if they are moved to a different location. After you move a file on the primary computer, the file stored in Briefcase becomes an orphan file, and therefore it can no longer be synchronized with its original counterpart outside Briefcase. This is the case even if the file is moved back to its original location. To resolve this issue, first rename the modified version of the file, and then copy the original file to Briefcase. Open and save the modified version of the file with the same name as the original file that you just copied to Briefcase, and then delete the orphan file.
Use the following guidelines to determine which Windows XP feature to use when you work with synchronized files:
Use the Briefcase feature if you typically transfer files between computers by using either a removable disk (such as a floppy disk) or a direct cable connection.
Use the Offline Files feature when you work with shared files on a network.