Madina Computer And Vocational institute Topsin Swat

Madina Computer And Vocational institute Topsin Swat Contact information, map and directions, contact form, opening hours, services, ratings, photos, videos and announcements from Madina Computer And Vocational institute Topsin Swat, Computer Company, Topsin.

17/01/2026
Excel Important Function
09/01/2026

Excel Important Function

πŸ”Ή Ctrl + 0 – Hide selected columns πŸ™ˆπŸ”Ή Ctrl + Shift + 0 – Unhide hidden columnsπŸ”Ή Ctrl + 9 – Hide selected rowsπŸ”Ή Ctrl + Sh...
28/12/2025

πŸ”Ή Ctrl + 0 – Hide selected columns πŸ™ˆ
πŸ”Ή Ctrl + Shift + 0 – Unhide hidden columns
πŸ”Ή Ctrl + 9 – Hide selected rows
πŸ”Ή Ctrl + Shift + 9 – Unhide hidden rows
πŸ”Ή Ctrl + A – Select entire worksheet
πŸ”Ή Ctrl + Space – Select entire column
πŸ”Ή Shift + Space – Select entire row
πŸ”Ή Ctrl + C – Copy
πŸ”Ή Ctrl + X – Cut
πŸ”Ή Ctrl + V – Paste
πŸ”Ή Ctrl + Z – Undo last action
πŸ”Ή Ctrl + Y – Redo last undone action
πŸ”Ή Ctrl + D – Fill down
πŸ”Ή Ctrl + R – Fill right
πŸ”Ή Ctrl + T – Convert range to Excel Table
πŸ”Ή Ctrl + F – Find
πŸ”Ή Ctrl + H – Replace
πŸ”Ή Ctrl + ; – Insert today’s date
πŸ”Ή Ctrl + Shift + : – Insert current time
πŸ”Ή Ctrl + 1 – Open Format Cells dialog
πŸ”Ή Ctrl + Shift + L – Toggle Filters ON/OFF
πŸ”Ή Ctrl + Page Up – Move to previous worksheet
πŸ”Ή Ctrl + Page Down – Move to next worksheet
πŸ”Ή Ctrl + Arrow Keys – Jump to data edges
πŸ”Ή Ctrl + Shift + Arrow Keys – Select data block
πŸ”Ή Alt + = – Auto-insert SUM
πŸ”Ή Alt + Enter – New line inside a cell
πŸ”Ή Alt + H + O + I – Auto-fit column width
πŸ”Ή F2 – Edit active cell
πŸ”Ή Shift + F11 – Insert new worksheet
✨ Quick Tip:
Use Ctrl + 0 to quickly hide unnecessary columns and keep your reports clean and focused!

What will be The Result
28/12/2025

What will be The Result

Linux Tools
13/12/2025

Linux Tools

04/12/2025

Admission Open

Office communication tools
03/12/2025

Office communication tools

🌐 HTTP vs HTTPS πŸ”’HTTP = Data without protection ⚠️HTTPS = Secure with encryption πŸ›‘οΈSafety πŸ†š Speed - What do you prefer? ...
22/11/2025

🌐 HTTP vs HTTPS πŸ”’
HTTP = Data without protection ⚠️
HTTPS = Secure with encryption πŸ›‘οΈ
Safety πŸ†š Speed - What do you prefer? πŸ€”πŸ’¬

VLAN Configuration & Trunking β€” How Two Switches Communicate in a Real Network! Ever wondered how large networks separat...
22/11/2025

VLAN Configuration & Trunking β€” How Two Switches Communicate in a Real Network!

Ever wondered how large networks separate departments, isolate traffic, and still allow communication between switches?
This is where VLANs and Trunk Links come in β€” two of the most important concepts in switching.

In this example, two Cisco switches exchange multiple VLANs using a trunk link, while maintaining separate broadcast domains for HR, Admin, and IT.

πŸ”Ή What This Lab Demonstrates

βœ… Creating VLANs on each switch
βœ… Assigning access ports to specific VLANs
βœ… Setting VLAN 50 as the native VLAN
βœ… Allowing only shared VLANs (40 & 50) across the trunk
βœ… Ensuring both switches maintain proper segmentation and communication

πŸ”Ή Why This Matters

VLANs are essential for:
β€’ Network segmentation
β€’ Security isolation
β€’ Reducing broadcast domains
β€’ Scaling enterprise networks
β€’ Enabling multi-VLAN communication over a single link

Trunking ensures that switches can exchange VLAN information while keeping traffic separated and secure.

πŸ‘‰ If you're preparing for CCNA/CCNP, working in enterprise networks, or learning switching fundamentals, this is one of the most practical configurations you’ll use daily.

What other switching topics should we break down next?

22/11/2025

Shortcut

Address

Topsin

Alerts

Be the first to know and let us send you an email when Madina Computer And Vocational institute Topsin Swat posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share