Excel Intro Essay

Submitted By kaif1012
Words: 3991
Pages: 16
Open Document
INTRODUCTION TO EXCEL

What is a spreadsheet?

The name comes from ‘spreading accounts’ across a piece of paper.

The idea is that a spreadsheet is a direct extension from the pocket calculator, whereby you can input information and use your calculator to process it and come up with the answer.

A spreadsheet allows you to enter and store data in cells called a GRID FORMAT (rows and columns) on a computer worksheet. The data can be in the form of numbers, words and (of course!) formulas. From this data it is also possible to produce graphs / charts, as well as transfer the data, for example to import it into a report (in word).

There are a wide variety of applications for spreadsheets, for example:

cash budgets job costing wages and tax calculations expenses claim forms forecasting, for example sales, loan repayments, depreciation calculations analyse figures (sales, investments, etc using chart facilities to help) conversions from one mode to another (for example currency)

Within the spreadsheet package, it is possible to set up templates with formulas entered, borders and cells shaded and many other formatting facilities. This saves template can then be used for numerous jobs.
The first way we are going to use a spreadsheet is by inputting cash budgets. This is a good example of where a pre-set template, along with a matching source document, can be used to ‘make your life easier’!

To start!

Firstly, you will need to switch the computer on and wait for a blue screen with a Start button (bottom left corner). Using the mouse, click on start, press programs, Microsoft Programs, and finally Excel.

You should now have a blank worksheet. This worksheet is part of a multi sheet workbook, each of which contains 16,384 rows and 256 columns. The rows are numbered (downwards) and the columns lettered (across the top).

How to move around the worksheet

There are various ways in which you can move around the worksheet:

( arrow keys (to the right of the main keyboard) can be used to move to adjacent cells

( pressing the {Enter} key will move the active cell down one row

( pressing {Shift} and [Enter} keys together will move the active cell up one row

To move to a cell on a visible part of the worksheet, position the pointer over the required cell reference and click the Left Hand mouse button.

Use the “Go to” command on the “Edit” menu to move directly to any cell

You can jump to a required cell by pressing {F5} and entering the new cell reference e.g. Z244

You can move to the hidden parts of the worksheet using the scroll bars (found just outside the worksheet in the ‘grey’ area - on the left and bottom)

Now to start putting in data!

On opening a worksheet, cell A1 is always the active cell. Look at your worksheet, you will see that A1 has a heavy border around it and its reference (“A1”) can be seen at the top left of the window.

Excel will treat your data in the best way it can, generally this means that: if you put = in to start, it recognises that you are imputing a formula if you input a number, unless specifically told otherwise it will align this to the right of the cell and treat it as a number anything else, it will treat as text and align left

As you input the information, you will see it appear in the formula bar, just underneath the tool bar, as well as in the active cell. When you have completed the data, press the {Enter} key. The active cell will automatically move down one row ready for you to continue entering data.

Using the cash budget “Mr & Mrs First” which you will find within this folder:

This is not the completed cash budget and you will now need to put in the formula that will add up columns and rows and convert this into a ‘first draft’.

Firstly however, we are going to Save your work.

Click on the Save button on the tool bar (it looks like a disk)
You will now have to make sure that your
Show More

Related Documents: Excel Intro Essay

Rhetorical Purpose Of WRTG 107

who you write to and to make sure that the desired message comes across clearly and with as little confusion as possible. The structuring of the paper is important to the argument being made, with the introduction meant to hook the reader in. The intro should also state the argument, while explaining why the argument matters in the first place. Conclusions are the most important…

Words 420 - Pages 2

Becoming A Marine Biologist

listening, critical-thinking, complex problem-solving, mathematics, science, speaking and writing skills; proficiency in scientific and analytical software like Visual Molecular Dynamics and Gene Codes Sequencher, plus Adobe Photoshop and Microsoft Excel; experience with microscopes, centrifuges and pipettes. According to environmentalscience.org, demand for Marine Biology Jobs is 3%, but is expected to rise 10%. The average salary of a Marine Biologist with a bachelor’s degree in Florida is $45,000…

Words 1000 - Pages 4

Sample Resume: Administrative Service Center

OBJECTIVE: That I obtain a position at FedEx as an Administrative Service Center Rep and maximize administration skills in a challenging environment for achieving a high degree of efficiency in my work. I am a responsible, highly dependable, and compassionate person with excellent patience and customer service skills. I am highly motivated, organized, and eager to learn. My experience includes both working independently and functioning within a team. EDUCATION: 09-2013- Anoka Technical…

Words 743 - Pages 3

What Is Standardized Testing Persuasive Essay

Jessica Hightower Mrs. Swank Intro Lit./Comp. 22 March 2024 Picture you’re a student who spends all of your free time creating and working on your art projects, the thing you’re best at. You wake up the morning of the SAT late with little sleep because you studied all night, rush to school without breakfast, and sit down to take the test. You’re tired, hungry, and overall not proficient in the questions you’re being asked, so as a result, you do poorly, and now all of the art colleges you want to…

Words 530 - Pages 3

A Brief Note On Writing Portfolio

was taught at the high school was again considerably more difficult then how it was taught at the university, this coming from SU students who we would compare class work too. The focus of the class was to expand our writing ability from the simple intro, body, conclusion where you restate the thesis statement in the conclusion too, developing a working claim and utilizing different ways of writing. The class was broke into a few major parts, at first we were “Disoriented”, with which they would…

Words 650 - Pages 3

Dopamine Hypothesis

Intro: Schizophrenia is a psychiatric disorder comprised of diverse clinical features, affecting over 21 million people (about 1 % of the world population) (WHO | Schizophrenia). While there are many individuals suffering from this debilitating disorder, the underlying biological mechanisms have yet to be fully elucidated. One popular hypothesis known as the “dopamine hypothesis”, states that an excess of the neurotransmitter dopamine disrupts normal cell communication within the mesolimbic pathway…

Words 608 - Pages 3

Essay about Writing Lab Reports and How Gear Ratios Work

Below is a walkthrough on how your Lab report should be written. This paper should be 2­3 pages; 1 page should be data. Each section (except the title) should be titled! Title (should be unique to your lab, both you and your partner can have the same title) Intro (less than a paragraph) This is where you give an introduction to your project; give a bit of background and a summary of the project. This should get the reader ready to read your report. Give enough information that they can easily follow your procedure and data…

Words 1085 - Pages 5

Essay on Liberal Arts Breadth and My Education

issues with the memorization of formulas and theorems. I have never been a learner by memorization. I completed these areas with Intro to Biology for Non Majors and Personal Community Health. I have also taken CPR and many computer classes. While, I may not have a passion for science in math I enjoy computers. I completed Word I, II, Excel I, II, Access I, II, PowerPoint, Intro to Computers and XHTML and CSS. I quickly pick up program platforms and enjoy poking around new software. The completion of these…

Words 1201 - Pages 5

The Effects Of The Cell Cycle

Morgan Fenoseff Bio 159 3/9/15 E. Coli Gowth INTRO In order for any cell to grow, it needs a source of nutrients; also known as energy. The process in which cells grow and multiply is known as the cell cycle. Once energy is attained within the cell, the cell wall inflates, and the cell begins to expand in size. Similarly, bacteria populations also go through phases of growth. There are four main stages of bacteria growth. (Earl 2014)…

Words 892 - Pages 4

Battle Royal Archetypes

Essay #2 Nicholas Dunroe SMCC ENGL 115: Intro to Literature Mike Bove April 5, 2024 1. Stories allow readers to decipher messages through hidden narratives that portray themes, impacting their overall importance in adhering to the plot. The absence of a message within a story creates ambiguous meaning, infringing upon the story's influential significance. Themes within narratives often facilitate symbolic elements portrayed within characters’ archetypes. These archetypes are contingent upon the…

Words 1051 - Pages 5