This free Excel course for beginners teaches you how to use spreadsheets for practical everyday work. You will learn how to enter and organize data, format worksheets, write formulas, use essential functions, work with cell references, sort and filter information, create charts and build a complete spreadsheet project from scratch.
What You Will Actually Learn
By the end of the course, you should be comfortable working with a basic spreadsheet instead of seeing Excel as a confusing grid of rows and columns.
Excel Skills You Will Build
- Understand workbooks, worksheets, cells and ranges.
- Enter and organize text, numbers and dates.
- Format worksheets for better readability.
- Create basic formulas.
- Use common Excel functions.
- Understand relative and absolute references.
- Sort and filter structured data.
- Create simple charts and reports.
Tasks You Should Be Able to Complete
- Create a monthly expense tracker.
- Calculate totals and averages.
- Build a basic sales worksheet.
- Organize customer or project records.
- Filter large lists for useful information.
- Highlight important values.
- Prepare a simple visual report.
- Build a complete practice workbook.
Build Your First Simple Worksheet
Create a basic expense list
Open a blank workbook and create a small table containing five everyday expenses. You do not need formulas yet. The purpose is to understand how information is organized inside cells.
Learn Excel Step by Step
Complete these eight modules in order and practise each skill directly inside a spreadsheet.
01 Understanding the Excel Workspace
Before learning formulas, you need to understand how an Excel workbook is organized.
Important terms
- Workbook: the complete Excel file.
- Worksheet: an individual sheet inside the workbook.
- Row: a horizontal line of cells identified by numbers.
- Column: a vertical line of cells identified by letters.
- Cell: the point where a row and column meet.
- Range: a group of selected cells.
Cell references
Every cell has an address. For example, the cell in column B and row 5 is called B5.
Understanding cell references is essential because formulas use them to identify which values should be calculated.
02 Entering, Editing and Formatting Data
A useful spreadsheet depends on clean and consistent data entry.
Practise entering
- Text.
- Whole numbers.
- Decimal numbers.
- Currency values.
- Percentages.
- Dates.
Useful formatting skills
- Bold important headings.
- Adjust column widths.
- Wrap long text.
- Change number formats.
- Apply borders carefully.
- Align content consistently.
Formatting should make information easier to understand. Avoid adding unnecessary decoration simply because Excel provides many styling options.
03 Creating Your First Excel Formulas
Formulas allow Excel to calculate values automatically. A formula normally begins with an equals sign.
Basic examples
=A1+B1=C2-D2
=B4*C4
=D10/2
Example sales calculation
If cell B2 contains quantity and C2 contains price, you could calculate total sales value with:
=B2*C2If you later change either value, Excel recalculates the result automatically.
04 Essential Excel Functions for Beginners
Functions are built-in formulas that help you perform common calculations more efficiently.
SUM
Adds values together.
=SUM(B2:B10)AVERAGE
Calculates the average of a range.
=AVERAGE(B2:B10)MIN and MAX
Find the smallest or largest value in a range.
=MIN(B2:B10)=MAX(B2:B10)
COUNT
Counts cells containing numbers.
=COUNT(B2:B10)COUNTA
Counts non-empty cells.
=COUNTA(A2:A10)IF
Returns different results depending on whether a condition is true or false.
=IF(B2>=50,”Pass”,”Fail”)05 Relative and Absolute Cell References
Cell references can behave differently when formulas are copied to other cells.
Relative reference
=B2*C2If this formula is copied down one row, Excel normally changes it to:
=B3*C3Absolute reference
$F$1Dollar signs can lock a row, column or both. This is useful when several formulas need to use the same fixed value.
Example
If F1 contains a tax rate and B2 contains a price:
=B2*$F$1When copied down, the B2 reference can change, while $F$1 remains fixed.
06 Sorting, Filtering and Working with Lists
Large worksheets become easier to use when information is structured consistently.
Sorting can help you
- Arrange names alphabetically.
- Order sales from highest to lowest.
- Arrange dates from oldest to newest.
- Group similar records more logically.
Filtering can help you
- Show records from one category.
- Display values above or below a threshold.
- Focus on particular dates.
- Temporarily hide records that are not relevant.
Always check that the complete data range is included before sorting so related values remain together.
07 Tables, Conditional Formatting and Charts
Excel includes tools that can make structured data easier to analyse and present.
Tables
Converting a consistent data range into a table can make sorting, filtering and expanding data easier.
Conditional formatting
Conditional formatting changes the appearance of cells based on rules.
- Highlight overdue tasks.
- Show high or low values.
- Identify duplicate values.
- Make important exceptions easier to notice.
Charts
Charts help communicate patterns visually. Select a chart based on what the data needs to show, rather than choosing one only because it looks decorative.
- Column charts for comparing categories.
- Line charts for changes over time.
- Bar charts for clear category comparisons.
08 Cleaning, Reviewing and Presenting a Workbook
A professional spreadsheet should be understandable to someone other than the person who created it.
Final workbook checks
- Use descriptive worksheet names.
- Check column headings.
- Remove accidental blank rows where unnecessary.
- Check formulas for incorrect ranges.
- Use consistent number formats.
- Check spelling and labels.
- Make important totals easy to identify.
- Confirm charts use the intended data range.
Before sending a spreadsheet to someone else, review it as if you were seeing the file for the first time.
Use a Simple Excel Process
A structured workflow keeps your workbook easier to build, understand and correct.
Decide what information the sheet needs.
Add clean and consistent data.
Add formulas and useful functions.
Sort, filter and review results.
Format and communicate the final information.
Essential Excel Functions Worth Practising
SUM
Add a range of numeric values together.
=SUM(B2:B12)AVERAGE
Find the average value in a range.
=AVERAGE(C2:C12)MIN
Return the smallest numeric value.
=MIN(D2:D12)MAX
Return the largest numeric value.
=MAX(D2:D12)COUNT
Count cells containing numbers.
=COUNT(E2:E12)IF
Return different results based on a condition.
=IF(C2>=100,”Target Met”,”Below Target”)Complete These Excel Exercises
Do these exercises inside Excel instead of only reading the instructions.
Practice 1 — Expense Tracker
Build a worksheet containing Date, Description, Category and Amount.
Practice 2 — Student Score Sheet
Create a list containing student names and test scores.
Practice 3 — Sales Worksheet
Add Product, Quantity, Unit Price and Total columns.
Practice 4 — Filter a Customer List
Create at least 20 records containing customer name, city, status and order value.
Three Habits That Make Spreadsheets Better
Use the same type of value in each column. Mixing dates, text and unrelated information in the same field can make analysis harder.
When practical, keep detailed records organized and create separate summary areas for totals, key figures or charts.
A formula can look correct while referencing the wrong range. Review important calculations before relying on the result.
Avoid These Common Excel Problems
If a result should change when the data changes, use a formula instead of entering the final number manually.
Labels such as “Value 1” or “Info” can make the workbook difficult to understand later.
Dates, currencies and percentages should be formatted consistently when they represent the same type of information.
Sorting part of a dataset incorrectly can separate related values from the records they belong to.
Relative cell references change as formulas are copied. Always verify important results.
Excessive colours, borders and fonts can make important information more difficult to identify.
Build a Complete Monthly Sales Workbook
Your Final Excel Project
Create a monthly sales workbook for a fictional small business. The goal is to combine data entry, formulas, formatting, analysis and charts in one useful file.
- 1. Create columns for Date, Product, Category, Quantity and Unit Price.
- 2. Add at least 20 sample sales records.
- 3. Create a Total column using Quantity × Unit Price.
- 4. Calculate total monthly sales using SUM.
- 5. Calculate average order value using AVERAGE.
- 6. Identify the highest sale using MAX.
- 7. Sort or filter the data by product or category.
- 8. Apply useful number and currency formatting.
- 9. Create one chart summarizing part of the data.
- 10. Review formulas, labels and formatting before considering the workbook complete.
Test Your Excel Basics
1. What is the difference between a workbook and a worksheet?
Answer: A workbook is the complete Excel file, while a worksheet is an individual sheet inside that workbook.
2. What symbol normally begins an Excel formula?
Answer: An equals sign (=).
3. Which function would you use to add B2 through B10?
Answer: =SUM(B2:B10)
4. Why are dollar signs used in references such as $F$1?
Answer: They create an absolute reference so the selected row and column can remain fixed when the formula is copied.
5. What is the difference between sorting and filtering?
Answer: Sorting changes the order of records, while filtering temporarily displays only records that meet selected criteria.
Before You Consider the Course Complete
Excel Course FAQs
Is this Excel course suitable for complete beginners?
Is this Excel course free?
Do I need previous spreadsheet experience?
Which Excel formulas should a beginner learn first?
How can I practise Excel after completing this course?
Does this Excel course include a certificate?
Learn Excel by Building Real Spreadsheets
Excel becomes easier when you stop trying to memorize every feature and start solving practical problems. Build clean data, use formulas carefully, analyze the results and practise with real worksheets until the process becomes familiar.
Explore More SkillsHaven Courses