Day 5: Excel Chapters 2

1 / 10

# Day 5: Excel Chapters 2 - PowerPoint PPT Presentation

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 =

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

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

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

Rahul KaviRahul.Kavi@mail.wvu.edu

SEPTEMBER 3rd, 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 =
• 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
• 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
• 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
• 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 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
• 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
• MyITLabLesson A Due Today (03/09/2013).
• Homework/Assignment posted.
• Homework/Assignment due on 09/13/2013
• Revise previous slides for Class Project soon.