Nikto: Web Security Testing Tool Guide English

🛡️ Nikto: Web Security Testing Tool

Nikto Web Security Tool

Nikto is an open-source web server security scanner that performs comprehensive tests against web servers for multiple vulnerabilities.

🔧 Key Features of Nikto:

  • Written in Perl - Cross-platform compatibility
  • Web server scanning - Detects dangerous files/CGIs
  • Vulnerability identification - Finds security weaknesses
  • Misconfiguration detection - Identifies server issues
  • Software version checking - Checks outdated software
  • Plugins support - Extensible with additional checks

💻 Basic Nikto Commands:

Basic Scan:

nikto -h https://example.com

Scan with Specific Port:

nikto -h example.com -p 443

Save Output to File:

nikto -h example.com -o results.txt

🎯 Common Use Cases:

Scenario Command Purpose
Basic vulnerability scan nikto -h target.com General security check
SSL/TLS scan nikto -h target.com -ssl Check SSL configuration
Specific port scan nikto -h target.com -p 8080 Scan non-standard ports
Aggressive scan nikto -h target.com -Tuning 5 More thorough testing

⚠️ Important Notes:

Legal and Ethical Use:

  • Only scan servers you own or have permission to test
  • Unauthorized scanning is illegal in many countries
  • Always get written permission before testing
  • Use in controlled environments (labs, authorized pentests)

📊 Sample Output Interpretation:

Understanding Nikto Results:

+ Server: Apache/2.4.29 (Ubuntu)
+ Retrieved x-powered-by header: PHP/7.2.24
+ Root page / redirects to: http://example.com/login.php
+ OSVDB-3092: /phpmyadmin/: phpMyAdmin directory found

What to look for:

  • ❌ Red flags: Default files, outdated software
  • ⚠️ Warnings: Directory listings, information disclosure
  • ✅ Good signs: Security headers, updated software

🔧 Installation Guide:

🐧 Linux (Kali/Ubuntu)

sudo apt update
sudo apt install nikto

🍎 macOS

brew update
brew install nikto

🪟 Windows (via WSL)

wsl --install
sudo apt install nikto

📚 Learning Resources:

💡 Pro Tip:

Nikto is best used as part of a comprehensive security assessment. Combine it with other tools like:

  • Nmap - Network scanning
  • OWASP ZAP - Application security testing
  • Burp Suite - Web vulnerability scanning
  • Metasploit - Exploitation framework

🛡️ Nikto: Ferramenta Teste Seguransa Web

Ferramenta Seguransa Web Nikto

Nikto mak sai ferramenta ida ba teste seguransa web ne'ebé uza hodi hasai informasaun kona-ba server web no pájina web sira.

🔧 Funsaun Nikto nian:

  • Hakerek ho lian Perl - Kompatibilidade multiplataforma
  • Eskaneamentu server web - Deteta arquivu/CGI perigozu
  • Identifika vulnerabilidade - Hetan frakeza seguransa
  • Deteta konfigurasaun la loos - Identifika problema server
  • Verifika versão software - Hetke software tuan
  • Suporta plugins - Bele estende ho verifikasaun adicional

💻 Komandu Báziku Nikto:

Eskaneamentu Báziku:

nikto -h https://ezemplu.com

Eskaneamentu ho Portu Espesífiku:

nikto -h ezemplu.com -p 443

Rai Rezultadu ba Ficheiru:

nikto -h ezemplu.com -o rezultadu.txt

🎯 Kazu Uza Komún:

Szenáriu Komandu Objetivu
Eskaneamentu vulnerabilidade báziku nikto -h alvu.com Verifikasaun seguransa jeral
Eskaneamentu SSL/TLS nikto -h alvu.com -ssl Hetke konfigurasaun SSL
Eskaneamentu portu espesífiku nikto -h alvu.com -p 8080 Eskaneamentu portu la padrón
Eskaneamentu agresivu nikto -h alvu.com -Tuning 5 Teste kompletu liu

⚠️ Nota Importante:

Uzu Légal no Étiku:

  • De'it eskaneia server ne'ebé ita boot sai donu ka iha permissaun atu testa
  • Eskaneamentu la autorizadu ilegal iha nasaun barak
  • Sempre hetan permissaun hakerek molok testa
  • Uza iha ambiente kontroladu (laboratóriu, pentest autorizadu)

📊 Interpretasaun Rezultadu Amostra:

Komprende Rezultadu Nikto:

+ Server: Apache/2.4.29 (Ubuntu)
+ Retrieved x-powered-by header: PHP/7.2.24
+ Root page / redirects to: http://ezemplu.com/login.php
+ OSVDB-3092: /phpmyadmin/: phpMyAdmin directory found

Buat ne'ebé tenke hare:

  • ❌ Bandeira mean: Ficheiru padrón, software tuan
  • ⚠️ Avisu: Listajen diretóriu, diskolse informasaun
  • ✅ Sinál di'ak: Header seguransa, software atualizadu

🔧 Guida Instalasaun:

🐧 Linux (Kali/Ubuntu)

sudo apt update
sudo apt install nikto

🍎 macOS

brew update
brew install nikto

🪟 Windows (via WSL)

wsl --install
sudo apt install nikto

📚 Rekursu Aprendizajen:

🇹🇱 Nikto iha Timór-Leste:

Ema uza Nikto iha Timór hodi:

  • Teste seguransa website governu nian - Garante website governu seguru
  • Proteje server hosi atake hacker - Identifika frakeza molok hacker hetan
  • Haree frakeza iha sistema komputadór nian - Imajina se mak baze iha Timór
  • Edukasaun seguransa sibér - Uza ba fins edukasaun iha universidade

Nikto hanesan "tester" ida ne'ebé ajuda hetan problema molok hacker sira utiliza.

💡 Dika Profisionál:

Nikto di'ak liu uza hanesan parte ida husi avaliasaun seguransa kompletu. Kombina ho ferramenta seluk hanesan:

  • Nmap - Eskaneamentu rede
  • OWASP ZAP - Teste seguransa aplikasaun
  • Burp Suite - Eskaneamentu vulnerabilidade web
  • Metasploit - Framework eksploitasaun

Password Security Guide: Protect Your Digital Data English

🔐 Password Security Guide: Protect Your Digital Data

Topic: Digital Security | Level: All Levels | Time: 8 minutes

Cyber Security

🎯 Why Are Passwords Important?

Passwords are your digital keys. 81% of data breaches occur due to weak passwords!

⚠️ SHOCKING STATISTICS:

  • 123456 is the most popular password (23 million accounts!)
  • The average person has 100+ online accounts
  • 53% of people use the same password for multiple accounts
  • Only 35% of people use 2FA (Two-Factor Authentication)

❌ WORST Passwords (Don't Use These!)

TOP 10 Weakest Passwords:

1. 123456
HACKED in 0 seconds
2. password
HACKED in 0 seconds
3. 12345678
HACKED in 0 seconds
4. qwerty
HACKED in 0 seconds
5. 123456789
HACKED in 0 seconds

Other dangerous ones: "admin", "iloveyou", "welcome", "monkey", "abc123", "letmein"

✅ How to Create STRONG Passwords

📏 Strong Password Rules:

MINIMUM:
  • ✅ 12+ characters
  • ✅ Uppercase & lowercase letters
  • ✅ Numbers (0-9)
  • ✅ Symbols (!@#$%)
  • ✅ No dictionary words
  • ✅ No personal information
IDEAL:
  • 🎯 16+ characters
  • 🎯 Passphrase (sentence)
  • 🎯 Unique per account
  • 🎯 Change every 3-6 months
  • 🎯 Store in password manager

💡 Techniques for Creating Strong Passwords:

  1. Passphrase Method: Take a favorite sentence, take the first letter of each word, add numbers/symbols
    "I love to eat fried rice every day!"Iltefre!2024
  2. Acronym Method: Create acronyms from something memorable
    "My first child was born on January 15, 2020 in Jakarta"Mfcwbo15J@n2020iJkt
  3. Pattern Method: Use complex keyboard patterns
    1qazXSW@3edcVFR$ (look at the keyboard pattern)

🔄 Password vs Passphrase

Type Example Time to Crack Advantages
Weak Password andy123 < 1 second Easy to remember
Strong Password A@nd1!2024# 3 years Hard to guess
Passphrase MyCatEats3Times@Day! 1 million years Easy to remember & very strong

💡 Conclusion: Use passphrases for strength and ease of remembering!

📱 Password Managers: The Best Solution

🤖 Why Do You Need a Password Manager?

Password managers are like digital vaults for all your passwords:

🔐 LastPass
✅ Free version available
✅ Cross-platform
✅ Password generator
lastpass.com
🛡️ Bitwarden
✅ Open source
✅ Self-host option
✅ Very secure
bitwarden.com
🔑 1Password
✅ Family plans
✅ Travel mode
✅ Great UX
1password.com

How Password Managers Work:

  1. Create a SUPER STRONG MASTER PASSWORD (remember this one only!)
  2. Install browser extension
  3. The password manager will:
    • ✅ Automatically save new passwords
    • ✅ Generate strong passwords
    • ✅ Auto-fill login forms
    • ✅ Sync across devices
    • ✅ Alert about data breaches

🔒 Two-Factor Authentication (2FA)

⚡ 2FA: Extra Security Layer

2FA = Password + Something you have/are

🎯 Types of 2FA:
  1. SMS Code (most common)
  2. Authenticator App (more secure)
  3. Biometric (fingerprint, face ID)
  4. Security Key (YubiKey)
  5. Backup Codes (if others fail)
📱 Best Authenticator Apps:
  • ✅ Google Authenticator
  • ✅ Microsoft Authenticator
  • ✅ Authy (cloud backup)
  • ✅ LastPass Authenticator
How to Setup 2FA on Gmail:
  1. Login to Google Account
  2. Security → 2-Step Verification
  3. Select "Authenticator app"
  4. Scan QR code with the app
  5. Save backup codes
  6. Done! Now login requires password + 6-digit code

⚠️ Common Password Mistakes

❌ Mistake ✅ Solution 💀 Risk
Same password for all accounts Password manager + unique passwords One breach = All breached
Never change passwords Reminder every 3-6 months Long exposure
Share password via email/chat Password manager sharing feature Interception
Write on sticky note Password manager Physical theft

🔍 Check Your Password Strength

📊 Password Strength Meter:

VERY WEAK
< 8 characters
Only letters/numbers
WEAK
8-11 characters
Basic combination
GOOD
12-15 characters
Letters, numbers, symbols
STRONG
16+ characters
Complex passphrase

Tools to Check Passwords:

  • Have I Been Pwned (haveibeenpwned.com) - Check if your password has been leaked
  • Password Strength Testers (online tools) - Test password strength
  • Google Password Checkup - Built into Chrome

⚠️ WARNING: Don't test real passwords on untrusted websites!

🚀 Action Plan: Secure Your Accounts NOW!

📋 Password Security Checklist:

Priority 1: Critical Accounts Email, Banking, Social Media
1. Install password manager LastPass/Bitwarden/1Password
2. Enable 2FA Google/Microsoft Authenticator
3. Change to strong passphrase Minimum 16 characters
4. Check for breaches haveibeenpwned.com
Priority 2: Important Accounts Shopping, Cloud Storage, Work
5. Update all passwords Unique per account
6. Enable 2FA if available
Priority 3: Maintenance Routine & Education
7. Setup password change reminder Every 3-6 months
8. Educate family/friends Share knowledge
9. Backup recovery methods Store in safe place

👨‍👩‍👧‍👦 Passwords for Families

💝 Family Password Management:

  1. Family Password Manager (LastPass Families, 1Password Families)
  2. Shared Folder for common passwords (WiFi, streaming, etc)
  3. Emergency Access setup for emergencies
  4. Digital Legacy planning - who can access if something happens
  5. Education for children about online safety

Family Password Example: OurFamily@2024#Jakarta!

📱 Passwords on Smartphones

📱 Android
  • Google Smart Lock
  • Biometric authentication
  • Password manager apps
  • Encrypted backup
🍎 iOS
  • iCloud Keychain
  • Face ID / Touch ID
  • Auto-fill passwords
  • Security recommendations

🛡️ Password Security Challenge: 7 Days

Day 1: Install PM
Day 2: Update Email
Day 3: Setup 2FA
Day 4: Banking
Day 5: Social Media
Day 6: Backup
Day 7: Family

Goal: All main accounts protected with strong passwords + 2FA!

🔐 More Security Materials 🔑 Password Tips

📞 Emergency: If Password is Stolen

  1. IMMEDIATELY change the stolen password
  2. Check for suspicious activity in the account
  3. Enable 2FA if not already
  4. Report to service provider
  5. Monitor financial accounts
  6. Consider identity theft protection

🔐 Guida Seguransa Password: Proteje Ita Boot Nia Dadus Digitál

Tópiku: Seguransa Digitál | Nível: Hotu-hotu | Tempu: Minutu 8

Seguransa Sibér

🎯 Tansa Password Importante?

Password maka ita boot nia kiís digitál. 81% violasaun dadus akontese tanba password fraku!

⚠️ ESTATÍSTIKA ASSUSTADÓRU:

  • 123456 maka password popular liu (kontu 23 millaun!)
  • Pessoa médiu iha kontu online 100+
  • 53% ema uza password hanesan ba kontu barak
  • De'it 35% ema uza 2FA (Two-Factor Authentication)

❌ Password AAT LIU (La'os Uza sira ne'e!)

TOP 10 Password Fraku Liu:

1. 123456
HACKED iha segundu 0
2. password
HACKED iha segundu 0
3. 12345678
HACKED iha segundu 0
4. qwerty
HACKED iha segundu 0
5. 123456789
HACKED iha segundu 0

Seluk ne'ebé perigozu: "admin", "iloveyou", "welcome", "monkey", "abc123", "letmein"

✅ Oinsá atu Kria Password FORTE

📏 Regra Password Forte:

MÍNIMU:
  • ✅ Karakter 12+
  • ✅ Letra boot & ki'ik
  • ✅ Númeru (0-9)
  • ✅ Símbulu (!@#$%)
  • ✅ La iha liafuan disionáriu
  • ✅ La iha informasaun pessuál
IDEÁL:
  • 🎯 Karakter 16+
  • 🎯 Passphrase (sentensa)
  • 🎯 Úniku ba kada kontu
  • 🎯 Troka kada fulan 3-6
  • 🎯 Rai iha password manager

💡 Tékníka atu Kria Password Forte:

  1. Metódu Passphrase: Fotí sentensa favoritu, fotí letra primeiru husi kada liafuan, tau númeru/símbulu
    "Hau gosta han nasi goreng loron-loron!"Hghngll!2024
  2. Metódu Akrónimu: Kria akrónimu husi buat ne'ebé fasil atu recorda
    "Oan primeiru hau nian moris iha Janeiru 15, 2020 iha Jakarta"Ophnmih15J@n2020iJkt
  3. Metódu Padraun: Uza padraun tekladu kompleksu
    1qazXSW@3edcVFR$ (haree padraun iha tekladu)

🔄 Password vs Passphrase

Tipu Ezemplu Tempu atu Konsege Vantajen
Password Fraku andi123 < 1 segundu Fasil atu recorda
Password Forte A@nd1!2024# Tinan 3 Susar atu advinha
Passphrase BisuHau3xHan@Loron! Tinan 1 millaun Fasil atu recorda & forte tebes

💡 Konkluzaun: Uza passphrase ba forteza no fasilidade atu recorda!

📱 Password Manager: Solusaun Di'ak Liu

🤖 Tansa Presiza Password Manager?

Password manager hanesan kofre digitál ba ita boot nia password hotu:

🔐 LastPass
✅ Versaun grátis disponível
✅ Multiplataforma
✅ Jeradór password
lastpass.com
🛡️ Bitwarden
✅ Open source
✅ Opsaun self-host
✅ Seguru tebes
bitwarden.com
🔑 1Password
✅ Planu família
✅ Modu viajen
✅ UX di'ak
1password.com

Oinsá Password Manager Servisu:

  1. Kria MASTER PASSWORD SUPER FORTE (recorda ida ne'e de'it!)
  2. Instala ekstensaun browser
  3. Password manager sei:
    • ✅ Automátikamente rai password foun
    • ✅ Jeradór password forte
    • ✅ Automátikamente prenxe formuláriu login
    • ✅ Sinkroniza entre dispositivu
    • ✅ Alerta kona-ba violasaun dadus

🔒 Two-Factor Authentication (2FA)

⚡ 2FA: Kada Seguransa Extra

2FA = Password + Buat ne'ebé ita boot iha/sai

🎯 Tipu 2FA:
  1. SMS Code (komum liu)
  2. Authenticator App (seguru liu)
  3. Biométriku (fingerprint, face ID)
  4. Security Key (YubiKey)
  5. Backup Codes (se seluk falla)
📱 Authenticator App Di'ak Liu:
  • ✅ Google Authenticator
  • ✅ Microsoft Authenticator
  • ✅ Authy (cloud backup)
  • ✅ LastPass Authenticator
Oinsá atu Setup 2FA iha Gmail:
  1. Login ba Konta Google
  2. Seguransa → Verifikasaun 2-Step
  3. Hili "Authenticator app"
  4. Scan kódigu QR ho app
  5. Rai backup codes
  6. Done! Agora login presiza password + kódigu 6-digit

⚠️ Sala Password Komún

❌ Sala ✅ Solusaun 💀 Risku
Password hanesan ba kontu hotu Password manager + password úniku Violasaun ida = Hotu violadu
Nunka troka password Lembrante kada fulan 3-6 Espozisaun naruk
Fahe password via email/chat Funsaun fahe password manager Interkepsaun
Hakerek iha sticky note Password manager Roubu fíziku

🔍 Hetke Forteza Ita Boot Nia Password

📊 Medidór Forteza Password:

FRAKU TE-BES
< karákter 8
De'it letra/númeru
FRAKU
Karákter 8-11
Kombinasaun báziku
DI'AK
Karákter 12-15
Letra, númeru, símbulu
FORTE
Karákter 16+
Passphrase kompleksu

Ferramenta atu Hetke Password:

  • Have I Been Pwned (haveibeenpwned.com) - Hetke se ita boot nia password tiha ona leek
  • Testadór Forteza Password (ferramenta online) - Teste forteza password
  • Google Password Checkup - Inklui iha Chrome

⚠️ ATENSAUN: La'os teste password reál iha website la konfia!

🚀 Planu Asaun: Seguru Ita Boot Nia Konta AGORA!

📋 Checklist Seguransa Password:

Prioridade 1: Konta Krítiku Email, Banku, Média Sosiál
1. Instala password manager LastPass/Bitwarden/1Password
2. Ativa 2FA Google/Microsoft Authenticator
3. Troka ba passphrase forte Mínimu karákter 16
4. Hetke violasaun haveibeenpwned.com
Prioridade 2: Konta Importante Sosa, Armajen Cloud, Servisu
5. Atualiza password hotu Úniku ba kada kontu
6. Ativa 2FA se disponível
Prioridade 3: Manutensaun Rutina & Edukasaun
7. Setup lembrante troka password Kada fulan 3-6
8. Eduka família/ maluk Fahe koñesimentu
9. Backup metódu rekuperasaun Rai iha fatin seguru

👨‍👩‍👧‍👦 Password ba Família

💝 Jestu Password Família:

  1. Password Manager Família (LastPass Families, 1Password Families)
  2. Pasta Fahe ba password komún (WiFi, streaming, etc)
  3. Aksesu Emerjénsia setup ba situasaun emerjénsia
  4. Planu Legadu Digitál - sé mak bele asesu se akontese buat ruma
  5. Edukasaun ba oan kona-ba seguransa online

Ezemplu Password Família: FamíliaIta@2024#Jakarta!

📱 Password iha Smartphone

📱 Android
  • Google Smart Lock
  • Autentikasaun biométriku
  • Password manager apps
  • Backup enkriptadu
🍎 iOS
  • iCloud Keychain
  • Face ID / Touch ID
  • Auto-fill passwords
  • Rekomendasaun seguransa

🛡️ Desafiu Seguransa Password: Loron 7

Loron 1: Instala PM
Loron 2: Atualiza Email
Loron 3: Setup 2FA
Loron 4: Banku
Loron 5: Média Sosiál
Loron 6: Backup
Loron 7: Família

Objetivu: Konta prinsipál hotu protejidu ho password forte + 2FA!

🔐 Materiál Seguransa Seluk 🔑 Dika Password

📞 Emerjénsia: Se Password Hetan Rouba

  1. IMEDIATAMENTE troka password ne'ebé rouba tiha
  2. Hetke atividade suspeitu iha konta
  3. Ativa 2FA se seidauk
  4. Rapórtu ba provider servisu
  5. Monitoriza konta finansiál
  6. Konsidera protesaun identidade roubu

📊 Microsoft Excel Basics: Complete Guide English

🎯 Why Learn Excel?

Excel is the most popular data analysis tool in the workplace. 82% of office workers use Excel!

  • 💰 Finance
    Budget, invoices, financial reports
  • 📈 Data Analysis
    Statistics, graphs, dashboards
  • 📋 Administration
    Inventory lists, schedules
  • 🎯 Project Management
    Timeline, progress tracking

📑 Excel Workbook Structure

  1. Workbook
    Excel File (.xlsx)
  2. Worksheet
    Sheet in a workbook
  3. Cell
    Row & column intersection
  4. Formula Bar
    A place to write formulas

📍 Excel Coordinate System

     A     B     C     D
  1 |  A1 |  B1 |  C1 |  D1 |
  2 |  A2 |  B2 |  C2 |  D2 |
  3 |  A3 |  B3 |  C3 |  D3 |
  4 |  A4 |  B4 |  C4 |  D4 |

  Cell Reference: Column Letter + Row Number
  Example: B3 = Column B, Row 3
  

🔢 10 Most Important Excel Formulas

Formula Function Example Result
=SUM() Add numbers =SUM(A1:A5) Total A1 to A5
=AVERAGE() Average =AVERAGE(B2:B10) Average B2-B10
=MAX() Highest value =MAX(C1:C20) Max value C1-C20
=MIN() Lowest value =MIN(D5:D15) Min value D5-D15
=COUNT() Count cells with numbers =COUNT(E1:E100) Number count
=IF() Conditional logic =IF(F1>50,"Pass","Fail") Check condition
=VLOOKUP() Vertical data lookup =VLOOKUP(G1,A:B,2,FALSE) Lookup value
=CONCATENATE() Combine text =CONCATENATE(H1," ",H2) Combine text
=TODAY() Today's date =TODAY() 15/01/2024
=ROUND() Rounding =ROUND(I1,2) Round to 2 decimals

📈 Create Simple Charts

Sample Sales Data:

Month Product A Product B Total
January 150 200 350
February 180 220 400
March 210 250 460

Steps to Create Chart:

  1. Select data (A1:D4)
  2. Insert → Recommended Charts
  3. Choose Column Chart
  4. Customize title & colors
  5. Place chart in worksheet

Tip: Use Ctrl + T to convert to Table for automatic chart updates!

🔢 Data Formatting

💰 Currency
Rp 1,500,000
Ctrl+Shift+4
📅 Date
15 January 2024
Ctrl+Shift+3
📊 Percentage
75.50%
Ctrl+Shift+5
🔢 Number
1,234.56
Ctrl+Shift+1

⚡ Important Excel Shortcuts

Shortcut Function Category
Ctrl + S Save workbook 💾 Basic
Ctrl + C / V Copy / Paste 📋 Editing
Ctrl + Z / Y Undo / Redo ↪️ Editing
Ctrl + Arrow Key Navigate to edge 📍 Navigation
Ctrl + Shift + L Toggle Filter 🔍 Data
Alt + = AutoSum 🧮 Formula
F2 Edit cell ✏️ Editing
Ctrl + T Create Table 📊 Formatting

📋 Project: Create Personal Budget

Task: Create Personal Financial Report

Create spreadsheet with this structure:

  PERSONAL BUDGET 2024
  ├── 📄 Sheet 1: INCOME
  │   ├── Basic Salary
  │   ├── Freelance
  │   ├── Bonus
  │   └── TOTAL INCOME (SUM formula)
  │
  ├── 📄 Sheet 2: EXPENSES
  │   ├── Needs (food, transport)
  │   ├── Bills (electricity, internet)
  │   ├── Entertainment
  │   ├── Savings
  │   └── TOTAL EXPENSES (SUM formula)
  │
  └── 📄 Sheet 3: SUMMARY
      ├── Monthly Balance
      ├── Income vs Expenses Chart
      ├── Savings Percentage
      └── CONCLUSION (IF formula: "Healthy"/"Needs Adjustment")
  

Requirements:

  • Use =SUM() for totals
  • Use =IF() for conclusion
  • Create pie chart for expenses
  • Format currency for all numbers
  • Use cell styles for headers

🔍 Filter & Sort Data

Sample Employee Data:

Name Department Salary Status
Andy Marketing 8,000,000 Active
Budi IT 12,000,000 Active

How to Filter:

  1. Select data range
  2. Data → Filter (Ctrl+Shift+L)
  3. Click dropdown in header
  4. Select criteria (e.g., Salary > 10,000,000)
  5. Apply filter

How to Sort:

  1. Select column to sort
  2. Data → Sort A to Z (ascending)
  3. Or Sort Z to A (descending)

⚠️ Common Errors & Solutions

❌ Error ✅ Solution
#VALUE! error Check data type (text vs number)
#REF! error Invalid cell reference
File too large Delete unused cells, compress images
Formula not updating Calculation Options → Automatic
Data not filtering Ensure no blank rows in range

🚀 Advanced Level: Basic Pivot Tables

📊 Magic of Pivot Tables

Pivot Tables are the most powerful data analysis tool in Excel!

How to Create Pivot Table:

  1. Select data range
  2. Insert → PivotTable
  3. Drag fields to areas:
    • Rows: Category (e.g., Month)
    • Columns: Sub-category (e.g., Product)
    • Values: Numerical data (e.g., Sales)
    • Filters: Global filter
  4. Customize layout & design

Example Use Case: Analyze sales per region per month!


📈 Excel Roadmap: 30 Day Mastery

Week 1
Basic Functions
Week 3
Data Analysis
Week 2
Formulas & Charts
Week 4
Pivot & Advanced
Bonus
Macros & VBA

Commitment: 1 hour/day of practice = Excel Expert in 1 month!

📊 Other Excel Topics 💼 Microsoft Office

🎯 Se sidauk komprende sa aprende Excel?

Excel maka ferramenta análize dadus ne'ebé popular liu iha mundu serbisu. 82% husi traballadór eskritóriu sira uza Excel!

  • 💰 Finansas
    Orsamentu, fatura, relatóriu finanseiru
  • 📈 Análize Dadus
    Estatístika, gráfiku, dashboard
  • 📋 Administrasaun
    Lista inventáriu, horáriu
  • 🎯 Jestun Projetu
    Linha tempu, monitorizasaun progressu

📑 Estrutura Workbook Excel

  1. Workbook
    Ficheiru Excel (.xlsx)
  2. Worksheet
    Folha iha dentru workbook
  3. Cell
    Kotu enkontu entre linha & koluna
  4. Formula Bar
    Lugar hodi hakerek fórmula

📍 Sistema Koordenada Excel

     A     B     C     D
  1 |  A1 |  B1 |  C1 |  D1 |
  2 |  A2 |  B2 |  C2 |  D2 |
  3 |  A3 |  B3 |  C3 |  D3 |
  4 |  A4 |  B4 |  C4 |  D4 |

  Referénsia Cell: Letra Koluna + Númeru Linha
  Exemplu: B3 = Koluna B, Linha 3
  

🔢 10 Fórmula Excel Importante Liu

Fórmula Funsaun Exemplu Rezultadu
=SUM() Soma númeru =SUM(A1:A5) Total A1 to'o A5
=AVERAGE() Média =AVERAGE(B2:B10) Média B2-B10
=MAX() Valór altu =MAX(C1:C20) Valór máksimu C1-C20
=MIN() Valór baixu =MIN(D5:D15) Valór mínimu D5-D15
=COUNT() Konta selula ho númeru =COUNT(E1:E100) Kontagem númeru
=IF() Lójika kondisionál =IF(F1>50,"Lae","Falha") Verifika kondisaun
=VLOOKUP() Prokura dadus vertikál =VLOOKUP(G1,A:B,2,FALSE) Prokura valór
=CONCATENATE() Kombina textu =CONCATENATE(H1," ",H2) Kombina textu
=TODAY() Data oin =TODAY() 15/01/2024
=ROUND() Arredondamentu =ROUND(I1,2) Arredonda ba 2 desimál

📈 Kria Gráfiku Simples

Dadu Amostra Venda:

Fulan Produtu A Produtu B Total
Janeiru 150 200 350
Fevereiru 180 220 400
Marsu 210 250 460

Passu hodi Kria Chart:

  1. Seleciona dadus (A1:D4)
  2. Insert → Gráfiku Rekomendadu
  3. Escolhe Gráfiku Koluna
  4. Personaliza títulu & kór
  5. Coloka gráfiku iha worksheet

Dika: Uza Ctrl + T hodi konverte ba Tabela ba gráfiku atualiza otomatikamente!

🔢 Formata Dadus

💰 Moeda
Rp 1.500.000
Ctrl+Shift+4
📅 Data
15 Janeiru 2024
Ctrl+Shift+3
📊 Persentuajen
75,50%
Ctrl+Shift+5
🔢 Númeru
1.234,56
Ctrl+Shift+1

⚡ Atalhu Importante Excel

Atalhu Funsaun Kategoria
Ctrl + S Grava workbook 💾 Báziku
Ctrl + C / V Kópia / Kola 📋 Edisaun
Ctrl + Z / Y Desfazer / Refazer ↪️ Edisaun
Ctrl + Tekla Frecha Navega ba extremidade 📍 Navegasaun
Ctrl + Shift + L Ativa/Desativa Filtu 🔍 Dadus
Alt + = Soma Automátika 🧮 Fórmula
F2 Edita selula ✏️ Edisaun
Ctrl + T Kria Tabela 📊 Formataun

📋 Projetu: Kria Orsamentu Pessuál

Tarefa: Kria Relatóriu Finanseiru Pessuál

Kria spreadsheet ho estrutura tuir mai:

  ORSAMENTU PESSUÁL 2024
  ├── 📄 Folha 1: RECEITA
  │   ├── Saláriu Báziku
  │   ├── Freelance
  │   ├── Bónus
  │   └── TOTAL RECEITA (fórmula SUM)
  │
  ├── 📄 Folha 2: DESPEZA
  │   ├── Nesesidade (han, transporte)
  │   ├── Konta (eletrisidade, internet)
  │   ├── Lazer
  │   ├── Poupansa
  │   └── TOTAL DESPEZA (fórmula SUM)
  │
  └── 📄 Folha 3: RESUMU
      ├── Saldu Mensál
      ├── Gráfiku Receita vs Despeza
      ├── Persentuajen Poupansa
      └── KONKLUZÁUN (fórmula IF: "Saude"/"Korrexe")
  

Requisitus:

  • Uza =SUM() ba total
  • Uza =IF() ba konkluzaun
  • Kria gráfiku tipu pizza ba despeza
  • Formata moeda ba númeru hotu
  • Uza estilu selula ba kabeça

🔍 Filtu & Ordena Dadus

Dadu Amostra Empregadu:

Naran Departamentu Saláriu Status
Andi Marketing 8.000.000 Ativu
Budi IT 12.000.000 Ativu

Modu Filtu:

  1. Seleciona intervalu dadus
  2. Dadus → Filtu (Ctrl+Shift+L)
  3. Klika menu desizente iha kabeça
  4. Seleciona kritéru (exemplu: Saláriu > 10.000.000)
  5. Aplika filtu

Modu Ordena:

  1. Seleciona koluna hodi ordena
  2. Dadus → Ordena A to Z (asendente)
  3. Ou Ordena Z to A (desendente)

⚠️ Erros Komuns & Solusaun

❌ Erro ✅ Solusaun
#VALUE! error Verifika tipu dadus (textu vs númeru)
#REF! error Referénsia selula inválida
Ficheiru too grande Apaga selula la uza, komprime imagem
Fórmula la atualiza Opasaun Kalkulasaun → Automátiku
Dadus la hetan filtu Garante ne'ebé la iha liña branku iha intervalu

🚀 Nivel Superior: Tabela Dinámika Báziku

📊 Májika Tabelas Dinámika

Tabelas Dinámica (PivotTables) maka ferramenta análize dadus boot poderuza iha Excel!

Modu Kria Tabela Dinámica:

  1. Seleciona intervalu dadus
  2. Insert → Tabela Dinâmica
  3. Arrasta kaampu ba área:
    • Linha: Kategoria (exemplu: Fulan)
    • Koluna: Sub-kategoria (exemplu: Produtu)
    • Valór: Dadus numéruku (exemplu: Venda)
    • Filtu: Filtu globál
  4. Personaliza layout & designu

Ezemplu Kazu Uza: Análize venda por rejião kada fulan!


📈 Mapa Estrada Excel: 30 Dias Dominu

Semana 1
Funsaun Báziku
Semana 3
Análize Dadus
Semana 2
Fórmulas & Gráfiku
Semana 4
Tabela Dinámica & Avansadu
Bónus
Makros & VBA

Kompromissu: 1 oras/dia de prática = Espértu Excel iha 1 fulan!

📊 Tópiku Excel Seluk 💼 Microsoft Office

FUNCTIONS (TRANSPORT & COMPUTER LAB) English

🚌 Transport Services

We provide free transportation for all registered students to ensure easy access to our learning centers.

Route Schedule Pick-up Points
Central Route 07:00, 13:00, 18:00 Tasi Tolu, Bidau, Cristo Rei
Eastern Route 07:30, 13:30, 18:30 Becora, Bairopite, Lahane
Western Route 07:15, 13:15, 18:15 Comoro, Kampung Alor, Audian

💻 Computer Lab Facilities 

Our modern computer lab is equipped with the latest technology to support your learning journey:

🖥️ Equipment

  • 25 High-speed computers
  • Windows 11 Pro installed
  • Microsoft Office 365
  • Adobe Creative Suite

🌐 Internet

  • 1 Gbps fiber optic
  • Wi-Fi 6 coverage
  • Unlimited access
  • VPN for research

🛠️ Support

  • Lab technician available
  • Printing services (100 pages free)
  • Scanner & photocopy
  • Technical assistance

📋 Computer Lab Rules

Rule Description
Operating Hours Monday-Saturday: 08:00-20:00, Sunday: 09:00-17:00
Booking System Max 2 hours per session, can be extended if available
No Food/Drink Only water in closed containers allowed
Data Saving Always save to cloud or USB, computers reset daily

📍 How to Access

  1. Show your Student ID Card at entrance
  2. Register at the Lab Assistant desk
  3. Choose available computer (numbered system)
  4. Log in with provided credentials
  5. Log out and clean station after use

📞 Contact Information

Transport Coordinator: +670-XXXX-XXXX
Lab Manager: +670-XXXX-XXXX
Email: facilities@studahamutuk.tl
Location: Main Building, Room 101

🚌 Servisu Transporte

Ami fornese transporte grátis ba estudante rejistadu hotu hodi garante asesu fasil ba ami nia sentru aprendizajen.

Ruta Horáriu Puntu Hasai
Ruta Sentrál 07:00, 13:00, 18:00 Tasi Tolu, Bidau, Cristo Rei
Ruta Leste 07:30, 13:30, 18:30 Becora, Bairopite, Lahane
Ruta Oeste 07:15, 13:15, 18:15 Comoro, Kampung Alor, Audian

💻 Fasilidade Laboratóriu Komputador

Ami nia laboratóriu komputador modernu iha teknologia foun liu hodi suporta ita boot nia jornada aprendizajen:

🖥️ Ekipamentu

  • 25 Komputador ho velocidade altu
  • Windows 11 Pro instaladu
  • Microsoft Office 365
  • Adobe Creative Suite

🌐 Internet

  • 1 Gbps fibra óptika
  • Wi-Fi 6 kobertura
  • Aksesu ilimitadu
  • VPN ba peskiza

🛠️ Suporta

  • Tékniku laboratóriu disponível
  • Servisu imprima (pájina 100 grátis)
  • Eskane & fotokópia
  • Asisténsia tékníka

📋 Regra Laboratóriu Komputador

Regra Deskrisaun
Oras Operasaun Segunda-Sábadu: 08:00-20:00, Domingu: 09:00-17:00
Sistema Rezerva Máksimu oras 2 per sesaun, bele estende se disponível
Lae Han/Heen De'it bee iha kontéiner taka mak permitidu
Salva Dadus Sempre salva ba cloud ka USB, komputador reset loron-loron

📍 Oinsá atu Asesu

  1. Hatudu ita boot nia Kárta Estudante iha entrada
  2. Rejistra iha Meza Asistente Laboratóriu
  3. Hili komputador disponível (sistema numeru)
  4. Log in ho kredensiál fornese
  5. Log out no limpa estasaun depois uza

📞 Informasaun Kontaktu

Koordenadór Transporte: +670-XXXX-XXXX
Jerente Laboratóriu: +670-XXXX-XXXX
Email: facilities@studahamutuk.tl
Lokasaun: Edifísiu Prinsipál, Sala 101

LIBRARY FACILITIES English

📚 Welcome to Studa Hamutuk Library

Our library is a knowledge hub designed to support your academic and personal development with comprehensive resources.

📖 Collection Overview

  • 5,000+ Physical Books across all subjects
  • 10,000+ E-books accessible online
  • 50+ Academic Journals (print & digital)
  • 200+ Research Papers by local scholars
  • 500+ Multimedia Resources (DVDs, CDs)

🏛️ Facilities

  • Reading Area: 100 comfortable seats
  • Study Carrels: 30 private study spaces
  • Group Study Rooms: 8 rooms (4-8 people)
  • Computer Stations: 15 with internet access
  • Photocopy/Print: Self-service machines

📊 Library Collection by Category

Category Physical Books E-books Location
Technology & IT 1,200 3,500 Section A
Business & Management 800 2,000 Section B
Languages & Literature 600 1,500 Section C
Science & Engineering 900 2,200 Section D
Social Sciences 700 1,800 Section E

⏰ Operating Hours & Services

Day Opening Hours Services Available
Monday - Friday 08:00 - 20:00 All services (borrowing, research assistance)
Saturday 09:00 - 18:00 Limited services (no book returns)
Sunday 10:00 - 16:00 Reading room only (no borrowing)

📝 Membership & Borrowing Rules

Borrowing Privileges

🎓 Students
  • 5 books for 14 days
  • 2 renewals allowed
  • Free membership
👨‍🏫 Teachers
  • 10 books for 30 days
  • Unlimited renewals
  • Free membership
🏢 Staff
  • 3 books for 21 days
  • 1 renewal allowed
  • Free membership

🔍 Online Resources & Databases

Access these resources with your library account:

  • 📚 E-Library Portal: library.studahamutuk.tl
  • 🔗 Academic Databases: JSTOR, IEEE, SpringerLink
  • 🎥 Video Tutorials: LinkedIn Learning, Coursera
  • 📄 E-books Platform: OverDrive, Project Gutenberg
  • 📰 News & Journals: The Economist, Nature

💡 Library Tips

  • Use the online catalog to check book availability before visiting
  • Bring your student ID for all library transactions
  • Respect the quiet study zones - use group rooms for discussions
  • Return books on time to avoid fines (Rp 1,000/day per book)
  • Attend our weekly research workshops every Thursday at 15:00

📚 Benvindu ba Biblioteka Studa Hamutuk

Ami nia biblioteka maka sentru koñesimentu ne'ebé dezenha atu suporta ita boot nia dezenvolvimentu akadémiku no pessuál ho rekursu kompletu.

📖 Vizualizasaun Koleksaun

  • 5,000+ Livru Físiku iha área hotu-hotu
  • 10,000+ E-livru asesu online
  • 50+ Jurnál Akadémiku (imprime & digitál)
  • 200+ Paper Peskiza husi estudante lokál
  • 500+ Rekursu Multimédia (DVD, CD)

🏛️ Fasilidade

  • Área Lee: 100 kadeira konfortável
  • Karela Estudu: 30 espasu estudu privadu
  • Sala Estudu Grupu: 8 sala (ema 4-8)
  • Estasaun Komputador: 15 ho asesu internet
  • Fotokópia/Imprime: Máquina autoservisu

📊 Koleksaun Biblioteka por Kategoria

Kategoria Livru Físiku E-livru Lokasaun
Teknologia & IT 1.200 3.500 Seisaun A
Biznis & Jestu 800 2.000 Seisaun B
Lian & Literatura 600 1.500 Seisaun C
Siénsia & Enjinaría 900 2.200 Seisaun D
Siénsia Sosiál 700 1.800 Seisaun E

⏰ Oras Operasaun & Servisu

Loron Oras Loke Servisu Disponível
Segunda - Sexta 08:00 - 20:00 Servisu hotu (empresta, asisténsia peskiza)
Sábadu 09:00 - 18:00 Servisu limitadu (la iha devolusaun livru)
Domingu 10:00 - 16:00 Sala lee de'it (la iha empresta)

📝 Membru & Regra Empresta

Priviléjiu Empresta

🎓 Estudante
  • Livru 5 ba loron 14
  • Renova 2 permitidu
  • Membru grátis
👨‍🏫 Mestri
  • Livru 10 ba loron 30
  • Renova ilimitadu
  • Membru grátis
🏢 Staff
  • Livru 3 ba loron 21
  • Renova 1 permitidu
  • Membru grátis

🔍 Rekursu Online & Baze Dadus

Aksesu rekursu sira ne'e ho ita boot nia konta biblioteka:

  • 📚 Portal E-Biblioteka: biblioteka.studahamutuk.tl
  • 🔗 Baze Dadus Akadémiku: JSTOR, IEEE, SpringerLink
  • 🎥 Video Tutorial: LinkedIn Learning, Coursera
  • 📄 Plataforma E-livru: OverDrive, Project Gutenberg
  • 📰 News & Jurnál: The Economist, Nature

💡 Dika Biblioteka

  • Uza katalógu online atu hetke disponibilidade livru molok vizita
  • Lori ita boot nia kárta estudante ba transasaun biblioteka hotu
  • Rezpeita zona estudu silénsiu - uza sala grupu ba diskusaun
  • Devolve livru iha tempu hodi evita multa (Rp 1.000/loron per livru)
  • Partisipa ami nia workshop peskiza semana kada Kinta iha 15:00