Kulti Institute Of Commerce

18/12/2025

Windows Keyboard Shortcuts 💥💯🚀
Most USEFUL windows Keys 👇🏻

17/12/2025

15/12/2025

VLOOKUP Mastery

15/12/2025

Understanding IP Address Classes 🌐

When working with IP addresses, it's crucial to know the different classes for better network management.

Here's a quick guide:

Class A
✔️ Range: 0 – 127
✔️ Private Range: 10.0.0.0 to 10.255.255.255
✔️ Ideal for large networks

Class B
✔️ Range: 128 – 191
✔️ Private Range: 172.16.0.0 to 172.31.255.255
✔️ Perfect for medium-sized networks

Class C
✔️ Range: 192 – 223
✔️ Private Range: 192.168.0.0 to 192.168.255.255
✔️ Common for small networks

Class D
✔️ Range: 224 – 239
✔️ Reserved for multicast groups

Class E
✔️ Range: 240 – 255
✔️ Reserved for research and development

Private IP Ranges are used for local networks, ensuring security and reducing the need for public IP addresses.

Tip: Understand your network’s needs and choose the appropriate IP class for better performance and management!

15/12/2025

Quiz Day 3
Short cut key of Pivot Table?

05/12/2025

🔹 Alt + H + B + A – Apply All Borders to the selection 🔳
🔹 Alt + H + B + N – Remove all borders
🔹 Alt + H + B + T – Apply Top Border
🔹 Alt + H + B + M – Apply Thick Outside Border
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + O + A – Auto-fit row height
🔹 Alt + H + M + C – Merge & Center
🔹 Alt + A + E – Text to Columns
🔹 Alt + A + M – Remove duplicates
🔹 Alt + W + F + F – Freeze/Unfreeze panes
🔹 Alt + = – Auto-insert SUM
🔹 Alt + Enter – New line inside a cell
🔹 Ctrl + T – Convert range to Excel Table
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Shift + L – Toggle filters
🔹 Ctrl + Shift + $ – Apply Currency format
🔹 Ctrl + Shift + % – Percentage format
🔹 Ctrl + Shift + # – Date format
🔹 Ctrl + Shift + @ – Time format
🔹 Ctrl + Shift + ^ – Scientific format
🔹 Ctrl + C – Copy
🔹 Ctrl + X – Cut
🔹 Ctrl + V – Paste
🔹 Ctrl + Space – Select column
🔹 Shift + Space – Select row
🔹 F2 – Edit active cell

---

✨ Quick Tip:
Use Alt + H + B + A to instantly apply borders to your entire dataset — perfect for neat reports and clean tables!

---

05/12/2025

Windows 🪟 Shortcut Keys That You Need To Know For Daily Use! 😍💯

05/12/2025

Level up your SQL skills with this handy cheat sheet! 📊

Whether you're just starting out or you're looking to brush up, this guide covers everything from SELECT and INSERT to JOIN and Window Functions. Perfect for quick reference while coding!

05/12/2025

Quiz Day 2
Short Cut Key Of Data Validation in Excel is _______

03/12/2025

নিচে Adobe Photoshop-এর 100টি
সবচেয়ে দরকারি শর্টকাট বাংলা + ইংরেজি
দুটোই সংযুক্ত করে এ দেওয়া হলো

📌 Photoshop 100 Keyboard Shortcuts (Bangla + English)
Ctrl + N — নতুন ডকুমেন্ট তৈরি
Ctrl + O — ছবি/ফাইল ওপেন
Ctrl + S — সংরক্ষণ / Save
Ctrl + Shift + S — Save As / নতুন নামে সেভ
Ctrl + P — প্রিন্ট
Ctrl + W — ট্যাব/ফাইল বন্ধ
Ctrl + Q — Photoshop বন্ধ
Ctrl + Z — Undo / ফিরে যাওয়া
Ctrl + Alt + Z — Multiple Undo / একের পর এক ফিরে যাওয়া
Ctrl + Shift + Z — Redo / আবার এগিয়ে যাওয়া

Ctrl + A — Select All / সব নির্বাচন
Ctrl + D — Deselect / নির্বাচন বাতিল
Ctrl + Shift + I — Inverse Select / উল্টো নির্বাচন
Ctrl + C — Copy / কপি
Ctrl + X — Cut / কেটে নেওয়া
Ctrl + V — Paste / পেস্ট
Ctrl + Shift + V — Paste in Place / একই জায়গায় পেস্ট
Ctrl + T — Free Transform / বড় ছোট ও ঘোরানো
Ctrl + Alt + T — Transform Copy
Ctrl + Shift + T — Repeat Transform

Ctrl + J — New Layer via Copy / কপি করে নতুন লেয়ার
Ctrl + Shift + J — New Layer via Cut
Ctrl + Shift + N — New Layer / নতুন লেয়ার
Ctrl + G — Group Layer / গ্রুপ করা
Ctrl + Shift + G — Ungroup Layer / গ্রুপ খোলা
Ctrl + E — Merge Layers / লেয়ার এক করা
Ctrl + Shift + E — Merge Visible / দৃশ্যমান লেয়ার এক
Ctrl + L — Levels / রঙ ঠিক করা
Ctrl + M — Curves
Ctrl + U — Hue & Saturation / রঙ নিয়ন্ত্রণ

Ctrl + B — Color Balance
Ctrl + I — Invert / রঙ উল্টো করা
Ctrl + Shift + U — Desaturate / সাদা-কালো করা
Ctrl + K — Preferences সেটিংস
Ctrl + F — Apply Last Filter
Ctrl + Alt + F — Filter Settings ওপেন
Ctrl + Shift + Alt + E — Stamp Visible Layer
Ctrl + Alt + Shift + K — Keyboard Shortcut উইন্ডো
Ctrl + R — Ruler Show/Hide
Ctrl + ; — Guides Show/Hide

Ctrl + ’ — Grid Show/Hide
Ctrl + Alt + A — Select All Layers
Ctrl + + — Zoom In
Ctrl + - — Zoom Out
Ctrl + 0 — Fit to Screen
Ctrl + 1 — 100% View
Spacebar — Hand Tool / স্ক্রিন নড়ানো
Alt + Scroll — Zoom In/Out
Tab — সব প্যানেল লুকানো/দেখানো
F — Screen Mode পরিবর্তন

B — Brush Tool
E — Eraser Tool
P — Pen Tool
M — Marquee Tool
L — Lasso Tool
W — Magic Wand / Quick Selection
C — Crop Tool
T — Text Tool
V — Move Tool
G — Gradient / Paint Bucket

R — Blur / Sharpen / Smudge Tool
S — Clone Stamp Tool
J — Spot Healing / Remove
O — Dodge & Burn (Light / Dark)
I — Eyedropper Tool
H — Hand Tool
Z — Zoom Tool
Shift + F5 — Fill
Ctrl + Shift + Alt + S — Save for Web
Ctrl + Shift + Alt + W — Export As

Shift + Ctrl + C — Copy Merged
Alt + Backspace — Foreground Color Fill
Ctrl + Backspace — Background Color Fill
Shift + Backspace — Fill Options
[ or ] — Brush Size কম/বেশি
Shift + [ or ] — Brush Hardness কম/বেশি
X — রঙ অদল-বদল (Foreground/Background)
D — Default Black & White Color Reset
Ctrl + 2 — RGB Channel View
Ctrl + 3 / 4 / 5 — Red / Green / Blue Channel

Alt + Click Layer — Solo Layer / শুধু ওই লেয়ার দেখা
Shift + Click Layer — Multiple Layer Select
Alt + Drag Layer — Duplicate Layer
Ctrl + Drag Layer — Move Without Snap
Ctrl + Shift + Drag — Move snap On
Alt + Delete Mask — Mask Fill
Shift + Click Mask — Mask Disable/Enable
Backspace — Delete Selection
Shift + Ctrl + N — New Layer Popup
Alt + Ctrl + I — Image Size

Alt + Ctrl + C — Canvas Size
Ctrl + Alt + Shift + S — Legacy Save for Web
Ctrl + Alt + Shift + P — Print One Copy
Alt + Scroll (Layer Panel) — Layer Fast Scroll
Shift + Drag — Straight Line Draw
Shift + Hold Brush — Straight Brush Stroke
Ctrl + Enter — Complete Text / Text Apply
Ctrl + Shift + L — Auto Contrast
Ctrl + Alt + Shift + L — Auto Color
Alt + Ctrl + Shift + B — Black & White Adjustment

03/12/2025

Roadmap for data analytics in Excel