Tech & AI Hub | የቴክ እና AI ማዕከል
1.84K subscribers
1.34K photos
108 videos
570 files
909 links
​💻 Tech & AI Hub | የቴክ እና AI ማዕከል
​በቻናላችን የሚለቀቁ ዋና ዋና ይዘቶች፦
🚀 Programming & Software
🖥️ መሰረታዊ የኮምፒውተር እውቀቶች
🤖 የ-AI ክህሎቶች እና የ Prompt Tips
🎓 ነፃ ቴክኖሎጂ ነክ የትምህርት ዕድሎች
💡 ቴክኖሎጂ ነክ ትምህርቶችና ጠቃሚ ጥቆማዎች

Tiktok:

tiktok.com/@techaihub2
Download Telegram
Tech & AI Hub | የቴክ እና AI ማዕከል
Photo
📊 Master Microsoft Excel : 

The Excel Tree 👇 
| 
|──Basics
| ├── Workbook / Worksheet 
| ├── Rows & Columns 
| └── Cells & Ranges 
| 
|──Data Entry & Formatting 
| ├── Text / Numbers / Dates 
| ├── Cell Formatting (bold, color, borders) 
| ├── Conditional Formatting 
| └── Cell Styles & Themes 
| 
|──Formulas & Functions
| ├──

=SUM()

,

=AVERAGE()

 
| ├──

=IF()

,

=AND()

,

=OR()

 
| ├──

=VLOOKUP()

/

=HLOOKUP()

/

=XLOOKUP()

 
| ├──

=INDEX()

/

=MATCH()

 
| └──

=COUNT()

,

=COUNTA()

,

=COUNTIF()

 
| 
|──Charts & Graphs
| ├── Bar / Line / Pie / Column 
| ├── Combo Charts 
| └── Sparklines 
| 
|──Data Tools 
| ├── Data Validation 
| ├── Remove Duplicates 
| ├── Text to Columns 
| └── Flash Fill 
| 
|──Sorting & Filtering 
| ├── AutoFilter 
| ├── Custom Sort 
| └── Advanced Filter 
| 
|──Pivot Tables & Pivot Charts 
| ├── Summarize large data 
| ├── Drag & drop interface 
| └── Slicers for filtering 
| 
|──Tables & Named Ranges 
| ├── Excel Tables (Insert > Table) 
| └── Named Ranges for easy reference 
| 
|──Date & Time Functions
| ├──

=TODAY()

,

=NOW()

 
| ├──

=DATEDIF()

,

=EDATE()

 
| └──

=TEXT()

for formatting 
| 
|──Text Functions
| ├──

=LEFT()

,

=RIGHT()

,

=MID()

| ├──

=LEN()

,

=FIND()

,

=SEARCH()

 
| └──

=CONCAT()

/

=TEXTJOIN()

 
| 
|──Logical & Lookup Functions
| ├──

=IFERROR()

 
| ├──

=CHOOSE()

 
| └──

=SWITCH()

 
| 
|──Keyboard Shortcuts 
| ├── Ctrl + Arrow → Jump 
| ├── Ctrl + Shift + L → Filter 
| └── F2 → Edit Cell 
| 
|──Macros & Automation
| ├── Record Macros 
| └── VBA (Visual Basic for Applications) 
| 
|──Data Analysis Tools 
| ├── Goal Seek 
| ├── Solver 
| └── What-If Analysis 
| 
|── Best Practices
| ├── Use tables for dynamic data 
| ├── Use comments & named ranges 
| └── Avoid merged cells in data tables 
| 
|── END __


​══════════════
📱 Connect With Us

Ⓣ Tiktok:

https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S


Ⓣ Telegram:
https://t.me/TechAIHub1⁠

ⓕ Facebook:
https://www.facebook.com/TechandAIHub⁠
❤2
Tech & AI Hub | የቴክ እና AI ማዕከል
Photo
📚 10 ChatGPT Prompts to Improve English Communication Skills

1. Personal Communication Coach


Act as my personal English communication coach. Assess my communication skills through our interactions, identify my strengths and weaknesses, and create a personalized improvement plan. Don't ask me to rate my own skills. Start with a natural conversation.

2. Daily Conversation Practice

Act as my English conversation partner. Have a natural conversation with me about everyday topics. Ask one question at a time and correct my important mistakes after I respond. Gradually make the conversation more challenging.

3. Grammar Correction

Act as my English grammar coach. Whenever I write something, identify my important grammar mistakes, explain them simply, and show me the corrected version. Then give me a short practice task.

4. Speak More Naturally

I will write what I want to say in English. Correct my mistakes and show me 2–3 more natural ways to express the same idea. Focus on expressions commonly used by fluent English speakers.

5. Real-Life Role-Play

Give me realistic English communication situations, such as meeting someone, asking for help, making a request, attending a meeting, or talking to a colleague. Role-play the situation with me and correct my responses.

6. Vocabulary & Useful Expressions

Teach me practical English vocabulary and expressions for everyday communication. Give me a situation, teach me useful words or phrases, and then ask me to use them in my own sentences. Correct my mistakes.

7. Think in English

Help me learn to think directly in English instead of translating from my first language. Give me simple situations and ask what I would say or think in English. Correct my response and teach me more natural expressions.

8. Pronunciation & Speaking Practice

Act as my English pronunciation coach. Give me useful sentences to practice speaking. Identify difficult words, show simple pronunciation guidance, and help me speak more clearly and naturally.

9. Professional Communication

Act as my professional English communication coach. Help me practice situations such as explaining ideas, asking questions, giving instructions, participating in meetings, and communicating with colleagues. Correct my mistakes and make my expressions clear and professional.

10. Progressive Challenges & Assessment

Create a progressive English communication program for me. Give me one challenge at a time, assess my responses, correct my mistakes, and gradually increase the difficulty as I improve. Track the areas I need to work on and adapt future challenges accordingly.

​══════════════
📱 Connect With Us

Ⓣ Tiktok:

https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S


Ⓣ Telegram:
https://t.me/TechAIHub1⁠

ⓕ Facebook:
https://www.facebook.com/TechandAIHub⁠
Tech & AI Hub | የቴክ እና AI ማዕከል
Photo
🤖 MACHINE LEARNING ROADMAP

From Fundamentals → Intelligent Solutions

01. FUNDAMENTALS


Mathematics

Linear Algebra

Calculus — Gradients & Optimization

Probability & Statistics

Matrix Operations

Programming

Python — NumPy, Pandas, Scikit-learn

R — Optional for Statistical Modeling

SQL — Data Extraction

02. DATA PREPROCESSING

Data Cleaning

Feature Engineering

Encoding Categorical Data

Feature Scaling

Standardization

Normalization

Handling Missing Values

Dimensionality Reduction

PCA

LDA

03. SUPERVISED LEARNING

Regression

Linear Regression

Polynomial Regression

Ridge & Lasso Regression

Classification

Logistic Regression

Decision Trees

Support Vector Machines — SVM

Ensemble Methods

Random Forest

Gradient Boosting

XGBoost

04. UNSUPERVISED LEARNING

Clustering

K-Means

Hierarchical Clustering

DBSCAN

Dimensionality Reduction

Principal Component Analysis — PCA

t-SNE

Association Rules

Apriori

FP-Growth

05. REINFORCEMENT LEARNING

Markov Decision Processes — MDPs

Q-Learning

Deep Q-Learning

Policy Gradient Methods

06. MODEL EVALUATION & OPTIMIZATION

Model Validation

Train-Test Split

Cross-Validation

Performance Metrics

Accuracy

Precision

Recall

F1-Score

ROC-AUC

Mean Squared Error — MSE

R-Squared

Hyperparameter Tuning

Grid Search

Random Search

Bayesian Optimization

07. DEEP LEARNING

Neural Networks

Perceptrons

Backpropagation

Convolutional Neural Networks — CNN

Image Classification

Object Detection

YOLO

SSD

Recurrent Neural Networks — RNN

LSTM

GRU

Transformers

Attention Mechanisms

BERT

GPT

Tools & Frameworks

TensorFlow

PyTorch

08. ADVANCED TOPICS

Transfer Learning

Generative Adversarial Networks — GANs

Reinforcement Learning with Neural Networks

Explainable AI — XAI

SHAP

LIME

09. APPLICATIONS OF MACHINE LEARNING

Recommender Systems

Collaborative Filtering

Content-Based Filtering

Fraud Detection

Sentiment Analysis

Predictive Maintenance

Autonomous Vehicles

10. DEPLOYMENT OF MODELS

APIs & Web Deployment

Flask

FastAPI

Cloud Deployment

AWS SageMaker

Azure Machine Learning

Containerization

Docker

Kubernetes

Production Management

Model Monitoring

Model Retraining

🚀 THE LEARNING PATH

Fundamentals
↓
Data Preprocessing
↓
Supervised Learning
↓
Unsupervised Learning
↓
Reinforcement Learning
↓
Model Evaluation & Optimization
↓
Deep Learning
↓
Advanced Topics
↓
ML Applications
↓
Model Deployment

​══════════════
📱 Connect With Us

Ⓣ Tiktok:

https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S


Ⓣ Telegram:
https://t.me/TechAIHub1⁠

ⓕ Facebook:
https://www.facebook.com/TechandAIHub⁠

💡 TECH & AI HUB

Learn • Build • Innovate
❤2
MS-Word Full Course ፡ Part 4

✅ በቲክቶክ አካውንቲችን ተለቋል። ተጠቀሙበት።

👇👇👇👇👇

https://vt.tiktok.com/ZSbU4puPV/
❤1
How to Find the Right Career?
Tech & AI Hub | የቴክ እና AI ማዕከል
Photo
ጠቃሚ የGmail ሚስጥሮች

1. Confidential email
Gmail ስትልኩ የምትልኩላቸው ሰዎች ኢሜሉን copy, forward ወይም screenshot እንዳያደርጉት ከፈለጋቸው confidential mode on አድርጋቸሁ መላክ ትችላላችሁ።
ይህን ለማድረግ compose የሚለውን ነክታችሁ ኢሜሉን ከፃፋችሁ በኋላ 3 ነጥቡን ነክታችሁ confidential mode የሚለውን ትመርጣላችሁ።
ከዛ expire የሚያደርግበትን የጊዜ ገደብና የpasscode አማራጭ መርጣችሁ save አድርጋችሁ ትልኩላቸዋላችሁ።

2. Lebel
ሙሉ ሚሴጁን ፊትለፊት ከምትደረድሩት በጣም አስፈላጊ የሆኑትን ለይታችሁ label ማድረግ ትችላላችሁ።
ይህን ለማድረግ 3 ሰረዙን ነክታችሁ create label የሚለውን በመምረጥ label create ታደርጋላችሁ። ከዛ ዋናው የGmail list ውስጥ ገብታችሁ label ማድረግ የምትፈልጉትን message ትመርጡና 3 ነጥቡን ነክታችሁ  label as ብላችሁ የምትፈልጉት label ውስጥ ማስገባት ትችላላችሁ።

3. Keywords
Search bar ላይ specific የሆኑ የተለያዩ ኪ-ዎርዶችን በማስገባት ሙሉ message filter ማድረግ ትችላላችሁ።
ለምሳሌ "has:attachment" ብላችሁ search ብታደርጉ የተለያዩ የፋይል attachment ያላቸውን ኢሜሎች filter ያደርግላችኋል።

ሌሎች ተጨማሪ keywords
⚫ from:client@example.com = Emails from a sender
⚫ to:client@example.com = Emails you sent to someone
⚫ subject:proposal = Emails with a word in the subject
⚫ has:attachment = Emails with attachments
⚫ filename:pdf = Emails with PDF attachments
⚫ larger:10M = Emails larger than 10 MB
⚫ older_than:1y = Emails older than a year
⚫ after:2026/09/01 before:2026/10/01 = Emails within this date range
⚫ is:unread = Unread emails
⚫ is:starred = Starred emails
⚫ in:snoozed = Snoozed emails

©️

📱 Connect With Us

Ⓣ Tiktok:

https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S


Ⓣ Telegram:
https://t.me/TechAIHub1⁠

ⓕ Facebook:
https://www.facebook.com/TechandAIHub⁠

💡 TECH & AI HUB

Learn • Build • Innovate
Grade 5 & 6 ICT Short PPT (2018 E.C).pdf
29 MB
✅ Grade 5 and 6 ICT short PPT (Basic Computer Skills)


✅ Slide: 238 Slides
✅ MB Size: 29MB
✅ Format: PPT to PDF

✍️Prepared by: Reshad Muzemil
Grade 3 and 4 ICT (2018 E.C).pdf
1 MB
For Grade 3 and 4
Basic Computer Skills (IT)

📚 117 Pages
📚 15 Units (4 Lessons in each Unit)
♦️ Prepared by: Reshad Muzemil

✅ All Units Contain:
♦️ Interesting Short note
♦️ Real-world examples
♦️ Brainstorming Questions
♦️ Glossary
♦️ Summary
Grade 1 and 2 ICT Textbook-signed.pdf
1.9 MB
For Grade 1 and 2
Basic Computer Skills (IT)

📚 103 Pages
📚 14 Units (4 Lessons in each Unit)
♦️ Prepared by: Reshad Muzemil

✅ All Units Contain:
♦️ Interesting Short note
♦️ Real-world examples
♦️ Brainstorming Questions
♦️ Glossary
♦️ Summary


​══════════════
📱 Connect With Us

Ⓣ Tiktok:

https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S


Ⓣ Telegram:
https://t.me/TechAIHub1⁠

ⓕ Facebook:
https://www.facebook.com/TechandAIHub⁠

💡 TECH & AI HUB

Learn • Build • Innovate
❤2
chatGPTን የሆነ ነገር መጠየቅ ፈልጋችሁ ነገር ግን ትክክለኛ prompt ማስገባት ከከበዳችሁ በዚ መሰረት ብታስተካክሉት ራሱ አስተካክሎ ትክክለኛ መልስ ይሰጣችኋል።

chatGPT ክፈቱና 2 ሰረዙን ነክታችሁ የProfile ምልክታችሁን ነክታችሁ ግቡ። ከዛ personalization የሚለውን ምረጡ። መጨረሻ ላይ ታች improved version የሚል ቦታ ታገኛላችሁ ይህንን ወይም ሌላ የተመቻችሁን ትዕዛዝ አስገቡ።
Before answering any question I ask, please correct my grammar and improve my prompt to make it clearer, more natural, and well-structured...
የ✔️ ምልክት ነክታችሁ ከወጣችሁ በኋላ ማንኛውም ጥያቄ በምትጠይቁበት ጊዜ መጀመርያ promptን ካስተካከለ በኋላ መልስ ይሰጣችኋል።
🔥🔥🔥🔥🔥🔥🔥🔥

©️ bighabesha
MS-Word Skills Full Video Course ፡ Part 5

✅ በቲክቶክ አካውንቲችን ተለቋል። ተጠቀሙበት።

👇👇👇👇👇

https://vt.tiktok.com/ZSb4M8sY9/