Exceed expectations Spreadsheets.

Uploaded on:
Category: Home / Real Estate
What to Know. What is ExcelWhat is a SpreadsheetThe Excel WindowToolbars (Shortcut Bars)The
Slide 1

Exceed expectations Spreadsheets The Basics ICS100 – Spring 2007 D. Pai

Slide 2

What to Know What is Excel What is a Spreadsheet The Excel Window Toolbars (Shortcut Bars) The "HELP" Functions Basic Operations in Excel

Slide 3

What is Excel? Exceed expectations is the spreadsheet program with the Microsoft Office Applications Suite Excel likewise has outlining/charting abilities to imagine the information Excel additionally plays out some database capacities, for example, sorting a rundown of information

Slide 4

What is a Spreadsheet? In the domain of bookkeeping language a "spread sheet" or spreadsheet was and is a huge sheet of paper with sections and lines that lays everything out about exchanges for an agent to inspect. It spreads or demonstrates the greater part of the costs, pay, charges, and so on a solitary sheet of paper for a director to take a gander at when settling on a choice. An electronic spreadsheet composes data into programming characterized sections and lines. The information can then be "added up" by a recipe to give an aggregate or total. The spreadsheet program outlines data from numerous paper sources in one place and introduces the data in an arrangement to help a leader see the money related "big picture" for the organization. (Power, D.J., 2000, www.dssresources.com/history/sshistory.html)

Slide 5

The Excel Window Title Bar Active Cell Columns (Letters) Menu Bar Rows (Numbers) Active Sheet Selector Status Bar

Slide 6

Excel Window (Cont.) Standard Toolbar Formula Bar Cell Reference Formatting Toolbar Fill Handle is the dark square in the lower right hand corner of the dynamic area Drawing Toolbar

Slide 7

What are Toolbars (Shortcut Bars)? Select "Perspective  Toolbars" Toolbars give regular capacities utilized as a part of Excel for single-tick access (Shortcuts to things you can do)

Slide 8

HELP!!!! Two Additional types of HELP with the Microsoft Office Suite Office Assistant – a noticeable symbol that gives tips and permits to you to sort questions in a semi-conversational way to get answers The Help Menu – Provides Table of Contents, Answer Wizard and Index types of getting to help

Slide 9

Office Asst is the Paper Clip

Slide 10

Office Assistant Allows you to Ask for Help as a Question

Slide 11

Help Menu has 3 Ways to Access Help

Slide 12

Basic Concepts in Excel Entering Text in a Cell Copying Text starting with One Cell then onto the next Creating a Numerical Series Entering a Formula in a Cell Inserting a Row or Column into a Worksheet

Slide 13

Entering Text in a Cell To Enter Text (or numbers) in a Cell, Just Click the Mouse in the Cell Where you might Want the Text and Start Typing

Slide 14

Copying Text starting with One Cell then onto the next To Copy Text, Just Like in Word, Select the Cell (or Cells), then utilize: Edit  Copy Select new Location Edit  Paste Click and Drag to Select Many Adjacent Cells (Range of Cells) Ctrl-Click to Select Multiple Non-Adjacent Cells or Ranges

Slide 15

Creating a Numerical Series To Create an Arithmetic Series… 1,2,3… or 1,3,5… or 1,4,7,… Enter First 2 Numbers in Your Series in Adjacent Cells Click on Fill Handle and Drag to Desired Length NOTE: This works with Dates and Anything that Ends with a Number

Slide 16

Numerical Series Example Using the Technique Previously Defined… Create the accompanying arrangement Odd numbers from 1-11 Dates from 3/14/07-3/19/07 Listing from PO1001 – PO1006 Try to make Listing from 1001a – 1001f What did you get for this last one?

Slide 17

Entering a Formula in a Cell To Enter a Formula in a Cell… Must Start with… THE = SIGN Math Symbols incorporate +  Addition -  Subtraction *  Multiplication/ Division ^  Exponent (to the Power of) Use Parentheses to Make Sure the Order of your Processing is Correct

Slide 18

Formatting the Worksheet

Slide 19

What is Formatting? Changing how things are shown in Excel for accentuation or stylish reasons Can arrange cells, sections, lines, sheet Can likewise utilize prior configurations gave by Excel utilizing Autoformat Can likewise characterize the substance of a phone to be of a specific sort

Slide 20

Format Cells for Numbers Options accessible are given through the "Organization  Cells" determination on the menu bar Some basic alternate routes are accessible on the designing toolbar $ - Displays substance of cell as coin and incorporates a $ in the phone % - Displays substance of cell as a rate , - Displays commas in cell numbers  .0 – Increases # of digits after decimal by one  .0 – Decreases # of digits after decimal by one

Slide 21

Aligning Data Once scope of cells is chosen (could be segments or lines additionally), select "Configuration  Cells" from Menu Bar Select the "Arrangement" tab You can adjust Horizontally, Vertically, Rotate You can likewise wrap the content in a case, shrink content to fit the container and union cells

Slide 22

Changing Fonts Same as adjusting information aside from utilize the Font tab in the Format Cells exchange box Can change: Font style Size Color Underline Effects

Slide 23

Changing Cell Borders In Format Cells discourse box select Border tab Option Available include: Presets Manual Selection of fringes Line styles Color Also some constrained easy routes in the arranging toolbar

Slide 24

Changing Cell Colors In Format Cells exchange box select Patterns Can change the foundation shade of the chose cells and the example Can Also change utilizing the "Fill Color" symbol in the organizing toolbar

Slide 25

Inserting a Row or Column into a Worksheet To Insert a Row or Column… First Select the Row underneath where you need your new line or the Column to one side of where you need your new segment Then select "Supplement  Row or Column" from the Menu Bar

Slide 26

Changing the Column Width Basic Methods Dragging the outskirt of a segment by selecting the edge in the segment header region (where the letters are) Select the segment and afterward select "Organization  Column" from the menu bar Double-tap on the bar between 2 segment letters (or line numbers) to autofit the width of the segment (or line) to its substance NOTE: IF A CELL IS FILLED WITH "####" IT MEANS THAT THE NUMBER IS TOO BIG TO FIT IN THE CELL – INCREASE THE COLUMN WIDTH TO VIEW THE NUMBER

Slide 27

Hide a Column Removes the segment from perspective, Does not change substance of the phones nor any estimation performed utilizing these phones Once segment that you need to cover up has been chosen, pick "Configuration  Column  Hide" from the menu bar To UNHIDE – Select segments on both sides of concealed segment and pick "Organization  Column  Unhide" from the menu bar

Slide 28

Changing Row Height and Hiding Rows Same concerning segments with the exception of select the line alternatives

Slide 29

AutoFormat Simple to utilize Large choice of organizations effectively arranged Select scope of cells to be designed Select "Organization  AutoFormat" from the menu bar Select wanted preset arrangement

Slide 30

Some Practice Starting with a Blank Worksheet In Column A, Starting at the First Row enter the accompanying information:

Slide 31

Now… . Figure the cost per container of brew for Brooklyn Brand Beer Calculate the aggregate calories in a 6-pack of Brooklyn Brand Beer Using the fill handle, duplicate these 2 recipes down for every other brand of lager

Slide 32

And Now… Insert a section to one side of Column An In new cell A1, enter the title of "Thing No." In the segment, include line numbers utilizing the fill handle to create just odd line numbers for every brand of brew (ie. 1, 3, 5,… )

Slide 33

Your last spreadsheet ought to appear as though this Hit the "Ctrl" key and after that the "`" key to show equations in cells instead of the consequence of the estimation:

Slide 34

Now Add Some Extras Format the Fonts, Cell Colors, Borders and Other Items to Brighten Up the Spreadsheet!

Slide 35

Assignment 12 Create a Spreadsheet and decide the regularly scheduled installment for an auto advance given the accompanying parameters: Amount of Loan: $29,000 Annual Interest Rate (APR): 5.4% Term of Loan: 5 years Payments made month to month The equation to figure an advance installment is: Where P = installment sum per period (ie. Regularly scheduled installment) A = Original measure of the advance (sum obtained) i = loan fee per installment period (ie. on the off chance that the yearly financing cost is 12% and installments are made month to month, i = 12%/12 or 1%) N = Total number of installments All estimations must be performed in Excel and your cells ought to have equations in them… not only the Answer ought to be in coin design (dollars and pennies) Your spreadsheet ought to seem conciliating to the eye – use hues, outskirts, and so on… to highlight key things and, specifically, the response to the issue. To turn in your task, email your exceed expectations record as a connection to: paid@hawaii.edu with the title "ICS100, Assignment 12 – your name"

View more...