₦airaland Forum

Welcome, Guest: Register • Login • With Google • Trending • Recent • New

Stats: 3,346,020 members, 8,520,684 topics. Date: Wednesday, 18 November 2026 at 08:56 AM

Toggle theme

Esere826's Posts

Nairaland Forum › Esere826's Profile › Esere826's Posts

1 2 3 4 5 6 7 8 ... 36 37 38 39 40 41 42 43 44 (of 94 pages)

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op):
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 <-|->

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op):
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

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 10:41am On Jun 17, 2013
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
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 10:36am On Jun 17, 2013
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

Literature › Re: In Need Of A Very Short Story by esere826: 8:57pm On Jun 14, 2013
clemmonce: thanks you got me laffing with the reward on earth stuff...okay but how can i get across to her ... this private message here on nairaland does not work for me ooooo i dont know how to use it
She has a thread called Iyawo Nylon bag. drop her a message there
Career › Re: Do You Believe In Luck? by esere826: 10:56am On Jun 14, 2013
@OP

I have never really felt lucky sad
Everything I have had, I have always felt I deserved and much more

If I own Glo, or even become Nigerian president, I'd feel I deserve it and even feel short-changed
Literature › Re: In Need Of A Very Short Story by esere826: 10:51am On Jun 14, 2013
@Clemmonce

Plead with Ishilove to help you out. Also tell her what her reward will be on earth if she helps out wink
For example, you cld ask that she is involved in the production of the drama, and that your church will take care of her logistics etc
Career › Re: About Sap? by esere826: 7:59am On Jun 13, 2013
markos: whats the latest in your SAP career, this thread is quiet, have people realised that there are no cutting corners in the SAP world, have people realised SAP career can take up to 10 years before you start earning decent money?? whats your thoughts?
shocked 10 yrs!!!?? there goes my SAP dreams
So if SAP is overtaken by a new ERP, I wld have lost all my investment
Nairaland General › Re: The War To Come -Cutting Off The River Niger At Guinea by esere826(op): 4:54am On Jun 13, 2013
Interesting that Egypt and Ethiopia are facing similar issues on utilization of river Nile
http://www.guardian.co.uk/world/2013/jun/11/ethiopia-rejects-egyptian-protests-nile-dam
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 4:49am On Jun 13, 2013
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
Career › Re: A Harsh Take On Locally-Trained Nigerians by esere826: 4:41am On Jun 13, 2013
*sits down, chopping pop corn and watches the bottles fly*
*all these locally trained combatants vs the foreign mercenaries*

*eyes the Tpia girl with her forked tongue. She might make for a great war booty (no pun intended)*
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 11:55am On Jun 06, 2013
salsera: do you have any links for advanced skills, e.g pivot charts and T or F formulas
i need a refresher course
This guy will teach you everything you need to know in a fun way: http://www.youtube.com/user/ExcelIsFun (He is however not strong in VBA)
Another chap is MrExcel. But he is more technical in his approach plus he knows VBA
Literature › Re: Two Can Play The Game - A Competition To Test Your IQ (Be A Critical Thinker) by esere826: 7:08pm On Jun 05, 2013
Cuddlemii: Don't kill yourself O
This your hyperactive trait needs to be calmed down with a wet kiss
You truly deserve it! haha!
*sits with bum on the floor and outstretched paws*
*pants heavily salivating with rolling tongue licking his canines*
*does a little macho growl*
*and winks* wink

Travel › Re: Yet To See A Nigerian That Has Done A Bungee Jump... by esere826: 10:01am On Jun 05, 2013
olasberguk: Yet to see a Nigerian that has done a bungee jump...
Still seaching....if you have done it before ,lets hear about your experience.
I have not done a bunjee jump
But there is someone who is at this very moment cooking in my kitchen that has done it wink
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op):
princessmay: Pls were will i get ribbon dat ll enable mi to click on insert.
U see the diagram below?
That entire big blue box at the top is called the ribbon
The first tab on the top Left is the Ribbon's Home,
The tab after it is the Ribbon's Insert

(I'll delete the image later cos its taking up space, and make im no chop people megabyte)
Christianity Etc › Re: Ww3 Armageddon Update by esere826: 11:22pm On Jun 04, 2013
Befor u get excited about world war III
what made the first 2 be defined as world wars?

Its not like every nation in the world were fighting
Career › Re: Not Happy With Career Path! Help by esere826: 11:11pm On Jun 04, 2013
my child
you said:
i dont see myself in any field of electricity
This is the single most important thing I have learnt with the pain of my grey hair:
If you cant see it, u cant have/be it

Look out for what 'you can see' so that u dont struggle in life
when u do see ur future in a career path, struggles become challenges, and challenges will become exciting
even soaking garri within your sphere of vision will become like cornflakes

but meanwhile, go to class and 'struggle' until 'you've seen' what u need to do and the oppurtunity beckons u to grab it
Literature › Re: Two Can Play The Game - A Competition To Test Your IQ (Be A Critical Thinker) by esere826: 10:59pm On Jun 04, 2013
o my cuddlemii is back
*hugs the thread*
*kisses the thread*
**somooches the thread*
* grabs a jar ..*
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 1:57pm On Jun 04, 2013
Tips:

Great that some folks are learning

When u are in your Excel sheet and somehow get lost is a maze of data or empty space
you can find your way back to the first cell A1
by simply placing your finger on 'ctrl' key then clicking on 'home' key at the same time


the 'home' key is somewhere at the top right hand corner of your keyboard
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 6:56am On Jun 04, 2013
Excel/spreadsheet skills are a must have
especially for those in the UK
Even if na dead body u dey wash for there, Spreadsheet skills will bring you before your Oga like Josephs dreams brought him before pharoah

If in the UK without a good job, u can tie this skills with strategy I posted here: https://www.nairaland.com/950830/before-leaving-nigeria-things-must/4#10993340 Look out for my post all the way to the end
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 10:16am On Jun 03, 2013
Lets say you have more items that you want to add up, and the space seems restricted
What u do is to create a new row

Click on cell B8
place you finger on the 'alt' key, and at the same time, click on key 'I' then 'R'

yo will see a new row appear
You can put in data into this new row, and it will also add up at the bottom

*NOTE that the reason it adds up is because earlier, you used the equation =sum(B5:B9)
This equation is very flexible and can easily expand

if you had typed in addition like this: =B5+B6+B7+B8+B9
A new row within your summation block wouldnt have been automatically added
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 4:00pm On Jun 02, 2013
By the way, you can add some complexities to your spreadsheet

For example yo could create another set of summation that feeds data into cell B9
(the data for 'others')

click on cell H7....Type: 1000...click enter
click on cell H8....Type: 3000...click enter
click on cell H9....Type: =sum(H7:H8)...cclick enter

now go to cell B9...Type: =H9...click enter


cell B9 will henceforth be driven by data from H9
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 2:08pm On Jun 02, 2013
ANY QUESTIONS, COMMENTS? smiley

The next lesson (on another thread) will be on Visio
Not everyone needs to learn Visio
But it could be useful in showing you how you make and take decisions at home and work
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 2:02pm On Jun 02, 2013
You can now see that Enjoyment takes up most of your money

At work, such chart quickly shows 'oga at the top' where the bulk of expenditure is spent

(Remember to save oooo)

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 1:52pm On Jun 02, 2013
Step 7

You might have the need to quickly visually see where the bulk of your money is spent especially compared to other expenditures

Firstly
Click on cell A5...drag to Cell B9

Secondly
Go to ribon and click on 'insert'
Click on 'Pie' on the ribbon

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 1:38pm On Jun 02, 2013
Step 7: Input numerical dat plus some calculations

click on cell B3......Type: 100,000...click enter
Click on cell B5......Type: =B3*0.1 ..click enter
Click on cell B6......Type: 10,000....click enter

Click on cell B7......Type: 20,000....click enter
Click on cell B8......Type: 30,000....click enter
Click on cell B9......Type: 20,000....click enter

Click on cell B10 ....Type: =sum(...then click on cell B5 and drag downwards to cell B9....Type: ) ...click enter

Click on cell B12.....Type: =....then click on cell B3.....Type: -.....then click on cell B10......click enter

Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 1:11pm On Jun 02, 2013
Step 6: practice begins

Go to Excel

click on cell A1......Type: My monthly salary vs expenditure....click enter
Click on cell B2......Type: Naira.....click enter
Click on cell A3......Type:Monthly Salary....click enter

Click on cell A5......Type: Tithe.....click enter
Click on cell A6......Type: Transport...click enter

Click on cell A7......Type: Feeding.......click enter
Click on cell A8......Type: Enjoyment......click enter

Click on cell A9......Type: Others........click enter
Click on cell A10 ....Type: Total Expenditure...click enter

Click on cell A12.....Type: Balance.....click enter


(* Hang on there, dont give up yet. This will soon be so easy you'd do it in a minute or less)
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op):
Step 5: calculating your expenditure against your salary:

You can start by writting down what you expect to spend for the month, or calculate what you have spent at the end of the month

Per month

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


We'll take this into Excel
Career › Re: Learn How To Use Excel Spreadsheets For Beginners by esere826(op): 11:40am On Jun 02, 2013
Step 4 learning to save for retrieval

Click on the Window icon at the top left hand corner of your computer
Click "save as"
A tray of different ways you can save excel is exposed
I usually choose either: Excel Workbook or Excel 97-2003 workbook
Click on the desired format.....
Figure out the rest for ya self


*hint if you save documents with memorable keywords in the name, you can always do a 'find' from the window icon at the bottom left of your computer

1 2 3 4 5 6 7 8 ... 36 37 38 39 40 41 42 43 44 (of 94 pages)