|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction to electronic spreadsheet and general concepts.
|
R1
|
|
2
|
Window elements and display formats.
|
R1
|
|
3
|
Worksheet, view creation, view adjustment, window splitting. Filing operations.
|
R1
|
|
4
|
Opening a file, changing the record type. Working with cells.
|
R1
|
|
5
|
Cell selection, row and column adjustment, naming, data entry, cell editing, cell merging, renewal, data discovery.
|
R1
|
|
6
|
Data copying and moving. Worksheet settings, pre-printing rows and columns.
|
R1
|
|
7
|
Formatting operations, borders, patterning, formatting, conditional formatting.
|
R1
|
|
8
|
Add operations, add parent and child insert, page number, time, date.
|
R1
|
|
9
|
Adding graphics, images, objects and linking between pages.
|
R1
|
|
10
|
Create menus, add icons, assign commands on toolbars.
|
R1
|
|
11
|
Data analysis. Data sorting, filtering, checking, validation, data form creation, summary table creation.
|
R1
|
|
12
|
Formulas, using circular reference, conditional formulas.
|
R1
|
|
13
|
Formulas, using mathematical formulas, text formulas, date and time formulas.
|
R1
|
|
14
|
Do not use tools. Creating protection, sharing a workbook, creating a macro. Applications.
|
R1
|