Stats: 3,188,291 members, 7,934,196 topics. Date: Wednesday, 28 August 2024 at 08:21 PM |
Nairaland Forum / Nairaland / General / Jobs/Vacancies / Introduction To Microsoft Excel For Job Seekers (video) (1669 Views)
Civil Defence Recruitment: 2.5m Job Seekers Groan Over Tight Measures Adopted / The Menace Of "Long Legs" For Job Seekers / Monster HR Personnels; A Nightmare For Job Seekers. Share Your Experience (2) (3) (4)
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 ( ![]() 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 |
Re: Introduction To Microsoft Excel For Job Seekers (video) by ghettowriter(m): 10:44am On Nov 03, 2016 |
Nice thread. 1 Like |
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 |
Re: Introduction To Microsoft Excel For Job Seekers (video) by Benjom(m): 11:40am On Nov 03, 2016 |
Job applicants need to see this... If only they could add this to their skills. 1 Like |
Re: Introduction To Microsoft Excel For Job Seekers (video) by Didoris(f): 9:39pm On Nov 03, 2016 |
for Just having the thought to help people like me out on excel and for this iñtro, God bless u real good @poster |
Re: Introduction To Microsoft Excel For Job Seekers (video) by Nobody: 10:50pm On Nov 03, 2016 |
Thanks op, good job! |
Re: Introduction To Microsoft Excel For Job Seekers (video) by Nobody: 12:37am On Nov 04, 2016 |
Op pls update dis page frequently biko 1 Like |
Re: Introduction To Microsoft Excel For Job Seekers (video) by bustamode: 5:18am On Nov 04, 2016 |
Nice one,excel gives most people nightmares 1 Like |
Re: Introduction To Microsoft Excel For Job Seekers (video) by darlingjoylyn(f): 9:15am On Nov 04, 2016 |
God bless you OP,we are following. Kindly update. We appreciate |
Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 9:24pm On Nov 05, 2016 |
Watch part 2 video here>> https://www.nairaland.com/3448833/simple-continuous-assessment-program-using |
Re: Introduction To Microsoft Excel For Job Seekers (video) by semasir: 4:36pm On Nov 07, 2016 |
God bless you.... Had This been snake or cucumber now, it'll hit FP |
Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:53pm On Nov 07, 2016 |
Didoris: You're welcome... Thanks for reading! |
Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:54pm On Nov 07, 2016 |
semasir: Lol. Guess lalasticlala is yet to see it ![]() |
Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 7:59pm On Nov 07, 2016 |
franciskaine:updated . Check the link to the second video above |
Re: Introduction To Microsoft Excel For Job Seekers (video) by lalasticlala(m): 8:28pm On Nov 07, 2016 |
emymeeky: Just watched the earlier part of the video, you were busy marketing Linda's LIS instead of going straight to do the teaching |
Re: Introduction To Microsoft Excel For Job Seekers (video) by Nobody: 9:22pm On Nov 07, 2016 |
emymeeky:thanks |
Re: Introduction To Microsoft Excel For Job Seekers (video) by emymeeky: 10:48pm On Nov 07, 2016 |
lalasticlala: Oh .. didn't know I defaulted ... Did that innocently ... Can I get a FP for my second video? |
(1) (Reply)
FG To Deploy 50,000 Non-graduate N-power Volunteers / I Am In Dire Need Of A Job. Somebody Help! / Banking Job In Kaduna
(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. 54 |