Learnthat.com

Most Popular

Working with Formulas in Microsoft Excel 2007

by Jeremy Reis on Tuesday, September 25, 2007

60. Now let’s go to cell F4 again.

61. Edit the formula and change it to =IF(E4="","",E4-$B4) and press Enter.

62. The only thing you are change is placing a $ sign in front of the reference to cell B4. This change is to place an absolute reference to column B. When you copy or fill this cell, the reference will always stay with column B, but change the rest of the formula.

63. Now click on cell F4 and press CTRL+C to copy the formula. Paste it in cell H4. View the formula in cell H4:

64. The “B” part stayed the same, while the rest of the formula changed to reflect its new location.

65. Now, fill the formula down in the column to all of the empty cells.

66. Now repeat the process of copying the formula over to the rest of the “Difference” columns for the other months until all of them have the formula filled in.

67. Remember to go back to January and all of February and change the formula to match the new one.

Page 19 of 23

Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | Next Page

Comments

Rate This Post:

It is a good web site

Your site is very nice i appriate you

Anonymous, Sunday, December 23, 2007

354 out of 634 people found this comment informative.

Rate This Post:

Good material

I like your learningthat page. I think it has been very helpful.
Thanks for all the hard work.

Anonymous, Wednesday, January 02, 2008

325 out of 587 people found this comment informative.

Rate This Post:

free courses

it it very interesting and there are a lot of people that do not have the funds for expensive colleges that can learn from you - sorry some courses are not credited or certification,but it's coool.

Anonymous, Saturday, January 19, 2008

307 out of 564 people found this comment informative.

Rate This Post:

Thanks lot

thank you for assisting..

Anonymous, Wednesday, January 23, 2008

298 out of 555 people found this comment informative.

Rate This Post:

appreciation

i'm so thankfull of the respected one running this website. here is so useful matirials that can help people get better.

Anonymous, Wednesday, February 20, 2008

252 out of 475 people found this comment informative.

Rate This Post:

Thanks!

Very nice intro!

Anonymous, Thursday, February 28, 2008

240 out of 447 people found this comment informative.

Rate This Post:

Cool Tut

I really got usefull from this Tut

Anonymous, Friday, February 29, 2008

236 out of 453 people found this comment informative.

Rate This Post:

learning point

I want to learn computer fundamental, jut like to how to create a folder and hide a folder and show it

Anonymous, Friday, March 07, 2008

215 out of 418 people found this comment informative.

Rate This Post:

Commendation

I want to let you all know that you are doing a great job at Learnthat. Keep up the good work

Anonymous, Tuesday, April 15, 2008

165 out of 322 people found this comment informative.

Rate This Post:

very useful

I enjoyed this free tutorial and am looking forward to taking an intermediate one.

Anonymous, Thursday, May 01, 2008

160 out of 310 people found this comment informative.

Rate This Post:

Thanks for the great job

This is a great job..too informative...Thanks a lot

Anonymous, Wednesday, May 28, 2008

141 out of 272 people found this comment informative.

Rate This Post:

Thank you very much

Thank you for the free tutorial. Didn't know ANYTHING about excel before and an honestly say it helped me in starting out!
:)

Anonymous, Saturday, May 31, 2008

132 out of 254 people found this comment informative.

Rate This Post:

Logical Progression of Introductory Material

You have created a user-friendly intro to Excel 2007 that allows the learner to access the information in a sequence that answers questions the normal inquisitive user would have.

Kudos!

Anonymous, Friday, June 06, 2008

132 out of 250 people found this comment informative.

Rate This Post:

molson

Thank you very much. I take excel app. for acct principles at college and the teacher goes too fast. Here I can go at my own pace. :)

Anonymous, Friday, October 17, 2008

49 out of 92 people found this comment informative.

Add a Comment to This Article

Comment Title:

Username:

Anonymous (Please Login to Post With Your Account)

Your Comment:

By posting a comment on this site, you agree to the following terms and conditions: 1. You are not promoting any commercial entity through this post. 2. You are the original author of this comment and heretoafter license That Network to use this post in any form it sees fit, electronic or otherwise. 3. You grant an exclusive worldwide license to That Network for this comment or post.
HTML not permitted, some code allowed in [brackets]:
[b]bold[/b] , [i]italicized[/i], [br] line break, other formatting...