Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,223 members, 7,953,840 topics. Date: Friday, 20 September 2024 at 07:40 AM |
Nairaland Forum / Emymeeky's Profile / Emymeeky's Posts
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (of 31 pages)
Jobs/Vacancies / Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 10:49am On Nov 03, 2016 |
Abeg this thread go good for job seekers |
Jobs/Vacancies / Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 10:43am On Nov 03, 2016 |
Let me introduce myself. My name is Christian and I am going to be your teacher. In this blog post, I will be taking you on the basics of Microsoft Excel. In Nigeria, many employers of labor require from job seekers some basic knowledge of excel whereas, other employers may require more complex knowledge. The reason is not far-fetched. Excel is a pure mathematical machine (program) designed to aid computations of mathematical equations and accountancy. Apart from solving basic and complex mathematics, excel is used for keeping records. For example, we can use excel to keep records of how many items are in a shop, amount of daily rainfall, the grades of students in a subject, the ages of students in a class and anything you can think about. Learning excel is not as difficult as people think. Many get intimidated once they open up Microsoft excel and see lines running horizontal and vertical without any clue on what to do with them. Don't be scared as we will be learning how to manipulate those lines to the extent that you can beat and pound your chest in front of your potential employer. I will try as much as possible to make the lesson very simple. We will start from simple to less simple tasks.Relax your mind and be ready for an interesting session with me! In order not to bore you with the theories of excel, let us create our first excel project! Creating this projects and the subsequent projects, will make learning excel faster as you will subconsciously learn to use many features of excel without undergoing an extra training. I am using 2013 Excel. Whichever version of excel you have will suffice. Let's take a look at the picture below: [img]http://2.bp..com/-jG3BwkV7BJg/WBkfy5VbEpI/AAAAAAAAEGc/1fILcWRrLKMS3QZTRuS4gAuaL24q3ikPwCLcB/s640/2016-11-01.png[/img] Our first project will be to recreate the above table Can we create that? Of course yes. Open your Excel software and type in those stuffs. Easy huh? Make sure you save your workbook by pressing CTRL S on your keyboard and save it with any name and to any folder of your choice. Next which is very easy but important is identifying the positions of our entries.Entries is derived from the word, "enter" . It means what we enter in the cells .It is very important we learn addressing (or naming) each of the cells where those entries are made. Cells are those rectangular boxes in the worksheet above. The cells which run horizontally are called rows. Can we identify entries on the first row? certainly! The entries on the first row are Names, age[ and gender. What can we find on the 7th row? we can find Jane, 15 and F on the 7th row. On which row can we find Emeka? Your guess is as good as mine! we can find Emeka on the 9th row. You can see that the rows are actually numbered. we have a total of 13 rows in our project. There are thousands of rows in an excel worksheet depending on which version of excel you are using. On Excel 2007, we have a total of 65536 rows. So it means we can actually expand our list to 65536 rows! On Excel 2013, we have a total of 1,048,576! and so on depending on the version. We should not bother ourselves memorizing them. The cells which run vertically are called columns. Unlike the rows which are labelled in numbers, the columns are labelled in alphabets. So let's identify entries under column A. Moving downwards(vertically) , we can see entries like Names, Amaka, Jane, Luke, Monica, down to John. On which column can we find gender? We can find gender under column C. Easy right? There are only three columns in our project, from A to C. There are hundreds and thousands of columns in excel depending on which version you are using. In identifying the position of an entry, we may need to combine the row and the column where it is found. For example, the entry, Amaka can be found under column A and the second row (row 2) So we can actually say that the entry Amaka is found at column A, row 2. For simplicity , we can say that Amaka is found at cell A2 where "A" represents the column and "2" represents the row as seen in the picture below. Easy right? [img]http://3.bp..com/--QxbDJ0xD2A/WBmYIjLVyfI/AAAAAAAAEG8/PzFV9z4XY8wktz87B5avdQlntWYMAsezwCLcB/s320/sample.png[/img] Question: On which cell can we find Harry? Answer: From the above worksheet, Harry can be found at A6 Question:Where can we find age 22? Answer: We can find age 22 on cells B4 and B13 I guess you are now familiar with naming cell ranges. So authoritatively, we can say our list/entries starts from A1 and ends at C13. This can be shortly written as A1:C13. In excel , the colon ( sign means "to". In otherwords, A1:C13 can be read as A1 to C13. Wow! We have covered many things in a short while! We just learnt how make a list in excel. Not just that. We also learnt how to identify the positions of the cells which contains our entries by using their rows and column numbers In my next blog post, will be going into a more interesting session! You will be learning how to manipulate that list you created ( so keep that workbook saved) . We are going to perform some magic with that list so much that your employer will be nodding in consternation! So Stay tuned! Definition of terms Worksheet: Worksheet is a single page in excel composed of cells. A worksheet is the first thing you see when you open an excel program. Workbook: Workbook is composed of different worksheets. We can have hundreds of worksheets in a workbook. https://www.youtube.com/watch?v=u0wd_VTpCpA Source: http://www.jadijadi.com/2016/11/introduction-to-microsoft-excel-for-job.html?m=1 2 Likes |
Career / Re: My Lebanese Boss Promises To Sack Me When Next I Bend Or Try To Collect His Bag by emymeeky: 7:10am On Nov 03, 2016 |
Haha hahaha He has worked in 5 African countries but he hasn't worked with a Yoruba. Why should you help me with my bag ... Am I handicapped? 4 Likes |
Politics / Re: Professor Chukwuka Okonjo Honoured In ghana by emymeeky: 7:08am On Nov 03, 2016 |
See as they finished sarrki for this thread 4 Likes 1 Share
|
Celebrities / Re: Davido: If I Die Bury Me In A Gucci Store, As He Lavishes Millions Shopping by emymeeky: 8:04pm On Nov 02, 2016 |
1 Like |
Politics / Re: APC Begs Senate To Approve Buhari’s $30bn Loan Request by emymeeky: 6:15pm On Nov 02, 2016 |
RockHard: 4 Likes
|
Politics / Re: APC Begs Senate To Approve Buhari’s $30bn Loan Request by emymeeky: 6:14pm On Nov 02, 2016 |
SweetLove0: Zombie 4 Likes 1 Share
|
Celebrities / Re: Tiwa Savage Slays In Ankara Outfits And Boots by emymeeky: 12:15pm On Nov 02, 2016 |
Asha..... 144 Likes 12 Shares
|
Celebrities / Re: Fan Mocks Halima Abubakar's Skin Colour As She Claps Back by emymeeky: 3:04pm On Nov 01, 2016 |
See knuckles
|
Politics / Re: Buhari’s Strategists Chasing Ants By Reuben Abati by emymeeky: 10:26am On Nov 01, 2016 |
modath: The "adults" are not looking back to learn. They look back to blame . 1 Like |
Webmasters / Who Has Gotten USA Adsense Approval Lately ? by emymeeky: 6:55am On Nov 01, 2016 |
After pasting their codes for more than 2 week , I'myet to get a reply. Who's experiencing same ? |
Webmasters / Re: 4 Million Email Addresses For Sale For A Very Cheap Price by emymeeky: 6:48am On Nov 01, 2016 |
Still available |
Programming / Re: Microsoft Office 2010 by emymeeky: 5:48pm On Oct 31, 2016 |
AbalosA: You're in the right section. Excel is also a programming tool . Check the file extension of the file you want to open and make sure it saved in the correct format. Does the file contain macro ? |
Politics / Re: Orji Uzor Kalu Re-arraigned By EFCC by emymeeky: 1:56pm On Oct 31, 2016 |
Bunch of lazy investigators ! You arrest someone for "lack of evidence" , you harass him for "lack of evidence" , you release him for " lack of evidence" , you re-arrest/re-arraign him for "lack of evidence" . Are you crazy ? Can't you make an investigation and get a cast iron evidence that can stick ? Bunch of amateurs headed by a balded monster . I see him walk free. 3 Likes |
Business / Re: Banks’ Profits Rise Despite Recession by emymeeky: 12:38pm On Oct 31, 2016 |
The profits were from the extraneous bank charges and illegal resale of foreign currencies to the bureau d change dealers 5 Likes |
Crime / Re: I Bought Two Human Heads For N10,000 — Herbalist (photo) by emymeeky: 8:09pm On Oct 30, 2016 |
Apcmyheart |
Health / Re: Multiple Bumps On My 3-Year-Old Boy Scalp. by emymeeky: 7:48pm On Oct 30, 2016 |
This is called okpu is eri ego. The blade that barbs hair without collecting money . Try using penicillin 5 Likes 1 Share |
Politics / Re: Saraki's Birthday Cake To Shehu Sani (Photos) by emymeeky: 9:54pm On Oct 29, 2016 |
This saraki is even overshadowing the Dullard sef |
Business / Re: I Want To Sell $100 From My Diamond Dorm Account@ N430 by emymeeky: 9:49pm On Oct 29, 2016 |
tempex88: Charges like how much ? Please make it N425 |
Business / Re: I Want To Sell $100 From My Diamond Dorm Account@ N430 by emymeeky: 9:39pm On Oct 29, 2016 |
Dyt:Sorry this is not payoneer or PayPal |
Business / Re: I Want To Sell $100 From My Diamond Dorm Account@ N430 by emymeeky: 9:38pm On Oct 29, 2016 |
tempex88: Can't withdraw sir |
Culture / Re: No Burial In Benin Kingdom Till January 2017- Oba Of Benin by emymeeky: 9:30pm On Oct 29, 2016 |
Nigerians and cave life... 5 Likes
|
Business / I Want To Sell $100 From My Diamond Dorm Account@ N430 by emymeeky: 9:25pm On Oct 29, 2016 |
07068097535. I need d money ASAP |
Politics / Re: Why Nigerian Shiites Should Be Allowed To Fully Practice Their Faith — US Envoy by emymeeky: 5:38pm On Oct 29, 2016 |
Culture / Re: The Artwork Ooni Ogunwusi Gave Fayose As A Gift (Photos) by emymeeky: 3:30pm On Oct 29, 2016 |
Fayose .. the wisest man in Yoruba land ever liveth 4 Likes |
Politics / Re: Bomb Blast At Bakassi IDP And NNPC Station In Maiduguri This Morning (Photos) by emymeeky: 11:14am On Oct 29, 2016 |
soul2:
|
Politics / Re: Bomb Blast At Bakassi IDP And NNPC Station In Maiduguri This Morning (Photos) by emymeeky: 10:39am On Oct 29, 2016 |
Alhaji Lie Muhammed 42 Likes
|
Webmasters / Re: 4 Million Email Addresses For Sale For A Very Cheap Price by emymeeky: 10:24am On Oct 29, 2016 |
Ourown: #4,500 |
Webmasters / Re: 4 Million Email Addresses For Sale For A Very Cheap Price by emymeeky: 10:02am On Oct 29, 2016 |
Ourown: Many countries like Canada , USA , united kingdom, Nigeria ( about 5℅ ) |
Webmasters / 4 Million Email Addresses For Sale For A Very Cheap Price by emymeeky: 9:22am On Oct 29, 2016 |
I'm selling a whopping 4 million ACTIVE email addresses at a giveaway price. Contact me on 07068097535 1 Like |
Politics / Re: Amendment Of CCB/CCT Act By National Assembly Is Null & Void - Olatunde Bakare by emymeeky: 9:16am On Oct 29, 2016 |
Celebrities / Re: T-pain And His Bodyguard Arrive Nigeria (Photos) by emymeeky: 8:58am On Oct 29, 2016 |
Is that a bottle of hero in his hand ? 1 Like |
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (of 31 pages)
(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. 42 |