([FHO - DEUkisi.deu.edu.tr/sedat.capar/STA1052_1.pdf · ([fho ([fho :kdw lv ([fho iru" &dofxodwlqj...
Transcript of ([FHO - DEUkisi.deu.edu.tr/sedat.capar/STA1052_1.pdf · ([fho ([fho :kdw lv ([fho iru" &dofxodwlqj...
S.ÇAPAR 1
IST 1052
COMPUTATIONAL TOOLS FOR STATISTICS II(İSTATİSTİK İÇİN HESAPLAMA ARAÇLARI II)
2017-2018
Excel
Excel• What is Excel for?
• Calculating (formulas, macros, …)
• Charting (charts, plots,…)
• Database (sorting, filtering,…)
• Touring the interface
• Ribbon, tabs
• Office button, shortcuts, quick access toolbar
• Name box, formula bar
• Columns, rows
• Sheets
• Page views
Excel• Finding the commands you need
• Ribbon, toolbars
• Home
• Insert
• Page layout
• Formulas
• Data
• Review
• Toolbars group
• Picture tools, format
Excel
• Backstage view
• Office button
• Open, save, save as, recent
• Info
• New, templates
• Options
• Maintain file compability
Excel
• Creating a worksheet
• Cursor, entering, escape key
• Editing
• Rows and columns
• Autofill
• Selection
• Copying and pasting
Excel
• Creating a worksheet
• Cursor, entering, escape key
• Editing
• Rows and columns
• Autofill
• Selection
• Copying and pasting
S.ÇAPAR 2
Excel• Formulas and functions
• Formulas and functions always start with an equal sign
• Cell references
• Formulas are basic arithmetic (+, -, *, /, ^)
• Functions are premade formulas, each does a unique task
• General syntax:
=name_of_function(……..)
• Order of operations (parantheses, exponents, multiplication, division, addition,
substraction)
8
Excel. Example 1
Satış Fiyatı= Fiyat – (Fiyat*indirim)
9
Excel. Example 1
Satış Fiyatı= Fiyat – (Fiyat*indirim)
10
Excel. Example 1
11
Excel. Example 2
Prim= Satış Miktarı * 0.10
Kar = Satış Miktarı – Prim
12
Excel. Example 2
Prim= Satış Miktarı * 0.10
Kar = Satış Miktarı – Prim
S.ÇAPAR 3
13
Excel. Example 2
14
Excel. Example 3
A satış tutarı = A ürünü fiyatı * A satış miktarı
B satış tutarı = B ürünü fiyatı * B satış miktarı
15
Excel. Example 3
A satış tutarı = A ürünü fiyatı * A satış miktarı
B satış tutarı = B ürünü fiyatı * B satış miktarı16
Excel. Example 3
$ sign: absolute references