Microsoft Excel Tutorial for Beginners: Complete Step-by-Step Guide

Microsoft Excel is a powerful spreadsheet tool used to organize, calculate, and analyze data efficiently. It allows you to manage information, apply formulas, create charts, and automate tasks with ease. Learning MS Excel boosts productivity and supports smarter decision-making. 

It helps you clean, process, and visualize large datasets quickly, making everyday tasks more efficient and accurate. Whether for financial analysis, reporting, or tracking performance, Excel remains an essential skill in every domain.

In this Excel tutorial, you’ll read more about Excel basics, key formulas and functions, data organization, formatting, chart creation, PivotTables, and workflow tips, all explained through practical, step-by-step instructions.

Looking to build your career in one of the fastest-growing data science fields? Explore our online Data Science Course and gain the skills that employers are actively looking for all from the convenience of your home! 

Getting Started with MS Excel

Before you begin working with data, it’s important to understand how Microsoft Excel looks and functions. This section will help you open Excel, explore its interface, and learn how to navigate it confidently.

Installing and Opening Excel

You can access Excel through Microsoft Office or Microsoft 365. It’s available for both Windows and macOS.

To open Excel:

1. Click the Start menu and search for Microsoft Excel.
2. Select Blank Workbook to start fresh.
3. Explore the opening screen, it displays templates for budgets, calendars, and reports.

If you’re using Excel Online, sign in with your Microsoft account and choose New Workbook to begin.

Also Read: What Is Data Science? Courses, Basics, Frameworks & Careers

Understanding the Excel Interface

Once your workbook opens, you’ll see a grid of rows and columns. Each small box is a cell, identified by its column letter and row number (like A1 or C3).

Here’s a quick overview of what you’ll find:

Area	Description
Ribbon	The toolbar at the top with tabs like Home, Insert, and Data.
Formula Bar	Shows or edits the contents of a selected cell.
Worksheet Tabs	Located at the bottom; they let you switch between sheets.
Name Box	Displays the address of the active cell.
Status Bar	Shows useful info like the average or count of selected data.

Also Read: Ribbon in MS Excel: Features, Tips, and Customisation

Creating and Saving a Workbook

Each Excel file is called a workbook. It can contain one or more worksheets.

Steps to create and save your first workbook:

1. Click File → New → Blank Workbook.
2. Enter data in any cell.
3. Save your file using File → Save As or press Ctrl + S.
4. Choose a location and give your workbook a name.

Saving your work frequently prevents data loss and keeps your progress secure.

Navigating the Excel Sheet

You can move through cells using the arrow keys or by clicking directly on a cell.

• Press Enter to move down.
• Use Tab to move right.
• Use Ctrl + Arrow keys to jump across large data sets.

If you’re working with large spreadsheets, you can Freeze Panes (under the View tab) to keep headers visible as you scroll.

Also Read: Data Science Life Cycle: Phases, Tools and Best Practices

Customizing Your Workspace

Personalizing Excel helps you work faster.

• Add your favorite tools to the Quick Access Toolbar.
• Change the theme under File → Options → General.
• Adjust gridlines and zoom for better visibility.

These small tweaks make your workspace more comfortable and easier to navigate.

Once you’re familiar with Excel’s layout and tools, you’re ready to start entering data and applying formulas. The next steps in this Excel tutorial will guide you through these essential skills.

Basic Excel Tutorial Skills

Once you understand the layout of Excel, the next step is to start working with data. These basic skills will help you create, edit, and format your first worksheet confidently.

Entering and Editing Data

Every cell in Excel can hold text, numbers, or dates.

• Click a cell and start typing.
• Press Enter to move down or Tab to move right.
• Use Ctrl + Z to undo and Ctrl + Y to redo.
• To edit, double-click the cell or use the formula bar.

You can also use AutoFill to copy patterns. For example, type “January” and drag the fill handle to automatically complete the months.

Also Read: Data Validation in Excel

Formatting Cells

Formatting helps your worksheet look clean and easy to read.

You can adjust:

• Font and alignment for better readability.
• Number formats like currency, percentage, or date.
• Borders and fill colors to highlight important data.

Table – Common Cell Formatting Options

Formatting Type	Example	Purpose
Number	12345	Standard numerical display
Currency	₹12,345.00	Financial data presentation
Percentage	75%	Display ratios or growth
Date	11/11/2025	Manage schedules and timelines

To apply formatting, select your cells and use the Home tab options.

Organising Worksheets

A workbook can have multiple sheets. Rename each sheet based on its purpose, such as “Sales Data” or “Expenses.”

• Add a new sheet with the + icon.
• Right-click to rename or delete.
• Use Move or Copy to duplicate a sheet.

You can also Freeze Panes or Split View to keep headers visible when scrolling through large data sets.

These basic Excel tutorial skills form the foundation for your next steps, learning formulas, functions, and data organization.

Also Read: How to Become a Data Scientist – Answer in 9 Easy Steps

Working with Formulas and Functions

Formulas and functions are at the core of Microsoft Excel. They turn raw data into meaningful insights by helping you perform calculations, summarize data, and automate repetitive tasks. Once you understand how to use them, Excel becomes far more powerful and time-saving.

Formula Basics

Every formula in Excel begins with an equal (=) sign. You can add, subtract, multiply, or divide numbers or cell values directly.

Examples:

• =A1+B1 adds two cells
• =A1-B1 subtracts
• =A1*B1 multiplies
• =A1/B1 divides

Excel automatically recalculates formulas when you change the data. If you see errors like #DIV/0! or #VALUE!, it means there’s an invalid input or calculation.

Tip: Always double-check cell references and data types before applying formulas.

Also Read: 60 Advanced Excel Formulas – A Must Know For All Professionals

Common Functions for Beginners

Functions are predefined formulas that make calculations easier. They save time and reduce manual effort.

Most used Excel functions:

• =SUM(A1:A5) – Adds all numbers in a range
• =AVERAGE(A1:A5) – Calculates the mean
• =MIN(A1:A5) / =MAX(A1:A5) – Finds smallest or largest values
• =COUNT(A1:A5) – Counts numeric cells
• =IF(A1>50,"Pass","Fail") – Applies logic based on condition

Table – Common Excel Functions and Their Purpose

Function	Description	Example
SUM	Adds a range of numbers	=SUM(A1:A5)
AVERAGE	Finds average value	=AVERAGE(B1:B5)
COUNT	Counts numeric cells	=COUNT(A1:A10)
MIN/MAX	Finds smallest or largest value	=MIN(A1:A10)
IF	Tests a condition	=IF(A1>100,"Yes","No")

Also Read: Supercharge Your Analysis with Statistical Functions in Microsoft Excel!

Relative and Absolute References

When you copy formulas, Excel adjusts the cell references automatically. This is called a relative reference.

Example: Copying =A1+B1 down to the next row becomes =A2+B2.

If you want a fixed reference, use the $ symbol.
Example: =$A$1+B1 keeps A1 constant when copied.

Using AutoSum and Quick Tools

AutoSum helps you calculate totals instantly.

1. Select the cell below your data.
2. Click AutoSum (Σ) on the Home tab.
3. Press Enter to confirm.

You can also use the Quick Analysis tool to apply functions, charts, and conditional formatting in one click.

Once you’re comfortable with formulas and functions, you’ll be ready to analyze data faster and more accurately, a crucial step before moving into sorting, filtering, and data validation.

Also Read: Excel Worksheet for Practice

Data Organisation and Validation

Once you’ve learned formulas and functions, the next part of this Excel tutorial focuses on organizing your data properly. Structured data improves accuracy, analysis, and readability. In MS Excel, features like sorting, filtering, tables, and validation help you manage large datasets easily and prepare them for reports or dashboards.

Sorting and Filtering Data

Sorting arranges information in a clear order, while filtering lets you focus on what’s important.

To sort data:

1. Highlight the range or table you want to sort.
2. Go to the Data tab → select Sort A to Z (ascending) or Z to A (descending).
3. For multiple criteria, click Sort and add levels like “Region” then “Revenue.”

To filter data:

1. Select the header row.
2. Click Data → Filter.
3. Use the drop-down arrows to display or hide specific values.

Sorting and filtering are essential steps in any Excel tutorial for beginners because they make large spreadsheets more manageable.

Also Read: Top 15 Ways to Improve Excel Skills [Actionable Tips]

Using Tables in Excel

Converting your data range into a table makes it easier to format, analyze, and apply formulas.

Steps:

1. Select your data range.
2. Press Ctrl + T or go to Insert → Table.
3. Check “My table has headers.”

Tables automatically include filters, alternate row shading, and auto-updating formulas. You can also use structured references like =SUM(Table1[Sales]) to make formulas easier to read.

Table – Benefits of Using Tables in MS Excel

Feature	Benefit
Built-in filters	Quick data sorting and selection
Dynamic range	Updates automatically when rows are added
Table formatting	Clean, professional look
Structured references	Simplifies formulas and calculations

This feature is covered in every MS Excel tutorial because it simplifies day-to-day data management.

Data Validation and Drop-Down Lists

Data validation ensures that only correct and consistent information is entered.

To set up validation:

1. Select the target cells.
2. Go to Data → Data Validation.
3. Choose rule type — Whole Number, Decimal, or List.

You can create a drop-down list by selecting List and typing values (e.g., Yes, No, Pending).

Example: In a company tracker, you can create a Department list: Sales, HR, Marketing, Finance.

Data validation prevents input errors and is an essential step in a well-organized Excel tutorial workflow.

Also Read: Top 50 Excel Interview Questions in 2025

Conditional Formatting

Conditional formatting makes patterns and trends stand out instantly.

Steps:

1. Select the data range.
2. Go to Home → Conditional Formatting.
3. Apply rules like Greater Than, Duplicate Values, or Data Bars.

Table – Common Conditional Formatting Rules

Rule	Example	Purpose
Greater Than	>10000	Highlight top sales values
Text Contains	“Pending”	Identify incomplete tasks
Duplicate Values	—	Find repeated entries
Data Bars	—	Visualize value intensity

Conditional formatting is a key part of both basic and advanced tutorials, helping you interpret data visually without writing extra formulas.

Strong data organization and validation are the backbone of any efficient Excel workflow. Once you master these skills, you’re ready to move toward charts, PivotTables, and the next level of your MS Excel tutorial journey.

Also Read: 40 Essential Excel Tools, Functions, and Formulas for Enhanced Data Management

Charts and Visualisation

Data becomes more meaningful when it’s visual. Charts help you present information clearly and spot trends at a glance. In this part of the Excel tutorial, you’ll learn how to create, customize, and interpret charts in MS Excel, skills that are useful for both beginners and advanced users.

Inserting Basic Charts

Charts make numbers easier to understand. MS Excel offers many chart types such as column, bar, line, and pie charts.

To insert a chart:

1. Select the data you want to visualize.
2. Go to the Insert tab.
3. Choose a chart type (Column, Line, Pie, etc.).
4. Excel automatically generates a chart based on your selection.

You can move the chart anywhere on your sheet or resize it for better viewing.

Table – Common Excel Chart Types and Their Uses

Chart Type	Best For	Example Use
Column	Comparing categories	Monthly sales by region
Line	Showing trends over time	Yearly revenue growth
Pie	Showing proportions	Market share distribution
Bar	Comparing many items	Employee performance
Area	Highlighting volume changes	Cumulative profit trend

Customising Charts

Once the chart is created, you can modify its appearance for clarity and impact.

To customize:

• Click the chart to enable Chart Tools.
• Add or edit titles, axis labels, and legends.
• Use Chart Elements (+ icon) to toggle data labels or gridlines.
• Change colors, styles, or themes from the Format tab.

Well-formatted charts make your Excel tutorial for beginners projects look clean and professional.

Tip: Use contrasting colors for different categories to improve readability.

Also Read: Learn How to Create a Project Plan in Excel 2025

Using Sparklines and Mini-Charts

Sparklines are small, cell-sized charts that show trends within a single cell. They’re great for quick overviews without taking much space.

To insert a Sparkline:

1. Go to Insert → Sparklines.
2. Choose Line, Column, or Win/Loss.
3. Select your data range and click OK.

Sparklines are helpful in dashboards, where you need to display many trends side by side.

Advanced Visualisation Options

Once you’re comfortable with basic charts, explore more powerful visualization tools. These include:

• Combo Charts – Combine two chart types (e.g., column and line) for better comparison.
• Secondary Axis – Display two different data scales on one chart.
• Scatter and Bubble Charts – Ideal for showing relationships and distributions.
• PivotCharts – Dynamic charts based on PivotTable summaries.

These tools mark the transition from a basic to an advanced Excel tutorial, where you can build interactive dashboards and reports.

Also Read: What is Macros in Excel? How to add, Examples and uses

Working with Multiple Worksheets and Workbooks

In real projects, you’ll rarely work with just one sheet. Excel allows you to manage multiple worksheets and even combine data from different files, making your work organized and efficient. This part of the Excel tutorial explains how to link, manage, and protect worksheets and workbooks in MS Excel.

Linking Worksheets

You can connect data from one sheet to another to keep everything updated automatically.

Example:
If you have sales data in Sheet1 and want to display totals in Sheet2, use a formula like:
=Sheet1!B2

This pulls the value directly from that cell. If the data in Sheet1 changes, the linked value updates instantly.

Steps to link data:

1. Go to the destination sheet.
2. Type = and navigate to the source sheet.
3. Click the desired cell and press Enter.

Linking sheets is a simple but powerful feature covered in every Excel tutorial for beginners because it saves time and ensures accuracy.

Also Read: What is Excel VBA? Explained with Real Time Examples

Consolidating Data from Multiple Workbooks

When working on large projects, you may have several Excel files that need to be merged or summarized. Instead of copying manually, Excel offers tools to consolidate data.

Steps to consolidate data:

1. Open a new workbook.
2. Go to Data → Consolidate.
3. Select the function (Sum, Average, etc.).
4. Add references from each workbook.
5. Click OK to combine.

You can also import data from another file using Data → Get Data → From Workbook.

Table – When to Use Workbook Consolidation

Situation	Benefit
Monthly sales reports from different branches	Single combined report
Team expense sheets	Centralized view
Department-wise data	Unified dashboard

These features are a key part of MS Excel tutorial practices for business and financial reporting.

Protecting Worksheets and Workbooks

To prevent unwanted edits or data loss, you can lock cells or secure entire sheets.

To protect a worksheet:

1. Go to Review → Protect Sheet.
2. Set a password and choose what users can modify (e.g., formatting, inserting rows).

To protect a workbook:

1. Click File → Info → Protect Workbook.
2. Choose to encrypt with a password or mark as read-only.

You can also lock specific cells before protecting a sheet by selecting the range → Format Cells → Protection → Lock Cell.

Table – Worksheet vs Workbook Protection

Protection Type	Scope	Example Use
Worksheet	Individual sheet	Lock formulas or data entry
Workbook	Entire file	Prevent structure changes or file edits

Also Read: Gantt Chart in Excel

Managing multiple worksheets and workbooks efficiently helps you organize large datasets, reduce redundancy, and maintain consistency. These techniques are essential to master before moving toward PivotTables and other advanced Excel tutorial topics.

Introduction to PivotTables and PivotCharts

PivotTables are one of the most powerful tools in MS Excel. They help you summarize, analyze, and explore large datasets without complex formulas. This section of the Excel tutorial introduces you to PivotTables and PivotCharts, two essential features for anyone who wants to turn raw data into clear insights.

What is a PivotTable?

A PivotTable allows you to rearrange and summarize data dynamically. You can group, filter, and calculate information without changing the original dataset.

Example:
If you have a list of sales transactions, you can quickly find:

• Total sales by region
• Average revenue by product
• Count of orders per salesperson

PivotTables are especially useful in Excel tutorials for beginners because they simplify complex analysis into a few simple clicks.

Table – Common Uses of PivotTables

Task	Example	Benefit
Summarizing data	Total sales by category	Quick overview
Comparing values	Sales by month or region	Identify trends
Filtering	Show data for one product	Focused analysis
Grouping	Combine months into quarters	Better structure

Also Read: How to use Pivot Table in Excel? Step by Step Tutorial

Creating Your First PivotTable

Follow these steps to create your first PivotTable in MS Excel:

1. Select your dataset (include headers).
2. Go to Insert → PivotTable.
3. Choose to place it in a new or existing worksheet.
4. In the PivotTable Fields pane, drag and drop:
   • Rows: Categories (e.g., Product or Region)
   • Values: Numeric data (e.g., Sales or Revenue)
   • Columns: Optional (e.g., Year or Month)
   • Filters: Optional (e.g., Country)

Excel will instantly generate a summary based on your selections. You can change the layout anytime by moving fields between areas.

Tip: Always ensure your source data has no blank rows or duplicate headers before creating a PivotTable.

Also Read: Data Visualisation: The What, The Why, and The How!

Analysing Data with PivotCharts

A PivotChart is a visual representation of a PivotTable. It updates automatically when you adjust the table fields, filters, or layout.

To insert a PivotChart:

1. Click anywhere inside your PivotTable.
2. Go to Insert → PivotChart.
3. Choose the chart type (Column, Line, Pie, etc.).

PivotCharts make data interpretation faster. For example, you can see which product category brings in the most revenue or how sales vary across regions.

Table – Benefits of Using PivotCharts

Feature	Description
Dynamic updates	Changes automatically with PivotTable
Easy comparison	View multiple metrics side by side
Interactive filters	Use slicers to explore data quickly
Better insights	Combines summary and visualization

Moving Toward an Advanced Excel Tutorial

Once you’re confident with basic PivotTables, you can explore advanced options such as:

• Grouping data by date, month, or custom ranges
• Calculated fields for custom formulas within PivotTables
• Power Pivot to combine data from multiple sources
• Slicers and Timelines for interactive dashboards

These advanced tools expand your capabilities beyond basic reporting. They’re often covered in advanced Excel tutorials, helping you analyze, visualize, and present business data more effectively.

Also Read: 10 Must-Know Data Visualization Tips for Beginners in 2025

PivotTables and PivotCharts transform how you handle data in Excel. They simplify complex information, enhance decision-making, and are essential for anyone aiming to master both beginner and advanced levels of MS Excel.

Tips and Tricks to Boost Your Excel Workflow

Once you’ve mastered the basics of this Excel tutorial, it’s time to make your work faster and smarter. Excel offers many built-in tools, shortcuts, and hidden features that can help you save time and increase productivity. 

Keyboard Shortcuts for Speed

Learning shortcuts can cut your work time in half. They make navigation, editing, and formatting much faster.

Table – Most Useful Excel Shortcuts

Action	Shortcut	Description
Save Workbook	Ctrl + S	Save your progress instantly
Copy / Paste	Ctrl + C / Ctrl + V	Duplicate or move data
Undo / Redo	Ctrl + Z / Ctrl + Y	Reverse or repeat an action
Insert Row	Ctrl + Shift + +	Add a new row or column
Delete Row	Ctrl + –	Remove unwanted data
Select All	Ctrl + A	Highlight entire sheet
AutoSum	Alt + =	Insert sum formula quickly
Freeze Panes	Alt + W + F + F	Lock header rows while scrolling
Autofit Columns	Alt + H + O + I	Adjust column width to fit content

Using these shortcuts regularly helps you build muscle memory and move through Excel faster.

Also Read: What is Data Analytics: Definition, Types, Applications & Challenges

Use Flash Fill for Quick Data Entry

Flash Fill detects patterns and automatically completes data for you.
For example, if you type “Rahul Sharma” in one cell and then “Rahul” in the next column, Excel can fill down all first names automatically.

Steps:

1. Enter the first example pattern.
2. Go to Data → Flash Fill or press Ctrl + E.

This is one of the most time-saving features highlighted in many MS Excel tutorials.

Using the Name Box and Go To Feature

The Name Box (left of the formula bar) isn’t just for displaying cell references. You can type a cell address or range name (like A1 or SalesData) and press Enter to jump directly to that location.

To navigate faster in large sheets, press Ctrl + G or F5 to open the Go To dialog box. Enter any range, name, or formula reference to locate it instantly.

Also Read: Top Data Analytics Tools Every Data Scientist Should Know About

Customize the Ribbon and Quick Access Toolbar

Personalizing Excel’s interface makes frequently used commands easier to reach.

To customize:

1. Right-click the Ribbon → Choose Customize the Ribbon.
2. Add your favorite commands like Sort, Filter, or Conditional Formatting.
3. For quick actions, use the Quick Access Toolbar (QAT) above the Ribbon.

You can even move the QAT below the Ribbon for better visibility.

Use Templates and AutoSave

• Start new projects with Excel’s pre-designed templates for budgets, invoices, or calendars.
• Turn on AutoSave in Microsoft 365 to back up your file automatically as you work.

These small steps help maintain consistency and prevent data loss.

Explore the Quick Analysis Tool

Highlight any data range, and a small icon appears at the bottom right, this is the Quick Analysis Tool.
You can instantly:

• Apply conditional formatting
• Add totals or averages
• Create charts
• Insert sparklines

It’s an easy way to visualize or summarize data without navigating menus, perfect for Excel tutorial for beginners learners.

Also Read: Difference between Data Analysis and Data Analytics

Mastering these Excel tips and tricks will save time and make your workflow smoother. As you practice, you’ll find your own shortcuts and techniques that fit your routine. These habits not only boost productivity but also prepare you for advanced Excel tasks like automation, macros, and dashboard creation.

Common Errors and How to Fix Them

While learning from this Excel tutorial, it’s normal to encounter a few common errors. Excel displays specific error messages when something goes wrong with formulas, references, or data inputs. Understanding what these errors mean and how to fix them will save you time and frustration.

Understanding Excel Error Messages

Each error in MS Excel has a reason. Once you know what causes it, fixing it becomes simple.

Table – Common Excel Errors and Their Fixes

Error Type	Meaning	How to Fix
#DIV/0!	Division by zero	Check the denominator. Add an IFERROR or IF condition to avoid dividing by zero.
#VALUE!	Invalid data type	Ensure cells used in formulas contain numbers, not text.
#REF!	Invalid cell reference	A referenced cell or range was deleted. Recheck and update the formula.
#NAME?	Unrecognized text or function	Verify function spelling or missing quotation marks.
#N/A	Lookup value not found	Check if the searched value exists in the data range.
#NUM!	Invalid numeric operation	Ensure formulas don’t produce impossible results, like square roots of negative numbers.
#NULL!	Incorrect range operator	Replace space with a comma or colon in range references.

Also Read: The Ultimate Data Science Cheat Sheet Every Data Scientist Should Have

Formula Not Calculating

Sometimes Excel doesn’t update formulas automatically.
Fix:

• Press F9 to refresh all calculations.
• Go to Formulas → Calculation Options → Automatic to ensure updates occur in real time.

Data Not Displaying Properly

If numbers appear as “####” or text overlaps, it’s usually a formatting issue.
Fix:

• Double-click the column edge to auto-fit width.
• Check if the cell format is set correctly (General, Number, or Text).

Broken Links Between Sheets or Files

When a source file or sheet is moved or renamed, links can break.
 Fix:

• Go to Data → Edit Links → Change Source to reconnect to the right file.
• Use relative paths when working with multiple files to reduce broken references.

Error Prevention Tips

• Use IFERROR() to replace error messages with blank cells or custom text.
  Example: =IFERROR(A1/B1,"Check Data")
• Regularly save backups before editing linked files.
• Keep consistent naming and structure across worksheets.

Also Read: The Future of Data Science in India: Opportunities, Trends & Career Scope

Knowing how to identify and fix these issues makes working in MS Excel smoother. Every error is a learning opportunity, and mastering them moves you closer to handling data confidently, whether you’re following a beginner or advanced Excel tutorial.

Conclusion

You’ve now learned the core skills from this Microsoft Excel tutorial for beginners, from data entry and formulas to charts, PivotTables, and error handling. These basics will help you organize, analyze, and present data efficiently in MS Excel. Keep practising to strengthen your understanding and speed. 

upGrad offers specialized programs to help you enhance your Excel skills. These data science and Excel-focused courses combine practical exercises with essential knowledge to help you master the tools you need.

Here are some of the top courses recommended by upGrad to improve your Excel skills:

• Master’s Degree in Artificial Intelligence and Data Science
• Masters in Data Science Degree
• Post Graduate Certificate in Data Science & AI (Executive)
• Executive Diploma in Data Science & AI with IIIT-B
• Professional Certificate Program in AI and Data Science

Not sure which career path in MS Excel and data science suits you best? Get personalized career counseling to identify the best opportunities for you. Visit upGrad’s offline centers for expert mentorship, hands-on workshops, and networking sessions to connect you with industry leaders!