Microsoft Excel - Tech-Recipes

Microsoft Excel tutorials

Excel 2010: Change the number of sheets in a new workbook

contributed by Lê Hoàng on November 25, 2011 under Microsoft Excel

By default, when you create a new Excel workbook, the program will create three new sheets for you. If you usually work on only one sheet, the rest will be unnecessary. Or if you always have to work on a big workbook, then three sheets may be not enough and you have to manually create new sheet. For your convenience, you can change the program’s setting to make it include the number of sheets that you usually have to work on right at the start.

Using Autosum with Microsoft Excel

contributed by Chris Luongo on March 3, 2011 under Microsoft Excel

Many people use Microsoft Excel to crunch numbers and keep track of sales. It’s ability to insert and utilizing formulas is incredible. This tutorial and screencast demonstrates Excel’s powerful autosum feature to calculate the sum and the average of a column of numbers.

Microsoft Excel: How to Hide Tabs

contributed by Rob Rogers on August 18, 2009 under Microsoft Excel

If your spreadsheet is shared and used by others, you may want to keep your formulas and some data from being viewed or changed by others. By hiding the tabs that these are located, you can allow others to use your spreadsheet without having to worry about them playing where they don’t belong.

Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet

contributed by Rob Rogers on April 27, 2009 under Microsoft Excel

If you find yourself yearning to view Twitter updates in a worksheet, then this is for you. Seriously, Excel can be a useful tool for viewing Tweets, allowing you to format them to your liking. You can add multiple Twitter feeds to your worksheet and have an inconspicuous viewer to read them.

Excel 2007: How to Sort Rows

contributed by Rob Rogers on November 30, 2008 under Microsoft Excel

By default, Excel allows you to sort your data by columns. If you run into a situation that requires that you sort the rows, you could do it by hand or let Excel do it for you.

Excel 2007: How to Clear the Values while Keeping Formulas

contributed by Rob Rogers on August 12, 2008 under Microsoft Excel

If you are constantly using a spreadsheet that requires you clear the values but retain the formulas, it can be painful to go through and select each field individually for deletion. Excel makes it easy to do this in just a few steps.

Excel 2007: Use Descriptions in Complex Formulas

contributed by Rob Rogers on under Microsoft Excel

If you are troubleshooting a spreadsheet with complex formulas, it can sometimes be a very time consuming task to figure out what the formula is supposed to be calculating. A good practice to follow is to include a description in the formula itself so the user can more easily understand the purpose of the formula.

Excel 2007: How to Print Comments

contributed by Rob Rogers on August 8, 2008 under Microsoft Excel

It can be quite helpful to have a printout of all the comments that have been inserted on a worksheet. This way you have a hard copy to use as you make any necessary changes to the worksheet.