Nairaland Forum

Welcome, Guest: Join Nairaland / Login / Trending / Recent / New
Stats: 1231673 members, 1620109 topics. Date: Tuesday, 02 September 2014 at 03:00 PM

Learn How To Use Excel Spreadsheets For Beginners - Career - Nairaland

Nairaland Forum / Nairaland / General / Career / Learn How To Use Excel Spreadsheets For Beginners (27687 Views)

Beginners In Photography / Research Assistance And Excel Forecast. / Ict Skill Acquisition Institute Beginners (1) (2) (3) (4)

(0) (1) (2) (3) (4) (5) (6) (7) (8) (9) (Reply) (Go Down)

Learn How To Use Excel Spreadsheets For Beginners by esere826: 9:49am On Jun 02, 2013
Hey guys. How una dey.
I am going to teach/baby feed us basic spreadsheets skills. This skill is one you wont regret having.
You could use it in both your every day life, and your career -so, its not a waste of time

We'll practice spreadsheets by analysing your salary vs expenditure. You will now be able to understand how you use your money, and thus dispel ur superstitious believe that na winch dey steal ya money.

I'll also try to use very simple languages so that even if na coconut water u carry for head, u can understand.




*Please pray for me to have the strength to finish this tutorial....Tnx*

21 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 9:55am On Jun 02, 2013
Step 1: Check that you have Excel in your laptop/tablet etc
Re: Learn How To Use Excel Spreadsheets For Beginners by An0nimus(m): 10:25am On Jun 02, 2013
Student #1 cool I get a scholarship that covers materials and tuition Sir?
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:37am On Jun 02, 2013
You can check that you have excel by clicking on the icon that looks like a window (1)
Clicking on (1) opens up (2)
at the bottom of (2), click on "All programs' (3)
Scroll through the list that opens up until you see 'Microsoft ....'
Click on 'Microsoft office' to reveal Excel if it exists

If it does not exist in ur system, then beg ur IT friends to help u install it

3 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:38am On Jun 02, 2013
An0nimus: Student #1 cool I get a scholarship that covers materials and tuition Sir?

Good that you have such materials. Have you applied it?
Re: Learn How To Use Excel Spreadsheets For Beginners by An0nimus(m): 10:54am On Jun 02, 2013
esere826:

Good that you have such materials. Have you applied it?
a bit yeah. it gets complicated along the way. Hopefully you'll help clear that up with time.
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:55am On Jun 02, 2013
Step 3

When you click on 'Excel', the application opens up as shown in the diagram below

Excel is made of a lot of horizontal and vertical lines , much like those old time graph note books
The labeling/identifying of your position in this 'graph sheet' is simple:

When you click on any cell in Excel, and look uppwards and sideways of the 'graph sheet'
you'll notice that a letter lights up at the top, and a number lights up at the left side. This is called coordinates.

The first cell of Excel (English style of reading) is "A1"

2 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 11:09am On Jun 02, 2013
The interface shown above is a very exciting one
It can perform magic.

Excel can be used just like MS word etc, but once u start writing with symbols such as: =, -, +
Excel might suddenly start behaving like an ogbanje.

Reason is because Excel is a spreadsheet that was actually created to calculate.
That is the power of spreadsheets

8 Likes

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

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 12:33pm On Jun 02, 2013
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
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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)

2 Likes

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

8 Likes

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

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

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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
Re: Learn How To Use Excel Spreadsheets For Beginners by babyshaQ1(m): 4:38pm On Jun 02, 2013
Nice work. Trying to do same on my Libreoffice calc.
Re: Learn How To Use Excel Spreadsheets For Beginners by CrazyMan(m): 5:06pm On Jun 02, 2013
Good Job @ Op
Re: Learn How To Use Excel Spreadsheets For Beginners by aieromon(m): 7:43pm On Jun 02, 2013
Nice job here.
Re: Learn How To Use Excel Spreadsheets For Beginners by Feraz(m): 10:58pm On Jun 02, 2013
Good one here. . .pls. . .don't abandon this thread cool

2 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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
 
Re: Learn How To Use Excel Spreadsheets For Beginners by talura(f): 6:32am On Jun 04, 2013
Thanks Op..you rock!!
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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: http://www.nairaland.com/950830/before-leaving-nigeria-things-must/4#10993340 Look out for my post all the way to the end
Re: Learn How To Use Excel Spreadsheets For Beginners by An0nimus(m): 10:45am On Jun 04, 2013
esere826: 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: http://www.nairaland.com/950830/before-leaving-nigeria-things-must/4#10993340 Look out for my post all the way to the end
Read the link. Very informative. Would be nice to have it on pdf. Permission to make pdf out of it? or you can help us out and give us a link to download. arigatosmiley

2 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by swtchicgurl: 11:15am On Jun 04, 2013
THANK YOU OP!!! GOD BLESS YOU.

DON'T STOP! I'M FOLLOWING YOU AND THIS THREAD LIKE TWITTER!!!!!!!! smiley

1 Like

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

3 Likes

Re: Learn How To Use Excel Spreadsheets For Beginners by princessmay(f): 8:42am On Jun 05, 2013
Pls were will i get ribbon dat ll enable mi to click on insert.
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 9:51am On Jun 05, 2013
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)
Re: Learn How To Use Excel Spreadsheets For Beginners by salsera(f): 10:57am On Jun 06, 2013
do you have any links for advanced skills, e.g pivot charts and T or F formulas
i need a refresher course
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 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

1 Like

Re: Learn How To Use Excel Spreadsheets For Beginners by opendo21(m): 1:18am On Jun 08, 2013
OP e be like say na you God wan use bless me this year. This thread is coming at a very crucial time for me. Great job bro. God Bless you PLENTY! PLENTY!! Fully subscribing. In fact Page Saved.

1 Like

(0) (1) (2) (3) (4) (5) (6) (7) (8) (9) (Reply)

Common Interview Questions And Answer Tips / Help!!!! Globacom Is Being Messed Up... / Zenith Bank Sacks Marketers & Managers

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (0) (1) (2) (3) (4) (5) (6) (7) (8) (9)

Nairaland - Copyright © 2005 - 2014 Oluwaseun Osewa. All rights reserved. See Nairalist and How To Advertise. 87
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.