1. Computing

Learn Excel

Learn the Small Stuff in Excel

By

This series of tutorials will help you learn the small things in Excel that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, or how to quickly undo mistakes you just made. Each tutorial in Learn Excel includes a step by step example.

Add the Current Date in Excel

Learn Excel 2007
Learn Excel 2007
Dates are important in spreadsheets. Most if not all spreadsheets should show the date. Learn how to quickly add the current date to an Excel spreadsheet.

Change Column Widths in Excel

Learn Excel 2007
Learn Excel 2007

As with all things Microsoft, there is more than one way to change column widths in Excel. This tutorial covers how to change column widths using options available on the ribbon and changing column widths using the mouse.

Insert a New Worksheet in Excel

Learn Excel 2007
Learn Excel 2007
By default, Excel only gives you three worksheets in each new file. Often this is not enough. Learn how to quickly insert a new worksheet into an Excel spreadsheet with this tutorial.

Use the Name Box to Navigate an Excel Spreadsheet

Learn Excel 2007
Learn Excel 2007
For larger worksheets (remember there are over 16,000 columns and more than one million rows in a single Excel 2007 worksheet) there has to be a better way to get around then endless scrolling with the mouse - and there is - by using the Name Box. Learn how to jump from one area of your spreadsheet to the next in this tutorial.

Excel's Undo Feature

Learn Excel 2007
Learn Excel 2007
Ever make a mistake in Excel? Who hasn't? Learn how to quickly fix mistakes such as deleting data, applying incorrect formats, or moving formulas using Excel's Undo feature.

Select All Cells in Excel

Learn Excel 2007
Learn Excel 2007
Sometimes we need to make changes to an entire worksheet. It might be a background color change, change the widths of all columns, or apply number formatting to every cell. The best way to make changes of this sort is all at once to every cell in the worksheet. Learn how to select all cells in Excel in this tutorial.

Copy and Paste in Excel

Learn Excel 2007
Learn Excel 2007
You can save a great deal of time in Excel by copying data, formulas, and formatting rather than repeating the steps needed to recreate or reapply them over and over. Learn how to use Excel's copy and paste options to copy items to different areas of the same worksheet, different worksheets, or even different Excel files.

Move Data in Excel

Learn Excel 2007
Learn Excel 2007
Sometimes we don't need to copy data, headings or formulas, but just move them to a new location. Learn how to do this using Excel's cut and paste features.

Merge and Center Data in Excel

Learn Excel 2007
Learn Excel 2007
Spreadsheet titles often look best when they are centered over all the columns used in the worksheet. Getting the title exactly center though can be next to impossible if you just try typing it in. Learn how to use Excel's Merge and Center feature to quickly and painlessly get the title exactly centered over your data - the first time.

Wrap Text in Excel

Learn Excel 2007
Learn Excel 2007
Sometimes column headings are very long - much longer then the data they are describing. Rather than leaving big white gaps in your spreadsheet, learn how to place text on multiple lines within a single cell using the Wrap Text feature in Excel.

Print Gridlines and Headings in Excel

Learn Excel 2007
Learn Excel 2007
If you are printing a large worksheet, it is sometimes difficult to read the data across several columns without losing track of which row you are in. Learn how to printing gridlines to makes it easier to read your data.

©2014 About.com. All rights reserved.