Lecture8-IE122

# Lecture8-IE122 - IE122 Lecture 8 Introduction to MS Excel...

This preview shows pages 1–7. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: IE122 Lecture 8 Introduction to MS. Excel What is Excel? A spread sheet program To analyze numbers and data Prepare a professional-looking work using the applications of Excel. You can ⋄ Make complex calculations ⋄ Solve problems and make analysis ⋄ Make statistical analysis ⋄ Make simulation ⋄ Draw charts and figures ⋄ etc. Introduction to Excel 2007 Using Ribbons- tabs groups commands Office button Use Help Basic Operations Inserting a sheet Home/Cells/Insert Name a sheet Name a cell Inset columns Insert rows Calculations Use “=“ sign to enter a formula =8+3 To fix a column or row number use “\$” =B4*\$C\$4 (the cell C4 will be fixed if you copy the formula to another cell) Shortcut F4 Most Common Functions To insert a function: Menu Bar/Formulas/Insert Function Can use AutoSum Button (Home tab/editing group) for: =Sum(B2:B10) =Average(B2:B10) =Max(10,20, B2:B10) =Min(C2:C10) Logical Functions...
View Full Document

## This note was uploaded on 07/08/2011 for the course IE 121 taught by Professor Perevalov during the Spring '08 term at Lehigh University .

### Page1 / 13

Lecture8-IE122 - IE122 Lecture 8 Introduction to MS Excel...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online