• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Get control of your email attachments. Connect all your Gmail accounts and in less than 2 minutes, Dokkio will automatically organize your file attachments. You can also connect Dokkio to Drive, Dropbox, and Slack. Sign up for free.


Excel Tutorials

Page history last edited by Donald Achim 11 years, 1 month ago


Home More Free Tutorials Educational Resources

Microsoft Excel 2007 Tutorial—Free & Online
A tutorial by Denise Etheridge

You can use this free online tutorial to learn Microsoft Excel 2007. If you do not have a copy of Excel, you can click here to download the free trial version. Then click here to start the tutorial.

If you are using an older version of Excel, click here for our Excel 97 tutorial.


Lesson 1: Entering Text and Numbers

Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with Excel.

Lesson 2: Entering Excel Formulas and Formatting Data

Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.

Lesson 3: Creating Excel Function, Filling Cells, and Printing

By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.

A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. This lesson teaches you how to use functions, how to create a series, how to create headers and footers, and how to print.

Lesson 4: Creating Charts

In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This lesson teaches you how to create a chart in Excel.

Our Free Tutorials Word Basics 2007 Word Basics 2003/2002 Word Basics 97 Excel Basics 2007 Excel Basics 2003/2002 Excel Basics 97 PowerPoint Basics 2007 PowerPoint Basics 2002 Windows Vista Tutorial Windows XP Tutorial Windows 98 Tutorial Scalable SQL -- A Tutorial RealSlideshow for RealPlayer Guide to Paint Shop Pro Flash Photoshop
Enter your search terms
Submit search form




Online Learning University of Phoenix - Obtain a Degree in Information Technology Online or on Campus. Click Here! The Art Institute of Pittsburgh -- Online Division - Learn Graphic Design Online. Click Here! DeVry University - Earn a Bachelor's Degree Online or on Campus. Click Here!
Legal Privacy

Comments (0)

You don't have permission to comment on this page.