Using formulas tab in excel 2007 with autosum and insert function commands

http://www.learningcomputer.com/index.html

In Microsoft Excel 2007, mathematical computations are typically done by built-in functions and formulas. excel has a library of several hundred functions that will let you perform a number of mathematical and statistical calculations. E.g. You can use the sum function to add numbers, average a list of numbers, the PMT function to figure out a payment on a loan, so on and so forth. For our lesson today we will be using Grades data.

Category:

Howto & Style

Tags:

• excel
• formulas
• Excel
• Bank
• Reconciliation
• Make
• Table
• in
• microsoft
• open+online
• spreadsheet
• Microsoft
• Template
• Checking
• Checkbook
• Register
• Spreadsheet
• Formulas
• energy
• Calendar
• Double
• Elimination
• Free
• Templates
• 2007
• templates
• tutorial
• help
• automated
• character
• sheet
• Download
• of
• EXCEL
• Autosum
• Insert
• Function
• average
• calculation
• Total
• summation
• formula
• bar
• grade
• workbook

[joshteriyaki2]

go go go.. this helps me a lot...

[baghul]

@joshteriyaki2 I am glad, thanks. Liked your channel, you should def upload more videos! ;-))

[kamikim1]

TALKING ABOUT THE FORMILAS I NEED A HELP O THIS : I N MY WORK SHEET I JUST CREATED I M USING =NOW(),WHICH WORKS FONE FOR ME BUT THE PROBLEM STARTS WHEN I OPEN SAME SHEET A FEW DAYS LATER IT THEN UPDATES TIME AND DATE WHICH I DONT WANT , INEED TO KEEP THE SAME DATE AND TIME

ANY HELP PLS

[baghul]

@kamikim1 The NOW function will always return the current date, are you trying to keep a fixed date?

[kamikim1]

@baghul yes fixed date and time

[baghul]

@kamikim1 Hi if its fixed date, you should be able to enter a date and then use formatting to get it in the right format.

[kamikim1]

@baghul yes

[baghul]

You are very welcome!!

[Saintboss]

Beautiful Baghul... Thanks.

[baghul]

Thank you for your nice comments. Have a great day.