|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Monday, November 28, 2011 – Permalink – Embed a showStick it in WordYou might like to distribute a short PowerPoint slide show, and include some extra material. Open Word and PowerPoint. Arrange the windows so that both applications can be seen. (Right-click an empty area of the Task bar and choose "Tile Windows Vertically." Type your introductory text in the Word document. Switch to PowerPoint and open the PowerPoint file. In Slide Sorter View, hold down the Ctrl key and select the slides you want to include. Drag the selected group of slides onto the Word document. You will only see the first slide in the document, but if you double-click on the image, the PowerPoint show will run. It will also work in Excel. (This, of course assumes that the target machine has PowerPoint or PowerPoint Viewer installed) See all Topics excel <Doug Klippert@ 3:58 AM
Comments:
Post a Comment
Sunday, November 20, 2011 – Permalink – Conditional FormattingIf it's Tuesday, it must be mauveConditional formatting is one of Excel's better features. It allows you to preset certain font styles, colors, and cell-background colors based on cell values. This can be very useful for highlighting important information and values outside an accepted range or providing a visual cue to associate value ranges with color codes. The best part is that conditional formatting is very easy to set up. Just click the cells you'd like to format and select Format >Conditional Formatting. The Conditional Formatting dialog box lets you set up the conditions by which the formatting of the cell will occur. You pick the operator (between, equal to, less than, etc.) and the value or range of values. Click Format to open the Format Cells dialog box, where you can select the colors and styles to be used. Each cell can have several conditional formats. For example, you might say that if a certain cell's value is between 20 and 50, the text should be blue on a yellow background. However, you can format that same cell to exhibit red, bolded text on a green background if it contains a value between 51 and 100.  Before 2007, you could use up to three conditions, but earlier versions of Excel can be tricked to use more if it should become necessary. Oz Grid: Excel VBA Macro Code to Get Around Excel's 3 Criteria Limit in Conditional Formatting GR Business Process Solutions: Graham Barrow and Ray BlakeHighlight the current or past month in Excel with conditional formatting Chip Pearson: Conditional Formatting Also Adding Customized Rules to Excel 2007 Demo: Data takes shape with conditional formatting See all Topics See all Topics excel <Doug Klippert@ 3:45 AM
Comments:
Post a Comment
Sunday, November 06, 2011 – Permalink – Power Utility Pak v6-7Excel the way you've wanted itJohn Walkenbach (J-Walk.com) has improved on the previous versions of PUP. It now includes more than 70 general purpose Excel utilities and 50 worksheet functions. You can download a 30 day trial at PUP V6 Home Here are some features just in the area of Chart & Graphics Tools:
There is, of course, PUP v7 Power Utility Pak v7 See all Topics excel <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Friday, November 04, 2011 – Permalink – Excuse me, your formulas's showingFormatting slipTry this experiment. On a sample worksheet, enter some arbitrary data in say the A1:B5 range. Select the C column and format it as Text. (Right click choose Format Cells - on the Number tab choose Text) In cell C1 enter a function, such as =sum(a1:b1) With C1 still selected, double click the Fill handle (the tiny box at the lower right corner of the cell.) The formula is filled down the column as long as there is data in an adjacent column. But wait! I don't see the value. I see the formulas! In addition, the formulas are still in lower case and the relative references have not been updated. Easy to fix, I hear you say. Just reformat the column as General. Nothing happens. To fix the problem, make sure the column is formatted as General. Select the first cell. Click in the formula bar and hit the Enter key. Now double click the Fill handle. (You could also use Edit>Replace to replace = with =. However, Relative references will be incorrect and unless you have reformatted the whole column as General, any new formulas will still display as text.) The reverse also causes a problem. In a column formatted as General, enter some formulas. Now reformat the column as Text. The formulas still work, but if you edit one of them, it reverts to a text display. Microsoft KB: Cell Linked to Text-Formatted Cell Shows Formula Not Value Formulas can, of course, be toggled using CTRL+~ (Tilde) (Though it really should be called CTRL+` (Grave Accent), since the Shift key is not used.) See all Topics excel <Doug Klippert@ 3:21 AM
Comments:
Post a Comment
|
