I came across some good software for Microsoft power point.... Power-point is a wide used presentation software in business and classroom...
Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. This happens most often when: ...
Array formulas are surrounded by curly braces "{ } ". These are added to a formula by pressing the CTRL, SHIFT, and ENTER keys af...
Excel sorts data according to a defined order, as follows: Numeric values: Numeric values, including date and time, are sorted from low...
Sort by columns in Excel 2007 : 1. Select Data -> Sort (in Sort & Filter Group) -> Options. 2. Select Sort left to right opti...
Importing a text file in Excel 2007 : 1. Select File -> Open -> find the text file and click Open. 2. In Text Import Wizard dialo...
Select Cell A1. From the Insert menu, select Picture, From File. Select the picture you want, and then copy and paste it int...
1. Open Excel 2000, and from the Data menu, select Get External Data, and then New Web Query. 2. In the Enter the address box, paste ...
In order to use camera tool, you must add the tool to a tool bar in excel menu area. Here is how you can do that: Go to menu > to...
Remove any vertical grid-lines. Change horizontal grid-line colours from black to a very light shade of Gray. Adjust chart series ...
To format a phone number, use the custom format code “000-000-0000″ To set phone number with 1 digit country code format, enter (+0)...
To get the first name of a person, use =left(name,find(” “,name)-1) To calculate mortgage payments, use =PMT(interest-rate,number-of-...
To format any selected object, press ctrl+1 To insert current date, press ctrl+; To insert current time, press ctrl+shift+; Rea...
Click on the tab(s) of the worksheets you want to re-colour. To select more than one tab hold down the CTRL key on the keyboard and c...
Using Format Painter to copy formatting options to one cell:Add all the formatting options you want to use to at least one cell. Click ...
A good choice of background colour, font style and font size, plus other formatting options can make the most important information on th...
SUMIF formula is very versatile and can provide solution for many business needs. Let’s say that you have a couple of columns. You woul...
In some cases,You am creating spreadsheets where others will be entering data. In these sheets,you want to make the data entry as automat...
We have done some tiring research and some juggling to presents you some tips and tricks related to Microsoft Office Excel. After Mi...
Sometimes,you have a list of items in Excel that I would like to filter through the data to get rid of the duplicates. One way to fin...
Posts
All Comments
