Wow! op you are doing a great job. Keep it up, now following

Good! I have learnt something new today.

Though hough I did it on Quickoffice pro on my android phone.
Waiting for the day the knowledge will be useful.
The process is similar but when it gets to the calculation part, you realise that...... @op! you deceived me into thinking this tutorial was for the beginners and coconut-brainers as you emphasised.

You didn't think we coconut-brainers would want to know how you came up with those equations you used or what ? For example I had to think up the church-meaning of tithe as the one tenth of one's income before I grasped why the hell you had to put (=B*0.1) in B5 instead of the N10000 you outlined here.........

Salary =N100,000
Tithe = 10,000
Transport = 10,000
Feeding = 20,000
Enjoyment =30,000
Others = 20,000
Total expenditure = 90,000
Balnce = 10,000

Overall, It was a genuine lesson, but frankly due to the absence of term definitions and all, I had to do about all the thinking as to why some of the inputs should be put where they were put.


Looking forward to seeing the
rest of the lessons or is it done?

Sylvekzee: Good! I have learnt something new today.

Though hough I did it on Quickoffice pro on my android phone.
Waiting for the day the knowledge will be useful.
The process is similar but when it gets to the calculation part, you realise that...... @op! you deceived me into thinking this tutorial was for the beginners and coconut-brainers as you emphasised.

You didn't think we coconut-brainers would want to know how you came up with those equations you used or what ? For example I had to think up the church-meaning of tithe as the one tenth of one's income before I grasped why the hell you had to put (=B*0.1) in B5 instead of the N10000 you outlined here.........



Overall, It was a genuine lesson, but frankly due to the absence of term definitions and all, I had to do about all the thinking as to why some of the inputs should be put where they were put.


Looking forward to seeing the
rest of the lessons or is it done?

Bros nor mind our teacher o.... e just dey try tell us say, incase you get coconut head, you better go drain the water comot , because seriously, excel is the most tasking package of the whole lot...

Back to topic... fantastic job op, hopefully peeps can take advantage of this and become better at using this awesome package.

Personally am already in advanced level... currently studying VBA and am loving it...
Shebi dem say we wen nor get 2.1 no go get jobs, lets wait and see na.... we go learn until we sabi everything ni...

Oga esere abeg make the lessons continue, but tell them say na those when their coconut head nor get water again go fit understand am o

I actually taught excel during my NYSC to fellow corpers, so if our input is needed, we will happily become your graduate assistant

Time is what I have plenty of at the moment, but hopefully not for long

LOL

u guys are really funny. But good to know ur learning,.... and learning fast
Spreadsheets are extemely useful o.. for life and work

Even when I am broke, Spreadsheets tell me how to navigate with my lean finances

I'll gradually push out more Excel knowledge. I just need to ensure that what I put out is usefull to all

@esere826, thank you so much. Please do not stop. More lessons please!

@ op - GOD GO BLESS U FOR THIS IMPORTANT PRACTICAL TUITORIA TIPS... I HAVE BEEN LOOKING FOR THIS KIND OF PRACTICAL EXPLANATION WITH THE AID OF DIAGRAM ON HOW TO USE EXCEL ET AL... PLEASE I BEG U IN THE NAME OF GOD TO PLEASE SEND TO MY EMAIL ADDRESS THE FULL VERSION OF THIS TYPE OF PRACTICAL PRESENTATION ON HOW TO USE EXCEL,POWER POINT,MS WORD,COREL DRAW,OUTLOOK ET AL.. ...MY EMAIL IS - olaklives05@yahoo.com ... hope to see your beep..GOD BLESS YOU WITH THIS TIP..AM A GRADUATE OF ACCOUNTING BRO.. MOD MOVE THIS THREAD TO THE FRONT PAGE PLS

@ ESERE - PLS DNT STOP THE LECTURE , JUST CONTINUE PLLLLLLLLLLLLLLLLLLLLLLLLLLLLSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

@op. Pls we need you to continue. Some of us can't afford to go to standard IT schools to get this invaluable knowledge u've been sharing.

Pls go on op. My email is kuntosh73@gmail.com
Twitter @kuntosh

YOUR LIFE BEFORE YOUR EYES

1st Goal: Erase all data from your Excel sheet

-With your cursour, Go to the box between the left of A column and top of 1st Row (see figure 1 in diagram below)
-click on the box. This automatically highlights all data in the sheet (see figure 1)
-press on the key 'delete' on your keypad. This deletes all data in the sheet. The 'delete' key might be somewhere on the Right hand side of your keyboard

You can recover all you've lost by pointing your cursor to the 'undo typing' (see figure 2) and clicking with your mouse

YOUR LIFE BEFORE YOUR EYES 2

Assuming you are wondering what to make of your life in the years to come, Spreadsheets could be extremely usefull
Lets see:

Year: 2013; Your Age: 19; Your Uni level: Yr 1

we will look out for dates we shld be married, have our houses, have kids, buryour parents, send our kids to school, and kick the bucket at a repectable age etc using spreadsheets

In cell A1, type: Year .... In cell B1, type: Uni Level ....In cell C1, type: My age
In cell D1, type: Dad's age ... In cell E1, type: Mums Age ...In cell F1, type: 1st child's age
In cell G1, type: 2nd child's age...... In cell H1, type: 3rd child's age

YOUR LIFE BEFORE YOUR EYES 3

You notice that sizes of cells E, F, G, and H are too small for the data inputted into them.
To expand the cells so that data fits more nicely into it, you can do any of these:

Move your cursor gently to the line seperating one column from the next
For example,
move your cursor to the line dividing header F, from header G
u'll notice that the cursor shape has changed from something like this + to something like this <-|->

***Raising my right hand***
Why is this not on front page?
***Continues browsing***

rodeo0070: ***Raising my right hand***
Why is this not on front page?
***Continues browsing***

because its not finished.
1stly, because if it hits front page when it is not finished,... we'll all have fun making a mess of it with comments by the likes of Yuzedo etc

YOUR LIFE BEFORE YOUR EYES 4

now, when your cusor changes to this <-|->
double click and drag the line either left or right to expand or contract it
then relaese the click

You can also do same to the horizontal sizes by clicking on the header sections of the rows,
for example, between 1 and 2

YOUR LIFE BEFORE YOUR EYES 5

Another way of expanding the cells is by first clicking on the cell between the left of column header A and top of row header B
(This highlights the entire spreadsheet)

You can then resize any of the row or column headers as I demonstrated in the earlier post
(This sizing affects the entire spreadsheet)

esere826:

because its not finished.
1stly, because if it hits front page when it is not finished,... we'll all have fun making a mess of it with comments by the likes of Yuzedo etc

True talk...

Good thread. Closely following

@ ESERE - May God bless your generation..i dey follow this thread..pls continue ooooooooooooooooooooooooooooo...waiting mode for the remaining lecture...

Good job.

Pls does any one knw a site whre I can downlOad. Apptitude test for free?I v test on friday...pleaseeeeee

Good work Mr.sinister

@ esere - pls we are seldomly waiting for u to complete this strategic topic

nkiie: Pls does any one knw a site whre I can downlOad. Apptitude test for free?I v test on friday...pleaseeeeee

Go to my profile and send me a mail, and I would send you the PDF attachment for free I have it on my laptop.

Nice Job you are doing..... Pls crazy man can i send u send me d attachment too?

Nice job..really learn from this.Thumbs up

Sorry guys
I am a little bit busy at the moment.
I'll return to update next week...
Just keep on practicing what you've already learnt

.......Cheers