office-winner

What is the use of Sumif formula?  Sums items in a list matching a condition Syntax of Sumif formula: sumif(in this range, values meeting this criteria, [sum-this-range]) Examples of Excel Sumif formula:   sumif(A1:A20, 3) = sums the cells with a value of "3" sumif(A1:A20, 3, b1:b20) = same as above but adds values in B1:B20 SUMIF function syntax The SUMIF function has the following syntax:          =SUMIF( range , criteria ,sum_range) range is the range of cells you want to add up. It is required for the function to work. criteria is the criteria which must be met for a cell to be included in the total. It is also required. sum_range is the range of cells that will be added up. It is optional; if you leave it out, Excel will check the criteria against the sum_range. In the two examples above, the first example doesn't need you to provide a sum_range, while the second example does. One of t...

Array Formulas Many of the formulas described here are Array Formulas, which are a special type of formula in Excel.  If you are not familiar with Array Formulas, click here. Array To Column Sometimes it is useful to convert an MxN array into a single column of data, for example for charting (a data series must be a single row or column).  Click here for more details. Averaging Values In A Range You can use Excel's built in =AVERAGE function to average a range of values.  By using it with other functions, you can extend its functionality. For the formulas given below, assume that our data is in the range A1:A60. Averaging Values Between Two Numbers Use the  array formula =AVERAGE(IF((A1:A60>=Low)*(A1:A60<=High),A1:A60)) Where Low and High are the values between which you want to average. Averaging The Highest N Numbers In A Range To average the N largest numbers in a range, use the  array form...

ctrl+arrow keys: Move to the edge of next data region (cells that contains data)(MS Excel-Version: 2007)(MS Excel-Version: 2010) Navigate Inside Worksheets end : Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right(MS Excel-Version: 2010) Work With Data Selections ctrl+shift+o : Select all cells with comments(MS Excel-Version: 2010) Manage Active Selections shift+f8 : Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection(MS Excel-Version: 2010) Manage Active Selections shift+backspace : Select only the active cell when multiple cells are selected(MS Excel-Version:2003,2007,2010) Select inside cells shift+arrow left / shift+arrow right : Select or unselect one character to the le...

Windows - On either side of the spacebar, outside the Alt key, is a key with the Windows logo. Holding the Windows key down and pressing another key will initiate quite a few actions. Some of the more common are listed in the table below: + F to display Find: All Files + F1 to display Help + R to display the Run command + M to minimize or restore all windows + E to display Windows Explorer + Break to display System Properties + Tab to cycle through buttons on the task bar Shift + + M to undo minimize all windows to display the Start menu and then press U to display the Turn Off Computer menu, press U again (on laptops) or press S (on desktops) to Turn Off the computer. + D to quickly get to your Desktop [Thanks Charlotte!] If your computer has XP installed and you want to lock your computer when you walk away from it use + L . OK, I won't leave you hanging. Your...

  Keyboard shortcuts specific to MS Excel Escape - Esc is used to back out of situations. When you find yourself in a place where you don't want to be, try the Esc key. In PowerPoint this key will stop a running slide show. The keyboard combination Ctrl + Esc will open the Start menu. www.officewin.blogspot.com F1 - While working in an application, depressing this key will bring up the applications help menu. If there is no open application F1 will open Windows Help . www.officewin.blogspot.com F2 - Choose this key to rename a selected item. Alt + Ctrl + F2 to open a new document in MS Word Ctrl + F2 to open print preview in MS Word (this is a toggle, tap the keys again to return to the edit page) www.officewin.blogspot.com F3 - Depressing this key will display the Find: All Files dialog box. 2 - Shift + F3 will change case in MS Word. Continue to press F3 ( with the Shift key depressed) to toggle through all choices. www.officewin.blogspo...