Learning how to use Microsoft Excel can feel overwhelming at first, but once you understand the basics, it becomes one of the most powerful tools for organising data, doing calculations, and improving productivity. Whether you’re a student, entrepreneur, or job seeker, Excel is a skill worth mastering.
This step-by-step guide will walk you through the essentials in a simple and practical way.
1. Understanding What Excel Is
Excel is a spreadsheet program used to store, organize, and analyse data. It works like a digital worksheet made up of:
- Rows (horizontal lines)
- Columns (vertical lines)
- Cells (individual boxes where data is entered)
Each cell can hold numbers, text, or formulas.
2. Opening Excel and Creating a Workbook
When you open Excel, you start with a Workbook, which is simply an Excel file.
Steps:
- Open Excel
- Click “Blank Workbook”
- Save your file immediately to avoid losing work
Tip: Use clear file names like “Budget2026” or “SchoolMarksQ1”.
3. Entering Data into Cells
Click on any cell and start typing.
Examples:
- A1: Name
- B1: Surname
- C1: Age
Press Enter to move down or Tab to move across.
Good practice:
- Keep headings in the first row
- Use consistent formatting
4. Basic Formatting (Making It Readable)
To make your spreadsheet easier to read:
- Bold headings (Ctrl + B)
- Adjust column width by dragging edges
- Add borders around tables
- Change text alignment (left, centre, right)
Clean formatting makes your data look professional and organised.
5. Using Simple Formulas
Formulas are where Excel becomes powerful.
All formulas start with =.
Common beginner formulas:
Addition
= A1 + A2
Subtraction
= A1 - A2
Multiplication
= A1 * A2
Division
= A1 / A2
6. Using the SUM Function
Instead of adding numbers one by one, use:
=SUM(A1:A10)
This adds all values between A1 and A10 automatically.
This is one of the most important beginner functions.
7. AutoFill (Saving Time)
Excel can automatically continue patterns.
Examples:
- Numbers: 1, 2, 3…
- Days of the week
- Formulas copied across rows
How to use:
- Type a value or formula
- Drag the small square at the bottom-right corner of the cell
8. Creating Simple Tables
Tables help you organise data neatly.
Steps:
- Highlight your data
- Click “Insert”
- Select “Table”
- Tick “My table has headers”
Benefits:
- Easy sorting
- Filtering data
- Better readability
9. Sorting and Filtering Data
You can quickly organise large datasets:
Sort:
- Alphabetical order (A–Z or Z–A)
- Smallest to largest numbers
Filter:
- Show only specific data (e.g., only “Pass” students)
This is useful for reports and analysis.
10. Saving and Exporting Your Work
Always save your progress:
- Click File > Save As
- Choose a location
- Save as
.xlsx
You can also export as:
- PDF (for sharing)
- CSV (for data systems)
Conclusion
Excel is not just a spreadsheet tool, it’s a skill that improves how you work with data in almost any field. By learning the basics like entering data, using formulas, and organising tables, you’re already building a strong foundation.
Once you’re comfortable, you can move on to advanced features like charts, pivot tables, and data analysis tools.
FDM STUDIO CO. 
Leave a comment