Monthly Archives: February 1998

Excel offers two ways to calculate the power of a number. Let’s look at both.Click in cell A1 to select it. Enter =22^3 and press Enter. Excel will perform the calculation and report that 22 to the third power is … Continue reading →

If you’re working with a Word document and you run across a need for a small spreadsheet, you can use Excel and then insert the worksheet into the Word document. But if the spreadsheet requirements are minimal, why not use … Continue reading →

In Microsoft Excel, entering a time with more than 60 minutes into a cell may change the cell to the General number format and give you a decimal. If you type 5:62, for example, the cell will pop up with … Continue reading →

Let’s say you have a worksheet designed to handle your widget sales. Here you are at the start of your fiscal year and you know you must realize at least $2,000,000 in widget sales during the coming year to meet … Continue reading →

In the last tip, we showed you how to modify the colors of the bars in a bar chart. You can do the same for your pie charts, but the method is slightly different. Insert your pie chart. You’ll get … Continue reading →

When you create a chart in Excel (or any other Office program) you may find the default chart colors a bit drab. Let’s say you have three bars in a bar chart. By default, the bars will appear as light … Continue reading →

In Excel, you can copy a group of cells by selecting them and then pressing Ctrl-C. This copies the cells to the Windows Clipboard. Now you can move to another cell range and press Ctrl-V to paste the cells to … Continue reading →