Tutorials in English
   abc Word 2010
   abc Excel 2003
   abc Excel 2010
   abc PowerPoint 2010

abc Tutorials:
   Operativni sistemi
   abc Windows 7
   abc Windows XP
   abc Operativni sistemi
   Microsoft Office
   abc Word 2010
   abc Word 2007
   abc Word 2003
   abc Excel 2010
   abc Excel 2007
   abc Excel 2003
   abc Power Point 2010
   abc Power Point 2003
   abc Access 2010
   abc Access 2007
   abc Expression Web
   abc Front Page 2003
   Računari i Internet
   abc Osnove računara
   abc Internet osnove
   abc HTML5
   abc HTML
   abc Jasc Animation Shop
   abc Flash
   abc Movie Maker
   Algoritmi i programski jezici
   abc Algoritmi
   abc BASIC
   abc Pascal
   abc C
   abc C++
   abc Java
   Provjera znanja
   abc Quiz-Test

Priručnici:
   MatchCAD
   MatchCAD 2001
   Corel Draw X6
   CSS

Učenjenje kroz igru /LEARNING THROUGH GAMES/

abc MICROSOFT EXCEL - freee online tutorial
by Željko Grbić
and co-authors

This is a basic tutorial of Excel with .gif animations, descriptions and step by step explanations. The tutorial is very usefull for prepariong ECDL Excel exam.

  1. INTRODUCTION

  2. OPENING AND CLOSING MICROSOFT EXCEL

  3. Open Microsoft Excel window
  4.    Starting Excel using the Microsoft Office submenu
  5.    Starting Excel using the Windows Start menu
  6.    Starting Excel using a shortcut application icon
  7.    Starting Excel using a document icon

  8. Close MICROSOFT EXCEL window
  9.    Closing: CONTROL menu - CLOSE item
  10.    Closing:CONTROL button - DOUBLE CLICK/
  11.    Closing: FILE menu EXIT item
  12.    Closing: CLOSE button - click/

  13. EXCEL WINDOW
  14.    Parts of a EXCEL window
  15.    ENVIROMENT - Toolbars in a EXCEL window
  16.    GRIDLINES
  17.    TASK PANE
  18.    Zoom In/ Zoom Out Working Area

  19. PAGE SETUP
  20.    Paper Size
  21.    Page Orientation
  22.    Margins
  23.    Header & Footer
  24.    Preview the Header & Footer - PRINT PREVIEW item from FILE menu
  25.    Preview the Header & Footer - PRINT PREVIEW button from Toolbar

  26. DATA ENTRY
  27.    Data entry into celll
  28.    Data entry: from Formula bar
  29.    Data entry: DATA FORM-SHEET dialog box
  30.    Data type: Text
  31.    Data type: Date
  32.    Delete character right of the cursor - Delete key
  33.    Delete character left of the cursor - Backspace key
  34.    New line in cell ALT+ENTER

  35. WORKSHEET
  36.    SELECT WORKSHEET
  37.    WORKSHEET BAR
  38.    INSERT WORKSHEET
  39.    INSERT WORKSHEET - SHIFT + F11
  40.    RENAME WORKSHEET
  41.    DELETE WORKSHEET
  42.    MOVE WORKSHEET
  43.    COPY WORKSHEET

  44. COLUMN
  45.    Select column
  46.    Insert column, INSERT menu
  47.    Column width, a column header
  48.    Column width, FORMAT menu
  49.    Visible/unvisble cell content #### – Changing column width by column headings
  50.    Delete column

  51. Examples
  52.    Insert column example 01
  53.    Delete COLUMN example 01

  54. ROW
  55.    Select row
  56.    Insert row
  57.    Row height - row header
  58.    Row height - FORMAT menu
  59.    Delete row

  60. Primjeri /EXAMPLES/
  61.    Insert row example 01
  62.    Delete row example 01

  63. CELL
  64.    Active cell
  65.    Range cell
  66.    Erasing data
  67.    Move a cell content
  68.    Insert cell(s)
  69.    Delete cell(s)

  70. QUIZ - TEST
  71.    Quiz - test

  72. FORMAT CELLS from TOOLBAR
  73.    Font
  74.    The Font color button 01
  75.    The Font color - the arrow next to the Font color button 02
  76.    Alignment
  77.    Border
  78.    Shadow

  79. FORMAT CELLS - dijalog prozor
  80.    Open Format cell dialog box
  81.    Number tab
  82.    Font tab
  83.    Alignment tab
  84.    Alignment tab - Orientation 01
  85.    Alignment tab - Orientation 02
  86.    Alignment tab - Wrap text
  87.    Alignment tab- Shrink to fit
  88.    Border tab
  89.    Patterns tab - Shadow 01
  90.    Patterns tab - Shadow 02
  91.    Patterns tab - Shadow 03

  92. FORMAT CELLS - examples
  93.    Format cell example 01
  94.    Format cell BACKGROUND example 02
  95.    Format cell NUMBER example 03
  96.    Format cell NUMBER & ALIGNMENT example 04

  97. Formula - equation /=/
  98.    Typing values in equal from keyboard (npr =2+3)
  99.    Write equation by using a mouse click 1
  100.    Write equation by using a mouse click 2
  101.    Aritmetičke operacije i operatori - Stepenovanje /EXPONENTIATION/

  102. Addressing
  103.    Relative address 01 (copy)
  104.    Absolute address 01 (copy)


  105. Funkcije /FUNCTIONS Fx/
  106.    Function SUM - AutoSum button (SIGMA)
  107.    Function SUM - INSERT FUNCTION dialog box
  108.    Function PRODUCT - INSERT FUNCTION dialog box
  109.    Function AVERAGE - INSERT FUNCTION dialog box
  110.    Function COUNT - INSERT FUNCTION dialog box
  111.    Function COUNTA - INSERT FUNCTION dialog box
  112.    Function MAX - Example

  113. NEW, OPEN, SAVE
  114.    New file: File Menu, New item
  115.    Save the first time file: File Menu, Save As
  116.    Save file: File Menu, Save As item
  117.    Save file - Save button
  118.    Save file: shortcut keys CTRL+S
  119.    Open file: Open Recently
  120.    Open file: File Menu - Open Item
  121.    Open file: Open button
  122.    Open file: Shortcut keys Ctrl+O

  123. FIND, REPLACE
  124.    Find: EDIT menu FIND item
  125.    Find: Shortcut keys Ctrl+F
  126.    Replace: EDIT menu REPLACE item

  127. BLOCK, CUT, COPY, PASTE
  128.    Select range
  129.    Select all: SELECT ALL BUTTON
  130.    Select all: Shortcut keys CTRL+A
  131.    Select the cells witch are not near each other: CTRL+CLICK
  132.    Copy: EDIT menu COPY item
  133.    Move: EDIT menu CUT item
  134.    Move: From one worksheet to another worksheet

  135. SORT
  136.    SORT ASCENDING - from TOOLBAR
  137.    SORT DESCENDING from TOOLBAR
  138.    SORT ASCENDING - dialog box
  139.    SORT DESCENDING - dialog box
  140.    Sortiranje po tri kriterija

  141. DATA FILTER
  142.    Autofilter

  143. CHART
  144.    Standard types of chart
  145.    Drawing CHART
  146.    Create chart by F11 key

  147. PRINT
  148.    PRINT - FILE menu - PRINT item
  149.    Open PRINT dilog box by shortcut keys CTRL + P
  150.    Printing gridlines

  151. APPENDIX
  152.    Decrease decimal places
  153.    Increase decimal places
  154.    Fill marker

  155. Examples:
  156.    Create a chart: Iterations
  157.    Create a chart: Iterations - change number of data
  158.    Create a chart: Speed
  159.    Create a chart: Speed - change data
  160.    Create a chart: Histogram

  161. QUIZ - TEST
  162.    Quiz - test