Tanx

esere826:


B3*0.1 when typed in B5
it multiplies the value in B3 which is 100,000 by 0.1 to give 10,000

0.1 is the numerical equivalent of 10% which is the percentage for tithe

esere826:

That could be on another thread
I have actually started making videos on Excel, Access , SQl, SharePoint and other Business Analysis toolkit which takes my spare time
The challenge that I have is that I use my real name on the videos
so I am unable to post them here

I apparently did not think through it properly

Bros you like book too much.

chingydaboss:
Tanx

You're welcome

yinkeys:
Bros you like book too much.

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

esere826:


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

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

yinkeys:
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

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

yinkeys:
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

Name of the book and Author.

GoldenDr:
Name of the book and Author.

Excel 2007: The Missing Manual by Mathew McDonald

yinkeys:
Excel 2007: The Missing Manual by Mathew McDonald

Can you direct me to a bookshop where I can get it? Thanks.

GoldenDr:
Can you direct me to a bookshop where I can get it? Thanks.

check online ; it's an ebook I've got

yinkeys:
check online ; it's an ebook I've got

can you send it to my mail rynojay@gmail.com

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.

mokarios:
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.

In cell B2 type (21*110)/27 or( A2*B1)/A1 then click enter.

mokarios:
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.

In cell B2 type = (21*110)/27 or( A2*B1)/A1 then click enter.

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

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.

scarr:
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

is it only expenses or include revenue?

ify84:
How do I calculate interest rate payment

type = IPMTon any cell within your spreadsheet, and put the value accordingly.

T4kbaba:


is it only expenses or include revenue?

Both

T4kbaba:


is it only expenses or include revenue?

if you have both i wont mind having them both. thanks

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

dayo20002002:
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

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!

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?

aieromon:
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?

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.

T4kbaba:


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.

Thanks a lot

T4kbaba:


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!

Thanks a lot.

manny4life:
Finally


What is VLOOKUP?

V + LOOK+ UP = VLOOKUP

V = Vertical

LOOKUP = Search

VLOOKUP is a function, a predefined formula used to search for information across columns in a table. This function serves a very important purpose, when you have a large data set and you're trying to locate an a text field, number of any sort of string, rather than scrolling several thousands of rows below, this function comes handy.

[img]http://1.bp..com/-gfbhnR028Vk/Usx1iiLClUI/AAAAAAAAAes/YEOqK5BVREE/s1600/Image+1-a.jpg[/img]

For the purpose of this illustration, above is a sample table file with basic information.

The table above is an inventory manifest list, there are several "rows" of data with usable information in each column. Assuming that I had 1,000 rows of data and I wanted to search for a "Part #", I will use VLOOKUP feature to automate my search and avoid repetition.

On this table, I will use the part # to lookup the price, therefore, the Part # is our lookup field.

A good example of where VLOOKUP application is utilized is using this function to fill out "INVOICE INFORMATION. I will explain more in details.


The table has SEVEN columns of data

Column a: Part numbers (#)
Column b: Fulfillment Center
Column c: Product group
Column d: Item name (description)
Column e: Qty
Column f: Price
Column g: Extended cost ( # of qty x price per piece)



Now the next portion is using VLOOKUP to search for information.

NOTE: The Lookup Data MUST always be the first left column, this makes the argument easier. In the table, when I enter the function argument, the part number will be our lookup data.

Next, below is a table showing the function

[img]http://1.bp..com/-5Xn6RfeS3e0/Usx1kU-TQPI/AAAAAAAAAe0/o92BauCI0no/s1600/Image+1-b.jpg[/img]

This is the function argument for VLOOKUP

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])


a. lookup_value: This is the value used as a search reference. In the table above, this would be the "part #" = "C6"

b. table_array: This is search reference table. In this case, I will reference the previous tab "Master file", and select B5:H27

c. column_index_num: This is the column referenced to get the resultant information from. In this case, the pricing is what I want. NOTE, it's asking for the "num" meaning number, therefore, I have to count from the left of the "table_array", which is number SIX (6)
d. [range_lookup]: This is explanatory, unless you're seeking an for rounded results, USE the "FALSE" option... False ALWAYS returns an exact match. In this case, I am looking for an exact price for the unique part number.


Combining the information will give us this function argument.

=VLOOKUP(C6, Master File '!B5:H27,6,FALSE)

[img]http://3.bp..com/-fqIj1Mie5wA/Usx1lzhLC_I/AAAAAAAAAe8/-tXGzu65oBc/s1600/Image+1-c.jpg[/img]

Having entered this function argument in C7= pricing, because the precedent cell is "null" value, it will return a "#N/A" result. However, the moment I entered a part #, it populates the pricing for that item. This is how VLOOKUPis used. Furthermore, I applied the same rule to the last two and the right should be used for activity exercise.

NOTE: The VLOOKUP function table is different from the previous table, this is because the previous table does not have $$$ signs. Absolute and Relative reference are very important because when a cell is moved, if you want to maintain the cell integrity, it is imperative to make it "ABSOLUTE". To do this, you have to change the reference from "Relative" to "Absolute", by highlight the cell information such as "B5" and press F4. This toggles between both references. I used absolute reference because I wanted to keep the absolute range of B5:H27.

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

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.

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

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

runomurphyOAP:

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

There are some videos on Youtube,why don't you check them out.

Congrats on your new job.

Very intetesting