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

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

Close MICROSOFT EXCEL window

7.    Closing: CONTROL menu - CLOSE item
8.    Closing:CONTROL button - DOUBLE CLICK/
9.    Closing: FILE menu EXIT item
10.    Closing: CLOSE button - click/

EXCEL WINDOW

11.    Parts of a EXCEL window
12.    ENVIROMENT - Toolbars in a EXCEL window
13.    GRIDLINES
14.    TASK PANE
15.    Zoom In/ Zoom Out Working Area


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


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


32. WORKSHEET
33.    SELECT WORKSHEET
34.    WORKSHEET BAR
35.    INSERT WORKSHEET
36.    INSERT WORKSHEET - SHIFT + F11
37.    RENAME WORKSHEET
38.    DELETE WORKSHEET
39.    MOVE WORKSHEET
40.    COPY WORKSHEET


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

Examples

48.    Insert column example 01
49.    Delete COLUMN example 01

ROW

50.    Select row
51.    Insert row
52.    Row height - row header
53.    Row height - FORMAT menu
54.    Delete row

Primjeri /EXAMPLES/

55.    Insert row example 01
56.    Delete row example 01


57. CELL
58.    Active cell
59.    Range cell
60.    Erasing data
61.    Move a cell content
62.    Insert cell(s)
63.    Delete cell(s)

QUIZ - TEST

64.    Quiz - test


65. FORMAT CELLS from TOOLBAR
66.    Font
67.    The Font color button 01
68.    The Font color - the arrow next to the Font color button 02
69.    Alignment
70.    Border
71.    Shadow

FORMAT CELLS - dijalog prozor

72.    Open Format cell dialog box
73.    Number tab
74.    Font tab
75.    Alignment tab
76.    Alignment tab - Orientation 01
77.    Alignment tab - Orientation 02
78.    Alignment tab - Wrap text
79.    Alignment tab- Shrink to fit
80.    Border tab
81.    Patterns tab - Shadow 01
82.    Patterns tab - Shadow 02
83.    Patterns tab - Shadow 03

FORMAT CELLS - examples

84.    Format cell example 01
85.    Format cell BACKGROUND example 02
86.    Format cell NUMBER example 03
87.    Format cell NUMBER & ALIGNMENT example 04


88. Formula - equation /=/
89.    Typing values in equal from keyboard (npr =2+3)
90.    Write equation by using a mouse click 1
91.    Write equation by using a mouse click 2
92.    Aritmetičke operacije i operatori - Stepenovanje /EXPONENTIATION/

Addressing
93.    Relative address 01 (copy)
94.    Absolute address 01 (copy)



95. Funkcije /FUNCTIONS Fx/
96.    Function SUM - AutoSum button (SIGMA)
97.    Function SUM - INSERT FUNCTION dialog box
98.    Function PRODUCT - INSERT FUNCTION dialog box
99.    Function AVERAGE - INSERT FUNCTION dialog box
100.    Function COUNT - INSERT FUNCTION dialog box
101.    Function COUNTA - INSERT FUNCTION dialog box
102.    Function MAX - Example


103. NEW, OPEN, SAVE
104.    New file: File Menu, New item
105.    Save the first time file: File Menu, Save As
106.    Save file: File Menu, Save As item
107.    Save file - Save button
108.    Save file: shortcut keys CTRL+S
109.    Open file: Open Recently
110.    Open file: File Menu - Open Item
111.    Open file: Open button
112.    Open file: Shortcut keys Ctrl+O

FIND, REPLACE
113.    Find: EDIT menu FIND item
114.    Find: Shortcut keys Ctrl+F
115.    Replace: EDIT menu REPLACE item

BLOCK, CUT, COPY, PASTE
116.    Select range
117.    Select all: SELECT ALL BUTTON
118.    Select all: Shortcut keys CTRL+A
119.    Select the cells witch are not near each other: CTRL+CLICK
120.    Copy: EDIT menu COPY item
121.    Move: EDIT menu CUT item
122.    Move: From one worksheet to another worksheet


123. SORT
124.    SORT ASCENDING - from TOOLBAR
125.    SORT DESCENDING from TOOLBAR
126.    SORT ASCENDING - dialog box
127.    SORT DESCENDING - dialog box
128.    Sortiranje po tri kriterija

DATA FILTER

129.    Autofilter


130. CHART
131.    Standard types of chart
132.    Drawing CHART
133.    Create chart by F11 key

PRINT

134.    PRINT - FILE menu - PRINT item
135.    Open PRINT dilog box by shortcut keys CTRL + P
136.    Printing gridlines

APPENDIX

137.    Decrease decimal places
138.    Increase decimal places
139.    Fill marker

Examples:
140.    Create a chart: Iterations
141.    Create a chart: Iterations - change number of data
142.    Create a chart: Speed
143.    Create a chart: Speed - change data
144.    Create a chart: Histogram

QUIZ - TEST

145.    Quiz - test