Kozi ya Excel na Google Sheets kwa Waanzilishi
Course Modules
Viewing Preview
You can view this course without enrolling. Your progress won't be saved unless you login and enroll.
-
Maelezo ya msingi ya spreadsheet na matumizi yake
-
Tofauti kati ya Excel na Google Sheets
-
Jinsi ya kufungua na kuunda faili mpya
-
Mazingira ya kazi na uboreshaji wa maandishi (rangi, bold, italic)
-
Kuchanganya na kupanga seli
Module Content
-
1.3 Kufungua na Kuunda Faili Mpya kwa Undani Zaidi Text Content
-
Mazoezi ya Vitendo na Marejeleo ya Undani Text Content
-
Kuingiza na kuendesha data (namba, maandishi, tarehe)
-
Kubadilisha upana wa safu na safu mlalo
-
Kuongeza na kufuta safu/safu mlalo
-
Fomula za msingi (+,-,*,/) na AutoSum
-
Vitendakazi muhimu (SUM, AVERAGE, MAX, MIN, COUNT)
-
Kuiga fomula kwa kutumia Fill Handle
Module Content
-
2.1 Kuingiza na Kuendesha Data - Upanuzi wa Kina Text Content
-
2.2 Kufanya Hesabu Rahisi kwa Undani Zaidi Text Content
-
Mazoezi ya Vitendo ya Kina na Rasilimali Text Content
-
Kupanga data (Sort) na kuchuja (Filter)
-
Conditional Formatting kwa kuonyesha data kwa masharti
-
Kuunda meza zenye mipangilio mizuri
-
Kutengeneza chati na michoro (Pie, Bar, Line)
-
Kuongeza picha na maoni kwenye spreadsheet
Module Content
-
3.2 Mifano ya Formatting ya Kina Text Content
-
Kufanya kazi na tarehe na muda (TODAY, NOW, DATEDIF)
-
Kutumia vifungu (IF statements) na AND/OR
-
VLOOKUP kwa kutafuta data kwenye jedwali
-
PivotTables kwa muhtasari wa data
-
Kudhibiti makosa (IFERROR, #N/A, #VALUE!)
No content available for this module yet.
-
Kuhifadhi faili kwenye kompyuta na wingu (OneDrive/Google Drive)
-
Kugawa faili na kudhibiti ruhusa (edit/view)
-
Kazi ya pamoja kwa wakati mmoja (Google Sheets)
-
Kufuatilia mabadiliko (Track Changes/Version History)
-
Kuagiza kurasa na kuchapisha spreadsheet
No content available for this module yet.
Quizzes & Assessments
No assessments have been created for this course yet.
Instructors
-
chuosmart_lms
Course Information
- Course Type General Course
ChuoSmart Notifications