Microsoft Excel
When editing an Excel file with multiple formulas, it is sometimes useful to switch between Excel's normal display, which shows the results of the ...
Mon, 23 Jun, 2014 at 3:42 PM
When you're working on a worksheet that contains formulas, there is an easy way to quickly navigate through all the cells referenced in a formula: Highl...
Mon, 23 Jun, 2014 at 3:49 PM
Restricting access to an Excel document
1. Click on "File" and then go to "Save As".
2. Choose a location where the file...
Mon, 7 Dec, 2015 at 2:02 PM
Like all other MS Office programs, Excel offers many convenient keyboard shortcuts to help make dealing with spreadsheets easier. Most people know about usi...
Mon, 23 Jun, 2014 at 4:00 PM
When creating a series of charts for a project, such as an annual report, you will usually need to reuse the same basic format. Excel allows you to create...
Mon, 23 Jun, 2014 at 4:55 PM
Sometimes when working in Excel, you end up with your data not all in one region on the worksheet. Fortunately you can still work with it. When you want to ...
Mon, 23 Jun, 2014 at 5:05 PM
One useful feature of Excel is that it automatically fills a row with the names of months or weekdays when you type in the first few items in the row. To d...
Wed, 25 Jun, 2014 at 12:05 PM
Sometimes formulas are not as clear as they could be. A formula that looks like '=C2*C5', for instance, is much harder to understand at a glance tha...
Wed, 25 Jun, 2014 at 12:09 PM
Large numbers, such as thousands and millions, are often easier to work with as a rounded number than the exact value. You can set the cells containing larg...
Wed, 25 Jun, 2014 at 12:14 PM
For a lengthy list, shading alternate rows can improve legibility. This is simple to do with Excel's Conditional Formatting feature, which allows you ...
Wed, 25 Jun, 2014 at 12:31 PM