Excel is a spreadsheet application by Microsoft used to store, organise, calculate and visualise data in a grid of rows and columns. This excel tutorial for beginners covers the interface, data entry, essential formulas like SUM and IF, and table formatting — everything you need to reach functional competence in one focused 60-minute session.
Microsoft Excel lets you handle budgeting, grade tracking, sales reporting, payroll, inventory and data analysis without any coding knowledge. If you are starting this excel tutorial for beginners with zero prior experience, you can learn the core mechanics in a single focused session of about 60 minutes.
Key Takeaways
- Excel organises data in cells identified by a column letter and row number, like A1 or B3.
- Every formula starts with an equals sign (=), for example =SUM(A1:A10).
- The Ribbon, Name Box, formula bar and worksheet tabs are the four interface elements you will use every session.
- Excel is not a coding language, but it does support VBA scripting and a newer function called LAMBDA for advanced users.
- Most beginners reach functional competence — enough to use formulas and format tables — in under two hours of practice.
What Excel Is Used For
Excel sits inside the Microsoft 365 suite and is one of the most widely installed pieces of software in the world. Microsoft reported in 2023 that over 1.2 billion people use Microsoft Office globally, and Excel is consistently among the top three most-used apps in that suite. That number matters because it tells you why employers list Excel as a baseline skill in job descriptions across almost every sector.
In India specifically, the demand is very real. NASSCOM’s 2023 Future of Work report noted that data literacy, including spreadsheet skills, ranks among the top five competencies Indian employers want from fresh graduates. If you are thinking about a career in data, check our guide on data analyst kaise bane after you finish this excel tutorial for beginners.
Common Job Uses of Excel
Accountants use Excel to build profit-and-loss statements. HR teams track attendance, leaves and payroll calculations. Marketing teams measure campaign spend against conversions. Data analysts clean raw data, build pivot tables and hand off summaries to stakeholders. Even a small kirana store owner in Pune can use a basic Excel spreadsheet tutorial to track daily sales, monthly GST reconciliation and expenses.
The table below shows which industries use Excel most and what they typically do with it.
| Industry | Primary Excel Use | Common Functions Used |
|---|---|---|
| Banking and Finance | Loan calculations, financial modelling | PMT, NPV, VLOOKUP, IF |
| E-commerce and Retail | Inventory tracking, sales dashboards | SUMIF, COUNTIF, Pivot Tables |
| Healthcare | Patient data, billing records | AVERAGE, MAX, MIN, Conditional Formatting |
| Education | Grade sheets, fee tracking | SUM, AVERAGE, RANK |
| IT and Cybersecurity | Log analysis, incident tracking dashboards | FILTER, SORT, COUNTIF, Pivot Tables |
| Marketing and Advertising | Campaign budgets, ROI tracking | IF, SUMPRODUCT, Charts |
Excel skills also transfer directly into cybersecurity and SOC analyst roles, where professionals build dashboards to monitor network events, filter log data and flag anomalies. It is a skill that travels across domains, not just finance. You can see how Excel fits into broader highest paying tech skills if you want a bigger picture of where to invest your learning time.
Parts of an Excel Spreadsheet
Before you type a single number in this ms excel tutorial, you need to know what you are looking at. Excel’s interface has a handful of fixed elements that appear every time you open the app, and understanding them removes 90% of beginner confusion.
The Workbook and Worksheets
A workbook is the file itself — the .xlsx file you save to your computer or OneDrive. Inside every workbook you will find one or more worksheets, which are the individual grid tabs at the bottom of the screen. By default Excel gives you one sheet named “Sheet1”, but you can add more by clicking the plus icon next to the tab.
Think of a workbook like a physical notebook and each worksheet like a page inside it. A monthly budget workbook might have separate sheets for January, February and March.
Cells, Rows and Columns
The grid is made up of cells, which are the individual boxes where you enter data. Each cell has an address: the column letter followed by the row number. Cell A1 is the top-left corner. Cell C5 is in column C, row 5. When people say “excel box”, they are usually referring to a cell reference.
Columns run vertically and are labelled A, B, C through to XFD. Modern Excel supports 1,048,576 rows and 16,384 columns. You will never need most of them, but it is useful to know the grid is enormous.
The Ribbon
The Ribbon is the toolbar at the top of the screen, organised into tabs: Home, Insert, Page Layout, Formulas, Data, Review and View. The Home tab is where you will spend most of your time as a beginner. It holds formatting options like bold, font size, cell colour and alignment.
The Name Box and Formula Bar
Just above the grid on the left, you will see a small white box that shows the address of your currently selected cell. That is the Name Box. You can type a cell address directly into the Name Box and press Enter to jump straight to it, which saves a lot of scrolling in large sheets.
To the right of the Name Box is the formula bar. Whatever you type into a cell appears here too. If a cell shows a number but was calculated by a formula, the formula bar is where you will see the actual formula. This is one of the most important things to check when you inherit someone else’s spreadsheet and cannot figure out where a number came from.
How to Start MS Excel
On Windows, click Start, type “Excel” and press Enter. On a Mac, open Finder, go to Applications and double-click Microsoft Excel. If you do not have a licence, you can use Excel Online for free at office.com with a Microsoft account. Google Sheets is another free browser-based alternative with a very similar interface, and most formulas work the same way.
Once Excel opens, click “Blank Workbook” to start fresh. That is it. You are in.
Entering Data and Your First Formulas
Click any cell and start typing. Press Enter to confirm and move down one row, or press Tab to confirm and move one column to the right. To edit a cell you have already filled, double-click it or press F2. This is the core mechanic every excel tutorial for beginners starts with.
How to Write in Excel: Data Types
Excel recognises three basic data types. Text (labels like “Name” or “City”) aligns to the left by default. Numbers align to the right. Dates are stored as numbers internally but display as dates, so you can do date arithmetic like calculating how many days remain between two deadlines.
A common beginner mistake is typing a number with a unit attached, like “500 kg”. Excel reads that as text, not a number, so you cannot add it up. Keep units in a separate column header and store only the numeric value in the data cell.
Writing Your First Formula
Every formula in Excel starts with an equals sign. Without it, Excel treats your entry as plain text. Here are the four beginner Excel formulas you will use in your very first session:
- =SUM(A1:A10) adds up all values from A1 to A10. The colon means “from A1 through A10”.
- =AVERAGE(B2:B8) calculates the mean of the values in that range.
- =MAX(C1:C20) returns the largest number in the range.
- =IF(D2>50,”Pass”,”Fail”) checks a condition and returns one of two results. This is your first taste of logic in Excel.
To try SUM right now: type numbers in cells A1 through A5, click on A6, type =SUM(A1:A5) and press Enter. Excel shows the total instantly.
Is Excel a Coding Language?
Excel is not a coding language in the traditional sense. It is a spreadsheet application that uses a formula language for calculations. That formula language is powerful, and you can build complex logic with nested IF statements and array formulas, but it is not the same as Python, Java or SQL.
Excel does include VBA (Visual Basic for Applications), which is a real programming language you can use to automate repetitive tasks with macros. Microsoft also introduced LAMBDA, which lets you define your own reusable functions. These are advanced features, not beginner territory. If you are curious about where Excel sits relative to actual data languages, our comparison of data analyst vs data scientist roles explains which tools each role typically uses.
Formatting Your Data as a Table
Once you have data entered, press Ctrl+T to convert your range into an official Excel Table. This gives you automatic filter dropdowns on every column header, banded row colours for readability and the ability to reference columns by name in formulas instead of cell addresses. It is one of those features that experienced Excel users apply from day one, and beginners often discover only after months of frustration.
According to LinkedIn Learning’s 2024 Workplace Learning Report, spreadsheet skills appear in job postings across more than 60 different job categories, from operations managers to marketing coordinators. Getting comfortable with tables and basic formulas puts you in a strong position for entry-level tech jobs growing this year.
Next Skills After the Basics
Once you can enter data, write a SUM or AVERAGE formula and format a table, you have covered ms excel basics. The logical next step is building on that foundation with skills that show up in real job tasks. This is where an excel tutorial for beginners transitions into intermediate territory.
VLOOKUP and XLOOKUP
These functions let you search one column for a value and pull related data from another column. Say you have a product code in column A and prices in column B. VLOOKUP lets you type any product code and retrieve its price automatically. XLOOKUP is the newer, more flexible version that works in both directions and handles errors more gracefully. Indian e-commerce teams use XLOOKUP constantly to reconcile SKU lists against supplier price sheets.
Pivot Tables
A pivot table summarises thousands of rows of data into a compact report in seconds, with no formulas required. You drag fields into rows, columns and values, and Excel does the aggregation. This is genuinely one of the most-used tools in data analyst and business analyst roles across India, particularly in BFSI and e-commerce sectors.
Conditional Formatting
This feature changes a cell’s colour, font or border based on its value. You can highlight all sales figures below a target in red, or show the top 10% in green. It turns a wall of numbers into a visual summary without building a chart. EPFO payroll teams and school administrators across India use conditional formatting to flag anomalies in large datasets instantly.
For hands-on practice with real datasets after you have finished this excel tutorial for beginners, our list of data analytics projects includes beginner-friendly Excel exercises you can add to a portfolio. If you want structured learning with a certificate, browse free online courses with certificate to find Excel-adjacent options at no cost.
How Long Does It Take to Learn Excel Basics?
Most beginners can handle data entry, basic formulas (SUM, AVERAGE, IF) and table formatting in a single two-hour session. Reaching intermediate competence with VLOOKUP, pivot tables and charts typically takes two to four weeks of daily 30-minute practice. A 2022 Coursera learner outcomes study found that learners who practised with real datasets progressed roughly 40% faster than those who only watched video lessons.
The fastest path is always to work on a dataset that means something to you — your own monthly expenses, your college marks, your freelance income. Real data keeps you motivated and makes this excel tutorial for beginners stick.
Frequently Asked Questions
What is Excel used for?
Excel is used for storing, organising, calculating and visualising data. Common uses include financial modelling, budgeting, payroll, inventory tracking, grade sheets and data analysis. It is one of the most widely required tools across job roles in India and globally, appearing in everything from banking to healthcare to cybersecurity operations.
How do I start MS Excel?
On Windows, click Start, type “Excel” and press Enter. On a Mac, go to Applications and open Microsoft Excel. If you do not have a paid licence, use Excel Online for free at office.com with a Microsoft account. Once open, click “Blank Workbook” to start a fresh spreadsheet.
What are the parts of an Excel spreadsheet?
The main parts of an Excel spreadsheet are the Ribbon (toolbar with tabs), the Name Box (shows the current cell address), the formula bar (shows cell content or formula), the worksheet grid (rows and columns of cells) and the sheet tabs at the bottom. Together these make up the standard Excel interface you will see every time you open the app.
Is Excel a coding language?
Excel is not a programming language. It uses a formula language for calculations, which is powerful but different from languages like Python or SQL. Excel does include VBA, a real scripting language for automation, and the newer LAMBDA function for custom formulas. For most beginners, formulas are enough to get real work done.
How long does it take to learn Excel basics?
You can learn the core mechanics of Excel — entering data, using SUM and AVERAGE, and formatting a table — in one focused session of 60 to 90 minutes. Reaching a level where you can confidently use VLOOKUP, pivot tables and IF statements takes two to four weeks of consistent daily practice with real data.
What is the best way to learn Excel for free?
The best way to learn Excel for free is to combine Excel Online (free at office.com) with a real personal dataset such as your monthly expenses or college marks. Practise one new formula each day, use Microsoft’s free support documentation, and supplement with free structured courses. Working on real data accelerates learning significantly compared to watching tutorials alone.
What is VLOOKUP used for in Excel?
VLOOKUP is used to search a column for a specific value and return a related value from another column in the same row. For example, you can look up a product code and automatically retrieve its price from a separate price list. It is one of the most commonly tested Excel skills in data analyst job interviews across India.
Where to go from here: You have covered the essential parts of an excel spreadsheet, written your first formulas and understood what Excel is actually used for in jobs. Here are three actions to take this week.
- Open Excel or Excel Online right now and build a personal monthly budget sheet using SUM and IF formulas on your own real numbers.
- Explore beginner data analytics projects and pick one that uses Excel so you have a real portfolio piece.
- If you want to take your data skills into a high-demand career path, look at 3.0 University’s online certification courses in Cybersecurity, AI and Ethical Hacking. Analysts who can read data in Excel are already doing half the work of a SOC analyst: filtering logs, spotting patterns and building dashboards. The EC-Council Certified SOC Analyst course at 3.0 University is a practical next step if that direction interests you.
Last updated: October 2026. Reviewed by the 3University editorial team.