As September approaches, I can count on a series of spreadsheet questions. One of the more popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product number into a product name. One of my favorite...

To create Excel 3D Chart ,  first start Microsoft Excel and open an existing workbook that contains data that you would like to turn into a 3D chart,the data that a chart uses can be resides in a single worksheet, or use data that’s stored in other worksheets. Excel 2007 has enhanced charting...

There are three ways on how to  insert video into powerpoint: Direct Play Video This broadcast method is to pre-prepared video file as a movie file directly into the slide, the method is the simplest, most intuitive way, using this method to video file into the slide, after, PowerPoint only a simple...

1 How to insert pdf text into word document? If you have your PDF converted to Word, it’s pretty simple job now!just convert pdf into word and you cant past from the word file.Here is a website http://www.pdftoword.com/you can convert you pdf into word freely. The first step (Step1) Open you want...

here are some funny pets picture and a very funny ppt with all the pictures. here is the very funny ppt downloads.

Microsoft Excel is a powerful tool that allows you to take data from your worksheet and position the chart within the worksheet. This type of chart is known as an Embedded Chart. The first step for creating your chart is to select the data that you want to chart. Ensure that you select the labels for...

open Excel to open a new file after casually, it would be “Save as Web images”, the press release and then will add interactive features tick, save the file as 2000.htm. in IE, open 2000.htm, you should see a spreadsheet appeared on the website of the Central. find the first 2000 rows,...

Word2003 document using the editing process, the alignment of the paragraph directly affect Word document layout effects.  Word2003 document paragraph alignment, including “Horizontal Alignment” and “vertical alignment” in two ways, where “the level of alignment”...

Excel sort is a very simple use of Microsoft EXCEL. sorting is a fundamental function of EXCEL, this article introduce several ways of excel sort method for you. When you face a lot of data in you excel sheets, if the data isn’t well sorted, you can’t effective edit it. In all recent versions of...

In my Excel there is a column, say, column A, where all the cells are text string such as company names. My task is to filter all the rows where the cells in column A contain the same company names. However, my problem is the company names was originally entered from different sources therefore for the...

I used conditional IF to write my formulas but when my table increase in size, it became many IF statements in a cell. I tried to replace IF with lookup function but some how I got so many ERR. Can someone write me the formulas to solve my issue? Here is the example: It can be a row or column but let...

i am trying to make an if statement that accomplishes something like, If c1=b1 then d1 = pick a choice from the data validation list(drop down list) that is from e1 to e5. else pick a choice from the data validation list(drop down list) that is from f1 to f5. i am new to running macros in excel. pls...

For a lot of work to do or write Financial Financial blog site, and friends often travel, in order to chart out the form to update the blog (or unit website OA) content will not be easy: the lack of professional software greatly restricted their work. If the chart can be automatically updated in real-time...

As we all know, Excel default grid lines are usually gray, but we can customize the following methods to achieve grid color to distinguish between the contents of the form. First of all, click “Tools menu → Options”, then “Options” dialog box, select “view” tab →...

Why convert powerpoint to Flash? FlashPlay have occupied 93% of the world’s computers, meaning that the vast majority of computers that can play Flash, so Flash after powerpoint  can be converted into computer security in other players, and do not have to consider the font is not installed...

Through the cell in Excel formula automatically enter the corresponding results obtained, but if you want to use a simple copy and paste the results of the command will be moved to other locations, it is not possible, because you copy and paste the formula instead of computing the result, it moved to...

In Excel, according to the paper size if the column width is set up, ready to print out a copy of the form, I would like to change the contents of some of its forms as another form, whether or not the form found in the contents of the stick has not changed, but the width of column has changed? Only once...

A friend of mine made a Email  asked me, Is there a way to insert Word document into  Excel spreadsheet? Answer  is yes. office series software is one of the major advantages of working together to each other, between different applications can easily exchange content. Use the Insert Object Excel...

61.SKEW Purposes: to return to a degree of asymmetry in the distribution. It reflects the average of the asymmetry in the distribution center the degree of asymmetry is that the degree of asymmetry of the distribution side of a time when even more difficult. That the asymmetry degree of negative asymmetry...

41.MAX Purposes: to return to the greatest concentration of numerical data. Syntax: MAX (number1, number2 ,…) Parameters: Number1, number2, … is the need to find the greatest value of 1-30 values. Example: If A1 = 71, A2 = 83, A3 = 76, A4 = 49, A5 = 92, A6 = 88, A7 = 96, while the formula...