Microsoft Excel Masterclass: A Complete Guide to Starting from Scratch (With Pictures)
Written by : Daily Tech News
Website: Tech News 24
Assalamu Alaikum. Welcome to the tech world. If you are a student, a job seeker or want to keep track of your business, one computer skill can make your life a lot easier. And that is Microsoft Excel . Many people are afraid of Excel just by hearing its name, thinking that it is only the work of mathematicians. But believe me, if you know some basic things, Excel will become your best friend.
In today's post, we will discuss all the essential topics of Excel, starting from scratch.
Tabel of content
Chapter 1: What is Microsoft Excel and why should you learn it?
Chapter 2: Introduction to the Excel interface (the inside world)
Chapter 3: Data entry and basic calculations (first steps)
Chapter 4: Auto-Fill and Quick Tips
Chapter 5: Data filters and page setup (pro tips)
Chapter 1: What is Microsoft Excel and why should you learn it?
Simply put, Microsoft Excel is a spreadsheet program. It is a digital ledger with thousands of cells where you can store information, perform complex calculations in seconds, and present that information in beautiful graphs or charts.
 |
| Excel is the digital accountant of the modern era. |
Why is learning Excel essential for you?
1. Essential in the job market: Excel is a must-have for all positions, from data entry to management.
2. Personal Account: You can easily keep track of your monthly expenses, DPS or loans.
3. Data Management: Information on thousands of customers or students can be organized.
Chapter 2: Introduction to the Excel interface (the inner world)
It's important to recognize the main parts of the screen you see after opening Excel. This is called the Workbook .
 |
| Main parts of the Excel interface. |
1. Row: These are arranged horizontally from left to right. They are marked with numbers 1, 2, 3...
2. Column: These are vertical from top to bottom. They are identified by the letters A, B, C...
3. Cell: The point where a row and a column meet is called a cell. Each cell has a name. For example: The point where column A and row number 5 meet is cell A5 .
4. Formula Bar: This is at the top of the page. When you write something in a cell, it will also be visible here. Especially if you write a formula, it will be clearly visible here.
Chapter 3: Data Entry and General Accounting (Step 1)
Entering data in Excel is very easy. Just click on any cell and start typing. Use the Arrow Keys or Tab button on your keyboard to move from one cell to another.
The Power = :
Before writing any mathematical calculation or formula in Excel, you must enter the = (equal) sign. Otherwise, Excel will treat it as normal text.
 |
| You must put the = sign before writing the formula . |
Finding a simple
Let's say you have 10 in cell A1 and 20 in cell A2. You want their sum in cell A3.
Chapter 4: Auto-Fill and Quick Tips
One of the best features of Excel is Auto-Fill . It will save you a lot of time.
 |
| Quickly generate serial numbers using the auto-fill feature. |
How to do it?
1. Enter 1 in the first cell and 2 in the second cell.
2. Select two cells.
3. If you hover your mouse over the lower right corner, a black + sign will appear.
4. Now hold down the mouse and drag it downwards. You will see the numbers 3, 4, 5... automatically appear. This also works for times, months or dates.
Chapter 5: Data Filters and Page Setup (Pro Tips)
If you have information about 100 people and you only want to see people from Dhaka city, then use Filter .
 |
| Find specific information using data filters. |
How to filter?
- Select the headlines for your table.
- Click Data > Filter at the top . Small arrows will appear next to the headlines.
- You can select specific information by clicking there.
Page setup and print:
Pages often get cut off when printing in Excel. To avoid this:
- Go to View > Page Break Preview . Here, you will see a blue dot that shows how much will print on one page. You can make this blue dot larger or smaller by dragging it with your mouse.
Keyboard Shortcuts List (Begineer Special)
Memorize these shortcuts to speed up your work:
- Ctrl + S: Save file (press this every 5 minutes).
- Ctrl + Z: Go back one step if you make a mistake.
- Ctrl + C / V: Copy and paste.
- Ctrl + Arrow Keys: Quickly move to a distant cell in Excel.
- Alt + =: Insert an automatic addition formula (Auto-Sum).
Keyboard Shortcuts List (Begineer Special)
Now it's your turn!
It is not possible to learn this vast world of Microsoft Excel in a day. However, with what we have learned in today's post, you can easily start doing small calculations and data entry. In this age of technology, knowing Excel is a huge asset for you.
 |
| You can become an Excel expert with regular practice. |
If you have any problem with any specific formula (e.g. VLOOKUP or IF) or task in Excel, please let us know in the comments. Daily Tech News always tries to increase your technical knowledge. Stay well, stay updated with technology.
Thank you ,
Team Daily Tech News
URL: Daily Tech News
URL: Tech News 24
© 2026 - Your Reliable Tech Partner
Post a Comment