In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data. A major strength of Excel is that you can perform mathematical calculations and format your data. Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. Lesson 2: Entering Excel Formulas and Formatting Data You use the window to interact with Excel.
This lesson will introduce you to the Excel window.
Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This tutorial teaches Microsoft Excel basics. You can also use it to perform mathematical calculations quickly. You can use it to organize your data into rows and columns. Microsoft Excel is an electronic spreadsheet that runs on a personal computer.
You can use this free online tutorial to learn Microsoft Excel 2007.
You can type a question in the Search for a function box and click GO.There are three ways to locate a function in the Insert Function dialog box:.If you don't see the function you want to use (Sum, Average, Count, Max, Min), display additional functions by selecting More Functions.On the Formulas tab, click the drop-down part of the AutoSum button.Using the point-click-drag method, select a cell range to be included in the formula.Click the Enter icon to calculate the average.Īccessing Excel 2007 functions To access other functions in Excel:.Left-click and drag the mouse to define a cell range (C8 through cell C20, in this example).Click on the first cell (in this example, C8) to be included in the formula.Click the drop-down arrow next to the AutoSum command.Select the cell where you want the function to appear.To calculate the average of a range of data: Click OK in the dialog box, and the sum of the two ranges is calculated.You can alter the cell range if necessary. The AutoSum command automatically selects the range of cells from G2 to G41, based on where you inserted the function. This formula, =SUM(G2:G41), is called a function.A formula will appear in the selected cell, G42. Select the drop-down arrow next to the AutoSum command.From here, you can access all available functions. To calculate the sum of a range of data using AutoSum: You don't have to memorize the functions, but you should have an idea of what each can do for you.
Download the example to work along with the video.