Hi-Tech Computer Institute “Umreth”

22/04/2026

21/12/2025

Microsoft Excel Lookup Function to Boost Productivity!
🔹Vlookup
🔹Hlookup
🔹Index
🔹Match
🔹Xlookup

16/12/2025

🔹 Ctrl + Shift + L – Turn Filters ON/OFF instantly 🔽🔼
🔹 Ctrl + T – Convert data range into an Excel Table
🔹 Ctrl + D – Fill down from the cell above
🔹 Ctrl + R – Fill right from the cell on the left
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + Shift + $ – Apply Currency format
🔹 Ctrl + Shift + % – Apply Percentage format
🔹 Ctrl + Shift + # – Apply Date format
🔹 Ctrl + Shift + @ – Apply Time format
🔹 Ctrl + Shift + ^ – Apply Scientific format
🔹 Ctrl + Shift + _ – Remove outline border
🔹 Ctrl + Shift + & – Add outline border
🔹 Ctrl + 9 – Hide selected rows
🔹 Ctrl + Shift + 9 – Unhide hidden rows
🔹 Ctrl + 0 – Hide selected columns
🔹 Ctrl + Shift + 0 – Unhide hidden columns
🔹 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 entire data region
🔹 Alt + A + E – Text to Columns wizard
🔹 Alt + A + M – Remove duplicates
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + H + B + A – Apply all borders
🔹 Alt + W + F + F – Freeze panes
🔹 Alt + = – Insert AutoSum
🔹 F2 – Edit active cell
🔹 F4 – Repeat last action / toggle $ references

16/12/2025

Basic outlook shortcuts

14/12/2025

Excel Shortcuts

14/12/2025

Useful shortcuts‼️

13/12/2025

Basic excel shortcuts