Carol Bratt

You can add a date in MS Excel by simply using the =SUM function. Since Excel stores dates as a number of days, no further effort is required of you. Follow the steps below to see how to add dates: To add five days to 08/25/07, type the date in A1. ... In B1 type =A1+5, which will give you 08/30/07. To add a number of months or years to a date, you first will need to decompose the initial date into its year, month and day components, add in the desired offset, and then have Excel put the components back together. Follow along below: Type a date in A1, to which you would like to add 3 months and 4 ... (view more)

You can add times in MS Excel using the =SUM worksheet function. All you have to do is enter all of your times as HH:MM:SS, and then use SUM to add them. You may omit the :SS if you like. By default, Excel will display the sum of times in ... time-of-day format, such that adding 12:30 + 12:45 will give you a total of 01:15. You can prevent MS Excel from rolling over at twenty-four hours by formatting the total cell as [h] :SUM, which will cause the total to display as 25:15 rather than 01:15. Another way of adding times is to use the TIME function. Follow along below: To add 2 hours, 30 minutes ... (view more)

There are many different reasons why you might want to round numbers in different applications within MS Excel. Sometimes it is very useful to round times to the nearest hour, half-hour or quarter-hour. The Analysis TookPack add-in module has a ... function that is very useful for this. It is called MROUND. If you are not familiar with the Analysis TookPack, click on Tools| Add-ins and check Analysis ToolPack. Enter a time in A1. In B1, enter the number of minutes to which you want to round the time. Say you want to round to the nearest half-hour, you would use the formula below: =TIME(HOUR(A1), ... (view more)

Philip recently wrote to inquire: I would like to ask if it is possible to still send a fax through MS Word 2007 without actually having to connect to the Internet because since I upgraded to MS Office 2007, the option that used to allow me to send ... faxes through Word 2003 is no longer available. I hope you can help. My Reply: You can easily send faxes from your computer instead of a stand-alone fax machine and you can indeed send a fax using Microsoft Word using your modem instead of the Internet Follow the steps below to fax with MS Word 2007: Open your document in MS Word. Click the Office ... (view more)

During a slide show in MS PowerPoint 2003 if you want to jump to another slide in the show, you can use the Slide Navigator. In Slide Show mode, right-click the mouse button to display a menu of selections. Select Go To. This will bring a list of ... all of the slides in the presentation and allow you to select the one that you want to move to. Click on the slide you want to go to. This is a particularly useful tip when moving to a slide you have added for a Question and Answer session or when re-starting a slide show during a training session. When you become a member at CarolsCornerOffice.com, ... (view more)

You can add, remove and otherwise customize your Office application toolbar. Toolbar buttons usually perform some action (e.g. underline text) or execute a macro. They can do a whole lot more than that too, such as open a Web page! Follow the steps ... below to learn how to do this: On your toolbar, click on Tools | Customize to display the Customize dialog box. Select the Commands tab. Click and drag one of the commands to your toolbar. It doesn't matter which one you drag -- it can be any one of them because it is only going to be a placeholder for now. For our purposes, just drag the first one ... (view more)

Why would you want to create a rule in Outlook? Well, suppose you are the chairman of a committee and everyone has to send you a report that you in turn share with another committee. Wouldn't it be a lot easier when you receive those reports to have ... a rule set up so that they will automatically be sent to the other committee? You bet it would! Follow the steps below to create a rule in MS Outlook: Display the Tools menu and then click the Rules Wizard command. The Rules Wizard dialog box will display. Click the New button. Click the type of rule you want to create. Click the Next button. ... (view more)

One of my subscribers wrote to me recently asking: Do you happen to know how to display paragraph style names in the document window under Word 2007. In the old word I used to go to tools, options, style area width and I cannot find it in MS Word ... 2007 and I use it constantly… Lesley My response: You can still display the Style in MS Word 2007. Follow the steps below: Go ahead and start keying in text in your document or just open a document were you have already applied Styles. Click on Alt. Click on F. Click on I. You should now see the Word Options dialog box. Click on Display. Click on ...<a href="/news/2527/displaying-style-area-ms-word-2007" class="more-link">view more

Almost 50% of the menu bar line is empty in MS Excel. You can use this real estate to add useful icons such as Page Setup, Custom Views, Macro, and whatever else you would like to add. To add icons to the menu bar follow the steps below: Launch MS ... Excel if it isn't already open. Place your cursor on one of the toolbars, right-click, and select Customize from the shortcut menu. Select the Commands tab. From Categories, select File and drag the Page Setup icon to the menu bar. Repeat step 4 for the Custom Views icon (from View) and for the Macro icon (from Built-in Menus). Click Close. These ... (view more)

Sometimes it seems as though Microsoft Excel is almost too efficient. For instance, Excel will automatically update a chart when you make a change to the chart data. If you need to capture a screenshot of your chart before a change is made, you need ... to break the link to its data source. Follow the steps below to prevent MS Excel from automatically updating your charts: To keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data. Launch MS Excel if it isn't already open. Copy the chart that you do not want to be automatically updated ... (view more)