excel

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)

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)

The millions of office and home office users that take advantage of Microsoft's Excel should be very careful. Last week, the company warned the public of a "zero-day" attack that acts upon certain weaknesses in the program. As expected, it's based ... on an email attachment threat, although it appears to look legitimate enough to pose a serious threat. While Microsoft's security advisory attempts to calm users by stating that the attack is "very limited", it's still got many businesses worried. According to reports, hackers are sending email packing malicious Excel attachments that are able to ... (view more)

Discover how to create stunning letters, effortless spreadsheet reports, dazzling PowerPoint presentations, and much more -- just like the professionals! Attention MS Office users -- Do you just muddle through and make do with the basic features of ... MS Word? Do you gawk at the gigantic array of features found in MS Excel? Do you feel powerless when using MS PowerPoint? Enough already! If you're like one of the millions of bewildered users around the world aching to unlock the simple secrets behind MS Office, now's your chance to shine! Announcing Carol's Corner Office Tips and Tricks eBook ... (view more)

Users of Excel's immensely popular spreadsheets are increasingly having to look over their shoulder. Insiders are today reporting that a new security leak -- for the third this month -- has been discovered within the program. Excel 2000, 2002, 2003 ... and Office 2000, XP and 2003 are all affected, and the fallout is driving accountants into the fetal position. The most recently reported flaw allows attackers to carry out their own commands by convincing a user that a repair is needed on a specific file. Once that file is opened, hackers can do what they wish to an affected users' system. Caught ... (view more)

You don't have to have two separate pages, one from MS Word and one from Excel, to display text and numbers in your document. This is because Word and Excel are built to work together, so that you can seamlessly bring your data from Excel into Word. ... Using Excel to generate your numeric data opens the door to more sophisticated calculations and numeric formatting. You can use all the features of Excel for making calculations, rather than being limited to the few formulas available on Word's Table | Formula command. Copying between Excel and Word uses the same techniques you know already: Open ... (view more)

Suppose your Excel worksheet has a long list of numbers to add. You can sum them instantly using Excel's AutoSum feature. Don't count on your fingers or pull out a calculator; Excel can calculate more quickly and accurately. Even more importantly, ... whenever a number changes, Excel instantly recalculates and displays the corrected sum. You can use either of these two methods to total the numbers using Excel: Click the cell below the list to make it the active cell. Click the AutoSum button. Excel surrounds the cells it thinks you want to total with a moving border. Press Enter or click the ... (view more)

While you are building an Excel worksheet, it is held in a temporary memory within your computer (called "RAM", or random access memory). Unlike human memory, the computer won't remember anything unless you save your work. If you turn off the ... computer or if the power goes out, all your work disappears. To store your work permanently, you must save it on a disk. The First Time You Save You can save a spreadsheet by using any of these methods: Choose File | Save. Click the Save button on the toolbar. Use the shortcut key Ctrl+S. The first time you save, the Save As dialog box appears ... (view more)

Most folks know the agony of having to resize column widths in Microsoft Excel when you move data from one formatted spreadsheet to another. Thankfully, Microsoft Office 2002 and 2003 offers you some relief from this painstaking chore! Prior to ... Microsoft Excel 2002, you had to use the Paste Special menu to retain the column width settings of the source file. However, if you use the 'Smart Tags' function in Excel 2002 and 2003, your column widths will be reformatted in just a couple of mouse clicks! Simply follow these steps in Excel 2002 or Excel 2003: Copy the data that you want transferred ... (view more)

Infopackets Reader Jon M. writes: "Hi Dennis! I recently uninstalled a program called 'RoboPDF' (not related to RoboForm ). Now, I receive an error message that "C:\ Program files \ Microsoft Office \ Office \ Startup \ roboPDF.xlt could not be ... found' every time I launch Excel. I was wondering how to get rid of this from appearing? " My response: I researched some topics in the MS Excel Help File, and found info relating to how Excel starts. Basically, the XLStart folder typically contains a bunch of mini-programs (called macro files) which execute every time Excel starts. A ... (view more)