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 Python
   abc C
   abc C++
   abc Java
   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. Starting and Closing MICROSOFT EXCEL

    3. 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
  8.    Closing: CONTROL menu - CLOSE item
  9.    Closing:CONTROL button - DOUBLE CLICK
  10.    Closing: FILE menu EXIT item
  11.    Closing: CLOSE button - click
  12.    Closing: SHORTCUT menu APPLICATION BUTTON - CLOSE item
  13.    Closing: SHORTCUT menu TITLE BAR - CLOSE item

    14. Parts of the EXCEL window
  14.    Scroll bar
  15.    Ribbon
  16.    FILE menu - FILE button
  17.    Quick access toolbar
  18.    Show quick access toolbar below the ribbon
  19.    Show quick access toolbar above the ribbon
  20.    Worksheet without ribbon
  21.    Worksheet without ribbon 2
  22.    Drop down menu
  23.    Display other parameters in RIBBON group
  24.    Display all parameters in RIBBON group
  25.    Dispay gallery in ribbon
  26.    All tabs in ribbon
  27.    Choosing tab in ribbon - HOME TAB
  28.    Choosing tab in ribbon - INSERT TAB
  29.    Choosing tab in ribbon - Page layout TAB
  30.    Choosing tab in ribbon - FORMULAS TAB
  31.    Choosing tab in ribbon - DATA TAB
  32.    Choosing tab in ribbon - REVIEW TAB
  33.    Zoom in
  34.    Zoom out
  35.    Formula bar
  36.    Formula button
  37.    Choosing tab in ribbon - VIEW TAB
  38.    Show or hide gridlines on a worksheet

  39. PAGE SETUP
  40.    Page size from Ribbon
  41.    Paper Size - Page Setup dialog box
  42.    Page Orientation - Page Setup dialog box
  43.    Paper orientation- LANDSCAPE from RIBBON
  44.    Paper orientation - Portrait from ribbon
  45.    Margins - Page Setup Dialog Box
  46.    Margins - Ribbon
  47.    Header & Footer - Page setup dialog box
  48.    Page break from ribbon
  49.    Opening SHEET TAB from PAGE SETUP group
  50.    Opening SHEET TAB - click PRINT TITLES button
  51.    Opening SHEET TAB from SHEET OPTIONS group
  52.    Opening SHEET TAB from SCALE TO FIT group

    53. BACKGROUND
  53.    Choose BACKGROUND parameters
  54.    Delete BACKGROUND

  55. DATA ENTRY
  56.    Data entry: Data Form-Sheet dialog box
  57.    Data entry into cell
  58.    Data entry: from Formula bar
  59.    Confirmation of inserting cell content
  60.    Changing content in formula bar
  61.    Data type - TEXT
  62.    Data type: Text
  63.    Data type: Date
  64.    Deleting cell content in FORMULA BAR - BACKSPACE push button
  65.    Delete character right of the cursor - Delete key
  66.    Withdrawal of inserting cell content (ESC push button)
  67.    Adding the Data Form button to the Quick Access Toolbar
  68.    Conditional formatting- DATA BARS
  69.    Conditional formatting- ICON SETS
  70.    Cell comment
  71.    New line in cell ALT+ENTER


  72. WORKSHEET, COLUMN and ROW
  73. WORKSHEET
  74.    Select worksheet by left click
  75.    Select worksheet - Worksheet bar
  76.    Rename worksheet - Right click
  77.    Rename worksheet - Worksheet tab
  78.    Rename worksheet - Ribbon, Rename sheet
  79.    Moving worksheet tab
  80.    Insert Worksheet by Insert Worksheet button
  81.    Insert Worksheet - Ribbon, Insert Sheet
  82.    Insert Worksheet - Right click
  83.    Insert Worksheet - Keys
  84.    Delete worksheet - Ribbon
  85.    Delete worksheet - Right click
  86.    Copy worksheet

  87. COLUMN

  88.    Select column
  89.    Column width, a column header
  90.    Column width - Ribbon, FORMAT button
  91.    Insert column - Ribbon, INSERT button
  92.    Insert column - Ribbon, Insert button 2
  93.    Insert column - Right click
  94.    Visible/invisble cell content #### – Changing column width by column headings
  95.    Delete Column - Ribbon, Delete
  96.    Delete Column - Right click

    97. Examples
  97.    Insert column example 01
  98.    Delete COLUMN example 01

  99. ROW
  100.    Select Row
  101.    Insert Row - Ribbon, INSERT button
  102.    Insert Row - Right click
  103.    Row height - Row header
  104.    Row height - Ribbon, FORMAT button
  105.    Delete Row - Ribbon, Delete
  106.    Delete Row - Right click

    107. Primjeri /EXAMPLES/
  107.    Insert row example 01
  108.    Delete row example 01

  109. CELL
  110.    Select cell - Active cell
  111.    Range cell
  112.    NAME BOX
  113.    Move a cell content
  114.    Insert cell(s)
  115.    Insert cell(s) 2
  116.    Inserting a cell - Right click
  117.    Delete name box
  118.    Erasing data
  119.    Delete cell(s)

  120. Format cells
  121. Opening FORMAT CELLS - NUMBER dialog box
  122.    Number tab - FORMAT CELLS dialog box
  123.    The choice of currenci from Format cells dialog box


  124. ALIGNMENT
  125.    Text aligment from Ribbon 02
  126.    Text aligment from Ribbon 03
  127.    Text formating from Ribbon - Displaying full content of cell - WRAP TEXT 04 04
  128.    Text orientation from Ribbon
  129.    Merged cells - Ribbon
  130.    Unmerge cells - Ribbon
  131.    Opening Format cells dialog box - Alignment tab
  132.    Opening format cells dialog box - Alignment tab 2
  133.    Alignment tab
  134.    Text orientation - Format cells dialog box - Allignment tab
  135.    Format cells dialog box - Orientation 2
  136.    Format cells - Wrap text
  137.    Format cells - Merge cells
  138.    Format cells dialog box - Shrink to fit
  139.    Format cells dialog box - Patterns cells tab


  140. FONT

  141.    The choice font color from RIBBON
  142.    Opening FORMAT CELLS - FONT dialog box
  143.    The choice font parameters - Format cells dialog box
  144.    The choice greek letters -SYMBOL- Format cells dialog box


  145. Formula - equation /=/
  146.    Typing the expression directly in the cell (e.g. =2+3)
  147.    Click on the cell 1 for input 1
  148.    Click on the cell to mark the coordinates of the cell 2
  149.    Arithmetic operations and operators - Exponentiation ^
  150.    Show-hide formulas

  151. Functions Fx
  152.    Function SUM - AutoSum button (SIGMA)) 01
  153.    Function SUM, INSERT FUNCTION 02
  154.    Function product /PRODUCT/
  155.    The minimum value /MIN/
  156.    The maximum value /MAX/
  157.    Function Average values /AVERAGE/
  158.    Branching, Function IF
  159.    Branching Function /FUNCTION IF/ - copy
  160.    Random value /RAND/
  161.    Random value from 0 to 10 /FUNCTION RAND/
  162.    Order of values by descending order /RANK/
  163.    Order of values by ascending order /RANK/
  164.    Function COUNT
  165.    Counting cells with content function (COUNTA)
  166.    Function SUMIF
  167.    Function SUMIF - absolute values
  168.    Counting the selected values - Function COUNTIF
  169.    Function SUMIF - Average
  170.    Counting the selected values COUNTIF - Average values
  171.    Average of the selected values
  172.    Function SUMIF - relational operator
  173.    Function COUNTIF - Counting the selected values - Relational operator

  174. Creating, opening and saving a document in EXCEL
  175.    Creating a document (NEW) from the Quick Access Toolbar
  176.    Creating a document (NEW) - FILE menu
  177.    Creating a document (NEW) - shortcut keys CTRL + N
  178.    Opening a document (OPEN) - Quick Access Toolbar
  179.    Opening a document (OPEN) - FILE menu
  180.    Opening a document (OPEN) - shortcut keys CTRL i O
  181.    Open a recently opened document /OPEN RECENT/
  182.    Saving a document under a different name (SAVE AS) - FILE menu
  183.    Saving a Document under a different name (SAVE AS) - Quick Access Toolbar
  184.    Saving a Document under a different name (SAVE AS) - shortcut keys CTRL + S

  185. Find and Replace
  186.    Searching for a group of characters - FIND
  187.    Searching for a group of characters by shortcut keys
  188.    Replacing characters (REPLACE)

    189. Block
  189.    Select a range of cells
  190.    Mark the entire document using the button SELECT ALL
  191.    Select the all entire document with buttons CTRL+A
  192.    Mark a group of cells which aren't next to eachother /CTRL+CLICK/

    193. BLOCK, CUT, COPY, PASTE
  193.    Copying contents within the same sheet /EDIT COPY PASTE/
  194.    Moving the contents of the cell /CUT-MOVE CELL/ within the same Sheet /EDIT CUT PASTE/
  195.    Moving a group of cells from one sheet to another /CUT PASTE/

    196. Addressing
  196.    Relative address 01 (copy)
  197.    Absolute address 01 (COPY)


    198. FILL LIST & CUSTOM LIST
  198.    Creating a complete fill list
  199.    Creating a custom list /ADD CUSTOM LIST
  200.    Using the custom list

  201. Show/hide parts of the window
  202.    Show Formula bar
  203.    Show Gridlines
  204.    Show Headings
  205.    Choosing the option 100% Zoom
  206.    Choosing the option Full screen
  207.    Choosing the option Normal
  208.    Choosing the option Page break preview
  209.    izbor opcije Page layout
  210.    Choosing the option Zoom to selection
  211.    Zooming in on the document
  212.    Excel options dialog box

  213. SORT
  214.    SORT ASCENDING - from a to z - DATA TAB
  215.    SORT DESCENDING - from z to a to z - DATA TAB
  216.    SORT ASCENDING - from a to z - HOME TAB - SORT & FILTER button
  217.    SORT DESCENDING - from z to a to z - HOME TAB - SORT & FILTER button
  218.    SORT dialog box
  219.    SORT dialog box - ASCENDING order
  220.    Sorting by three criteria

    221. VLOOKUP - HLOOKUP - RANK
  221.    VLOOKUP - student grades, numerical values
  222.    VLOOKUP - student grades, description grade
  223.    VLOOKUP - Student grades, final grade

    224. DATA FILETER
  224.    Autofilter

  225. CHART
  226.    Standard types of chart
  227.    Creating a chart
  228.    Select CHART data
  229.    Chart-3-D Rotation
  230.    Setting the chart tittle
  231.    Setting labels
  232.    Creating labels
  233.    Creating a Labels from a document
  234.    Showing values on the x- and y-axis
  235.    Changing the series name - Showing values on the x- and y-axis,
  236.    Select the axis value
  237.    Changing the colours of a chart
  238.    Changing the look of the chart
  239.    Changing the chart type
  240.    Changing data in a chart
  241.    Switiching rows and columns
  242.    Creating a GANTT chart
  243.    Creating a GANTT chart - 01 STACKED BAR
  244.    Creating a gantt chart - 02 SELECT DATA
  245.    Creating a gantt chart - 03 DELETE LEGEND
  246.    Creating a gantt chart - 04 REVERSE ORDER
  247.    Creating a gantt chart - 05 MAKING THE FIRST SERIE INVISIBLE
  248.    Creating a gantt chart - 06 START DATE
  249.    Creating a graph by using the Functional button F11

    250. Examples in phisics:
  250.    CHART Examples - Iterations - Create a chart


    251. Examples in physics:
  251.    Iterations
  252.    Delta - Greek letters
  253.    V0 - Index /SUBSCRIPT/
  254.    Heading of the table and the starting values of the variables
  255.    Printing out a formula
  256.    Absolute adressing of the variables
  257.    Values of the variable Delta_t
  258.    Values of velocity v
  259.    Repeat for the value of 220 and the formula delta t and v
  260.    Analyzing by changing the Values
  261.    CHART Examples - Iterations - Create a chart
  262.    Graphic viewing - changing the range
  263.    Speed - Graphics view the changes in speed
  264.    Analyzing by changing the values
  265.    Graph - Histogram - viewing values



  266. Pivot table
  267.    Creating pivot table
  268.    Data for Creating pivot table 1
  269.    Creating pivot table - deviding years and months
  270.    Creating pivot table - Years
  271.    Rename pivot table name
  272.    Adding Header
  273.    Shadowing rows and colloms
  274.    Showing headers of rows and colloms
  275.    Choosing shadow color of rows and collomms
  276.    Selecting data in pivot table
  277.    Choosing final number of all Rows-Colloms /GRAND TOTAL/
  278.    Data for creating pivot table 2
  279.    Display subtotals in pivot table /SUBTOTALS/
  280.    Placing Buttons in front of the header
  281.    Detailed showcase
  282.    Pivot Table Report Layout
  283.    Deviding rows in pivot table
  284.    Deleting files in pivot table
  285.    Move Pivot table
  286.    Changing data in pivot table
  287.    Sorting from A to Z in Pivot table
  288.    Sorting in Pivot table - SORT dialoge table
  289.    Creating Pivot diagram - Pivot Chart
  290.    Removing elements PIVOT CHART 2
  291.    Removing elements from PIVOT CHART 3

    292. PRINT
  292.    PRINT - FILE menu - PRINT item
  293.    Printing the selected range

    294. APPENDIX
  294.    Decrease decimal places
  295.    Increase decimal places

    296. QUIZ - TEST
  296.    Quiz - test