Microsoft Excel - Page 2 | Tech-Recipes

Microsoft Excel tutorials

Excel 2007: Have Your Data Read Back To You

Contributed by shamanstears on July 15, 2008 under Microsoft Excel

After taking the time to input a large amount of data, you will want to double check to make sure you entered everything correctly. It can be quite time consuming to have to constantly look back and forth from your printed list to your spreadsheet. A better way is to have Excel read your data back to you, allowing you to check the printed list while listening to the spreadsheet values.

Excel 2007: How To Hide Duplicate Records in a Spreadsheet

Contributed by shamanstears on July 8, 2008 under Microsoft Excel

If you have a large spreadsheet that contains duplicate entries (customer names, class subjects, etc.) and you want to view only the unique records in the list, you can filter out the duplicates.

Excel 2007: Use Data Bars for Cell Value Analysis

Contributed by shamanstears on April 14, 2008 under Microsoft Excel

Data bars make it easy to analyze the values in a range of cells. They are colored, horizontal bars whose length is dependent upon the value of the cell. The cell value itself, rests in front of the data bar, so the data is still easy to read. Using data bars can be helpful in easily determining high and low values. By default, Excel will configure the data bars based on the highest value and the lowest value in the range of cells. By default, Excel will configure the data bars based on the highest value and the lowest value in the range of cells. You can also apply customized data bars to the selected data range.

Excel 2007: Add Minimum, Maximum and Numerical Count to the Status Bar

Contributed by shamanstears on June 29, 2007 under Microsoft Excel

Excel’s status bar can come in handy by giving you additional information when you select a range of cells. By default, it displays the Average, Count, and Sum. You can also include Minimum, Maximum, and Numerical Count, or any combination of the six options.

Excel 2007: Change the Default File Location

Contributed by shamanstears on April 24, 2007 under Microsoft Excel

By default, Excel uses your Documents (if you use Vista) or My Documents (if you are using XP) directory as the location for saving files. To change the default file location, follow these steps:

Excel 2007: Use Custom View

Contributed by shamanstears on March 28, 2007 under Microsoft Excel

If you find yourself modifying the display of your worksheet multiple times in the course of working with your spreadsheet, then the Custom Views functionality is definitely for you. Custom Views allows you to save changes to current position and magnification, column widths, row heights, print settings, frozen panes and more. Instead of constantly making these modifications and changing them back, you simply select your custom view and you’re there, switch back to your normal view and you’re back to the default view.

Excel 2007: Print High Quality Graphics

Contributed by shamanstears on March 23, 2007 under Microsoft Excel

If you use graphics in your Excel spreadsheet and need them to really shine, print them out in high quality mode. Here’s how:

Excel 2007: Show Formulas to Verify Your Equations

Contributed by shamanstears on under Microsoft Excel

One mistake that is often made in spreadsheets containing lots of data and formulas, is the accidental placement of numbers in a cell instead of the formula. It is a painful task to examine each and every cell one at a time to verify that the proper cells are using the proper equation. In addition, verifying that the cells referenced in the equations are correct can be equally overwhelming. Fortunately, Excel allows you to show the formulas of the entire spreadsheet so that you can more easily check your work. Excel 2007 does a great job of automatically expanding the cell size to accommodate long equations. Once you are finished verifying the formulas, a simple click of the mouse returns the spreadsheet to it’s normal data view with your formatting intact.

—