Ounenara

Ounenara Welcome to personal vlogs 👀

Digital Tutor | Vlogs | Thoughts | Lifestyle | Microsoft Excel Hacks

Practice spoken English with me
(1)

What is HTML?
03/07/2026

What is HTML?

Create a complete children's storybook with Gemini using this one prompt. 👇👇
29/06/2026

Create a complete children's storybook with Gemini using this one prompt. 👇👇

Excel All-in-One Cheat Sheet
29/06/2026

Excel All-in-One Cheat Sheet

Html basics
29/06/2026

Html basics

Is your app acting weird on Windows? Try this quick reset trick!Press Windows + RType %appdata% and hit EnterFind the fo...
21/06/2026

Is your app acting weird on Windows? Try this quick reset trick!

Press Windows + R

Type %appdata% and hit Enter

Find the folder of the app that’s causing problems

Delete it (or rename it as a backup)

Now restart your PC

Open the app again and watch what happens!

This forces the application to create fresh settings and can fix crashes, glitches, and corrupted configurations without reinstalling the entire app.

Save this tip and follow for more powerful Windows tricks!

Important shortcut keys 🔐🔐
21/06/2026

Important shortcut keys 🔐🔐

Top 25 Excel formulas to save hours
21/06/2026

Top 25 Excel formulas to save hours

Click less, Work Faster! 🔖💯🔖
21/06/2026

Click less, Work Faster! 🔖💯🔖

Filter function in Excel
21/06/2026

Filter function in Excel

🔹 Ctrl + E → Flash Fill (Excel auto-detects patterns instantly)🔹 Alt + = → AutoSum selected data in one second🔹 Ctrl + S...
21/06/2026

🔹 Ctrl + E → Flash Fill (Excel auto-detects patterns instantly)
🔹 Alt + = → AutoSum selected data in one second
🔹 Ctrl + Shift + L → Turn filters ON/OFF instantly
🔹 Ctrl + T → Convert data into a smart Excel Table
🔹 F4 → Repeat last action/lock cell references ($)
🔹 Ctrl + Arrow Key → Jump to edge of data instantly
🔹 Ctrl + Shift + Arrow Key → Select large data range instantly
🔹 Alt + H + V + V → Paste values only
🔹 Ctrl + 1 → Open full Format Cells dialog
🔹 Ctrl + ; → Insert current date
🔹 Ctrl + Shift + : → Insert current time
🔹 Alt + W + F + F → Freeze panes instantly
🔹 Alt + N + V → Insert PivotTable
🔹 Alt + F5 → Refresh selected PivotTable
🔹 Ctrl + Alt + F5 → Refresh all PivotTables & connections
🔹 Ctrl + ` → Show or hide all formulas
🔹 Ctrl + Shift + U → Expand/collapse formula bar
🔹 Alt + Down Arrow → Open filter or dropdown list
🔹 Ctrl + Space → Select entire column
🔹 Shift + Space → Select entire row

Address

Hotel Bodhi Retreat, Ordinance Factory Road,
Rajgir
803116

Website

Alerts

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

Shortcuts

Share

Category