Welcome to My Office Power

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

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