Stats: 3,189,841 members, 7,938,458 topics. Date: Tuesday, 03 September 2024 at 06:46 AM |
Nairaland Forum / Nairaland / General / Career / Learn How To Use Excel Spreadsheets For Beginners (83358 Views)
Makeover,ankara & Cake Training For Beginners & Upgraders In Warri-delta State / Free Microsoft Excel Training Materials: From Beginners To Advanced / What Tinder Did For Dating, Tableau Wants To Do For Spreadsheets (BI) (2) (3) (4)
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (14) (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* 44 Likes 5 Shares |
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: 10:25am On Jun 02, 2013 |
Student #1 ![]() |
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 5 Likes 2 Shares
|
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:38am On Jun 02, 2013 |
An0nimus: Student #1 Good that you have such materials. Have you applied it? |
Re: Learn How To Use Excel Spreadsheets For Beginners by An0nimus: 10:54am On Jun 02, 2013 |
esere826: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" 4 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 12 Likes 1 Share |
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 1 Like
|
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 1 Like 1 Share |
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) 4 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 14 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) 5 Likes 1 Share
|
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 2:08pm On Jun 02, 2013 |
ANY QUESTIONS, COMMENTS? ![]() 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 2 Likes |
Re: Learn How To Use Excel Spreadsheets For Beginners by Nobody: 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 ![]() 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: https://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: 10:45am On Jun 04, 2013 |
esere826: Excel/spreadsheet skills are a must haveRead 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. arigato ![]() 4 Likes 1 Share |
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!!!!!!!! ![]() 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 4 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 Nobody: 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 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 3 Likes 1 Share |
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. 3 Likes |
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (14) (Reply)
Secretaries (Or Personal Assistants) On Nairaland / Man Spotted Love Machine In Their Office Today - Photos / Best Paid Careers In Nigeria For 2013
(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: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 35 |