Excel Academy

21/08/2025

📘 Lesson 2: Entering & Formatting Data

Objective:
Learn how to enter text and numbers into Excel, adjust column widths, and apply basic formatting (bold, italic, colors, alignment).

Step 1 – Entering Data
- Open a new Excel sheet.
- In Column A, type 5 names (e.g., Alice, Ben, Cara, David, Emma).
- In Column B, type their test scores (any numbers you like).

Step 2 – Formatting the Data
- Make the names bold.
- Make the scores italic.
- Change the header row (Row 1) background color to light green.

Adjust the column widths so everything fits nicely.

Your Practice Exercise:
Create a small table like this:

And Format it exactly as instructed above, then save it as Lesson2.xlsx.

21/08/2025

🔎 Answer to Lesson 1: Getting Started with Excel

Great work on Lesson 1, everyone 👏

The exercise was:

👉 Open Excel, type your name in cell A1, and save the file as Lesson1.xlsx.
Here’s what we learned:
✅ How to open Excel
✅ What a cell is (the smallest unit in a worksheet)
✅ How to type in a cell
✅ How to save a workbook

This first step may seem simple, but it’s the foundation of Excel. Every powerful formula, chart, or dashboard you’ll ever make starts with knowing your way around cells and workbooks.

Well done — you’ve officially completed your first Excel task 🎉

Today, we’ll move into Lesson 2:
Entering and Formatting Data.

20/08/2025

📘 Lesson 1: What is Excel & Navigating the Interface

Objective: Understand what Excel is, open it, and identify the key parts of the interface.

What is Excel?

Excel is a spreadsheet program by Microsoft used for:
Organizing data
Performing calculations
Creating reports, charts & dashboards
Automating tasks

When you open Excel, you’ll see:

Workbook → The entire file (.xlsx)
Worksheet → Individual sheets (Sheet1, Sheet2, etc.)
Cell → The smallest box where you type data (identified by column + row, e.g., A1)
Ribbon → Toolbar with commands (Home, Insert, Formulas, etc.)
Formula Bar → Where you see/edit what’s inside a cell
Status Bar → Bottom area (sum, average, etc. show up here)

20/08/2025

20/08/2025

👋 Welcome to our Excel From Zero to Hero Community!

This space is built for anyone who wants to learn Excel step-by-step — from complete beginner to advanced level.

Here’s how it will work:
✅ Every day, we’ll post one new Excel lesson (starting from the basics).
✅ Each lesson will include:

- A clear explanation
- A practice exercise
- An image/visual guide
- An answer/solution, revealed the next day

By following along daily, you’ll build Excel knowledge layer by layer and be able to apply it at work, in business, or in studies.

💡 Tip: Don’t just read the lessons — open Excel and practice every day.

📈 By the end, you’ll master formulas, charts, pivot tables, data analysis, automation, and dashboards.

Let’s start this journey together 🚀