Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,355 members, 7,957,952 topics. Date: Wednesday, 25 September 2024 at 05:26 AM |
Nairaland Forum / Nairaland / General / Career / Learn How To Use Excel Spreadsheets For Beginners (83434 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) ... (9) (10) (11) (12) (13) (14) (Reply) (Go Down)
Re: Learn How To Use Excel Spreadsheets For Beginners by chingydaboss(m): 3:37pm On Apr 15, 2015 |
Tanx esere826: |
Re: Learn How To Use Excel Spreadsheets For Beginners by yinkeys(m): 4:26pm On Apr 15, 2015 |
esere826:Bros you like book too much. |
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:10am On Apr 16, 2015 |
chingydaboss: You're welcome |
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 10:12am On Apr 16, 2015 |
yinkeys: naa just trying to make up for the lost years that the caterpillar stole with my approval when I was busy drinking beer, sleeping and chasing girls in my university days instead of studying |
Re: Learn How To Use Excel Spreadsheets For Beginners by yinkeys(m): 4:46pm On Apr 16, 2015 |
esere826:I did that too, but the truth is am sure right now you're better than alot of your mates. Maybe not financially but in the use of Microsoft office @ least. I heard being proficient in the use of Excel alone could give one a decent paying job. Even oil coys use it for petroleum economics. It's not easy to be a good programmer you know. Bros you're too much jor, I recently got a good excel book that will help me become a good model creator & programmer in it. No Nigerian university will teach one how to use Microsoft excel. It was actually in my final year that a visiting prof. from the US made it mandatory to create models & do assignments on Excel spreadsheets while learning petroleum economics. Ever since then I've had this undying desire to be very good at it. Thumbs up for creating this thread, it's a motivator for some lazy ones like me I don't know what you studied but engineering is very competitive. So many things to learn bros: Microsoft Office, Schlumberger Techlog, Autocad and so on. Academic/company learning just seems like a never ending journey |
Re: Learn How To Use Excel Spreadsheets For Beginners by esere826: 5:13pm On Apr 16, 2015 |
yinkeys: I actual started life as an engineer although, I am no longer an engineer, the mathematics and logic skills in engineering has proved useful in excel and programing language stuff it's actually soooooooo interrelated you find out soon |
Re: Learn How To Use Excel Spreadsheets For Beginners by Nobody: 8:55am On Apr 17, 2015 |
yinkeys:Name of the book and Author. |
Re: Learn How To Use Excel Spreadsheets For Beginners by yinkeys(m): 10:05am On Apr 17, 2015 |
GoldenDr:Excel 2007: The Missing Manual by Mathew McDonald |
Re: Learn How To Use Excel Spreadsheets For Beginners by Nobody: 10:14am On Apr 17, 2015 |
yinkeys:Can you direct me to a bookshop where I can get it? Thanks. |
Re: Learn How To Use Excel Spreadsheets For Beginners by yinkeys(m): 10:31am On Apr 17, 2015 |
GoldenDr:check online ; it's an ebook I've got |
Re: Learn How To Use Excel Spreadsheets For Beginners by Nobody: 7:25pm On Apr 17, 2015 |
yinkeys:can you send it to my mail rynojay@gmail.com |
Re: Learn How To Use Excel Spreadsheets For Beginners by mokarios(m): 3:57pm On May 19, 2015 |
I need to solve a problem via MS Excel, and it is about proportionality. I am tryiing to establish a proportionality between 2 variables, say A1 is 27, and B1 is 110, if I input A2 as 21, annd I want MS Excel to solve B2 using the relationship between A1 and B1, how do I go about it? As simple as this might appear, I would welcome your suggestions, or directions on this one. Thanks. |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 12:09pm On May 27, 2015 |
mokarios: In cell B2 type (21*110)/27 or( A2*B1)/A1 then click enter. |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 12:17pm On May 27, 2015 |
mokarios: In cell B2 type = (21*110)/27 or( A2*B1)/A1 then click enter. |
Re: Learn How To Use Excel Spreadsheets For Beginners by scarr: 12:40pm On May 27, 2015 |
Please can anyone help me with an excel template for recording daily expenses of an office......would appreciate all the help i can get. Thanks Yall |
Re: Learn How To Use Excel Spreadsheets For Beginners by tr3y(m): 6:12pm On May 27, 2015 |
I just finished this thread from start to end. Thumbs up to the OP. I have learnt some new things at the same time brushed up some old skills. Learning never stops. |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 10:04pm On May 27, 2015 |
scarr: is it only expenses or include revenue? |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 10:16pm On May 27, 2015 |
ify84: type = IPMTon any cell within your spreadsheet, and put the value accordingly. 1 Like |
Re: Learn How To Use Excel Spreadsheets For Beginners by Nobody: 11:11pm On May 27, 2015 |
T4kbaba:Both |
Re: Learn How To Use Excel Spreadsheets For Beginners by scarr: 10:25am On May 28, 2015 |
T4kbaba:if you have both i wont mind having them both. thanks |
Re: Learn How To Use Excel Spreadsheets For Beginners by dayo20002002: 5:22pm On May 28, 2015 |
Pls can someone put me through on how to use excel sheet to calculate mean and standard deviation of raw datas like 50, 52, 51, 56, 58 |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 10:19pm On May 28, 2015 |
dayo20002002: type 50 on cell A1, 52 on cell A2 etc. then on cell B6, type =stdev(A1:A5) , then click enter to get your standard deviation. As for mean , on cell B7type = average(A1:A5) ,then click enter and see the result pronto! 1 Like |
Re: Learn How To Use Excel Spreadsheets For Beginners by aieromon(m): 6:08am On May 29, 2015 |
Quick question I want to estimate the population of a state as at 2015 using figures from the 2006 census at a growth rate of 2.1%. What would Mr Excel do? |
Re: Learn How To Use Excel Spreadsheets For Beginners by T4kbaba(m): 6:57am On May 29, 2015 |
aieromon: type the year 2006 on cell A1,2007 on cell B1 and continue up to 2015. type 160000000 on cell A2, type = 1.021*A2 on cell B2 then press enter key.Having done that, there is what we call autofill, put your cursor on the right bottom of cell B2 when it change to tiny + sign , then drag it to up to year 2015. Goodluck and happy new Nigeria. 2 Likes |
Re: Learn How To Use Excel Spreadsheets For Beginners by aieromon(m): 7:37am On May 29, 2015 |
T4kbaba: Thanks a lot 1 Like |
Re: Learn How To Use Excel Spreadsheets For Beginners by dayo20002002: 5:08pm On May 29, 2015 |
T4kbaba:Thanks a lot. 2 Likes |
Re: Learn How To Use Excel Spreadsheets For Beginners by stadora(f): 8:22am On Jun 19, 2015 |
manny4life: pls am just joining d thread now and am goin tru d pages, Thanks for all your eforts and contributions. my qstion is , how did u combine row 3 n 4 together to bcome one row? seems I ll have a lot of qstion to ask on this vlook up topic. thanks |
Re: Learn How To Use Excel Spreadsheets For Beginners by manny4life(m): 12:30am On Jun 24, 2015 |
Use the "Merge & Center" 1. Go to the "Home" page 2. Look to 3rd section: "Alignment" 3. Select row 3 & 4 4. Click on "Merge & Center" I hope this answers your question.. If you have any question, let me know. 1 Like |
Re: Learn How To Use Excel Spreadsheets For Beginners by chapatti: 1:30pm On Jul 16, 2015 |
Microsoft Excel is a spreadsheet package and a spreadsheet package is an application soft ware that is design for financial calculation and keeping of financial records. Someone shouldn’t be so surprise when I will be making use of Microsoft Excel and Ms Excel together because Microsoft and Ms, is one meaning and they are used for financial calculation, this application are very important for school, banks and every areas of life. Ms excel is made up of component, this component of Microsoft Excel are divided into different part, like in the case of Ms Excel 2003, Ms Excel 2005 they have Title bar, Menu bar,. Standard tools bar, formatting tool bar, cell address, spreadsheet, scroll bar, status bar. Microsoft Excel 2003 and Microsoft Excel 2007 also with Microsoft Excel 2010 all have their differences, Ms Excel 2003 and Ms Excel 2005 have the same features and every bars I listed above but Ms Excel 2007 and Ms Excel 2010 also have the same Microsoft Excel feature. These similarities have their importance; they all calculate income and expenditure in a company, in the business company, insurance companies make use of Ms Excel. Microsoft Excel have a spreadsheet, which most people call work area, or work sheet. This work sheet is where calculation is carried out. This area is divided into four (4) elements and components mean the same thing. So there are four (4) of spreadsheet |
Re: Learn How To Use Excel Spreadsheets For Beginners by runomurphyOAP: 3:06pm On Aug 03, 2015 |
Please I just got a job and am too resume by september, I was told I need too master excel and access. Please if u can send me the video and written spread sheet lesson same way u have been helping those of us who do not have any knowledge of dis package..please send it too my email id....sirbeejay4uk@gmail.com |
Re: Learn How To Use Excel Spreadsheets For Beginners by beau49: 8:03pm On Aug 03, 2015 |
runomurphyOAP: There are some videos on Youtube,why don't you check them out. Congrats on your new job. |
Re: Learn How To Use Excel Spreadsheets For Beginners by Elegantdiva: 7:39am On Aug 04, 2015 |
Very intetesting 1 Like |
(1) (2) (3) ... (9) (10) (11) (12) (13) (14) (Reply)
Salary Structures In Nigeria And Their Full Meanings / Secretaries (Or Personal Assistants) On Nairaland / Man Spotted Love Machine In Their Office Today - Photos
(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. 63 |