Search

The article discusses several shortcut keys that can be used in the spreadsheet application Microsoft Excel 2007. It shows how to move among cells, apply general number formatting to a selected cell, see all formulas, use the Paste Special dialog box, and jump to the beginning or end of the worksheet. The article also details how to add a new line in a cell, and add a new worksheet.

The author offers tips on how to troubleshoot formulas using tools built into Microsoft Excel spreadsheet application program. He cites some common problems encountered by users when manually typing a formula such as missing parentheses, improper range punctuation and typing numbers with formatting. He notes that Excel flags any errors in typing a formula, and offers instant Help. He suggests a step-by-step approach on how to scour a worksheet for errors.

The article presents suggestions on handling file management problems in Microsoft Excel 2007. It explains that an .XLSX name extension is the program's new file format and its advantages include smaller file sizes, better resistance to macro-based viruses, and stronger problem-recovery possibilities. Files that are not opened during the course of the day would appear on the Recent Documents list that pops up when the Office button is clicked on.

The article offers tips for troubleshooting column settings in Microsoft Excel 2007. It is noted that the application's columns can stretch anywhere from zero characters wide to 255 characters wide. One can AutoFit every cell at once by using the Select All button. If the user intentionally hid the column or did it long enough ago that Undo is not a viable choice, he can use the Unhide function. To insert a column, one should click the column heading to the right of where he wants the new one.

The article offers guide to troubleshooting common problems with using PowerPoint 2007. To convert large Word documents into PowerPoint slides, copy the text in Word and then right-click in the appropriate text box in PowerPoint and choose Paste on the pop-up menu. However, for easy way, a feature of PowerPoint quickly imports a Word document's structure, which then creates separate PowerPoint slides in or close to the right spots. The reason for the failure to drop an image file onto a slide is that the image type may not be supported by PowerPoint.

In this article, the author covers the solutions to some common bullet point problems in PowerPoint 2007. The author instructs to press shift-enter to move words down but keep them as part of the same bullet item. To create more space between lines of the list, he advises to press the enter key, highlight the list and then click the Line Spacing button in the Home tab's Paragraph group. In addition, the author notes that the software lets the user to customize a bullet list's animation, but only to a certain extent.

In this article, the author offers ways to navigate worksheets using Excel 2007. The author instructs to use the View tab's Freeze Panes button to keep heading in view. He notes that the Watch Window feature of Excel 2007 provides a picture-in-picture option, letting the user to watch a couple of different channels at once. He reminds that the user can adjust the size of a quadrant by dragging the center of the crossbar to a new position. In addition, the author suggests that the user can jump to the beginning and end of worksheets with key combinations.

The article deals with the What-If Analysis tools of Excel 2007, which will make it easy for users to explore various outcomes and save snapshots of them for quick reference and modification. Scenarios, which are built on variations of existing, make users save various groups of values and then apply them whenever they want to see what outcomes the various values would produce. Goal Seek helps users figure out what has to happen to reach a specified goal and they can plug in the revenue goal they have in mind.

The article offers information on creating tables using the software Excel 2007. Inserting a table can be done by dragging the mouse across the range to highlight all the information, then click the Insert tab's Table button. There is also a checkbox labeled My Table Has Headers. This feature is used to automatically handle part of the chart's setup. When adding data in rows or columns, type data into an adjacent cell and press enter. Another feature of Excel's new tables is data sorting. Every column comes with a drop-down arrow.

The article offers some tips for creating charts with the use of the Microsoft Excel 2002 computer program. To make sure that rows and columns of data are arranged correctly, choose Help and Microsoft Excel Help and type create a chart in the search field. After clicking Create A Chart, select the kind of chart that Excel will make and read the examples of how to arrange data in rows and columns. The article also discusses the steps for generating charts with the use of the Chart Type toolbar button and the Chart Wizard.

The article explains the procedure for using the functions of Microsoft Excel 2002. A user can insert any function into a cell by clicking the Insert Function button on the Formula bar. The functions of Excel appears on the dialog box wherein a short description of each one is displayed at the bottom of the box. The ROUNDUP function of Excel is adequate for rounding numbers to the nearest whole. Information on other Excel functions such as SUMIF, COMBIN, CONCATENATE and PERCENTRANK and PERCENTILE is also presented.

The article presents information on the features of Microsoft PowerPoint 2002. A user is capable of resizing his entire diagram but getting the sizing handles to appear can be confusing at first. The buttons of the Drawing toolbar can be used to modify the attributes of the diagram wherein the user can edit the fill color, line thickness and shadows. In order to resize the individual parts of the chart, the user must click the Layout button of the Diagram toolbar and select AutoLayout. Information on how a user can animate a diagram is also presented.

The article presents tips on creating a slideshow using the Outline view of Microsoft PowerPoint 2002. It offers information on the advantages of the Outline view, how to write and format text in the outline section, and explains the lineup of new buttons that appears when switching to Outline view.

The article presents tips on using the filtering tools of Microsoft Excel 2002. It offers information on factors to consider before using Excel's filtering tools, how to start a filtering job, options for more involved filtering setups, and discusses the guidelines on filtering.

This article offers ways to from one cell to the other in the Microsoft Excel 2002 worksheets. The scrollbars along the bottom and right side of the active window are among the tools used. The keyboard can also be used such as the PAGE UP and PAGE DOWN keys. Meanwhile, the performance of a mouse varies by its brand. The home area of most worksheets is in the upper-left corner, in which key pieces of data and column and row headings appear.

Presents the steps to customize footers and headers for spreadsheets using Microsoft Excel 20002. Options for preset header and footer entries; Sections in the custom setup area; Way of adding a photo to each Excel page.

This article provides information on several Microsoft Excel 2002 formulas that can be put to work on real-world situations. A lot of work of Excel work boils down to comparing pieces of data against a benchmark. A couple of formulas make that easier by helping one set up basic calculations that test whether one number is equal to or greater than another one. To return a simple TRUE/FALSE statement based on whether the number is larger than the target, enter =G10>G11. Use the IF function when one would like to customize the formula's message. Most Excel users could trim their workload if they used the premade formulas stashed under the AutoSum button. The feature that gives the button its name lets one add up a group of numbers by dragging over them and clicking the button. Another formula for increasing numbers by a certain percentage is also presented in this article. In more complex calculations, one may want to find out what it would cost to give everyone on staff a raise. One doesn't have to change the percentage in each person's salary increase formula. Instead, refer each salary increase formula to a cell that one change once and affect every calculation. Meanwhile, one way to see how several figures rank against their peer group is to sort list in descending or ascending order. But when one would rather not re-order an entire list, use the RANK function to find out where everyone in the group stands.

This article enumerates the Options Dialog Box features of the computer software Microsoft Excel 2002 from Microsoft. Excel software users should utilize one taskbar button for all Excel documents. Excel normally places a separate button on the Taskbar for every open document. When your Taskbar gets crowded, uncheck the View tab's Windows in Taskbar box to have one button represent everything open in Excel. Inorder to change hue, one must use the Gridlines Color drop-down menu of the View tab. To limit recalculation to times of choosing, click manual on the Calculation tab. When you enter information into a cell and press ENTER, Excel selects the cell below the one you were working in. If your data entry lends itself to moves in another direction, maybe to the right, change the selection process with the drop-down menu below Move Selection After Enter on the Edit Tab. The File menu shows the last four files you have opened but you can change the number to anaything as long as it's from 1 to 9 on the General tab. One of the features of the software is the Zoom on Roll With IntelliMouse. If your mouse has a scroll wheel between the buttons, you can use the feature. Check the box and you can zoom in on spreadsheets by rolling the scroll wheel forward and zoom out by rolling the scroll wheel backward. Note that enabling this feature means the scroll wheel no longer works for moving up and down spreadsheets.

Reviews the computer software Microsoft Excel 2002 for spreadsheet applications.

This article provides information on sharing documents for review using Microsoft Excel 2002 software. Before sending a workbook for review, you must share it and turn on the tracking function. Turning on sharing or tracking turns on the other, in order to do each, you should choose Tools and Share Workbook. Then on the Editing tab, select Allow Changes By More Than One User At The Same Time. On the Advanced tab, adjust how many days changes will be saved. Set it long enough to let the file circulate and return to you, with enough time to review changes before they're discarded. Head to the Tools menu to set up the sheet to record changes everyone makes during the review process. Select Track Changes and Highlight Changes. In the dialog box, select When. Turning on change tracking also turns a workbook into a shared workbook. Ship the document off for review by others either by sending them the file as an attachment or by sending a link to the file stored in a shared location on an office network. When someone gets a document for review, he or she can click the attachment, make any changes, and then click Reply With Changes on the Reviewing Toolbar. To accept changes one by one, choose Tools, Track Changes, and Accept or Reject Changes. Excel will bring each change to the screen, letting you decide whether to accept or reject it.

This article presents guidelines in outlining data in a spreadsheet using Microsoft Excel 2002 computer software. When you use outlining to create collapsible spreadsheets, you can store large amounts of detailed data in worksheets but set them up so that with a click here and there, you see only certain pieces of information. You must set data up with outlining in mind. The basic ideas is that everything is organized in list format with similar pieces of data grouped together. The Burbank office's widget sales and gizmo sales is grouped, for example. Use summary rows under each subsection. To set up your outline, highlight blocks of data you want to expand and collapse as a unit. In the example, cells that show the breakdown of who sold which widgets and gizmos are grouped. The salespeople's names, column that indicates widgets, and the column that shows how many they sold are highlighted. Click the minus sign to hide the breakdown of widget sales or click the plus sign to see the details. In a setup like this, you should group the numbers that add up to the total but not the row that reports on the total. Excel puts the plus/minus icon on the row below the last one you highlight. If your groups include the row that shows the totals, it will disappear when you click the minus sign to collapse the section.

This article presents tips for formatting cells in Microsoft Excel 2002. To a copy the aspects of a cell's formatting to another, click the formatted cell and click the Format Painter button on the Formatting toolbar. Click the cell that will be formatted. To copy the formatting to several cells in succession, double-click the Format Painter button before clicking target cells. If a user develops a preferred cell format that includes many factors, the user should create a style that allows the application of all those elements with one step. Choose Format and Style. At the top of the dialog box, enter a name for the style. Click Add and Modify to start defining the style. Use the items on each tab to set the font, border, alignment, and other factors that will apply to cells defined with the style. Conditioning formatting makes its easier to pick out important points from large bodies of data. Choose Format and Conditional Formatting. Use the data boxes to set up the criteria that trigger the conditional formatting. Click Format to indicate what should happen when the criteria are met, such as the font turning red. Click OK. Excell provides a couple of slick ways to help if the user losses track of which cells in a worksheet have conditional formatting. To find cells with conditional formatting, choose Edit and To and click Special. Click the Data Validation radio button and click All or Same, depending on whether to find cells with any conditional formatting or just those that match the selected cell.

This article details the process of converting Microsoft PowerPoint 2002 slides into a Web-friendly format. Begin the process by clicking the File and Save As Web page. choose a destination for the presentation and enter a name for it just like in any other Save As operation. The Page Tile line toward the bottom of the Save As dialog box displays the words that appear in a browser window's tile bar when someone opens the presentation online. Next up is the Save As Type drop-down menu. Her once can choose to save the file as a Web Page or a Web Archive. Web pages include many elements, including the page's hypertext markup language coding, photographs, animations and sounds. The two Save As options address different ways of packaging all of these parts. The Wen Archive option puts all of the elements in one file, while the Web Page option create a new folder that holds all of the elements as separate files. To check how the presentation will look online, choose File and Web Page Preview. The presentation will open in the computers in the computer's default browser. One can click the pen Published Web Page In Browser checkbox in the Publish As Web Page dialog box. Or use the browser's File and Open feature to navigate the file and open it.