day 5 excel chapters 2 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Day 5: Excel Chapters 2 PowerPoint Presentation
Download Presentation
Day 5: Excel Chapters 2

Loading in 2 Seconds...

play fullscreen
1 / 10

Day 5: Excel Chapters 2 - PowerPoint PPT Presentation


  • 113 Views
  • Uploaded on

Day 5: Excel Chapters 2. Rahul Kavi Rahul.Kavi@mail.wvu.edu SEPTEMBER 3 rd , 2013. RECAP. Formatting. Number Formats. Printing and Page Layout. Cell References. Commonly used functions, other functions(Date & Time) Nested Functions. Conditional. IF(condition, then, else) Equal =

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Day 5: Excel Chapters 2' - lahela


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
day 5 excel chapters 2

Day 5:Excel Chapters 2

Rahul KaviRahul.Kavi@mail.wvu.edu

SEPTEMBER 3rd, 2013

recap
RECAP
  • Formatting.
  • Number Formats.
  • Printing and Page Layout.
  • Cell References.
  • Commonly used functions, other functions(Date & Time)
  • Nested Functions.
conditional
Conditional
  • IF(condition, then, else)
    • Equal =
    • Not Equal <>
    • Less Than <, LT or Equal <=
    • Greater Than >, GT or Equal >=
  • Example: You want to add bonus points if there is a yes in the bonus column
    • IF(C2=“YES”,B2+$E$2,B2)
nested functions
Nested Functions
  • You can use a function as the parameter for another function.
  • Example: Drop the lowest grade
    • 5 Assignments, 25 points each
    • SUM(B2:F2, -MIN(B2:F2))
payments
Payments
  • Used for calculating loan payments
  • PMT(rate, number of periods, present value)
    • Rate is per payment period
    • Present value is usually negative (loans are debt)
lookup functions
Lookup Functions
  • VLOOKUP(value, lookup table, column)
    • value is the item to look up
    • the table should use absolute references ($A$1:$B$6)
    • column is the column in the lookup table to get the return value
  • HLOOKUP(value, lookup table, row)
    • same as VLOOKUP, but for horizontal lookup tables
range names
Range names
  • Range names make it easier to specify ranges in formulas and find ranges within large spreadsheets
    • Must begin with a letter or underscore
    • Only letters, numbers, underscores, and periods
  • You can reference the range in formulas with the name instead of using absolute references
managing range names
Managing range names
  • Name Box
  • Name Manager Tool
    • Formulas->Name Manager
    • Can add, edit, or delete ranges names
  • Use in Formula
    • Paste Names as documentation
    • Find name for formula
  • Autocomplete will show range names, double click the name to fill it in
things to remember
Things to remember
  • MyITLabLesson A Due Today (03/09/2013).
  • Homework/Assignment posted.
  • Homework/Assignment due on 09/13/2013
  • Revise previous slides for Class Project soon.