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

253 out of 454 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

225 out of 411 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

205 out of 385 people found this comment informative.

Rate This Post:

Thanks lot

thank you for assisting..

Anonymous, Wednesday, January 23, 2008

201 out of 378 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

156 out of 295 people found this comment informative.

Rate This Post:

Thanks!

Very nice intro!

Anonymous, Thursday, February 28, 2008

144 out of 277 people found this comment informative.

Rate This Post:

Cool Tut

I really got usefull from this Tut

Anonymous, Friday, February 29, 2008

146 out of 279 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

122 out of 243 people found this comment informative.

Rate This Post:

excel

excel is a wonderful program but it is being taught to me by an idiot thats why it is taking a whole semester to learn

Anonymous, Wednesday, March 26, 2008

101 out of 199 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

71 out of 152 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

68 out of 140 people found this comment informative.

Rate This Post:

Nice

Nice topic
Thanks
I have found two interesting sources ( http://fileshunt.com and http://filesfinds.com ) and would like to give the benefit of my experience to you.

Rapidshare, Saturday, May 24, 2008

47 out of 95 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

50 out of 98 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

43 out of 89 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

41 out of 80 people found this comment informative.

Rate This Post:

thanku

iam the original commentand hear to licence

Anonymous, Tuesday, June 24, 2008

32 out of 64 people found this comment informative.

Rate This Post:

what about access 2003

i didn't saw any of it why don't you prepare for it. please!!!

Anonymous, Wednesday, July 02, 2008

28 out of 55 people found this comment informative.

Rate This Post:

Kuno ndi ku Malawi

Taonga peji yinu njiwemi - njakusambizga. Kweni sazgirani Excel ma Macros.
Yewo!!!

Anonymous, Thursday, July 31, 2008

27 out of 45 people found this comment informative.

Rate This Post:

Mr. Anonymous

Yes it's really good. Thank you. pliz, include more downloads.

Anonymous, Thursday, July 31, 2008

25 out of 43 people found this comment informative.

Rate This Post:

Miss Anonymous

Yes the free tut is really helping, i really appreciate. keep the good work. Kudos to u all

Anonymous, Saturday, August 02, 2008

15 out of 31 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...