E-tech Academy

Freeze Panes in Excel When working with large spreadsheets, scrolling up and down (or left and right) can make you lose track of headers or important information. That’s where Freeze Panes comes in. It’s like pinning certain rows or columns so they always stay visible , no matter how much you scroll. Where to Find Freeze Panes Go to the View tab on the Ribbon . Look for the Freeze Panes option in the Window group. Options in Freeze Panes Excel gives you three main options: 1️⃣ Freeze Panes Freezes both rows and columns above and to the left of the selected cell . Example: If you click cell C5 and choose Freeze Panes , rows 1–4 and columns A–B stay locked while you scroll. 2️⃣ Freeze Top Row Keeps only the first row visible as you scroll down. Handy for spreadsheets with column headers. 3️⃣ Freeze First Column Keeps only the first column visible as you scroll sideways. Useful when row labels are in the first column. Example Use Cas...

PowerPoint vs Google Slides: Which One Should You Use? When it comes to creating presentations, two names always come up: Microsoft PowerPoint and Google Slides . Both are powerful tools, both can make your ideas shine, and both are used by millions of people around the world. But here’s the big question: Which one is better for you? The answer depends on what you need. Let’s compare PowerPoint and Google Slides in a way that makes sense for students, professionals, and everyday users. A Quick Look at Both PowerPoint has been around since the 1980s. It’s the classic tool for creating professional presentations. It comes as part of the Microsoft Office suite and is packed with features, animations, and advanced design tools. Google Slides is the newer competitor. It’s web-based, free, and built for collaboration. Since it’s cloud-powered, you don’t need to worry about saving files or losing work. Both do the same core job—helping you build presentations—but they go a...

Creating WhatsApp Links with Microsoft Excel WhatsApp has become one of the easiest ways to connect with friends, clients, or business contacts. But did you know you can generate WhatsApp chat links directly from Microsoft Excel ? This simple trick saves time when you have a list of phone numbers and want to quickly create ready-to-use links. 🔹 What is a WhatsApp Link? A WhatsApp link lets someone start a chat with you without saving your number. The format is: https://wa.me/<PhoneNumber> For example: https://wa.me/2348132627521 When clicked, it opens WhatsApp and starts a conversation. 🔹 Why Use Excel? If you have many contacts (say, for a business campaign or class reminders), typing links one by one is time-consuming. With Excel, you can create all links automatically in seconds. 🔹 Step-by-Step Guide Open Excel and enter your phone numbers in Column A (without spaces or special characters). Example: A1 → 2348132627521 A2 → 2347012345678 In Column B...