Lecture8-IE122

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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
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

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 Right Arrow Icon
Ask a homework question - tutors are online