Tutorials in English
   abc Word 2010
   abc Excel 2010
   abc Excel 2003
   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 Brojni sistemi
   abc Osnove računara
   abc Računarski sistemi
   abc Internet osnove
   abc HTML5 i CSS3
   abc HTML
   abc Jasc Animation Shop
   abc Flash
   abc Movie Maker
   abc Računarska grafika
  Algoritmi i programski jezici
   abc Algoritmi
   abc BASIC
   abc Turbo Pascal
   abc Dev-Pascal
   abc C
   abc C++
   abc Java
   abc Python
   abc Matlab
   abc Asembler
  Provjera znanja
   abc Quiz-Test

Priručnici:
   MatchCAD
   MatchCAD 2001
   Corel Draw X6
   CSS

Učenjenje kroz igru /LEARNING THROUGH GAMES/

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

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

  1. INTRODUCTION

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

  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.    Closing: SHORTCUT menu APPLICATION BUTTON - CLOSE item
  14.    Closing: SHORTCUT menu TITLE BAR - CLOSE item

  15. Parts of the EXCEL window

  16.    Show or hide gridlines on a worksheet

  17. PAGE SETUP
  18.    Paper Size - Page Setup dialog box
  19.    Page Orientation - Page Setup dialog box
  20.    Margins - Page Setup Dialog Box
  21.    Margins - Ribbon
  22.    Header & Footer - Page Setup Dialog Box

  23. DATA ENTRY
  24.    Data entry into celll
  25.    Data entry: from Formula bar
  26.    Data type: Text
  27.    Data type: Date
  28.    Delete character right of the cursor - Delete key
  29.    Delete character left of the cursor - Backspace key
  30.    New line in cell ALT+ENTER


  31. WORKSHEET
  32.    SELECT WORKSHEET
  33.    WORKSHEET BAR
  34.    Insert Worksheet-the Insert Worksheet tab
  35.    INSERT WORKSHEET - Ribbon
  36.    INSERT WORKSHEET - Right click
  37.    INSERT WORKSHEET - SHIFT + F11
  38.    RENAME WORKSHEET
  39.    RENAME WORKSHEET - Ribbon
  40.    DELETE WORKSHEET
  41.    DELETE WORKSHEET - Ribbon
  42.    DELETE WORKSHEET - Right click
  43.    MOVE WORKSHEET
  44.    COPY WORKSHEET

  45. COLUMN
  46.    Select column
  47.    Insert column - Ribbon, INSERT button
  48.    Insert column - Right click
  49.    Column width, a column header
  50.    Column width - Ribbon, FORMAT button
  51.    Visible/unvisble cell content #### – Changing column width by column headings
  52.    Delete Column - Ribbon, Delete
  53.    Delete Column - Right click

  54. Examples
  55.    Insert column example 01
  56.    Delete COLUMN example 01

  57. ROW
  58.    Select Row
  59.    Insert Row - Ribbon, INSERT button
  60.    Insert Row - Right click
  61.    Row height - Row header
  62.    Row height - Ribbon, FORMAT button
  63.    Delete Row - Ribbon, Delete
  64.    Delete Row - Right click

  65. Primjeri /EXAMPLES/
  66.    Insert row example 01
  67.    Delete row example 01

  68. CELL
  69.    Active cell
  70.    Range cell
  71.    NAME BOX
  72.    DELETE NAME BOX
  73.    Erasing data
  74.    Move a cell content
  75.    Insert cell(s)
  76.    Delete cell(s)

  77. SORT
  78.    SORT ASCENDING - from a to z - DATA TAB
  79.    SORT DESCENDING - from z to a to z - DATA TAB
  80.    SORT ASCENDING - from a to z - HOME TAB - SORT & FILTER button
  81.    SORT DESCENDING - from z to a to z - HOME TAB - SORT & FILTER button
  82.    SORT dialog box - ASCENDING order

  83. DATA FILETER
  84.    Autofilter


  85. CHART
  86.    Creating a chart
  87.    Chart-3-D Rotation
  88.    Setting the chart tittle
  89.    Setting labels
  90.    Creating labels
  91.    Showing values on the x- and y-axis
  92.    Changing the series name - Showing values on the x- and y-axis,
  93.    Changing the colours of a chart
  94.    Changing the look of the chart
  95.    Changing the chart type
  96.    Changing data in a chart
  97.    Switiching rows and columns
  98.    Creating a GANTT chart
  99.    Creating a GANTT chart - 01 STACKED BAR
  100.    Creating a gantt chart - 02 SELECT DATA
  101.    Creating a gantt chart - 03 DELETE LEGEND
  102.    Creating a gantt chart - 04 REVERSE ORDER
  103.    Creating a gantt chart - 05 MAKING THE FIRST SERIE INVISIBLE
  104.    Creating a gantt chart - 06 START DATE


  105. Examples in phisics:
  106.    CHART Examples - Iterations - Create a chart

  107. PRINT
  108.    PRINT - FILE menu - PRINT item

  109. APPENDIX
  110.    Decrease decimal places
  111.    Increase decimal places