Welcome to My Office Power

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 .

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…

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

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

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

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