Lets begin at the beginning….
Excel is a spreadsheet program which stores, sorts and very efficiently crunches numbers. Whether you are an accountant, want to run your own business, or analyse data as a student, knowing the basics will give you a head start.
Parts of the spreadsheet.
The Excel spreadsheet contains tree main parts:-
- Columns- these are the vertical segments that are labelled with letters.
- Rows- these are the horizontal segments that are labelled with numbers.
- Cells – these are the individual boxes on he sheets where a row and a columns intersect.
This is the basis for the labelling or referencing for the cells in Excel.
The very first cell is A1 that is column A (the first column) and row 1 (the first row), the reference for this cell is therefore A1- simple!
These cells in Excel can store various types of data, for example
- text(labels, this is text with no numbers),
- numbers(constants- a number or constant value)
- formulas(the mathematical equations that to do hard work). These MUST begin with an = (equal) sign.
Labels are TEXT entries and do not have a value associated with them. Labels are typically used to identify what we are referring to or talking about. The labels are for humans!
So in Example 1 the labels are
Employee Name | Basic Salary | % Bonus | Bonus Total | Total |
The NUMBERS or constants are cells the likes of B4,B5 and B6 as well as C4,C5 and C6, these are the numbers we have entered into the spreadsheet and in this case they are the basic salary data ans the % bonus each person is to receive.
FORMULAS are entries that have an equation that calculates the value to display, we do not enter in the result we want as Excel will do all the work for us. So in this example the formulas are contained in cells D4, D5 and D6 – they calculate the % bonus of the basic salary, as well as E4, E5 and E6 which calculates the basic salary plus the bonus total. When you click in these cells, notice in the top bar of excel the acutal formula is displayed.
Remember Formulas MUST BEGIN with an equal sign (=).
Again, we use formulas to CALCULATE a value to be displayed. Let excel do the work!.
This was a very brief introduction to Excel to give you an idea of what it can do, how it looks and feels. Have a click around the site for more information on Excel.
visit says
I am genuinely thankful to the owner of this web page who has shared
this enormous paragraph at here.
ps2003.com says
Fantastic items from you, man. I’ve understand
your stuff previous to and you’re just too excellent.
I really like what you have bought right here, certainly like
what you’re saying and the way in which wherein you
are saying it. You are making it entertaining and you still
care for to keep it smart. I cant wait to read far
more from you. This is really a terrific website.
suzhouke.net says
Good blog post. I absolutely love this site. Thanks!
Rob says
I love what you guys are usually up too. This sort of clever
work and coverage! Keep up the wonderful works
guys I’ve incorporated you guys to blogroll.
sudarshan says
it doesn’t give actual formula
hard disk esterno says
I was curious if you ever considered changing the structure of your
blog? Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content so people could connect
with it better. Youve got an awful lot of text for only having one or 2 images.
Maybe you could space it out better?
idropulsore waterpik says
Hi excellent blog! Does running a blog similar to this take a large amount of work?
I have no understanding of programming but I was hoping to start
my own blog in the near future. Anyway, if you have any ideas
or techniques for new blog owners please share. I
understand this is off subject but I just had to ask. Cheers!
Jude says
I would like to thank you for the efforts you’ve put in writing this site.
I really hope to check out the same high-grade content from you later
on as well. In truth, your creative writing abilities has motivated me to get my
own site now 😉
Betty says
Fabulous, what a blog it is! This website gives useful information to us, keep it up.
gaufrier says
You can definitely see your enthusiasm within the work
you write. The world hopes for more passionate writers like you who
aren’t afraid to say how they believe. All the time go after your heart.
p4sch3r.com says
Excellent weblog right here! Also your site so much up fast!
What web host are you using? Can I get your affiliate link on your host?
I wish my web site loaded up as fast as yours lol
four micro-onde says
I don’t know whether it’s just me or if perhaps everyone else
experiencing problems with your blog. It appears like some of
the written text on your content are running off the screen.
Can somebody else please provide feedback and let
me know if this is happening to them as well?
This might be a problem with my internet browser because I’ve
had this happen previously. Kudos
saldatrice inverter classifica del 2017 says
Hello, its good piece of writing on the topic of media print, we
all understand media is a fantastic source of data.
mini four classement says
Very good write-up. I definitely appreciate this website. Thanks!
comparatif colonne de douche says
Hi there colleagues, its fantastic paragraph about cultureand completely explained, keep it up all the time.
mezo says
Hi! Ѕomeone in my Facebook ɡroup shared tһis website wіtһ
us so Ι ⅽame tо give it a lοoқ. I’m dеfinitely enjoying thе іnformation. I’m bookmarking ɑnd ԝill be tweeting thіs to my followers!
Ԍreat blog ɑnd excellent style and design.